Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.11, 11.4, 11.7(EOL), 11.8, 12.0
Description
--source include/have_innodb.inc
|
|
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; |
CREATE TABLE t(a INT,b INT,c INT) ENGINE=INNODB; |
INSERT INTO t VALUES(1,2,3),(4,5,6); |
CREATE TABLE t2(a INT,b INT,c INT) ENGINE=INNODB; |
XA START 'x'; |
UPDATE t SET a=20; |
SET pseudo_slave_mode=1; |
UPDATE t2 SET c=10; |
XA END 'x'; |
XA PREPARE 'x'; |
CREATE TABLE t3(a INT) ENGINE=INNODB; |
XA START '2'; |
CREATE TEMPORARY TABLE t3(a INT) ENGINE=INNODB; |
SET unique_checks=0,foreign_key_checks=0; |
INSERT INTO t3 VALUES(0); |
SET SESSION server_id=12; |
INSERT INTO t3 VALUES(1),(2),(3); |
INSERT INTO t2 VALUES(1,2,3),(4,5,6),(7,8,9); |
Leads to:
CS 11.8.0 dfdbec163628271bc5a9b0e9ae33ed24a9fad937 (Optimized) |
InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no
|
CS 11.8.0 dfdbec163628271bc5a9b0e9ae33ed24a9fad937 (Optimized) |
Core was generated by `/test/MD030225-mariadb-11.8.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x14da8405f700 (LWP 2089461))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014da9a091859 in __GI_abort () at abort.c:79
|
#2 0x0000563cfd0a5a69 in ut_dbg_assertion_failed (expr=expr@entry=0x563cfdda2e30 "trx->roll_limit <= trx->undo_no", file=file@entry=0x563cfdda2d78 "/test/11.8_opt/storage/innobase/trx/trx0roll.cc", line=line@entry=554) at /test/11.8_opt/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x0000563cfd0a2cfe in trx_rollback_start (roll_limit=<optimized out>, trx=0x14da944ae600) at /test/11.8_opt/storage/innobase/trx/trx0roll.cc:554
|
#4 trx_rollback_step (thr=thr@entry=0x14da4c017a38) at /test/11.8_opt/storage/innobase/trx/trx0roll.cc:617
|
#5 0x0000563cfd7e9c88 in que_thr_step (thr=0x14da4c017a38) at /test/11.8_opt/storage/innobase/que/que0que.cc:559
|
#6 que_run_threads_low (thr=<optimized out>) at /test/11.8_opt/storage/innobase/que/que0que.cc:609
|
#7 que_run_threads (thr=thr@entry=0x14da4c017a38) at /test/11.8_opt/storage/innobase/que/que0que.cc:629
|
#8 0x0000563cfd8505dd in trx_t::rollback_low (this=0x14da944ae600, savept=0x14da944aef10) at /test/11.8_opt/storage/innobase/trx/trx0roll.cc:120
|
#9 0x0000563cfd755cd8 in innobase_rollback (thd=0x14da4c000c58, rollback_trx=false) at /test/11.8_opt/storage/innobase/handler/ha_innodb.cc:4782
|
#10 0x0000563cfd4aa993 in ha_rollback_trans (thd=thd@entry=0x14da4c000c58, all=all@entry=false) at /test/11.8_opt/sql/handler.cc:2344
|
#11 0x0000563cfd360911 in trans_rollback_stmt (thd=thd@entry=0x14da4c000c58) at /test/11.8_opt/sql/transaction.cc:561
|
#12 0x0000563cfd22385e in mysql_execute_command (thd=0x14da4c000c58, is_called_from_prepared_stmt=<optimized out>) at /test/11.8_opt/sql/sql_parse.cc:5964
|
#13 0x0000563cfd213df5 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x14da4c000c58) at /test/11.8_opt/sql/sql_parse.cc:7915
|
#14 mysql_parse (thd=0x14da4c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/11.8_opt/sql/sql_parse.cc:7837
|
#15 0x0000563cfd220592 in dispatch_command (command=COM_QUERY, thd=0x14da4c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/11.8_opt/sql/sql_class.h:1655
|
#16 0x0000563cfd2226e9 in do_command (thd=thd@entry=0x14da4c000c58, blocking=blocking@entry=true) at /test/11.8_opt/sql/sql_parse.cc:1416
|
#17 0x0000563cfd34f215 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x563d00a865b8, put_in_cache=put_in_cache@entry=true) at /test/11.8_opt/sql/sql_connect.cc:1415
|
#18 0x0000563cfd34f52d in handle_one_connection (arg=0x563d00a865b8) at /test/11.8_opt/sql/sql_connect.cc:1327
|
#19 0x000014da9a5bd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#20 0x000014da9a18e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
CS 10.11.11 91585fff3e2e665cc067b55190c2cc10473f3fd8 (Optimized) |
InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no
|
CS 10.11.11 91585fff3e2e665cc067b55190c2cc10473f3fd8 (Optimized) |
Core was generated by `/test/MD230125-mariadb-10.11.11-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x1459800ed700 (LWP 2276342))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x000014599c6c7859 in __GI_abort () at abort.c:79
|
#2 0x00005596b6f597f2 in ut_dbg_assertion_failed (expr=expr@entry=0x5596b7bfb370 "trx->roll_limit <= trx->undo_no", file=file@entry=0x5596b7bfb2b0 "/test/10.11_opt/storage/innobase/trx/trx0roll.cc", line=line@entry=549) at /test/10.11_opt/storage/innobase/ut/ut0dbg.cc:60
|
#3 0x00005596b6f57108 in trx_rollback_start (roll_limit=<optimized out>, trx=0x14598fbff600) at /test/10.11_opt/storage/innobase/trx/trx0roll.cc:549
|
#4 trx_rollback_step (thr=thr@entry=0x14595001b370) at /test/10.11_opt/storage/innobase/trx/trx0roll.cc:612
|
#5 0x00005596b7664ae8 in que_thr_step (thr=0x14595001b370) at /test/10.11_opt/storage/innobase/que/que0que.cc:559
|
#6 que_run_threads_low (thr=<optimized out>) at /test/10.11_opt/storage/innobase/que/que0que.cc:609
|
#7 que_run_threads (thr=thr@entry=0x14595001b370) at /test/10.11_opt/storage/innobase/que/que0que.cc:629
|
#8 0x00005596b76cb65d in trx_t::rollback_low (this=0x14598fbff600, savept=0x14598fbfff10) at /test/10.11_opt/storage/innobase/trx/trx0roll.cc:115
|
#9 0x00005596b75c78f0 in innobase_rollback (thd=0x145950000c58, rollback_trx=false) at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:4798
|
#10 0x00005596b732d7d6 in ha_rollback_trans (thd=thd@entry=0x145950000c58, all=all@entry=false) at /test/10.11_opt/sql/handler.cc:2282
|
#11 0x00005596b7203961 in trans_rollback_stmt (thd=thd@entry=0x145950000c58) at /test/10.11_opt/sql/transaction.cc:570
|
#12 0x00005596b70d0ab4 in mysql_execute_command (thd=0x145950000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.11_opt/sql/sql_parse.cc:6218
|
#13 0x00005596b70c0cf5 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x145950000c58) at /test/10.11_opt/sql/sql_parse.cc:8187
|
#14 mysql_parse (thd=0x145950000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.11_opt/sql/sql_parse.cc:8109
|
#15 0x00005596b70cd8e2 in dispatch_command (command=COM_QUERY, thd=0x145950000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.11_opt/sql/sql_class.h:1399
|
#16 0x00005596b70cf8f9 in do_command (thd=thd@entry=0x145950000c58, blocking=blocking@entry=true) at /test/10.11_opt/sql/sql_parse.cc:1418
|
#17 0x00005596b71f28e5 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5596b9e5ca48, put_in_cache=put_in_cache@entry=true) at /test/10.11_opt/sql/sql_connect.cc:1386
|
#18 0x00005596b71f2bed in handle_one_connection (arg=0x5596b9e5ca48) at /test/10.11_opt/sql/sql_connect.cc:1298
|
#19 0x000014599cbf3609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#20 0x000014599c7c4133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.11.11 (dbg), 10.11.11 (opt), 11.7.2 (dbg), 11.7.2 (opt), 11.8.0 (dbg), 11.8.0 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.5.28 (dbg), 10.5.28 (opt), 10.6.21 (dbg), 10.6.21 (opt)
Attachments
Issue Links
- is blocked by
-
MDEV-22733 XA PREPARE breaks MDL in pseudo_slave_mode=1
-
- Stalled
-
- relates to
-
MDEV-25297 InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no in trx_rollback_start
-
- Closed
-
The test scenario seems to be a further development of MDEV-22733. The last 1 or 3 INSERT statements probably have something to do with
MDEV-24621, if the symptoms are not reproducible with MariaDB Server 10.6.