TRANSACTION 5171559091, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 927383, OS thread handle 140391894468352, query id 71641653 Update_rows_log_event::find_row(1144543396) UPDATE sbtest6 SET k=k+1 WHERE id=504105 2020-07-18 18:05:35 927383 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559052, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 17 row lock(s), undo log entries 14 MySQL thread id 932667, OS thread handle 140371823781632, query id 71641648 127.0.0.1 root Update INSERT INTO sbtest6 (id, k, c, pad) VALUES (449125, 538182, '33302072402-17526127259-24464519451-88066586713-55279246548-59515862494-64966193134-87560026103-81261595425-02842969319', '35640345011-51886607860-99659466629-75300423397-83302331044') 2020-07-18 18:05:35 927383 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 2447 n bits 288 index PRIMARY of table `shex`.`sbtest6` trx id 5171559052 lock_mode X locks rec but not gap Record lock, heap no 217 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b129; asc );; 1: len 6; hex 0001343fba8c; asc 4? ;; 2: len 7; hex 3e000001640110; asc > d ;; 3: len 4; hex 8007b16e; asc n;; 4: len 30; hex 38363230393439303539372d31303039343635353530352d383538313032; asc 86209490597-10094655505-858102; (total 120 bytes); 5: len 30; hex 33343938393733363839332d36303531373438303134362d353437323037; asc 34989736893-60517480146-547207; (total 60 bytes); 2020-07-18 18:05:35 927383 [Note] InnoDB: SQL1: UPDATE sbtest6 SET k=k+1 WHERE id=504105▒9_ 2020-07-18 18:05:35 927383 [Note] InnoDB: SQL2: INSERT INTO sbtest6 (id, k, c, pad) VALUES (449125, 538182, '33302072402-17526127259-24464519451-88066586713-55279246548-59515862494-64966193134-87560026103-81261595425-02842969319', '35640345011-51886607860-99659466629-75300423397-83302331044') 2020-07-18 18:05:35 927383 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 927383 [Note] WSREP: Winning thread: THD: 927383, mode: high priority, state: exec, conflict: executing, seqno: 1144543396 SQL: UPDATE sbtest6 SET k=k+1 WHERE id=504105▒9_ 2020-07-18 18:05:35 927383 [Note] WSREP: Victim thread: THD: 932667, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (449125, 538182, '33302072402-17526127259-24464519451-88066586713-55279246548-59515862494-64966193134-87560026103-81261595425-02842969319', '35640345011-51886607860-99659466629-75300423397-83302331044') 2020-07-18 18:05:35 927383 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 927471 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559134, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 927471, OS thread handle 140391074715392, query id 71641759 Update_rows_log_event::find_row(1144543456) UPDATE sbtest7 SET k=k+1 WHERE id=499342 2020-07-18 18:05:35 927471 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559070, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 12 MySQL thread id 932637, OS thread handle 140371831891712, query id 71641693 127.0.0.1 root Updating UPDATE sbtest7 SET c='80746279759-67150967667-56572006441-46960156854-16704557525-21564805075-44499956274-30434142356-04842002867-78942926009' WHERE id=502297 2020-07-18 18:05:35 927471 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097789 page no 480 n bits 384 index PRIMARY of table `shex`.`sbtest7` trx id 5171559070 lock_mode X locks rec but not gap Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079e8e; asc ;; 1: len 6; hex 0001343fba9e; asc 4? ;; 2: len 7; hex 4f00007a3540c7; asc O z5@ ;; 3: len 4; hex 80071b12; asc ;; 4: len 30; hex 37373531373334313533382d38353933383630353836302d393434323737; asc 77517341538-85938605860-944277; (total 120 bytes); 5: len 30; hex 39393730343633363431302d31343336383830353234302d323630323537; asc 99704636410-14368805240-260257; (total 60 bytes); 2020-07-18 18:05:35 927471 [Note] InnoDB: SQL1: UPDATE sbtest7 SET k=k+1 WHERE id=499342▒9_ 2020-07-18 18:05:35 927471 [Note] InnoDB: SQL2: UPDATE sbtest7 SET c='80746279759-67150967667-56572006441-46960156854-16704557525-21564805075-44499956274-30434142356-04842002867-78942926009' WHERE id=502297 2020-07-18 18:05:35 927471 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 927471 [Note] WSREP: Winning thread: THD: 927471, mode: high priority, state: exec, conflict: executing, seqno: 1144543456 SQL: UPDATE sbtest7 SET k=k+1 WHERE id=499342▒9_ 2020-07-18 18:05:35 927471 [Note] WSREP: Victim thread: THD: 932637, mode: local, state: exec, conflict: executing, seqno: -1 SQL: UPDATE sbtest7 SET c='80746279759-67150967667-56572006441-46960156854-16704557525-21564805075-44499956274-30434142356-04842002867-78942926009' WHERE id=502297 2020-07-18 18:05:35 927471 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 925754 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559144, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 925754, OS thread handle 140391898523392, query id 71641769 Update_rows_log_event::find_row(1144543481) UPDATE sbtest2 SET k=k+1 WHERE id=500621 2020-07-18 18:05:35 925754 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559027, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 24 lock struct(s), heap size 3488, 23 row lock(s), undo log entries 28 MySQL thread id 932653, OS thread handle 140371827566336, query id 71641690 127.0.0.1 root Updating DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:35 925754 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097780 page no 469 n bits 384 index PRIMARY of table `shex`.`sbtest2` trx id 5171559027 lock_mode X locks rec but not gap Record lock, heap no 162 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a38d; asc ;; 1: len 6; hex 0001343fba73; asc 4? s;; 2: len 7; hex 2600000151268e; asc & Q& ;; 3: len 4; hex 8007a7c6; asc ;; 4: len 30; hex 31353532353737393734342d36353830373034373036392d333032343439; asc 15525779744-65807047069-302449; (total 120 bytes); 5: len 30; hex 31393433323037393435322d39343730313532353939352d303038373637; asc 19432079452-94701525995-008767; (total 60 bytes); 2020-07-18 18:05:35 925754 [Note] InnoDB: SQL1: UPDATE sbtest2 SET k=k+1 WHERE id=500621▒9_ 2020-07-18 18:05:35 925754 [Note] InnoDB: SQL2: DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:35 925754 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 925754 [Note] WSREP: Winning thread: THD: 925754, mode: high priority, state: exec, conflict: executing, seqno: 1144543481 SQL: UPDATE sbtest2 SET k=k+1 WHERE id=500621▒9_ 2020-07-18 18:05:35 925754 [Note] WSREP: Victim thread: THD: 932653, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:35 925754 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 925743 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559129, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 925743, OS thread handle 140391737267968, query id 71642489 Update_rows_log_event::find_row(1144543446) UPDATE sbtest12 SET k=k+1 WHERE id=498918 2020-07-18 18:05:35 925743 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559068, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 15 MySQL thread id 932666, OS thread handle 140371824051968, query id 71642053 127.0.0.1 root Update INSERT INTO sbtest2 (id, k, c, pad) VALUES (544870, 500081, '81509617165-33340545592-22016709817-13601001446-76211449219-53051931025-62799674027-14640683391-52114875704-17553880428', '36589834039-52763232213-15466140537-22604289166-24978228003') 2020-07-18 18:05:35 925743 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097774 page no 2497 n bits 320 index PRIMARY of table `shex`.`sbtest12` trx id 5171559068 lock_mode X locks rec but not gap Record lock, heap no 94 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079ce6; asc ;; 1: len 6; hex 0001343fba9c; asc 4? ;; 2: len 7; hex 4d0000016601c0; asc M f ;; 3: len 4; hex 8007a7ca; asc ;; 4: len 30; hex 37353630353732393638392d39383133373234343339372d323031343939; asc 75605729689-98137244397-201499; (total 120 bytes); 5: len 30; hex 31373233373233363937342d30323038353932323631362d333838393638; asc 17237236974-02085922616-388968; (total 60 bytes); 2020-07-18 18:05:35 925743 [Note] InnoDB: SQL1: UPDATE sbtest12 SET k=k+1 WHERE id=498918▒9_ 2020-07-18 18:05:35 925743 [Note] InnoDB: SQL2: INSERT INTO sbtest2 (id, k, c, pad) VALUES (544870, 500081, '81509617165-33340545592-22016709817-13601001446-76211449219-53051931025-62799674027-14640683391-52114875704-17553880428', '36589834039-52763232213-15466140537-22604289166-24978228003') 2020-07-18 18:05:35 925743 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 925743 [Note] WSREP: Winning thread: THD: 925743, mode: high priority, state: exec, conflict: executing, seqno: 1144543446 SQL: UPDATE sbtest12 SET k=k+1 WHERE id=498918▒9_ 2020-07-18 18:05:35 925743 [Note] WSREP: Victim thread: THD: 932666, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (544870, 500081, '81509617165-33340545592-22016709817-13601001446-76211449219-53051931025-62799674027-14640683391-52114875704-17553880428', '36589834039-52763232213-15466140537-22604289166-24978228003') 2020-07-18 18:05:35 925743 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 927419 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559122, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 9 MySQL thread id 927419, OS thread handle 140391213262592, query id 71642509 Update_rows_log_event::find_row(1144543429) UPDATE sbtest1 SET c='13847479090-72792959153-27579047540-67461103879-82029393831-40428751126-21999649223-08554453318-59633552885-13998097664' WHERE id=497646 2020-07-18 18:05:35 927419 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559040, ACTIVE 0 sec updating or deleting mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 19 row lock(s), undo log entries 23 MySQL thread id 932640, OS thread handle 140371831080704, query id 71642504 127.0.0.1 root Updating DELETE FROM sbtest13 WHERE id=498746 2020-07-18 18:05:35 927419 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097791 page no 467 n bits 384 index PRIMARY of table `shex`.`sbtest1` trx id 5171559040 lock_mode X locks rec but not gap Record lock, heap no 114 2020-07-18 18:05:35 927419 [Note] InnoDB: SQL1: UPDATE sbtest1 SET c='13847479090-72792959153-27579047540-67461103879-82029393831-40428751126-21999649223-08554453318-59633552885-13998097664' WHERE id=497646▒9_ 2020-07-18 18:05:35 927419 [Note] InnoDB: SQL2: DELETE FROM sbtest13 WHERE id=498746 2020-07-18 18:05:35 927419 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 927419 [Note] WSREP: Winning thread: THD: 927419, mode: high priority, state: exec, conflict: executing, seqno: 1144543429 SQL: UPDATE sbtest1 SET c='13847479090-72792959153-27579047540-67461103879-82029393831-40428751126-21999649223-08554453318-59633552885-13998097664' WHERE id=497646▒9_ 2020-07-18 18:05:35 927419 [Note] WSREP: Victim thread: THD: 932640, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest13 WHERE id=498746 2020-07-18 18:05:35 927419 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 925760 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559081, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 19 row lock(s), undo log entries 36 MySQL thread id 925760, OS thread handle 140391210559232, query id 71642581 Delete_rows_log_event::find_row(1144543389) DELETE FROM sbtest15 WHERE id=503938 2020-07-18 18:05:35 925760 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559028, ACTIVE 0 sec 22 lock struct(s), heap size 3488, 20 row lock(s), undo log entries 34 MySQL thread id 932620, OS thread handle 140371836487424, query id 71642604 127.0.0.1 root Update INSERT INTO sbtest9 (id, k, c, pad) VALUES (498304, 501744, '33579183807-98806910024-55128189764-38733774422-33011913859-68671801698-72500784540-84926110557-85275793178-50350749600', '82159022726-45070803659-58742553317-25837535789-63221475502') 2020-07-18 18:05:35 925760 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097784 page no 464 n bits 384 index PRIMARY of table `shex`.`sbtest15` trx id 5171559028 lock_mode X locks rec but not gap Record lock, heap no 140 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b082; asc ;; 1: len 6; hex 0001343fba74; asc 4? t;; 2: len 7; hex 2700000140302a; asc ' @0*;; 3: len 4; hex 800abc74; asc t;; 4: len 30; hex 31333335393733363733392d33343838393932313131302d353733323931; asc 13359736739-34889921110-573291; (total 120 bytes); 5: len 30; hex 38333837383933363138312d32373533323132333236322d343737373334; asc 83878936181-27532123262-477734; (total 60 bytes); 2020-07-18 18:05:35 925760 [Note] InnoDB: SQL1: DELETE FROM sbtest15 WHERE id=503938▒9_ 2020-07-18 18:05:35 925760 [Note] InnoDB: SQL2: INSERT INTO sbtest9 (id, k, c, pad) VALUES (498304, 501744, '33579183807-98806910024-55128189764-38733774422-33011913859-68671801698-72500784540-84926110557-85275793178-50350749600', '82159022726-45070803659-58742553317-25837535789-63221475502') 2020-07-18 18:05:35 925760 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 925760 [Note] WSREP: Winning thread: THD: 925760, mode: high priority, state: exec, conflict: executing, seqno: 1144543389 SQL: DELETE FROM sbtest15 WHERE id=503938▒9_ 2020-07-18 18:05:35 925760 [Note] WSREP: Victim thread: THD: 932620, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest9 (id, k, c, pad) VALUES (498304, 501744, '33579183807-98806910024-55128189764-38733774422-33011913859-68671801698-72500784540-84926110557-85275793178-50350749600', '82159022726-45070803659-58742553317-25837535789-63221475502') 2020-07-18 18:05:35 925760 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 925800 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559110, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 10 MySQL thread id 925800, OS thread handle 140391213532928, query id 71642673 Update_rows_log_event::find_row(1144543414) UPDATE sbtest19 SET c='81084765484-15003794678-11037368880-79459508169-35322263247-03184732309-45850821342-47317487871-32553502899-42127718834' WHERE id=498774 2020-07-18 18:05:35 925800 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559033, ACTIVE 0 sec 20 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 32 MySQL thread id 932625, OS thread handle 140371835135744, query id 71642688 127.0.0.1 root Init DELETE FROM sbtest18 WHERE id=501772 2020-07-18 18:05:35 925800 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097790 page no 4416 n bits 320 index PRIMARY of table `shex`.`sbtest19` trx id 5171559033 lock_mode X locks rec but not gap Record lock, heap no 56 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079c56; asc V;; 1: len 6; hex 0001343fba79; asc 4? y;; 2: len 7; hex 2b000001630594; asc + c ;; 3: len 4; hex 80079d9b; asc ;; 4: len 30; hex 39363437333230383238372d36343738333530353835312d363536313035; asc 96473208287-64783505851-656105; (total 120 bytes); 5: len 30; hex 32303331383435343932342d30343034363438323838352d343439373237; asc 20318454924-04046482885-449727; (total 60 bytes); 2020-07-18 18:05:35 925800 [Note] InnoDB: SQL1: UPDATE sbtest19 SET c='81084765484-15003794678-11037368880-79459508169-35322263247-03184732309-45850821342-47317487871-32553502899-42127718834' WHERE id=498774▒9_ 2020-07-18 18:05:35 925800 [Note] InnoDB: SQL2: DELETE FROM sbtest18 WHERE id=501772 2020-07-18 18:05:35 925800 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 925800 [Note] WSREP: Winning thread: THD: 925800, mode: high priority, state: exec, conflict: executing, seqno: 1144543414 SQL: UPDATE sbtest19 SET c='81084765484-15003794678-11037368880-79459508169-35322263247-03184732309-45850821342-47317487871-32553502899-42127718834' WHERE id=498774▒9_ 2020-07-18 18:05:35 925800 [Note] WSREP: Victim thread: THD: 932625, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest18 WHERE id=501772 2020-07-18 18:05:35 925800 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 925919 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559102, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 9 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 9 MySQL thread id 925919, OS thread handle 140436272682752, query id 71642825 Update_rows_log_event::find_row(1144543406) UPDATE sbtest1 SET c='15465282306-00453170402-41749890958-41238926668-39171708672-15061305584-46372981982-56254897379-37755742256-47495296333' WHERE id=500522 2020-07-18 18:05:35 925919 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559034, ACTIVE 0 sec updating or deleting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 15 row lock(s), undo log entries 21 MySQL thread id 932655, OS thread handle 140371827025664, query id 71641973 127.0.0.1 root Updating DELETE FROM sbtest14 WHERE id=502542 2020-07-18 18:05:35 925919 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097791 page no 4480 n bits 304 index PRIMARY of table `shex`.`sbtest1` trx id 5171559034 lock_mode X locks rec but not gap Record lock, heap no 100 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a32a; asc *;; 1: len 6; hex 0001343fba7a; asc 4? z;; 2: len 7; hex 2c000001e3ba4d; asc , M;; 3: len 4; hex 8007f281; asc ;; 4: len 30; hex 36383138373039353134392d30313635373739353737322d333934353837; asc 68187095149-01657795772-394587; (total 120 bytes); 5: len 30; hex 37353432323036303938352d37333033353839313637382d313435323330; asc 75422060985-73035891678-145230; (total 60 bytes); 2020-07-18 18:05:35 925919 [Note] InnoDB: SQL1: UPDATE sbtest1 SET c='15465282306-00453170402-41749890958-41238926668-39171708672-15061305584-46372981982-56254897379-37755742256-47495296333' WHERE id=500522▒9_ 2020-07-18 18:05:35 925919 [Note] InnoDB: SQL2: DELETE FROM sbtest14 WHERE id=502542 2020-07-18 18:05:35 925919 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 925919 [Note] WSREP: Winning thread: THD: 925919, mode: high priority, state: exec, conflict: executing, seqno: 1144543406 SQL: UPDATE sbtest1 SET c='15465282306-00453170402-41749890958-41238926668-39171708672-15061305584-46372981982-56254897379-37755742256-47495296333' WHERE id=500522▒9_ 2020-07-18 18:05:35 925919 [Note] WSREP: Victim thread: THD: 932655, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest14 WHERE id=502542 2020-07-18 18:05:35 925919 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 927426 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559135, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 9 MySQL thread id 927426, OS thread handle 140391742134016, query id 71642955 Update_rows_log_event::find_row(1144543458) UPDATE sbtest6 SET k=k+1 WHERE id=498014 2020-07-18 18:05:35 927426 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558993, ACTIVE 0 sec 28 lock struct(s), heap size 3488, 34 row lock(s), undo log entries 51 MySQL thread id 932613, OS thread handle 140372484413184, query id 71638537 127.0.0.1 root Init COMMIT 2020-07-18 18:05:35 927426 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 2445 n bits 296 index PRIMARY of table `shex`.`sbtest6` trx id 5171558993 lock_mode X locks rec but not gap Record lock, heap no 30 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007995e; asc ^;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80079ec3; asc ;; 4: len 30; hex 31373136373531373330362d35303034323338383136382d373238343734; asc 17167517306-50042388168-728474; (total 120 bytes); 5: len 30; hex 32303833313339363933312d32303138393036373931332d313438303331; asc 20831396931-20189067913-148031; (total 60 bytes); Record lock, heap no 53 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 800799ae; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 8007b41c; asc ;; 4: len 30; hex 32393030333638383632352d36343638373330363333362d313336313932; asc 29003688625-64687306336-136192; (total 120 bytes); 5: len 30; hex 38333738393435373835382d35343637353938353938372d393439353836; asc 83789457858-54675985987-949586; (total 60 bytes); 2020-07-18 18:05:35 927426 [Note] InnoDB: SQL1: UPDATE sbtest6 SET k=k+1 WHERE id=498014▒9_ 2020-07-18 18:05:35 927426 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:35 927426 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:35 927426 [Note] WSREP: Winning thread: THD: 927426, mode: high priority, state: exec, conflict: executing, seqno: 1144543458 SQL: UPDATE sbtest6 SET k=k+1 WHERE id=498014▒9_ 2020-07-18 18:05:35 927426 [Note] WSREP: Victim thread: THD: 932613, mode: local, state: exec, conflict: committing, seqno: 1144543424 SQL: COMMIT 2020-07-18 18:05:35 927426 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:35 927596 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559092, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 8 MySQL thread id 927596, OS thread handle 140390468417280, query id 71642938 Update_rows_log_event::find_row(1144543397) UPDATE sbtest20 SET c='32211946436-65559923694-11978547448-78281636695-59329382995-85790653948-05700520652-48317243331-45191200855-09857272739' WHERE id=503867 2020-07-18 18:05:35 927596 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558999, ACTIVE 0 sec rollback ROLLING BACK 24 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 36 MySQL thread id 932596, OS thread handle 140391086610176, query id 71639047 127.0.0.1 root Init COMMIT 2020-07-18 18:05:35 927596 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097787 page no 4480 n bits 304 index PRIMARY of table `shex`.`sbtest20` trx id 5171558999 lock_mode X locks rec but not gap Record lock, heap no 217 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b03b; asc ;;; 1: len 6; hex 0001343fba57; asc 4? W;; 2: len 7; hex 0c000001f4a947; asc G;; 3: len 4; hex 8007abbb; asc ;; 4: len 30; hex 39383632363337363039332d32373738303333303634372d363139383935; asc 98626376093-27780330647-619895; (total 120 bytes); 5: len 30; hex 34383233343631383030372d38383930313335343336312d303137333333; asc 48234618007-88901354361-017333; (total 60 bytes); 2020-07-18 18:05:36 927596 [Note] InnoDB: SQL1: UPDATE sbtest20 SET c='32211946436-65559923694-11978547448-78281636695-59329382995-85790653948-05700520652-48317243331-45191200855-09857272739' WHERE id=503867▒9_ 2020-07-18 18:05:36 927596 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 927596 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927596 [Note] WSREP: Winning thread: THD: 927596, mode: high priority, state: exec, conflict: executing, seqno: 1144543397 SQL: UPDATE sbtest20 SET c='32211946436-65559923694-11978547448-78281636695-59329382995-85790653948-05700520652-48317243331-45191200855-09857272739' WHERE id=503867▒9_ 2020-07-18 18:05:36 927596 [Note] WSREP: Victim thread: THD: 932596, mode: local, state: exec, conflict: aborting, seqno: 1144543436 SQL: COMMIT 2020-07-18 18:05:36 927596 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925828 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559130, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 10 MySQL thread id 925828, OS thread handle 140391902848768, query id 71643096 Update_rows_log_event::find_row(1144543448) UPDATE sbtest3 SET c='11232363955-55251122198-45706294972-60218489968-12603905865-15806352383-28541013657-50637191635-38553431848-94745838958' WHERE id=503346 2020-07-18 18:05:36 925828 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559000, ACTIVE 1 sec rollback ROLLING BACK 27 lock struct(s), heap size 3488, 34 row lock(s), undo log entries 43 MySQL thread id 932590, OS thread handle 140391207855872, query id 71638835 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925828 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097792 page no 2937 n bits 296 index PRIMARY of table `shex`.`sbtest3` trx id 5171559000 lock_mode X locks rec but not gap Record lock, heap no 23 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ad52; asc R;; 1: len 6; hex 0001343fba58; asc 4? X;; 2: len 7; hex 0d00007a3b293e; asc z;)>;; 3: len 4; hex 8007a2be; asc ;; 4: len 30; hex 31373535353736393536332d30383830383037353038372d313532383338; asc 17555769563-08808075087-152838; (total 120 bytes); 5: len 30; hex 39383933363838393939392d35343538383331373935312d373834343231; asc 98936889999-54588317951-784421; (total 60 bytes); Record lock, heap no 82 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ae32; asc 2;; 1: len 6; hex 0001343fba58; asc 4? X;; 2: len 7; hex 0d00007a3b296a; asc z;)j;; 3: len 4; hex 8007a78a; asc ;; 4: len 30; hex 34383034313330313334352d31393336353431353432372d373438373538; asc 48041301345-19365415427-748758; (total 120 bytes); 5: len 30; hex 30383933333234333038392d38363937323139363736352d373332323832; asc 08933243089-86972196765-732282; (total 60 bytes); 2020-07-18 18:05:36 925828 [Note] InnoDB: SQL1: UPDATE sbtest3 SET c='11232363955-55251122198-45706294972-60218489968-12603905865-15806352383-28541013657-50637191635-38553431848-94745838958' WHERE id=503346▒9_ 2020-07-18 18:05:36 925828 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925828 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925828 [Note] WSREP: Winning thread: THD: 925828, mode: high priority, state: exec, conflict: executing, seqno: 1144543448 SQL: UPDATE sbtest3 SET c='11232363955-55251122198-45706294972-60218489968-12603905865-15806352383-28541013657-50637191635-38553431848-94745838958' WHERE id=503346▒9_ 2020-07-18 18:05:36 925828 [Note] WSREP: Victim thread: THD: 932590, mode: local, state: exec, conflict: aborting, seqno: 1144543433 SQL: COMMIT 2020-07-18 18:05:36 925828 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925816 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559105, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 15 MySQL thread id 925816, OS thread handle 140391898793728, query id 71643165 Delete_rows_log_event::find_row(1144543409) DELETE FROM sbtest9 WHERE id=502815 2020-07-18 18:05:36 925816 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559064, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 18 MySQL thread id 932661, OS thread handle 140371825403648, query id 71643114 127.0.0.1 root Update INSERT INTO sbtest7 (id, k, c, pad) VALUES (593031, 500980, '87788118808-48105590798-07963937814-23820887031-51405269870-43589235245-90661760872-36276923974-58938516349-06653755669', '96621391719-31858775191-62907917970-67474971717-99675058630') 2020-07-18 18:05:36 925816 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097769 page no 466 n bits 384 index PRIMARY of table `shex`.`sbtest9` trx id 5171559064 lock_mode X locks rec but not gap Record lock, heap no 19 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ab46; asc F;; 1: len 6; hex 0001343fba98; asc 4? ;; 2: len 7; hex 4a00007a098466; asc J z f;; 3: len 4; hex 80054ad1; asc J ;; 4: len 30; hex 32323530393033373035332d33383332353533373434332d323134373635; asc 22509037053-38325537443-214765; (total 120 bytes); 5: len 30; hex 38303933323033383239362d33393732363636333336382d363638333239; asc 80932038296-39726663368-668329; (total 60 bytes); Record lock, heap no 117 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007acce; asc ;; 1: len 6; hex 0001343fba98; asc 4? ;; 2: len 7; hex 4a00007a0986c6; asc J z ;; 3: len 4; hex 8007b15b; asc [;; 4: len 30; hex 35323631363537373537352d34373738393238383632302d343034333530; asc 52616577575-47789288620-404350; (total 120 bytes); 5: len 30; hex 35343537353932373536382d34353434313036353731352d333637373833; asc 54575927568-45441065715-367783; (total 60 bytes); Record lock, heap no 309 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ac1f; asc ;; 1: len 6; hex 0001343fba98; asc 4? ;; 2: len 7; hex 4a00007a0987f6; asc J z ;; 3: len 4; hex 8007a457; asc W;; 4: len 30; hex 32313637373430393330302d34303839383934323233322d343835353839; asc 21677409300-40898942232-485589; (total 120 bytes); 5: len 30; hex 34383836363838333032362d33363637353434313634362d363035333033; asc 48866883026-36675441646-605303; (total 60 bytes); 2020-07-18 18:05:36 925816 [Note] InnoDB: SQL1: DELETE FROM sbtest9 WHERE id=502815▒9_ 2020-07-18 18:05:36 925816 [Note] InnoDB: SQL2: INSERT INTO sbtest7 (id, k, c, pad) VALUES (593031, 500980, '87788118808-48105590798-07963937814-23820887031-51405269870-43589235245-90661760872-36276923974-58938516349-06653755669', '96621391719-31858775191-62907917970-67474971717-99675058630') 2020-07-18 18:05:36 925816 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925816 [Note] WSREP: Winning thread: THD: 925816, mode: high priority, state: exec, conflict: executing, seqno: 1144543409 SQL: DELETE FROM sbtest9 WHERE id=502815▒9_ 2020-07-18 18:05:36 925816 [Note] WSREP: Victim thread: THD: 932661, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (593031, 500980, '87788118808-48105590798-07963937814-23820887031-51405269870-43589235245-90661760872-36276923974-58938516349-06653755669', '96621391719-31858775191-62907917970-67474971717-99675058630') 2020-07-18 18:05:36 925816 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925799 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559107, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 8 MySQL thread id 925799, OS thread handle 140391892846336, query id 71643269 Update_rows_log_event::find_row(1144543411) UPDATE sbtest4 SET k=k+1 WHERE id=498982 2020-07-18 18:05:36 925799 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559006, ACTIVE 1 sec rollback ROLLING BACK 25 lock struct(s), heap size 3488, 30 row lock(s), undo log entries 6 MySQL thread id 932589, OS thread handle 140391088232192, query id 71639150 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925799 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097779 page no 499 n bits 384 index PRIMARY of table `shex`.`sbtest4` trx id 5171559006 lock_mode X locks rec but not gap Record lock, heap no 32 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079d26; asc &;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 8007aadf; asc ;; 4: len 30; hex 32303435373230373034342d38393635393134333839342d323731383732; asc 20457207044-89659143894-271872; (total 120 bytes); 5: len 30; hex 38313031393530363137332d36373235393937343638342d303735323832; asc 81019506173-67259974684-075282; (total 60 bytes); Record lock, heap no 151 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079edd; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 8007a2a2; asc ;; 4: len 30; hex 31313639313430333033332d36313830363731303730372d333633383836; asc 11691403033-61806710707-363886; (total 120 bytes); 5: len 30; hex 36313435363732303438332d39333336303330373936332d353438333032; asc 61456720483-93360307963-548302; (total 60 bytes); Record lock, heap no 152 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079d78; asc x;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 8007ab44; asc D;; 4: len 30; hex 31383834323731353532372d32353939333431313635342d333233303530; asc 18842715527-25993411654-323050; (total 120 bytes); 5: len 30; hex 36313539393537333038322d30353338383830383531302d303231353139; asc 61599573082-05388808510-021519; (total 60 bytes); 2020-07-18 18:05:36 925799 [Note] InnoDB: SQL1: UPDATE sbtest4 SET k=k+1 WHERE id=498982▒9_ 2020-07-18 18:05:36 925799 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925799 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925799 [Note] WSREP: Winning thread: THD: 925799, mode: high priority, state: exec, conflict: executing, seqno: 1144543411 SQL: UPDATE sbtest4 SET k=k+1 WHERE id=498982▒9_ 2020-07-18 18:05:36 925799 [Note] WSREP: Victim thread: THD: 932589, mode: local, state: exec, conflict: aborting, seqno: 1144543440 SQL: COMMIT 2020-07-18 18:05:36 925799 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927593 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559141, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 20 lock struct(s), heap size 3488, 22 row lock(s), undo log entries 30 MySQL thread id 927593, OS thread handle 140390804657920, query id 71643324 Delete_rows_log_event::find_row(1144543469) DELETE FROM sbtest10 WHERE id=503682 2020-07-18 18:05:36 927593 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559025, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 29 lock struct(s), heap size 3488, 32 row lock(s), undo log entries 41 MySQL thread id 932634, OS thread handle 140371832702720, query id 71643015 127.0.0.1 root Update INSERT INTO sbtest15 (id, k, c, pad) VALUES (499722, 501488, '36543718174-03000557178-76884000291-65743072397-14857142123-18670480936-05704437915-95186095214-06836841058-33807776490', '93752575233-92518052483-99562419369-15359268559-95221997110') 2020-07-18 18:05:36 927593 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097778 page no 533 n bits 384 index PRIMARY of table `shex`.`sbtest10` trx id 5171559025 lock_mode X locks rec but not gap Record lock, heap no 25 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007af82; asc ;; 1: len 6; hex 0001343fba71; asc 4? q;; 2: len 7; hex 2400007a3f26b6; asc $ z?& ;; 3: len 4; hex 8007ac40; asc @;; 4: len 30; hex 34393839373737353532332d39343937313733303131332d393631363536; asc 49897775523-94971730113-961656; (total 120 bytes); 5: len 30; hex 33353433313730323231372d33353035363235393236332d373034303239; asc 35431702217-35056259263-704029; (total 60 bytes); Record lock, heap no 75 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b04a; asc J;; 1: len 6; hex 0001343fba71; asc 4? q;; 2: len 7; hex 2400007a3f2792; asc $ z?' ;; 3: len 4; hex 8007a747; asc G;; 4: len 30; hex 31353639383733303532372d35383739333631363535312d373834353937; asc 15698730527-58793616551-784597; (total 120 bytes); 5: len 30; hex 39323032323739373635302d36323332393638303531362d353832353334; asc 92022797650-62329680516-582534; (total 60 bytes); 2020-07-18 18:05:36 927593 [Note] InnoDB: SQL1: DELETE FROM sbtest10 WHERE id=503682▒9_ 2020-07-18 18:05:36 927593 [Note] InnoDB: SQL2: INSERT INTO sbtest15 (id, k, c, pad) VALUES (499722, 501488, '36543718174-03000557178-76884000291-65743072397-14857142123-18670480936-05704437915-95186095214-06836841058-33807776490', '93752575233-92518052483-99562419369-15359268559-95221997110') 2020-07-18 18:05:36 927593 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927593 [Note] WSREP: Winning thread: THD: 927593, mode: high priority, state: exec, conflict: executing, seqno: 1144543469 SQL: DELETE FROM sbtest10 WHERE id=503682▒9_ 2020-07-18 18:05:36 927593 [Note] WSREP: Victim thread: THD: 932634, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest15 (id, k, c, pad) VALUES (499722, 501488, '36543718174-03000557178-76884000291-65743072397-14857142123-18670480936-05704437915-95186095214-06836841058-33807776490', '93752575233-92518052483-99562419369-15359268559-95221997110') 2020-07-18 18:05:36 927593 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 932230 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559090, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 18 lock struct(s), heap size 1128, 18 row lock(s), undo log entries 23 MySQL thread id 932230, OS thread handle 140390403991296, query id 71643642 Delete_rows_log_event::find_row(1144543395) DELETE FROM sbtest8 WHERE id=497866 2020-07-18 18:05:36 932230 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559027, ACTIVE 1 sec rollback ROLLING BACK 24 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 25 MySQL thread id 932653, OS thread handle 140371827566336, query id 71641690 127.0.0.1 root Freeing items DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:36 932230 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097772 page no 468 n bits 384 index PRIMARY of table `shex`.`sbtest8` trx id 5171559027 lock_mode X locks rec but not gap Record lock, heap no 101 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 800798ca; asc ;; 1: len 6; hex 0001343fba73; asc 4? s;; 2: len 7; hex 26000001512310; asc & Q# ;; 3: len 4; hex 8007993a; asc :;; 4: len 30; hex 36393534343834313334352d31313032333934373131362d353736393232; asc 69544841345-11023947116-576922; (total 120 bytes); 5: len 30; hex 31353034303630303830392d38303532333832303335342d393534373234; asc 15040600809-80523820354-954724; (total 60 bytes); 2020-07-18 18:05:36 932230 [Note] InnoDB: SQL1: DELETE FROM sbtest8 WHERE id=497866▒9_ 2020-07-18 18:05:36 932230 [Note] InnoDB: SQL2: DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:36 932230 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 932230 [Note] WSREP: Winning thread: THD: 932230, mode: high priority, state: exec, conflict: executing, seqno: 1144543395 SQL: DELETE FROM sbtest8 WHERE id=497866▒9_ 2020-07-18 18:05:36 932230 [Note] WSREP: Victim thread: THD: 932653, mode: local, state: exec, conflict: aborting, seqno: -1 SQL: DELETE FROM sbtest2 WHERE id=501953 2020-07-18 18:05:36 932230 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925939 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559119, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 11 row lock(s), undo log entries 11 MySQL thread id 925939, OS thread handle 140435566528256, query id 71643760 Update_rows_log_event::find_row(1144543426) UPDATE sbtest13 SET k=k+1 WHERE id=501507 2020-07-18 18:05:36 925939 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559000, ACTIVE 1 sec rollback ROLLING BACK 27 lock struct(s), heap size 3488, 34 row lock(s), undo log entries 38 MySQL thread id 932590, OS thread handle 140391207855872, query id 71638835 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925939 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097786 page no 2525 n bits 328 index PRIMARY of table `shex`.`sbtest13` trx id 5171559000 lock_mode X locks rec but not gap Record lock, heap no 179 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a703; asc ;; 1: len 6; hex 0001343fba58; asc 4? X;; 2: len 7; hex 0d00007a3b2a5a; asc z;*Z;; 3: len 4; hex 8007b109; asc ;; 4: len 30; hex 35373237313232353538332d30393837313637333634322d333131383339; asc 57271225583-09871673642-311839; (total 120 bytes); 5: len 30; hex 37353437313836393036302d38383334303730313734302d363230343434; asc 75471869060-88340701740-620444; (total 60 bytes); 2020-07-18 18:05:36 925939 [Note] InnoDB: SQL1: UPDATE sbtest13 SET k=k+1 WHERE id=501507▒9_ 2020-07-18 18:05:36 925939 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925939 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925939 [Note] WSREP: Winning thread: THD: 925939, mode: high priority, state: exec, conflict: executing, seqno: 1144543426 SQL: UPDATE sbtest13 SET k=k+1 WHERE id=501507▒9_ 2020-07-18 18:05:36 925939 [Note] WSREP: Victim thread: THD: 932590, mode: local, state: exec, conflict: aborting, seqno: 1144543433 SQL: COMMIT 2020-07-18 18:05:36 925939 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925892 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559133, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 17 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 24 MySQL thread id 925892, OS thread handle 140436279711488, query id 71644257 Delete_rows_log_event::find_row(1144543454) DELETE FROM sbtest1 WHERE id=498250 2020-07-18 18:05:36 925892 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559069, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 14 lock struct(s), heap size 1128, 15 row lock(s), undo log entries 26 MySQL thread id 932605, OS thread handle 140390401828608, query id 71644094 127.0.0.1 root Update INSERT INTO sbtest8 (id, k, c, pad) VALUES (502712, 498874, '96807448427-51227275703-99987927983-14966920340-77851938495-52242543934-96343033941-82087976551-66276337824-09469559272', '42403513374-06958683226-82967152187-00023399562-51175887029') 2020-07-18 18:05:36 925892 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097791 page no 2490 n bits 280 index PRIMARY of table `shex`.`sbtest1` trx id 5171559069 lock_mode X locks rec but not gap Record lock, heap no 125 Record lock, heap no 201 2020-07-18 18:05:36 925892 [Note] InnoDB: SQL1: DELETE FROM sbtest1 WHERE id=498250▒9_ 2020-07-18 18:05:36 925892 [Note] InnoDB: SQL2: INSERT INTO sbtest8 (id, k, c, pad) VALUES (502712, 498874, '96807448427-51227275703-99987927983-14966920340-77851938495-52242543934-96343033941-82087976551-66276337824-09469559272', '42403513374-06958683226-82967152187-00023399562-51175887029') 2020-07-18 18:05:36 925892 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925892 [Note] WSREP: Winning thread: THD: 925892, mode: high priority, state: exec, conflict: executing, seqno: 1144543454 SQL: DELETE FROM sbtest1 WHERE id=498250▒9_ 2020-07-18 18:05:36 925892 [Note] WSREP: Victim thread: THD: 932605, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (502712, 498874, '96807448427-51227275703-99987927983-14966920340-77851938495-52242543934-96343033941-82087976551-66276337824-09469559272', '42403513374-06958683226-82967152187-00023399562-51175887029') 2020-07-18 18:05:36 925892 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927666 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559153, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 16 lock struct(s), heap size 1128, 16 row lock(s), undo log entries 29 MySQL thread id 927666, OS thread handle 140390432413440, query id 71645431 Delete_rows_log_event::find_row(1144543496) DELETE FROM sbtest6 WHERE id=504821 2020-07-18 18:05:36 927666 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559055, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 20 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 36 MySQL thread id 932657, OS thread handle 140371826484992, query id 71645341 127.0.0.1 root Update INSERT INTO sbtest8 (id, k, c, pad) VALUES (501105, 504489, '60382086216-37427927808-23362194472-88750530414-83674493563-63739804813-89914782693-10180215618-74666337954-89153811067', '78467288269-83573370955-59048110655-50141141896-07036877521') 2020-07-18 18:05:36 927666 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 465 n bits 384 index PRIMARY of table `shex`.`sbtest6` trx id 5171559055 lock_mode X locks rec but not gap Record lock, heap no 92 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b3c2; asc ;; 1: len 6; hex 0001343fba8f; asc 4? ;; 2: len 7; hex 41000001faa264; asc A d;; 3: len 4; hex 80079773; asc s;; 4: len 30; hex 33383436383434383639342d37323737333632383132302d343231313231; asc 38468448694-72773628120-421121; (total 120 bytes); 5: len 30; hex 31393631303139393134302d32323235333337323536362d383035333332; asc 19610199140-22253372566-805332; (total 60 bytes); Record lock, heap no 154 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b3f5; asc ;; 1: len 6; hex 0001343fba8f; asc 4? ;; 2: len 7; hex 41000001faa238; asc A 8;; 3: len 4; hex 800797f4; asc ;; 4: len 30; hex 36313930383530333131392d37343235333835383731392d313238363534; asc 61908503119-74253858719-128654; (total 120 bytes); 5: len 30; hex 35363738363433343635362d34333839353339313830382d343434323032; asc 56786434656-43895391808-444202; (total 60 bytes); 2020-07-18 18:05:36 927666 [Note] InnoDB: SQL1: DELETE FROM sbtest6 WHERE id=504821▒9_ 2020-07-18 18:05:36 927666 [Note] InnoDB: SQL2: INSERT INTO sbtest8 (id, k, c, pad) VALUES (501105, 504489, '60382086216-37427927808-23362194472-88750530414-83674493563-63739804813-89914782693-10180215618-74666337954-89153811067', '78467288269-83573370955-59048110655-50141141896-07036877521') 2020-07-18 18:05:36 927666 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927666 [Note] WSREP: Winning thread: THD: 927666, mode: high priority, state: exec, conflict: executing, seqno: 1144543496 SQL: DELETE FROM sbtest6 WHERE id=504821▒9_ 2020-07-18 18:05:36 927666 [Note] WSREP: Victim thread: THD: 932657, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (501105, 504489, '60382086216-37427927808-23362194472-88750530414-83674493563-63739804813-89914782693-10180215618-74666337954-89153811067', '78467288269-83573370955-59048110655-50141141896-07036877521') 2020-07-18 18:05:36 927666 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925842 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559191, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 4 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 925842, OS thread handle 140391897171712, query id 71645763 Update_rows_log_event::find_row(1144543457) UPDATE sbtest18 SET k=k+1 WHERE id=503055 2020-07-18 18:05:36 925842 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559043, ACTIVE 1 sec rollback ROLLING BACK 21 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 30 MySQL thread id 932624, OS thread handle 140371835406080, query id 71645264 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925842 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097777 page no 466 n bits 384 index PRIMARY of table `shex`.`sbtest18` trx id 5171559043 lock_mode X locks rec but not gap Record lock, heap no 146 Record lock, heap no 182 2020-07-18 18:05:36 925842 [Note] InnoDB: SQL1: UPDATE sbtest18 SET k=k+1 WHERE id=503055▒9_ 2020-07-18 18:05:36 925842 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925842 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925842 [Note] WSREP: Winning thread: THD: 925842, mode: high priority, state: exec, conflict: executing, seqno: 1144543457 SQL: UPDATE sbtest18 SET k=k+1 WHERE id=503055▒9_ 2020-07-18 18:05:36 925842 [Note] WSREP: Victim thread: THD: 932624, mode: local, state: exec, conflict: aborting, seqno: 1144543515 SQL: COMMIT 2020-07-18 18:05:36 925842 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927636 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559195, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 7 MySQL thread id 927636, OS thread handle 140390456792832, query id 71645891 Update_rows_log_event::find_row(1144543503) UPDATE sbtest11 SET k=k+1 WHERE id=498405 2020-07-18 18:05:36 927636 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559049, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 20 lock struct(s), heap size 3488, 19 row lock(s), undo log entries 30 MySQL thread id 932631, OS thread handle 140371833513728, query id 71645904 127.0.0.1 root Update INSERT INTO sbtest2 (id, k, c, pad) VALUES (499482, 494652, '55791754161-12949973519-33418253914-21110290123-44896278846-43255844159-79677937595-66192736736-80506019217-67392304247', '50882817273-94769075259-31431734447-16680590561-09279686808') 2020-07-18 18:05:36 927636 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097782 page no 469 n bits 384 index PRIMARY of table `shex`.`sbtest11` trx id 5171559049 lock_mode X locks rec but not gap Record lock, heap no 166 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079955; asc U;; 1: len 6; hex 0001343fba89; asc 4? ;; 2: len 7; hex 3b00007a1a6b0f; asc ; z k ;; 3: len 4; hex 8007a862; asc b;; 4: len 30; hex 32383531333934353835312d38353032323539303933312d373737323231; asc 28513945851-85022590931-777221; (total 120 bytes); 5: len 30; hex 33373738393439373239352d31373533383638363236392d373430333137; asc 37789497295-17538686269-740317; (total 60 bytes); Record lock, heap no 176 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079ae5; asc ;; 1: len 6; hex 0001343fba89; asc 4? ;; 2: len 7; hex 3b00007a1a6a8b; asc ; z j ;; 3: len 4; hex 80083860; asc 8`;; 4: len 30; hex 37303631303135343335322d33353635353633313134312d363931353733; asc 70610154352-35655631141-691573; (total 120 bytes); 5: len 30; hex 33363439343234363131302d32323136303538303639332d303230353936; asc 36494246110-22160580693-020596; (total 60 bytes); 2020-07-18 18:05:36 927636 [Note] InnoDB: SQL1: UPDATE sbtest11 SET k=k+1 WHERE id=498405▒9_ 2020-07-18 18:05:36 927636 [Note] InnoDB: SQL2: INSERT INTO sbtest2 (id, k, c, pad) VALUES (499482, 494652, '55791754161-12949973519-33418253914-21110290123-44896278846-43255844159-79677937595-66192736736-80506019217-67392304247', '50882817273-94769075259-31431734447-16680590561-09279686808') 2020-07-18 18:05:36 927636 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927636 [Note] WSREP: Winning thread: THD: 927636, mode: high priority, state: exec, conflict: executing, seqno: 1144543503 SQL: UPDATE sbtest11 SET k=k+1 WHERE id=498405▒9_ 2020-07-18 18:05:36 927636 [Note] WSREP: Victim thread: THD: 932631, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest2 (id, k, c, pad) VALUES (499482, 494652, '55791754161-12949973519-33418253914-21110290123-44896278846-43255844159-79677937595-66192736736-80506019217-67392304247', '50882817273-94769075259-31431734447-16680590561-09279686808') 2020-07-18 18:05:36 927636 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927469 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559197, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 927469, OS thread handle 140391075256064, query id 71645958 Update_rows_log_event::find_row(1144543485) UPDATE sbtest6 SET k=k+1 WHERE id=499285 2020-07-18 18:05:36 927469 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559036, ACTIVE 1 sec rollback ROLLING BACK 24 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 40 MySQL thread id 932604, OS thread handle 140390402098944, query id 71645839 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 927469 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 2444 n bits 312 index PRIMARY of table `shex`.`sbtest6` trx id 5171559036 lock_mode X locks rec but not gap Record lock, heap no 223 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079e55; asc U;; 1: len 6; hex 0001343fba7c; asc 4? |;; 2: len 7; hex 2e00007a0888eb; asc . z ;; 3: len 4; hex 8008bd64; asc d;; 4: len 30; hex 35313937393731323934302d32383238313236393735302d333936393331; asc 51979712940-28281269750-396931; (total 120 bytes); 5: len 30; hex 34313334373734343733372d35353332383337323932362d343332353232; asc 41347744737-55328372926-432522; (total 60 bytes); 2020-07-18 18:05:36 927469 [Note] InnoDB: SQL1: UPDATE sbtest6 SET k=k+1 WHERE id=499285▒9_ 2020-07-18 18:05:36 927469 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 927469 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927469 [Note] WSREP: Winning thread: THD: 927469, mode: high priority, state: exec, conflict: executing, seqno: 1144543485 SQL: UPDATE sbtest6 SET k=k+1 WHERE id=499285▒9_ 2020-07-18 18:05:36 927469 [Note] WSREP: Victim thread: THD: 932604, mode: local, state: exec, conflict: aborting, seqno: 1144543517 SQL: COMMIT 2020-07-18 18:05:36 927469 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925799 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559107, ACTIVE 1 sec starting index read mysql tables in use 1, locked 1 22 lock struct(s), heap size 3488, 25 row lock(s), undo log entries 41 MySQL thread id 925799, OS thread handle 140391892846336, query id 71646126 Delete_rows_log_event::find_row(1144543411) DELETE FROM sbtest6 WHERE id=498094 2020-07-18 18:05:36 925799 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558993, ACTIVE 1 sec 28 lock struct(s), heap size 3488, 34 row lock(s), undo log entries 51 MySQL thread id 932613, OS thread handle 140372484413184, query id 71638537 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925799 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 2445 n bits 296 index PRIMARY of table `shex`.`sbtest6` trx id 5171558993 lock_mode X locks rec but not gap Record lock, heap no 30 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007995e; asc ^;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80079ec3; asc ;; 4: len 30; hex 31373136373531373330362d35303034323338383136382d373238343734; asc 17167517306-50042388168-728474; (total 120 bytes); 5: len 30; hex 32303833313339363933312d32303138393036373931332d313438303331; asc 20831396931-20189067913-148031; (total 60 bytes); Record lock, heap no 53 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 800799ae; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 8007b41c; asc ;; 4: len 30; hex 32393030333638383632352d36343638373330363333362d313336313932; asc 29003688625-64687306336-136192; (total 120 bytes); 5: len 30; hex 38333738393435373835382d35343637353938353938372d393439353836; asc 83789457858-54675985987-949586; (total 60 bytes); 2020-07-18 18:05:36 925799 [Note] InnoDB: SQL1: DELETE FROM sbtest6 WHERE id=498094▒9_ 2020-07-18 18:05:36 925799 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925799 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925799 [Note] WSREP: Winning thread: THD: 925799, mode: high priority, state: exec, conflict: executing, seqno: 1144543411 SQL: DELETE FROM sbtest6 WHERE id=498094▒9_ 2020-07-18 18:05:36 925799 [Note] WSREP: Victim thread: THD: 932613, mode: local, state: exec, conflict: committing, seqno: 1144543424 SQL: COMMIT 2020-07-18 18:05:36 925799 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927574 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559372, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 19 row lock(s), undo log entries 36 MySQL thread id 927574, OS thread handle 140390809794304, query id 71651658 Write_rows_log_event::write_row(1144543551) INSERT INTO sbtest8 (id, k, c, pad) VALUES (513232, 501093, '25611988553-34735429975-70072266461-78974429356-67458523874-11192927964-07817492733-25480986342-23125085490-51389624418', '66131971106-70342735047-87207711101-08329530111-53335671366') 2020-07-18 18:05:36 927574 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559203, ACTIVE 0 sec 27 lock struct(s), heap size 3488, 26 row lock(s), undo log entries 45 MySQL thread id 932653, OS thread handle 140371827566336, query id 71651653 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 927574 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097772 page no 481 n bits 368 index PRIMARY of table `shex`.`sbtest8` trx id 5171559203 lock_mode X locks rec but not gap Record lock, heap no 302 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007d4d0; asc ;; 1: len 6; hex 0001343fbb23; asc 4? #;; 2: len 7; hex b8000175e00d71; asc u q;; 3: len 4; hex 8007a732; asc 2;; 4: len 30; hex 31303932393433333730322d37353338363638343035382d303837323936; asc 10929433702-75386684058-087296; (total 120 bytes); 5: len 30; hex 30323932333034323036372d39303431393738393235332d313638333039; asc 02923042067-90419789253-168309; (total 60 bytes); 2020-07-18 18:05:36 927574 [Note] InnoDB: SQL1: INSERT INTO sbtest8 (id, k, c, pad) VALUES (513232, 501093, '25611988553-34735429975-70072266461-78974429356-67458523874-11192927964-07817492733-25480986342-23125085490-51389624418', '66131971106-70342735047-87207711101-08329530111-53335671366')▒9_ 2020-07-18 18:05:36 927574 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 927574 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927574 [Note] WSREP: Winning thread: THD: 927574, mode: high priority, state: exec, conflict: executing, seqno: 1144543551 SQL: INSERT INTO sbtest8 (id, k, c, pad) VALUES (513232, 501093, '25611988553-34735429975-70072266461-78974429356-67458523874-11192927964-07817492733-25480986342-23125085490-51389624418', '66131971106-70342735047-87207711101-08329530111-53335671366')▒9_ 2020-07-18 18:05:36 927574 [Note] WSREP: Victim thread: THD: 932653, mode: local, state: exec, conflict: certifying, seqno: -1 SQL: COMMIT 2020-07-18 18:05:36 927574 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927399 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559433, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 927399, OS thread handle 140391880951552, query id 71652205 Update_rows_log_event::find_row(1144543591) UPDATE sbtest13 SET k=k+1 WHERE id=503543 2020-07-18 18:05:36 927399 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559201, ACTIVE 0 sec 12 lock struct(s), heap size 1128, 13 row lock(s), undo log entries 13 MySQL thread id 932666, OS thread handle 140371824051968, query id 71647293 127.0.0.1 root 2020-07-18 18:05:36 927399 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097786 page no 2522 n bits 312 index PRIMARY of table `shex`.`sbtest13` trx id 5171559201 lock_mode X locks rec but not gap Record lock, heap no 213 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ae8c; asc ;; 1: len 6; hex 0001343fbb21; asc 4? !;; 2: len 7; hex 37000175de01ec; asc 7 u ;; 3: len 4; hex 8007a579; asc y;; 4: len 30; hex 36303132393832323630312d36383130393636333331382d353131333735; asc 60129822601-68109663318-511375; (total 120 bytes); 5: len 30; hex 35383437383331303130312d31323631393138363437392d323031313235; asc 58478310101-12619186479-201125; (total 60 bytes); Record lock, heap no 239 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007aef7; asc ;; 1: len 6; hex 0001343fbb21; asc 4? !;; 2: len 7; hex 37000175de0194; asc 7 u ;; 3: len 4; hex 8007e98c; asc ;; 4: len 30; hex 35343639373335343731312d36353730383435363235302d333935373330; asc 54697354711-65708456250-395730; (total 120 bytes); 5: len 30; hex 33393130303935323138372d35373337333235333639302d303036383231; asc 39100952187-57373253690-006821; (total 60 bytes); 2020-07-18 18:05:36 927399 [Note] InnoDB: SQL1: UPDATE sbtest13 SET k=k+1 WHERE id=503543▒9_ 2020-07-18 18:05:36 927399 [Note] InnoDB: SQL2: UPDATE sbtest8 SET c='64258598082-28558639196-75944371231-61410052501-81759981422-20852747393-91085195000-69005509502-66820816329-87685225963' WHERE id=498746 2020-07-18 18:05:36 927399 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927399 [Note] WSREP: Winning thread: THD: 927399, mode: high priority, state: exec, conflict: executing, seqno: 1144543591 SQL: UPDATE sbtest13 SET k=k+1 WHERE id=503543▒9_ 2020-07-18 18:05:36 927399 [Note] WSREP: Victim thread: THD: 932666, mode: local, state: exec, conflict: executing, seqno: -1 SQL: UPDATE sbtest8 SET c='64258598082-28558639196-75944371231-61410052501-81759981422-20852747393-91085195000-69005509502-66820816329-87685225963' WHERE id=498746 2020-07-18 18:05:36 927399 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925857 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559451, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 22 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 33 MySQL thread id 925857, OS thread handle 140391893927680, query id 71653111 Delete_rows_log_event::find_row(1144543576) DELETE FROM sbtest16 WHERE id=503632 2020-07-18 18:05:36 925857 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559273, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 18 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 34 MySQL thread id 932643, OS thread handle 140371830269696, query id 71653108 127.0.0.1 root Updating DELETE FROM sbtest6 WHERE id=498054 2020-07-18 18:05:36 925857 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097771 page no 509 n bits 384 index PRIMARY of table `shex`.`sbtest16` trx id 5171559273 lock_mode X locks rec but not gap Record lock, heap no 204 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007af50; asc P;; 1: len 6; hex 0001343fbb69; asc 4? i;; 2: len 7; hex 5b00007a266740; asc [ z&g@;; 3: len 4; hex 8007b1a4; asc ;; 4: len 30; hex 36373534373333333731332d31373531383031313339352d303637363133; asc 67547333713-17518011395-067613; (total 120 bytes); 5: len 30; hex 32363933303636323233302d34343939363938323832392d333339383031; asc 26930662230-44996982829-339801; (total 60 bytes); 2020-07-18 18:05:36 925857 [Note] InnoDB: SQL1: DELETE FROM sbtest16 WHERE id=503632▒9_ 2020-07-18 18:05:36 925857 [Note] InnoDB: SQL2: DELETE FROM sbtest6 WHERE id=498054 2020-07-18 18:05:36 925857 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925857 [Note] WSREP: Winning thread: THD: 925857, mode: high priority, state: exec, conflict: executing, seqno: 1144543576 SQL: DELETE FROM sbtest16 WHERE id=503632▒9_ 2020-07-18 18:05:36 925857 [Note] WSREP: Victim thread: THD: 932643, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest6 WHERE id=498054 2020-07-18 18:05:36 925857 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927523 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559493, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 12 MySQL thread id 927523, OS thread handle 140390942660352, query id 71653991 Update_rows_log_event::find_row(1144543644) UPDATE sbtest3 SET c='24056305850-16509361374-27207586228-11791315937-24052549548-76952765230-01740178296-80606504341-09315596968-70636083156' WHERE id=501910 2020-07-18 18:05:36 927523 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559377, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 17 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 29 MySQL thread id 932597, OS thread handle 140391087691520, query id 71653850 127.0.0.1 root Update INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927523 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097792 page no 2936 n bits 320 index PRIMARY of table `shex`.`sbtest3` trx id 5171559377 lock_mode X locks rec but not gap Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a896; asc ;; 1: len 6; hex 0001343fbbd1; asc 4? ;; 2: len 7; hex 1800007a3d3664; asc z=6d;; 3: len 4; hex 8007a427; asc ';; 4: len 30; hex 35333435333238383537382d30343336393432323132362d333235313233; asc 53453288578-04369422126-325123; (total 120 bytes); 5: len 30; hex 35383330373630323239332d33393432303530343731332d303036303534; asc 58307602293-39420504713-006054; (total 60 bytes); 2020-07-18 18:05:36 927523 [Note] InnoDB: SQL1: UPDATE sbtest3 SET c='24056305850-16509361374-27207586228-11791315937-24052549548-76952765230-01740178296-80606504341-09315596968-70636083156' WHERE id=501910▒9_ 2020-07-18 18:05:36 927523 [Note] InnoDB: SQL2: INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927523 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927523 [Note] WSREP: Winning thread: THD: 927523, mode: high priority, state: exec, conflict: executing, seqno: 1144543644 SQL: UPDATE sbtest3 SET c='24056305850-16509361374-27207586228-11791315937-24052549548-76952765230-01740178296-80606504341-09315596968-70636083156' WHERE id=501910▒9_ 2020-07-18 18:05:36 927523 [Note] WSREP: Victim thread: THD: 932597, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927523 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927549 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559477, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 17 lock struct(s), heap size 1128, 19 row lock(s), undo log entries 25 MySQL thread id 927549, OS thread handle 140390816823040, query id 71654014 Delete_rows_log_event::find_row(1144543602) DELETE FROM sbtest20 WHERE id=504173 2020-07-18 18:05:36 927549 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559304, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 20 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 40 MySQL thread id 932651, OS thread handle 140371828107008, query id 71654004 127.0.0.1 root Update INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927549 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097787 page no 4480 n bits 320 index PRIMARY of table `shex`.`sbtest20` trx id 5171559304 lock_mode X locks rec but not gap Record lock, heap no 199 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b16d; asc m;; 1: len 6; hex 0001343fbb88; asc 4? ;; 2: len 7; hex 77000001feaa43; asc w C;; 3: len 4; hex 8005cdb8; asc ;; 4: len 30; hex 37323437353736363336362d33303031383632323034312d313730373030; asc 72475766366-30018622041-170700; (total 120 bytes); 5: len 30; hex 35363836373335333136302d38393337333939323337372d313236383137; asc 56867353160-89373992377-126817; (total 60 bytes); 2020-07-18 18:05:36 927549 [Note] InnoDB: SQL1: DELETE FROM sbtest20 WHERE id=504173▒9_ 2020-07-18 18:05:36 927549 [Note] InnoDB: SQL2: INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927549 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927549 [Note] WSREP: Winning thread: THD: 927549, mode: high priority, state: exec, conflict: executing, seqno: 1144543602 SQL: DELETE FROM sbtest20 WHERE id=504173▒9_ 2020-07-18 18:05:36 927549 [Note] WSREP: Victim thread: THD: 932651, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927549 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927577 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559536, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 4 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 5 MySQL thread id 927577, OS thread handle 140390810334976, query id 71654296 Update_rows_log_event::find_row(1144543607) UPDATE sbtest19 SET k=k+1 WHERE id=502804 2020-07-18 18:05:36 927577 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559304, ACTIVE 0 sec rollback ROLLING BACK 20 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 35 MySQL thread id 932651, OS thread handle 140371828107008, query id 71654004 127.0.0.1 root Freeing items INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927577 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097790 page no 469 n bits 384 index PRIMARY of table `shex`.`sbtest19` trx id 5171559304 lock_mode X locks rec but not gap Record lock, heap no 215 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007ac14; asc ;; 1: len 6; hex 0001343fbb88; asc 4? ;; 2: len 7; hex 77000001fea56b; asc w k;; 3: len 4; hex 8007ae39; asc 9;; 4: len 30; hex 39323536363734363432362d31333536373136313436392d363233353330; asc 92566746426-13567161469-623530; (total 120 bytes); 5: len 30; hex 32373230373431353134342d36393535353335343732392d373932303137; asc 27207415144-69555354729-792017; (total 60 bytes); 2020-07-18 18:05:36 927577 [Note] InnoDB: SQL1: UPDATE sbtest19 SET k=k+1 WHERE id=502804▒9_ 2020-07-18 18:05:36 927577 [Note] InnoDB: SQL2: INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927577 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927577 [Note] WSREP: Winning thread: THD: 927577, mode: high priority, state: exec, conflict: executing, seqno: 1144543607 SQL: UPDATE sbtest19 SET k=k+1 WHERE id=502804▒9_ 2020-07-18 18:05:36 927577 [Note] WSREP: Victim thread: THD: 932651, mode: local, state: exec, conflict: aborting, seqno: -1 SQL: INSERT INTO sbtest7 (id, k, c, pad) VALUES (504195, 567708, '91286824491-86804280338-31821446776-38106856183-46912607520-52426435982-39300019737-25651789837-36661316094-94505122717', '11496969363-97381944495-65481657297-68618443049-38283260837') 2020-07-18 18:05:36 927577 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927392 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559505, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 16 row lock(s), undo log entries 16 MySQL thread id 927392, OS thread handle 140391888520960, query id 71654479 Update_rows_log_event::find_row(1144543629) UPDATE sbtest4 SET c='29737959638-33958984803-40843773222-04140930894-63229043130-34150667571-12123933223-54624024572-59612961509-18176946874' WHERE id=501490 2020-07-18 18:05:36 927392 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559334, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 20 lock struct(s), heap size 3488, 22 row lock(s), undo log entries 39 MySQL thread id 932590, OS thread handle 140391207855872, query id 71654491 127.0.0.1 root Update INSERT INTO sbtest4 (id, k, c, pad) VALUES (504842, 436699, '68760661366-14059343291-50969400108-65851166682-20902701208-67664961339-37711377301-60753284925-37635584873-02716181638', '79704955830-13474143202-44414900704-74061863029-44226820113') 2020-07-18 18:05:36 927392 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097779 page no 501 n bits 384 index PRIMARY of table `shex`.`sbtest4` trx id 5171559334 lock_mode X locks rec but not gap Record lock, heap no 67 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a6f2; asc ;; 1: len 6; hex 0001343fbba6; asc 4? ;; 2: len 7; hex 090000d1010aef; asc ;; 3: len 4; hex 80080cf0; asc ;; 4: len 30; hex 37373538313234383435352d33363032303231363631362d323731323431; asc 77581248455-36020216616-271241; (total 120 bytes); 5: len 30; hex 30343938313732323338392d30313538333733303632322d363637393332; asc 04981722389-01583730622-667932; (total 60 bytes); 2020-07-18 18:05:36 927392 [Note] InnoDB: SQL1: UPDATE sbtest4 SET c='29737959638-33958984803-40843773222-04140930894-63229043130-34150667571-12123933223-54624024572-59612961509-18176946874' WHERE id=501490▒9_ 2020-07-18 18:05:36 927392 [Note] InnoDB: SQL2: INSERT INTO sbtest4 (id, k, c, pad) VALUES (504842, 436699, '68760661366-14059343291-50969400108-65851166682-20902701208-67664961339-37711377301-60753284925-37635584873-02716181638', '79704955830-13474143202-44414900704-74061863029-44226820113') 2020-07-18 18:05:36 927392 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927392 [Note] WSREP: Winning thread: THD: 927392, mode: high priority, state: exec, conflict: executing, seqno: 1144543629 SQL: UPDATE sbtest4 SET c='29737959638-33958984803-40843773222-04140930894-63229043130-34150667571-12123933223-54624024572-59612961509-18176946874' WHERE id=501490▒9_ 2020-07-18 18:05:36 927392 [Note] WSREP: Victim thread: THD: 932590, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (504842, 436699, '68760661366-14059343291-50969400108-65851166682-20902701208-67664961339-37711377301-60753284925-37635584873-02716181638', '79704955830-13474143202-44414900704-74061863029-44226820113') 2020-07-18 18:05:36 927392 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927633 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559527, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 13 row lock(s), undo log entries 13 MySQL thread id 927633, OS thread handle 140390457603840, query id 71654625 Update_rows_log_event::find_row(1144543601) UPDATE sbtest3 SET c='43705708265-69232944224-58391389074-75806611997-31912309692-70057163418-07529736279-50714070538-21064616226-69246589365' WHERE id=501340 2020-07-18 18:05:36 927633 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559377, ACTIVE 0 sec rollback ROLLING BACK 17 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 4 MySQL thread id 932597, OS thread handle 140391087691520, query id 71653850 127.0.0.1 root Freeing items INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927633 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097792 page no 466 n bits 384 index PRIMARY of table `shex`.`sbtest3` trx id 5171559377 lock_mode X locks rec but not gap Record lock, heap no 185 2020-07-18 18:05:36 927633 [Note] InnoDB: SQL1: UPDATE sbtest3 SET c='43705708265-69232944224-58391389074-75806611997-31912309692-70057163418-07529736279-50714070538-21064616226-69246589365' WHERE id=501340▒9_ 2020-07-18 18:05:36 927633 [Note] InnoDB: SQL2: INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927633 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927633 [Note] WSREP: Winning thread: THD: 927633, mode: high priority, state: exec, conflict: executing, seqno: 1144543601 SQL: UPDATE sbtest3 SET c='43705708265-69232944224-58391389074-75806611997-31912309692-70057163418-07529736279-50714070538-21064616226-69246589365' WHERE id=501340▒9_ 2020-07-18 18:05:36 927633 [Note] WSREP: Victim thread: THD: 932597, mode: local, state: exec, conflict: aborting, seqno: -1 SQL: INSERT INTO sbtest4 (id, k, c, pad) VALUES (498875, 504585, '07903495070-06714745135-46781878979-05380804884-96287059951-00794867362-36850126433-94239768012-24227829228-99430602053', '45215290583-97051501631-61709655781-08704025672-63059322488') 2020-07-18 18:05:36 927633 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927479 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559559, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 4 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 927479, OS thread handle 140390954284800, query id 71655052 Update_rows_log_event::find_row(1144543580) UPDATE sbtest6 SET k=k+1 WHERE id=498160 2020-07-18 18:05:36 927479 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559184, ACTIVE 0 sec rollback ROLLING BACK 24 lock struct(s), heap size 3488, 26 row lock(s), undo log entries 27 MySQL thread id 932615, OS thread handle 140372483872512, query id 71654170 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 927479 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 2445 n bits 304 index PRIMARY of table `shex`.`sbtest6` trx id 5171559184 lock_mode X locks rec but not gap Record lock, heap no 232 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 800799f0; asc ;; 1: len 6; hex 0001343fbb10; asc 4? ;; 2: len 7; hex 2d000175d70194; asc - u ;; 3: len 4; hex 80079cd7; asc ;; 4: len 30; hex 31343336343936383538332d35393631363836383531332d393232363739; asc 14364968583-59616868513-922679; (total 120 bytes); 5: len 30; hex 34363134323538333532342d37323739343738313032302d373132373639; asc 46142583524-72794781020-712769; (total 60 bytes); 2020-07-18 18:05:36 927479 [Note] InnoDB: SQL1: UPDATE sbtest6 SET k=k+1 WHERE id=498160▒9_ 2020-07-18 18:05:36 927479 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 927479 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927479 [Note] WSREP: Winning thread: THD: 927479, mode: high priority, state: exec, conflict: executing, seqno: 1144543580 SQL: UPDATE sbtest6 SET k=k+1 WHERE id=498160▒9_ 2020-07-18 18:05:36 927479 [Note] WSREP: Victim thread: THD: 932615, mode: local, state: exec, conflict: aborting, seqno: 1144543934 SQL: COMMIT 2020-07-18 18:05:36 927479 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927549 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559477, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 18 lock struct(s), heap size 3488, 20 row lock(s), undo log entries 27 MySQL thread id 927549, OS thread handle 140390816823040, query id 71655177 Write_rows_log_event::write_row(1144543602) INSERT INTO sbtest20 (id, k, c, pad) VALUES (501293, 503750, '25554435793-53869022393-93950715345-08197401561-67685116689-81048874887-49780696229-89838758938-37148736086-34745800337', '10966383504-88537558116-80009259845-59382744527-18909948783') 2020-07-18 18:05:36 927549 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559459, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 21 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 34 MySQL thread id 932666, OS thread handle 140371824051968, query id 71655062 127.0.0.1 root Update INSERT INTO sbtest20 (id, k, c, pad) VALUES (503898, 502603, '22968674229-41369579636-45686810110-41202998824-76929432389-07313886577-18775030849-09926385040-59415176012-95304929728', '19757068811-54948258626-54056309750-11877127869-19466541855') 2020-07-18 18:05:36 927549 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097787 page no 466 n bits 384 index PRIMARY of table `shex`.`sbtest20` trx id 5171559459 lock_mode X locks rec but not gap Record lock, heap no 222 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a62d; asc -;; 1: len 6; hex 0001343fbc23; asc 4? #;; 2: len 7; hex b5000175dd17f2; asc u ;; 3: len 4; hex 8007a564; asc d;; 4: len 30; hex 33363633353138373932372d33353833353533383434322d353139373030; asc 36635187927-35835538442-519700; (total 120 bytes); 5: len 30; hex 30383238363939343136372d33313137373733303839372d343537313333; asc 08286994167-31177730897-457133; (total 60 bytes); 2020-07-18 18:05:36 927549 [Note] InnoDB: SQL1: INSERT INTO sbtest20 (id, k, c, pad) VALUES (501293, 503750, '25554435793-53869022393-93950715345-08197401561-67685116689-81048874887-49780696229-89838758938-37148736086-34745800337', '10966383504-88537558116-80009259845-59382744527-18909948783')▒9_ 2020-07-18 18:05:36 927549 [Note] InnoDB: SQL2: INSERT INTO sbtest20 (id, k, c, pad) VALUES (503898, 502603, '22968674229-41369579636-45686810110-41202998824-76929432389-07313886577-18775030849-09926385040-59415176012-95304929728', '19757068811-54948258626-54056309750-11877127869-19466541855') 2020-07-18 18:05:36 927549 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927549 [Note] WSREP: Winning thread: THD: 927549, mode: high priority, state: exec, conflict: executing, seqno: 1144543602 SQL: INSERT INTO sbtest20 (id, k, c, pad) VALUES (501293, 503750, '25554435793-53869022393-93950715345-08197401561-67685116689-81048874887-49780696229-89838758938-37148736086-34745800337', '10966383504-88537558116-80009259845-59382744527-18909948783')▒9_ 2020-07-18 18:05:36 927549 [Note] WSREP: Victim thread: THD: 932666, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest20 (id, k, c, pad) VALUES (503898, 502603, '22968674229-41369579636-45686810110-41202998824-76929432389-07313886577-18775030849-09926385040-59415176012-95304929728', '19757068811-54948258626-54056309750-11877127869-19466541855') 2020-07-18 18:05:36 927549 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925812 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559597, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 5 MySQL thread id 925812, OS thread handle 140391734564608, query id 71656034 Update_rows_log_event::find_row(1144543859) UPDATE sbtest17 SET c='33977206877-31451939313-18339939426-86373888510-61355905845-76702900505-98846419604-10397609334-17501898073-15247220745' WHERE id=499666 2020-07-18 18:05:36 925812 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559166, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 22 lock struct(s), heap size 3488, 20 row lock(s), undo log entries 25 MySQL thread id 932635, OS thread handle 140371832432384, query id 71656044 127.0.0.1 root Update INSERT INTO sbtest6 (id, k, c, pad) VALUES (503416, 500480, '27881755189-96090376460-10753781405-01258242304-72053832410-62114805202-02362995990-80093393357-44632288633-53007440128', '11658085612-15052406581-22821150104-80893664258-48064968507') 2020-07-18 18:05:36 925812 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097785 page no 1507 n bits 312 index PRIMARY of table `shex`.`sbtest17` trx id 5171559166 lock_mode X locks rec but not gap Record lock, heap no 88 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079fd2; asc ;; 1: len 6; hex 0001343fbafe; asc 4? ;; 2: len 7; hex 28000175d10218; asc ( u ;; 3: len 4; hex 8007b17c; asc |;; 4: len 30; hex 34323436313637393733372d37383131393337313233352d383734313730; asc 42461679737-78119371235-874170; (total 120 bytes); 5: len 30; hex 35363934373136383031362d38313834333630333935332d363132363939; asc 56947168016-81843603953-612699; (total 60 bytes); 2020-07-18 18:05:36 925812 [Note] InnoDB: SQL1: UPDATE sbtest17 SET c='33977206877-31451939313-18339939426-86373888510-61355905845-76702900505-98846419604-10397609334-17501898073-15247220745' WHERE id=499666▒9_ 2020-07-18 18:05:36 925812 [Note] InnoDB: SQL2: INSERT INTO sbtest6 (id, k, c, pad) VALUES (503416, 500480, '27881755189-96090376460-10753781405-01258242304-72053832410-62114805202-02362995990-80093393357-44632288633-53007440128', '11658085612-15052406581-22821150104-80893664258-48064968507') 2020-07-18 18:05:36 925812 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925812 [Note] WSREP: Winning thread: THD: 925812, mode: high priority, state: exec, conflict: executing, seqno: 1144543859 SQL: UPDATE sbtest17 SET c='33977206877-31451939313-18339939426-86373888510-61355905845-76702900505-98846419604-10397609334-17501898073-15247220745' WHERE id=499666▒9_ 2020-07-18 18:05:36 925812 [Note] WSREP: Victim thread: THD: 932635, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (503416, 500480, '27881755189-96090376460-10753781405-01258242304-72053832410-62114805202-02362995990-80093393357-44632288633-53007440128', '11658085612-15052406581-22821150104-80893664258-48064968507') 2020-07-18 18:05:36 925812 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927578 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559673, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 927578, OS thread handle 140390809253632, query id 71657597 Update_rows_log_event::find_row(1144543667) UPDATE sbtest4 SET k=k+1 WHERE id=504805 2020-07-18 18:05:36 927578 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559566, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 19 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 32 MySQL thread id 932663, OS thread handle 140371824862976, query id 71657627 127.0.0.1 root Update INSERT INTO sbtest11 (id, k, c, pad) VALUES (499475, 530898, '18202899213-45816944921-60963672534-55021583733-29557666519-79531455451-64207181255-08346649974-12958928351-63240293495', '85400256270-86559730454-94593734688-60924513916-83908519836') 2020-07-18 18:05:36 927578 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097779 page no 1546 n bits 368 index PRIMARY of table `shex`.`sbtest4` trx id 5171559566 lock_mode X locks rec but not gap Record lock, heap no 184 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b2c8; asc ;; 1: len 6; hex 0001343fbc8e; asc 4? ;; 2: len 7; hex 670000d12c0270; asc g , p;; 3: len 4; hex 80078b2f; asc /;; 4: len 30; hex 33373932323737383437362d31383333363032393331312d313734313432; asc 37922778476-18336029311-174142; (total 120 bytes); 5: len 30; hex 39373338393638353938382d38323938313437313631392d393337313137; asc 97389685988-82981471619-937117; (total 60 bytes); Record lock, heap no 244 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b3e5; asc ;; 1: len 6; hex 0001343fbc8e; asc 4? ;; 2: len 7; hex 670000d12c0600; asc g , ;; 3: len 4; hex 80078b70; asc p;; 4: len 30; hex 33383532373334303532302d35343933363734373930312d313330353239; asc 38527340520-54936747901-130529; (total 120 bytes); 5: len 30; hex 31333733333831313832342d35323236333938303437362d353235333832; asc 13733811824-52263980476-525382; (total 60 bytes); Record lock, heap no 251 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b3ef; asc ;; 1: len 6; hex 0001343fbc8e; asc 4? ;; 2: len 7; hex 670000d12c03a0; asc g , ;; 3: len 4; hex 8007a279; asc y;; 4: len 30; hex 39323636353734363133372d39323430383338383331392d353637363932; asc 92665746137-92408388319-567692; (total 120 bytes); 5: len 30; hex 37303737393337353432322d39323532333433353633382d353138373935; asc 70779375422-92523435638-518795; (total 60 bytes); 2020-07-18 18:05:36 927578 [Note] InnoDB: SQL1: UPDATE sbtest4 SET k=k+1 WHERE id=504805▒9_ 2020-07-18 18:05:36 927578 [Note] InnoDB: SQL2: INSERT INTO sbtest11 (id, k, c, pad) VALUES (499475, 530898, '18202899213-45816944921-60963672534-55021583733-29557666519-79531455451-64207181255-08346649974-12958928351-63240293495', '85400256270-86559730454-94593734688-60924513916-83908519836') 2020-07-18 18:05:36 927578 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927578 [Note] WSREP: Winning thread: THD: 927578, mode: high priority, state: exec, conflict: executing, seqno: 1144543667 SQL: UPDATE sbtest4 SET k=k+1 WHERE id=504805▒9_ 2020-07-18 18:05:36 927578 [Note] WSREP: Victim thread: THD: 932663, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest11 (id, k, c, pad) VALUES (499475, 530898, '18202899213-45816944921-60963672534-55021583733-29557666519-79531455451-64207181255-08346649974-12958928351-63240293495', '85400256270-86559730454-94593734688-60924513916-83908519836') 2020-07-18 18:05:36 927578 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925889 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559718, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 13 row lock(s), undo log entries 13 MySQL thread id 925889, OS thread handle 140436280792832, query id 71658938 Update_rows_log_event::find_row(1144543691) UPDATE sbtest3 SET c='93783726292-78177159047-56019472267-69072115080-21294711444-09139835701-66454027527-08304638017-03034329117-78544790192' WHERE id=498866 2020-07-18 18:05:36 925889 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559600, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 14 lock struct(s), heap size 1128, 13 row lock(s), undo log entries 13 MySQL thread id 932666, OS thread handle 140371824051968, query id 71658952 127.0.0.1 root Updating UPDATE sbtest3 SET c='01940475327-16098908882-31541702194-83106437235-49710115287-22131357961-02952411645-30311327321-82768181486-54348342144' WHERE id=501774 2020-07-18 18:05:36 925889 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097792 page no 2934 n bits 320 index PRIMARY of table `shex`.`sbtest3` trx id 5171559600 lock_mode X locks rec but not gap Record lock, heap no 155 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079cb2; asc ;; 1: len 6; hex 0001343fbcb0; asc 4? ;; 2: len 7; hex 77000001fea831; asc w 1;; 3: len 4; hex 80079971; asc q;; 4: len 30; hex 31303533353830363034302d31383930353638363131382d393437393231; asc 10535806040-18905686118-947921; (total 120 bytes); 5: len 30; hex 34363736393639303837312d34343835323635303337312d383336333732; asc 46769690871-44852650371-836372; (total 60 bytes); 2020-07-18 18:05:36 925889 [Note] InnoDB: SQL1: UPDATE sbtest3 SET c='93783726292-78177159047-56019472267-69072115080-21294711444-09139835701-66454027527-08304638017-03034329117-78544790192' WHERE id=498866▒9_ 2020-07-18 18:05:36 925889 [Note] InnoDB: SQL2: UPDATE sbtest3 SET c='01940475327-16098908882-31541702194-83106437235-49710115287-22131357961-02952411645-30311327321-82768181486-54348342144' WHERE id=501774 2020-07-18 18:05:36 925889 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925889 [Note] WSREP: Winning thread: THD: 925889, mode: high priority, state: exec, conflict: executing, seqno: 1144543691 SQL: UPDATE sbtest3 SET c='93783726292-78177159047-56019472267-69072115080-21294711444-09139835701-66454027527-08304638017-03034329117-78544790192' WHERE id=498866▒9_ 2020-07-18 18:05:36 925889 [Note] WSREP: Victim thread: THD: 932666, mode: local, state: exec, conflict: executing, seqno: -1 SQL: UPDATE sbtest3 SET c='01940475327-16098908882-31541702194-83106437235-49710115287-22131357961-02952411645-30311327321-82768181486-54348342144' WHERE id=501774 2020-07-18 18:05:36 925889 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927567 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559759, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 14 lock struct(s), heap size 1128, 13 row lock(s), undo log entries 13 MySQL thread id 927567, OS thread handle 140390812227328, query id 71659716 Update_rows_log_event::find_row(1144543882) UPDATE sbtest6 SET c='97939803516-55613745407-42737310134-03658990295-01020579543-83903495695-48308722180-87002441861-27231149298-16005255533' WHERE id=503510 2020-07-18 18:05:36 927567 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559065, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 18 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 34 MySQL thread id 932650, OS thread handle 140371828377344, query id 71659664 127.0.0.1 root Update INSERT INTO sbtest6 (id, k, c, pad) VALUES (501792, 504611, '67158717818-59868647591-68558768812-02208762303-14449094361-71920042750-22094913192-66114679645-99362729851-17502729821', '67077643365-45894792584-25008398288-70013853684-45101616836') 2020-07-18 18:05:36 927567 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 464 n bits 384 index PRIMARY of table `shex`.`sbtest6` trx id 5171559065 lock_mode X locks rec but not gap Record lock, heap no 73 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007aed6; asc ;; 1: len 6; hex 0001343fba99; asc 4? ;; 2: len 7; hex 4b00007a343ef1; asc K z4> ;; 3: len 4; hex 800918f3; asc ;; 4: len 30; hex 31353030313531323432302d35303233333739333536392d353037383532; asc 15001512420-50233793569-507852; (total 120 bytes); 5: len 30; hex 38333835313530333639362d33373334373331333831362d363639303332; asc 83851503696-37347313816-669032; (total 60 bytes); 2020-07-18 18:05:36 927567 [Note] InnoDB: SQL1: UPDATE sbtest6 SET c='97939803516-55613745407-42737310134-03658990295-01020579543-83903495695-48308722180-87002441861-27231149298-16005255533' WHERE id=503510▒9_ 2020-07-18 18:05:36 927567 [Note] InnoDB: SQL2: INSERT INTO sbtest6 (id, k, c, pad) VALUES (501792, 504611, '67158717818-59868647591-68558768812-02208762303-14449094361-71920042750-22094913192-66114679645-99362729851-17502729821', '67077643365-45894792584-25008398288-70013853684-45101616836') 2020-07-18 18:05:36 927567 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927567 [Note] WSREP: Winning thread: THD: 927567, mode: high priority, state: exec, conflict: executing, seqno: 1144543882 SQL: UPDATE sbtest6 SET c='97939803516-55613745407-42737310134-03658990295-01020579543-83903495695-48308722180-87002441861-27231149298-16005255533' WHERE id=503510▒9_ 2020-07-18 18:05:36 927567 [Note] WSREP: Victim thread: THD: 932650, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest6 (id, k, c, pad) VALUES (501792, 504611, '67158717818-59868647591-68558768812-02208762303-14449094361-71920042750-22094913192-66114679645-99362729851-17502729821', '67077643365-45894792584-25008398288-70013853684-45101616836') 2020-07-18 18:05:36 927567 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927533 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559781, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 12 MySQL thread id 927533, OS thread handle 140390939686656, query id 71661017 Update_rows_log_event::find_row(1144543694) UPDATE sbtest15 SET c='80185564690-58912225897-45897205636-07064101541-04786528835-82713290312-75371895861-42085688239-76457928347-87836681147' WHERE id=498378 2020-07-18 18:05:36 927533 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558998, ACTIVE 1 sec 20 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 39 MySQL thread id 932600, OS thread handle 140391087421184, query id 71638652 127.0.0.1 root 2020-07-18 18:05:36 927533 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097784 page no 1279 n bits 312 index PRIMARY of table `shex`.`sbtest15` trx id 5171558998 lock_mode X locks rec but not gap Record lock, heap no 76 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079a9a; asc ;; 1: len 6; hex 0001343fba56; asc 4? V;; 2: len 7; hex 0b00007a2c380a; asc z,8 ;; 3: len 4; hex 8007a0ff; asc ;; 4: len 30; hex 30363437373038343833382d37383539343732343236322d313335323038; asc 06477084838-78594724262-135208; (total 120 bytes); 5: len 30; hex 39363630333533383338332d34303537393633363139372d373234333939; asc 96603538383-40579636197-724399; (total 60 bytes); Record lock, heap no 90 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079aca; asc ;; 1: len 6; hex 0001343fba56; asc 4? V;; 2: len 7; hex 0b00007a2c388e; asc z,8 ;; 3: len 4; hex 800799d9; asc ;; 4: len 30; hex 32313230363031363633362d39303235333536353933392d313834303130; asc 21206016636-90253565939-184010; (total 120 bytes); 5: len 30; hex 30313438393536363836372d31343334343435333638302d373938323838; asc 01489566867-14344453680-798288; (total 60 bytes); Record lock, heap no 97 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079ae6; asc ;; 1: len 6; hex 0001343fba56; asc 4? V;; 2: len 7; hex 0b00007a2c3862; asc z,8b;; 3: len 4; hex 80079a79; asc y;; 4: len 30; hex 39333433373538363136392d33323138343437303331322d323436363632; asc 93437586169-32184470312-246662; (total 120 bytes); 5: len 30; hex 33323338303034393634332d32333533303833363931382d303338383233; asc 32380049643-23530836918-038823; (total 60 bytes); 2020-07-18 18:05:36 927533 [Note] InnoDB: SQL1: UPDATE sbtest15 SET c='80185564690-58912225897-45897205636-07064101541-04786528835-82713290312-75371895861-42085688239-76457928347-87836681147' WHERE id=498378▒9_ 2020-07-18 18:05:36 927533 [Note] InnoDB: SQL2: NULL 2020-07-18 18:05:36 927533 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927533 [Note] WSREP: Winning thread: THD: 927533, mode: high priority, state: exec, conflict: executing, seqno: 1144543694 SQL: UPDATE sbtest15 SET c='80185564690-58912225897-45897205636-07064101541-04786528835-82713290312-75371895861-42085688239-76457928347-87836681147' WHERE id=498378▒9_ 2020-07-18 18:05:36 927533 [Note] WSREP: Victim thread: THD: 932600, mode: local, state: idle, conflict: executing, seqno: -1 SQL: NULL 2020-07-18 18:05:36 927533 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925913 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559775, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 26 MySQL thread id 925913, OS thread handle 140436274034432, query id 71661102 Write_rows_log_event::write_row(1144543803) INSERT INTO sbtest20 (id, k, c, pad) VALUES (504171, 504660, '92673273964-29454741038-37875394555-01467036492-18705009273-28883288714-04180467822-77861533630-75138190144-50571586052', '83761172458-58228903173-20770333942-40969728413-70875206497') 2020-07-18 18:05:36 925913 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558998, ACTIVE 1 sec rollback ROLLING BACK 21 lock struct(s), heap size 3488, 25 row lock(s), undo log entries 36 MySQL thread id 932600, OS thread handle 140440667997952, query id 71638652 127.0.0.1 root 2020-07-18 18:05:36 925913 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097787 page no 4480 n bits 320 index PRIMARY of table `shex`.`sbtest20` trx id 5171558998 lock_mode X locks rec but not gap Record lock, heap no 235 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007b16b; asc k;; 1: len 6; hex 0001343fba56; asc 4? V;; 2: len 7; hex 8b00007a2c4151; asc z,AQ;; 3: len 4; hex 800798c1; asc ;; 4: len 30; hex 31393731323735393639342d30323436343633343539392d323739343734; asc 19712759694-02464634599-279474; (total 120 bytes); 5: len 30; hex 30303838343737383531362d31333131353332393237392d363235373434; asc 00884778516-13115329279-625744; (total 60 bytes); 2020-07-18 18:05:36 925913 [Note] InnoDB: SQL1: INSERT INTO sbtest20 (id, k, c, pad) VALUES (504171, 504660, '92673273964-29454741038-37875394555-01467036492-18705009273-28883288714-04180467822-77861533630-75138190144-50571586052', '83761172458-58228903173-20770333942-40969728413-70875206497')▒9_ 2020-07-18 18:05:36 925913 [Note] InnoDB: SQL2: NULL 2020-07-18 18:05:36 925913 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925913 [Note] WSREP: Winning thread: THD: 925913, mode: high priority, state: exec, conflict: executing, seqno: 1144543803 SQL: INSERT INTO sbtest20 (id, k, c, pad) VALUES (504171, 504660, '92673273964-29454741038-37875394555-01467036492-18705009273-28883288714-04180467822-77861533630-75138190144-50571586052', '83761172458-58228903173-20770333942-40969728413-70875206497')▒9_ 2020-07-18 18:05:36 925913 [Note] WSREP: Victim thread: THD: 932600, mode: local, state: idle, conflict: aborting, seqno: -1 SQL: NULL 2020-07-18 18:05:36 925913 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927381 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559839, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 12 MySQL thread id 927381, OS thread handle 140391897712384, query id 71661478 Update_rows_log_event::find_row(1144543921) UPDATE sbtest20 SET c='04572496363-44639454018-88960184324-11350857410-89575295304-03119553992-20947145661-55334956308-17477048111-18372815777' WHERE id=498430 2020-07-18 18:05:36 927381 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171558998, ACTIVE 1 sec rollback ROLLING BACK 21 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 21 MySQL thread id 932600, OS thread handle 140440667997952, query id 71638652 127.0.0.1 root 2020-07-18 18:05:36 927381 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097787 page no 2054 n bits 304 index PRIMARY of table `shex`.`sbtest20` trx id 5171558998 lock_mode X locks rec but not gap Record lock, heap no 136 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 80079afe; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80046490; asc d ;; 4: len 30; hex 39313031323636383831342d36303431343230303035362d373731333230; asc 91012668814-60414200056-771320; (total 120 bytes); 5: len 30; hex 39343930303737313738392d32383034343336383030352d323232333635; asc 94900771789-28044368005-222365; (total 60 bytes); 2020-07-18 18:05:36 927381 [Note] InnoDB: SQL1: UPDATE sbtest20 SET c='04572496363-44639454018-88960184324-11350857410-89575295304-03119553992-20947145661-55334956308-17477048111-18372815777' WHERE id=498430▒9_ 2020-07-18 18:05:36 927381 [Note] InnoDB: SQL2: NULL 2020-07-18 18:05:36 927381 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927381 [Note] WSREP: Winning thread: THD: 927381, mode: high priority, state: exec, conflict: executing, seqno: 1144543921 SQL: UPDATE sbtest20 SET c='04572496363-44639454018-88960184324-11350857410-89575295304-03119553992-20947145661-55334956308-17477048111-18372815777' WHERE id=498430▒9_ 2020-07-18 18:05:36 927381 [Note] WSREP: Victim thread: THD: 932600, mode: local, state: idle, conflict: aborting, seqno: -1 SQL: NULL 2020-07-18 18:05:36 927381 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925808 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171559987, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 4 MySQL thread id 925808, OS thread handle 140391737808640, query id 71664522 Update_rows_log_event::find_row(1144543806) UPDATE sbtest2 SET k=k+1 WHERE id=503490 2020-07-18 18:05:36 925808 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559889, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 18 lock struct(s), heap size 1128, 20 row lock(s), undo log entries 25 MySQL thread id 932589, OS thread handle 140391088232192, query id 71664527 127.0.0.1 root Updating DELETE FROM sbtest5 WHERE id=498412 2020-07-18 18:05:36 925808 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097780 page no 471 n bits 384 index PRIMARY of table `shex`.`sbtest2` trx id 5171559889 lock_mode X locks rec but not gap Record lock, heap no 145 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007aec2; asc ;; 1: len 6; hex 0001343fbdd1; asc 4? ;; 2: len 7; hex 01000175fe1152; asc u R;; 3: len 4; hex 8007b059; asc Y;; 4: len 30; hex 37343735363437323533312d32373037393033363035312d363033363737; asc 74756472531-27079036051-603677; (total 120 bytes); 5: len 30; hex 39383430323037303537372d32393539323435393235392d303439333932; asc 98402070577-29592459259-049392; (total 60 bytes); 2020-07-18 18:05:36 925808 [Note] InnoDB: SQL1: UPDATE sbtest2 SET k=k+1 WHERE id=503490▒9_ 2020-07-18 18:05:36 925808 [Note] InnoDB: SQL2: DELETE FROM sbtest5 WHERE id=498412 2020-07-18 18:05:36 925808 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925808 [Note] WSREP: Winning thread: THD: 925808, mode: high priority, state: exec, conflict: executing, seqno: 1144543806 SQL: UPDATE sbtest2 SET k=k+1 WHERE id=503490▒9_ 2020-07-18 18:05:36 925808 [Note] WSREP: Victim thread: THD: 932589, mode: local, state: exec, conflict: executing, seqno: -1 SQL: DELETE FROM sbtest5 WHERE id=498412 2020-07-18 18:05:36 925808 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925806 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171560102, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 11 lock struct(s), heap size 1128, 11 row lock(s), undo log entries 11 MySQL thread id 925806, OS thread handle 140391734023936, query id 71667199 Update_rows_log_event::find_row(1144543854) UPDATE sbtest1 SET c='13708480167-10188383641-96795112403-38986752068-59668054428-28144997697-19743513200-59258503430-91794849756-89735044021' WHERE id=500163 2020-07-18 18:05:36 925806 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171559573, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 16 lock struct(s), heap size 1128, 16 row lock(s), undo log entries 26 MySQL thread id 932597, OS thread handle 140391087691520, query id 71667190 127.0.0.1 root Update INSERT INTO sbtest19 (id, k, c, pad) VALUES (431703, 497641, '43251930729-87921419072-32539478079-72103445898-90656549958-65387740684-18948804663-67316334684-45844222231-76544458219', '79561430811-31244776769-12811555781-26313022573-71943113513') 2020-07-18 18:05:36 925806 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097791 page no 469 n bits 384 index PRIMARY of table `shex`.`sbtest1` trx id 5171559573 lock_mode X locks rec but not gap Record lock, heap no 208 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a1c3; asc ;; 1: len 6; hex 0001343fbc95; asc 4? ;; 2: len 7; hex 69000175fa10a9; asc i u ;; 3: len 4; hex 8007ae71; asc q;; 4: len 30; hex 36383834383132383635382d30343039303435343331302d353338323539; asc 68848128658-04090454310-538259; (total 120 bytes); 5: len 30; hex 39353330333230333333392d32333437373330383733372d323635333833; asc 95303203339-23477308737-265383; (total 60 bytes); 2020-07-18 18:05:36 925806 [Note] InnoDB: SQL1: UPDATE sbtest1 SET c='13708480167-10188383641-96795112403-38986752068-59668054428-28144997697-19743513200-59258503430-91794849756-89735044021' WHERE id=500163▒9_ 2020-07-18 18:05:36 925806 [Note] InnoDB: SQL2: INSERT INTO sbtest19 (id, k, c, pad) VALUES (431703, 497641, '43251930729-87921419072-32539478079-72103445898-90656549958-65387740684-18948804663-67316334684-45844222231-76544458219', '79561430811-31244776769-12811555781-26313022573-71943113513') 2020-07-18 18:05:36 925806 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925806 [Note] WSREP: Winning thread: THD: 925806, mode: high priority, state: exec, conflict: executing, seqno: 1144543854 SQL: UPDATE sbtest1 SET c='13708480167-10188383641-96795112403-38986752068-59668054428-28144997697-19743513200-59258503430-91794849756-89735044021' WHERE id=500163▒9_ 2020-07-18 18:05:36 925806 [Note] WSREP: Victim thread: THD: 932597, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest19 (id, k, c, pad) VALUES (431703, 497641, '43251930729-87921419072-32539478079-72103445898-90656549958-65387740684-18948804663-67316334684-45844222231-76544458219', '79561430811-31244776769-12811555781-26313022573-71943113513') 2020-07-18 18:05:36 925806 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925911 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171560307, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 22 lock struct(s), heap size 3488, 24 row lock(s), undo log entries 36 MySQL thread id 925911, OS thread handle 140436274575104, query id 71672503 Delete_rows_log_event::find_row(1144544007) DELETE FROM sbtest5 WHERE id=500878 2020-07-18 18:05:36 925911 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171560290, ACTIVE 0 sec 16 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 34 MySQL thread id 932605, OS thread handle 140390401828608, query id 71672399 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 925911 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097773 page no 466 n bits 384 index PRIMARY of table `shex`.`sbtest5` trx id 5171560290 lock_mode X locks rec but not gap Record lock, heap no 70 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a48e; asc ;; 1: len 6; hex 0001343fbf62; asc 4? b;; 2: len 7; hex 3b00007a1a9d7b; asc ; z {;; 3: len 4; hex 80079bc8; asc ;; 4: len 30; hex 34353837323234393632322d36303431333031383139322d393432383132; asc 45872249622-60413018192-942812; (total 120 bytes); 5: len 30; hex 33323235393333353932332d31373133373036393035312d323931393237; asc 32259335923-17137069051-291927; (total 60 bytes); 2020-07-18 18:05:36 925911 [Note] InnoDB: SQL1: DELETE FROM sbtest5 WHERE id=500878▒9_ 2020-07-18 18:05:36 925911 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 925911 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925911 [Note] WSREP: Winning thread: THD: 925911, mode: high priority, state: exec, conflict: executing, seqno: 1144544007 SQL: DELETE FROM sbtest5 WHERE id=500878▒9_ 2020-07-18 18:05:36 925911 [Note] WSREP: Victim thread: THD: 932605, mode: local, state: exec, conflict: certifying, seqno: -1 SQL: COMMIT 2020-07-18 18:05:36 925911 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925786 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171560444, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 925786, OS thread handle 140392014604032, query id 71673661 Update_rows_log_event::find_row(1144544054) UPDATE sbtest6 SET k=k+1 WHERE id=501348 2020-07-18 18:05:36 925786 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171560333, ACTIVE 0 sec 20 lock struct(s), heap size 3488, 20 row lock(s), undo log entries 31 MySQL thread id 932645, OS thread handle 140371829729024, query id 71673669 127.0.0.1 root Writing to net DELETE FROM sbtest15 WHERE id=500269 2020-07-18 18:05:36 925786 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097770 page no 462 n bits 384 index PRIMARY of table `shex`.`sbtest6` trx id 5171560333 lock_mode X locks rec but not gap Record lock, heap no 212 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007a664; asc d;; 1: len 6; hex 0001343fbf8d; asc 4? ;; 2: len 7; hex 4b0000d11c2de1; asc K - ;; 3: len 4; hex 8007a7b1; asc ;; 4: len 30; hex 32363635343336353735362d36363834303033383034382d353734373936; asc 26654365756-66840038048-574796; (total 120 bytes); 5: len 30; hex 31383031353033353735342d39383336323637333538392d373931323336; asc 18015035754-98362673589-791236; (total 60 bytes); 2020-07-18 18:05:36 925786 [Note] InnoDB: SQL1: UPDATE sbtest6 SET k=k+1 WHERE id=501348▒9_ 2020-07-18 18:05:36 925786 [Note] InnoDB: SQL2: INSERT INTO sbtest15 (id, k, c, pad) VALUES (500269, 498864, '48431819527-05789129706-25548914359-95720385190-61243091766-81452847918-08071725256-97425655482-07581397654-72397834277', '68702923797-07173661516-19498595120-90684747999-23703929089') 2020-07-18 18:05:36 925786 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925786 [Note] WSREP: Winning thread: THD: 925786, mode: high priority, state: exec, conflict: executing, seqno: 1144544054 SQL: UPDATE sbtest6 SET k=k+1 WHERE id=501348▒9_ 2020-07-18 18:05:36 925786 [Note] WSREP: Victim thread: THD: 932645, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest15 (id, k, c, pad) VALUES (500269, 498864, '48431819527-05789129706-25548914359-95720385190-61243091766-81452847918-08071725256-97425655482-07581397654-72397834277', '68702923797-07173661516-19498595120-90684747999-23703929089') 2020-07-18 18:05:36 925786 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 927426 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171560408, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 18 lock struct(s), heap size 3488, 21 row lock(s), undo log entries 35 MySQL thread id 927426, OS thread handle 140391742134016, query id 71674981 Delete_rows_log_event::find_row(1144544038) DELETE FROM sbtest8 WHERE id=497802 2020-07-18 18:05:36 927426 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171560323, ACTIVE 0 sec rollback ROLLING BACK 21 lock struct(s), heap size 3488, 22 row lock(s) MySQL thread id 932590, OS thread handle 140391207855872, query id 71673612 127.0.0.1 root Init COMMIT 2020-07-18 18:05:36 927426 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097772 page no 468 n bits 384 index PRIMARY of table `shex`.`sbtest8` trx id 5171560323 lock_mode X locks rec but not gap Record lock, heap no 85 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007988a; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80079d92; asc ;; 4: len 30; hex 38323335303235393835352d34333536373637333633382d353539383038; asc 82350259855-43567673638-559808; (total 120 bytes); 5: len 30; hex 30323731383737383831302d38323039343631303739302d353735383631; asc 02718778810-82094610790-575861; (total 60 bytes); 2020-07-18 18:05:36 927426 [Note] InnoDB: SQL1: DELETE FROM sbtest8 WHERE id=497802▒9_ 2020-07-18 18:05:36 927426 [Note] InnoDB: SQL2: COMMIT 2020-07-18 18:05:36 927426 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 927426 [Note] WSREP: Winning thread: THD: 927426, mode: high priority, state: exec, conflict: executing, seqno: 1144544038 SQL: DELETE FROM sbtest8 WHERE id=497802▒9_ 2020-07-18 18:05:36 927426 [Note] WSREP: Victim thread: THD: 932590, mode: local, state: exec, conflict: aborting, seqno: 1144544141 SQL: COMMIT 2020-07-18 18:05:36 927426 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 2020-07-18 18:05:36 925797 [Note] InnoDB: *** Priority TRANSACTION: TRANSACTION 5171560696, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 6 MySQL thread id 925797, OS thread handle 140391209748224, query id 71680544 Update_rows_log_event::find_row(1144544220) UPDATE sbtest9 SET k=k+1 WHERE id=502473 2020-07-18 18:05:36 925797 [Note] InnoDB: *** Victim TRANSACTION: TRANSACTION 5171560625, ACTIVE 0 sec mysql tables in use 1, locked 1 18 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 23 MySQL thread id 932615, OS thread handle 140372483872512, query id 71680558 127.0.0.1 root Update INSERT INTO sbtest9 (id, k, c, pad) VALUES (498962, 502823, '37727587529-59732292080-10930658250-71352599629-33243031214-29703313439-32469041409-21763485981-59518631172-23664011322', '23960870415-19438457934-44873337277-16862548352-33013968071') 2020-07-18 18:05:36 925797 [Note] InnoDB: *** WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3097769 page no 1289 n bits 344 index PRIMARY of table `shex`.`sbtest9` trx id 5171560625 lock_mode X locks rec but not gap Record lock, heap no 194 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 8007aac9; asc ;; 1: len 6; hex 0001343fc0b1; asc 4? ;; 2: len 7; hex 54000175f34969; asc T u Ii;; 3: len 4; hex 8007b10c; asc ;; 4: len 30; hex 35363232333739313932392d32353735353835323538362d333536363938; asc 56223791929-25755852586-356698; (total 120 bytes); 5: len 30; hex 37353834383738333430342d38323332393535333837392d383137333439; asc 75848783404-82329553879-817349; (total 60 bytes); 2020-07-18 18:05:36 925797 [Note] InnoDB: SQL1: UPDATE sbtest9 SET k=k+1 WHERE id=502473▒9_ 2020-07-18 18:05:36 925797 [Note] InnoDB: SQL2: INSERT INTO sbtest9 (id, k, c, pad) VALUES (498962, 502823, '37727587529-59732292080-10930658250-71352599629-33243031214-29703313439-32469041409-21763485981-59518631172-23664011322', '23960870415-19438457934-44873337277-16862548352-33013968071') 2020-07-18 18:05:36 925797 [Note] WSREP: cluster conflict due to high priority abort for threads: 2020-07-18 18:05:36 925797 [Note] WSREP: Winning thread: THD: 925797, mode: high priority, state: exec, conflict: executing, seqno: 1144544220 SQL: UPDATE sbtest9 SET k=k+1 WHERE id=502473▒9_ 2020-07-18 18:05:36 925797 [Note] WSREP: Victim thread: THD: 932615, mode: local, state: exec, conflict: executing, seqno: -1 SQL: INSERT INTO sbtest9 (id, k, c, pad) VALUES (498962, 502823, '37727587529-59732292080-10930658250-71352599629-33243031214-29703313439-32469041409-21763485981-59518631172-23664011322', '23960870415-19438457934-44873337277-16862548352-33013968071') 2020-07-18 18:05:36 925797 [Note] WSREP: context: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/handler/ha_innodb.cc:18714 mysqld: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/wsrep-lib/src/client_state.cpp:804: void wsrep::client_state::state(wsrep::unique_lock&, wsrep::client_state::state): Assertion `wsrep::this_thread::get_id() == owning_thread_id_' failed. 200718 18:05:36 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.4.13-MariaDB-log key_buffer_size=1048576 read_buffer_size=4194304 max_used_connections=81 max_threads=102 thread_count=608 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 7105983 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7faba0000c08 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7faf58e52c68 thread_stack 0x40000 *** buffer overflow detected ***: /usr/sbin/mysqld terminated