|

楼主 |
发表于 2018-4-3 10:25:32
|
显示全部楼层
*** (2) TRANSACTION:
TRANSACTION 19149395, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 42158833, OS thread handle 139828210513664, query id 313875099 172.17.250.26 root update
INSERT INTO SA_Task (SA_Task.sID, SA_Task.SPROCESS, SA_Task.SSTATUSID, SA_Task.SVARIABLE, SA_Task.SEXECUTEMODE, SA_Task.SCREATORPERSONNAME, SA_Task.SCREATETIME, SA_Task.SFLOWID, SA_Task.SSTATUSNAME, SA_Task.SEXECUTORPOSNAME, SA_Task.SCREATORFNAME, SA_Task.SCREATOROGNNAME, SA_Task.SEURL, SA_Task.SCREATORPOSID, SA_Task.SLASTMODIFYTIME, SA_Task.SEXECUTORPOSID, SA_Task.SCREATORDEPTID, SA_Task.SEXECUTORPERSONNAME, SA_Task.SEXECUTORPERSONID, SA_Task.STYPENAME, SA_Task.SDATA1, SA_Task.SEXECUTOROGNNAME, SA_Task.SCREATORDEPTNAME, SA_Task.SCREATORPOSNAME, SA_Task.SAIID, SA_Task.SLOCK, SA_Task.SACTIVITY, SA_Task.SEXECUTORFNAME, SA_Task.SEXPECTSTARTTIME, SA_Task.SCREATORFID, SA_Task.SPROCESSTEMPLATEID2, SA_Task.SAISTATUSID, SA_Task.SACTUALSTARTTIME, SA_Task.SEXECUTORFID, SA_Task.SACTIVITYINTEMPLATE, SA_Task.SRESPONSIBLE, SA_Task.SPROCESSNAME, SA_Task.SKINDID, SA_Task.SPREEMPTMODE, SA_Task.SEXECUTORDEPTNAME, SA_Task.S
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 521 page no 33119 n bits 88 index PRIMARY of table `expense_sys`.`sa_task` trx id 19149395 lock_mode X locks rec but not gap
Record lock, heap no 18 PHYSICAL RECORD: n_fields 130; compact format; info bits 0
0: len 30; hex 304230343735413431373244343230463931303535413739393131393037; asc 0B0475A4172D420F91055A79911907; (total 32 bytes);
1: len 6; hex 000001243253; asc $2S;;
2: len 7; hex 7f000001f30e3e; asc >;;
3: SQL NULL; |
|