Hello,
I got this error in mysql error log.
Does anyone have any idea about this and how to fix it, please ?
Thanks in advance.
LATEST FOREIGN KEY ERROR
2024-02-07 14:50:16 0x7f1c2d078700 Transaction:
TRANSACTION 9021550, ACTIVE 0 sec updating or deleting
mysql tables in use 8, locked 8
71 lock struct(s), heap size 8400, 133 row lock(s), undo log entries 102
MySQL thread id 1225121, OS thread handle 139758991279872, Updating
delete from ACT_RU_EXECUTION where ID_ = ‘a3a7618a-b554-11ee-a4d0-0242ac120007’ and REV_ = 9
Foreign key constraint fails for table act_ru_execution:
,
CONSTRAINT ACT_FK_EXE_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES act_ru_execution (ID_) ON DELETE CASCADE ON UPDATE CASCADE in parent table, in index ACT_FK_EXE_PROCINST tuple:
DATA TUPLE: 2 fields;
0: len 36; hex 61336137363138612d623535342d313165652d613464302d303234326163313230303037; asc a3a7618a-b554-11ee-a4d0-0242ac120007;;
1: len 36; hex 61336137363138612d623535342d313165652d613464302d303234326163313230303037; asc a3a7618a-b554-11ee-a4d0-0242ac120007;;
But in parent table act_ru_execution, in index PRIMARY,
the closest match we can find is record:
PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 30; hex 61336163353666342d383937612d313165652d383339322d303234326163; asc a3ac56f4-897a-11ee-8392-0242ac; (total 36 bytes);
1: len 6; hex 000000000000; asc ;;
2: len 7; hex 80000000000000; asc ;;
3: len 4; hex 80000002; asc ;;
4: len 30; hex 61336163353666342d383937612d313165652d383339322d303234326163; asc a3ac56f4-897a-11ee-8392-0242ac; (total 36 bytes);
5: SQL NULL;
6: SQL NULL;
7: len 30; hex 726571756573742e7265636f757672656d656e743a31323a323139316139; asc request.recouvrement:12:2191a9; (total 60 bytes);
8: SQL NULL;
9: SQL NULL;
10: SQL NULL;
11: SQL NULL;
12: len 30; hex 61336163353666342d383937612d313165652d383339322d303234326163; asc a3ac56f4-897a-11ee-8392-0242ac; (total 36 bytes);
13: len 1; hex 80; asc ;;
14: len 1; hex 80; asc ;;
15: len 1; hex 81; asc ;;
16: len 1; hex 80; asc ;;
17: len 4; hex 80000001; asc ;;
18: len 4; hex 80000011; asc ;;
19: len 8; hex 8000000000000030; asc 0;;
20: SQL NULL;
21: len 30; hex 61336163353666342d383937612d313165652d383339322d303234326163; asc a3ac56f4-897a-11ee-8392-0242ac; (total 36 bytes);