db crashed??

[pablos]

Hi,
My db crashed with an out of memory error - after it came back up everything appeared fine except for one innodb table. Now inserting into it I get an ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction.
Any suggestion please? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

mysql use "select max(id) from tablename" to get next id when it starts.
so try to get MAX before you insert into that table.
good luck! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --