Re: multi-thread insert into innodb table with auto_increment column cause deadlock

Gu Lei : Description: SQL state: HYT00 Native error: 1213 SQL Errortext: Deadlock found when trying to get lock; try restarting transaction SQL STATEMENT: insert into OCHARTORGANIZATION (CORPID,MODIFIED,MODIFIER,ORGIID,PARENTIID) values(?,?,?,?,?) mysql desc OCHARTORGANIZATION;

multi-thread insert into innodb table with auto_increment column cause deadlock

Description: SQL state: HYT00 Native error: 1213 SQL Errortext: Deadlock found when trying to get lock; try restarting transaction SQL STATEMENT: insert into OCHARTORGANIZATION (CORPID,MODIFIED,MODIFIER,ORGIID,PARENTIID) values(?,?,?,?,?) mysql desc OCHARTORGANIZATION;