pimguilherme commented on issue #7099:
URL:
https://github.com/apache/incubator-devlake/issues/7099#issuecomment-1980440633
this is the latest locks information on innodb:
```
------------------------
LATEST DETECTED DEADLOCK
------------------------
2024-03-06 09:28:06 22494182373120
*** (1) TRANSACTION:
TRANSACTION 9964411, ACTIVE 1 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 5
MySQL thread id 354, OS thread handle 22494692480768, query id 995814
10.172.34.108 devlake update
INSERT INTO `commit_parents`
(`created_at`,`updated_at`,`_raw_data_params`,`_raw_data_table`,`_raw_data_id`,`_raw_data_remark`,`commit_sha`,`parent_commit_sha`)
VALUES ('2024-03-06 09:28:05.308','2024-03-06
09:28:05.308','github:GithubRepo:1:189630055','gitextractor',0,'','7b2bc5000669d9b3fd5d231a581cc52271e36f4b','a4b384bf1c0f675739d075a146607518c1ce1457'),('2024-03-06
09:28:05.308','2024-03-06
09:28:05.308','github:GithubRepo:1:189630055','gitextractor',0,'','a4b384bf1c0f675739d075a146607518c1ce1457','8eadbeed5aee0e7b7c0ee0dba4dab06059950416'),('2024-03-06
09:28:05.308','2024-03-06
09:28:05.308','github:GithubRepo:1:189630055','gitextractor',0,'','8eadbeed5aee0e7b7c0ee0dba4dab06059950416','4ed72106c022a15b53adfa259510f0dcbc78ac99'),('2024-03-06
09:28:05.308','2024-03-06
09:28:05.308','github:GithubRepo:1:189630055','gitextractor',0,'','8eadbeed5aee0e7b7c0ee0dba4dab06059950416','6bf4ac71efaaf5407a9a9c8f7f27200
*** (1) HOLDS THE LOCK(S):
RECORD LOCKS space id 2340 page no 783 n bits 160 index PRIMARY of table
`lake`.`commit_parents` trx id 9964411 lock_mode X locks rec but not gap
Record lock, heap no 83 PHYSICAL RECORD: n_fields 10; compact format; info
bits 64
0: len 30; hex
366266346163373165666161663534303761396139633866376632373230; asc
6bf4ac71efaaf5407a9a9c8f7f2720; (total 40 bytes);
1: len 30; hex
346564373231303663303232613135623533616466613235393531306630; asc
4ed72106c022a15b53adfa259510f0; (total 40 bytes);
2: len 6; hex 000000980b7b; asc {;;
3: len 7; hex 81000036b50278; asc 6 x;;
4: len 7; hex 99b2cc97050c08; asc ;;
5: len 7; hex 99b2cc97050c08; asc ;;
6: len 29; hex 6769746875623a4769746875625265706f3a313a313839363330303535;
asc github:GithubRepo:1:189630055;;
7: len 12; hex 676974657874726163746f72; asc gitextractor;;
8: len 8; hex 0000000000000000; asc ;;
9: len 0; hex ; asc ;;
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 2340 page no 1944 n bits 168 index PRIMARY of table
`lake`.`commit_parents` trx id 9964411 lock_mode X locks gap before rec insert
intention waiting
Record lock, heap no 14 PHYSICAL RECORD: n_fields 10; compact format; info
bits 96
0: len 30; hex
346564383363313161326163326630383431383039323835633161363065; asc
4ed83c11a2ac2f0841809285c1a60e; (total 40 bytes);
1: len 30; hex
643464323931376263313931353639313063346336323335373636656162; asc
d4d2917bc19156910c4c6235766eab; (total 40 bytes);
2: len 6; hex 000000980b69; asc i;;
3: len 7; hex 01000027fc2b94; asc ' + ;;
4: len 7; hex 99b2ca77d6000a; asc w ;;
5: len 7; hex 99b2ca77d6000a; asc w ;;
6: len 28; hex 6769746875623a4769746875625265706f3a313a3936353934363639;
asc github:GithubRepo:1:96594669;;
7: len 12; hex 676974657874726163746f72; asc gitextractor;;
8: len 8; hex 0000000000000000; asc ;;
9: len 0; hex ; asc ;;
*** (2) TRANSACTION:
TRANSACTION 9964393, ACTIVE 1 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 333 lock struct(s), heap size 41080, 19875 row lock(s), undo log
entries 15662
MySQL thread id 342, OS thread handle 22494723909376, query id 995725
10.172.34.108 devlake updating
DELETE FROM `commit_parents` WHERE _raw_data_table = 'gitextractor' AND
_raw_data_params = 'github:GithubRepo:1:96594669'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 2340 page no 1944 n bits 168 index PRIMARY of table
`lake`.`commit_parents` trx id 9964393 lock_mode X locks gap before rec
Record lock, heap no 14 PHYSICAL RECORD: n_fields 10; compact format; info
bits 96
0: len 30; hex
346564383363313161326163326630383431383039323835633161363065; asc
4ed83c11a2ac2f0841809285c1a60e; (total 40 bytes);
1: len 30; hex
643464323931376263313931353639313063346336323335373636656162; asc
d4d2917bc19156910c4c6235766eab; (total 40 bytes);
2: len 6; hex 000000980b69; asc i;;
3: len 7; hex 01000027fc2b94; asc ' + ;;
4: len 7; hex 99b2ca77d6000a; asc w ;;
5: len 7; hex 99b2ca77d6000a; asc w ;;
6: len 28; hex 6769746875623a4769746875625265706f3a313a3936353934363639;
asc github:GithubRepo:1:96594669;;
7: len 12; hex 676974657874726163746f72; asc gitextractor;;
8: len 8; hex 0000000000000000; asc ;;
9: len 0; hex ; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 2340 page no 783 n bits 160 index PRIMARY of table
`lake`.`commit_parents` trx id 9964393 lock_mode X waiting
Record lock, heap no 83 PHYSICAL RECORD: n_fields 10; compact format; info
bits 64
0: len 30; hex
366266346163373165666161663534303761396139633866376632373230; asc
6bf4ac71efaaf5407a9a9c8f7f2720; (total 40 bytes);
1: len 30; hex
346564373231303663303232613135623533616466613235393531306630; asc
4ed72106c022a15b53adfa259510f0; (total 40 bytes);
2: len 6; hex 000000980b7b; asc {;;
3: len 7; hex 81000036b50278; asc 6 x;;
4: len 7; hex 99b2cc97050c08; asc ;;
5: len 7; hex 99b2cc97050c08; asc ;;
6: len 29; hex 6769746875623a4769746875625265706f3a313a313839363330303535;
asc github:GithubRepo:1:189630055;;
7: len 12; hex 676974657874726163746f72; asc gitextractor;;
8: len 8; hex 0000000000000000; asc ;;
9: len 0; hex ; asc ;;
*** WE ROLL BACK TRANSACTION (1)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
