MySQL带自增字段的表在并发插入时发生死锁
问题
'int' object has no attribute 'encode'", <class 'mysql.connector.errors.InternalError'>, (1213, '1213 (40001): Deadlock found when trying to get lock; try restarting transaction', u'40001'))
tbl_a有一个自增字段id(PRI,auto_increment),在python脚本中通过线程池并发执行insert into语句
insert into tbl_a (name) select name from tbl_b where name = '%s';
发生死锁错误:
(12