deadlock table in mysql

11 141013 6:06:22
22 *** (1) TRANSACTION:
33 TRANSACTION 876726B90, ACTIVE 7 sec setting auto-inc lock
44 mysql tables in use 1, locked 1
55 LOCK WAIT 9 lock struct(s), heap size 1248, 4 row lock(s), undo log entries 4
66 MySQL thread id 155118366, OS thread handle 0x7f59e638a700, query id 87987781416 localhost msandbox update
77 INSERT INTO t1 (col1, col2, col3, col4) values (10, 20, 30, 'hello')
88 *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
99 TABLE LOCK table `mydb`.`t1` trx id 876726B90 lock mode AUTO-INC waiting
1010 *** (2) TRANSACTION:
1111 TRANSACTION 876725B2D, ACTIVE 9 sec inserting
1212 mysql tables in use 1, locked 1
1313 876 lock struct(s), heap size 80312, 1022 row lock(s), undo log entries 1002
1414 MySQL thread id 155097580, OS thread handle 0x7f585be79700, query id 87987761732 localhost msandbox update
1515 INSERT INTO t1 (col1, col2, col3, col4) values (7, 86, 62, "a lot of things"), (7, 76, 62, "many more")
1616 *** (2) HOLDS THE LOCK(S):
1717 TABLE LOCK table `mydb`.`t1` trx id 876725B2D lock mode AUTO-INC
1818 *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
1919 RECORD LOCKS space id 44917 page no 529635 n bits 112 index `PRIMARY` of table `mydb`.`t2` trx id 876725B2D lock mode S locks rec but not gap waiting
2020 *** WE ROLL BACK TRANSACTION (1)
21