请教一个mysql 死锁的问题
请教一个mysql 死锁的问题,不同数据库表之间出现的死锁,完全懵逼,具体报错如下
LATEST DETECTED DEADLOCK
------------------------
2019-05-20 13:43:40 0x6040
*** (1) TRANSACTION:
TRANSACTION 2470496, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 2
MySQL thread id 191670, OS thread handle 9860, query id 2378993 00701E0000fb root update
INSERT INTO `order`(
serailnumber,
total_fee,
phone,
product_id,
recommendation_code,
STATUS,
order_source,
user_id,
create_time,
IDcard,
product_full_title,
product_title,
product_type_id,
scene_id,
company_id,
is_all,
sys_user_id
) values(
'116279777588936704',
50.0,
'13944603315',
263,
'1141',
0,
'0',
64711,
now(),
'',
'',
'',
9,
40,
6,
0,
0)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 170 page no 2085 n bits 152 index PRIMARY of table `cdztc`.`order` trx id 2470496 lock_mode X insert intention waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;
*** (2) TRANSACTION:
TRANSACTION 2470493, ACTIVE 3 sec starting index read, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
3761 lock struct(s), heap size 401616, 528334 row lock(s), undo log entries 7
MySQL thread id 189106, OS thread handle 24640, query id 2379008 00701E0000fb root updating
update cw.car_sch
set
lock_seat = lock_seat - 2
where sch_id = 39881 and lock_seat >= 2
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 170 page no 2085 n bits 152 index PRIMARY of table `cdztc`.`order` trx id 2470493 lock mode S
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;