Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36022

InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no in trx_rollback_start

Details

    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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22733 XA PREPARE breaks MDL in pseudo_slave_mode=1

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25297 InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no in trx_rollback_start

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            ramesh Ramesh Sivaraman created issue -
            marko Marko Mäkelä added a comment -

            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.

            marko Marko Mäkelä added a comment - 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.
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Andrei Elkin [ elkin ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.7(EOL) [ 29815 ]
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar made changes -
            Fix Version/s 11.8 [ 29921 ]
            Roel Roel Van de Paar added a comment -

            Note that before the crash the final INSERT semi-hangs for a while:

            CS 11.4.6 ef966af801afc2a07222b5df65dddd52c77431dd (Debug) Build 15/02/2025

            		 
            11.4.6-dbg>SHOW PROCESSLIST;
            		 
            +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+
            		 
            | Id | User | Host      | db   | Command | Time | State    | Info                                         | Progress |
            		 
            +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+
            		 
            |  4 | root | localhost | test | Query   |   36 | Update   | INSERT INTO t2 VALUES(1,2,3),(4,5,6),(7,8,9) |    0.000 |
            		 
            |  5 | root | localhost | test | Query   |    0 | starting | SHOW PROCESSLIST                             |    0.000 |
            		 
            +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+
            		 
            2 rows in set (0.001 sec)

            Roel Roel Van de Paar added a comment - Note that before the crash the final INSERT semi-hangs for a while: CS 11.4.6 ef966af801afc2a07222b5df65dddd52c77431dd (Debug) Build 15/02/2025 11.4.6-dbg>SHOW PROCESSLIST; +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+ | 4 | root | localhost | test | Query | 36 | Update | INSERT INTO t2 VALUES(1,2,3),(4,5,6),(7,8,9) | 0.000 | | 5 | root | localhost | test | Query | 0 | starting | SHOW PROCESSLIST | 0.000 | +----+------+-----------+------+---------+------+----------+----------------------------------------------+----------+ 2 rows in set (0.001 sec)
            Roel Roel Van de Paar made changes -
            Affects Version/s 11.4 [ 29301 ]
            Roel Roel Van de Paar made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            Roel Roel Van de Paar made changes -
            Affects Version/s 12.0 [ 29945 ]
            Roel Roel Van de Paar added a comment - - edited

            A different reduced testcase:

            --source include/have_innodb.inc
            		 
            --source include/have_partition.inc
            		 
            SET innodb_lock_wait_timeout=1;
            		 
            SET SESSION pseudo_slave_mode=ON;
            		 
            CREATE TABLE t1 (c INT PRIMARY KEY) ENGINE=InnoDB;
            		 
            XA START 'a';
            		 
            --error ER_DUP_ENTRY
            		 
            INSERT INTO t1 VALUES (1),(1);
            		 
            XA END 'a';
            		 
            SET foreign_key_checks=0,unique_checks=0;
            		 
            XA PREPARE 'a';
            		 
            CREATE TABLE t2 (c INT) ENGINE=InnoDB PARTITION BY HASH (c) PARTITIONS 4;
            		 
            XA START 'b';
            		 
            INSERT INTO t2 VALUES (1);
            		 
            SELECT * FROM t2;
            		 
            INSERT INTO t2 VALUES (0);
            		 
            INSERT INTO t1 VALUES (0);

            Leading to the same assert:

            CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 15/02/2025

            		 
            InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no

            CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 15/02/2025

            		 
            Core was generated by `/test/MD150225-mariadb-12.0.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
            		 
            Program terminated with signal SIGABRT, Aborted.
            		 
            #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
            		 
             
            		 
            [Current thread is 1 (LWP 735614)]
            		 
            (gdb) bt
            		 
            #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
            		 
            #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
            		 
            #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
            		 
            #3  0x000015155284526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
            		 
            #4  0x00001515528288ff in __GI_abort () at ./stdlib/abort.c:79
            		 
            #5  0x0000555babe01264 in ut_dbg_assertion_failed (expr=0x555bac95cd2e "trx->roll_limit <= trx->undo_no", file=0x555bac95cabd "/test/12.0_opt/storage/innobase/trx/trx0roll.cc", line=line@entry=554) at /test/12.0_opt/storage/innobase/ut/ut0dbg.cc:60
            		 
            #6  0x0000555bac58781b in trx_rollback_start (trx=0x15154c201680, roll_limit=0)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:554
            		 
            #7  trx_rollback_step (thr=thr@entry=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:617
            		 
            #8  0x0000555bac516ecc in que_thr_step (thr=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:559
            		 
            #9  que_run_threads_low (thr=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:609
            		 
            #10 que_run_threads (thr=thr@entry=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:629
            		 
            #11 0x0000555bac586a43 in trx_t::rollback_low (this=0x15154c201680, savept=0x15154c201f98)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:120
            		 
            #12 0x0000555bac4a0937 in innobase_rollback (thd=<optimized out>, rollback_trx=<optimized out>)at /test/12.0_opt/storage/innobase/handler/ha_innodb.cc:4772
            		 
            #13 0x0000555bac1be0df in ha_rollback_trans (thd=thd@entry=0x1514ec000c68, all=false) at /test/12.0_opt/sql/handler.cc:2344
            		 
            #14 0x0000555bac089aca in trans_rollback_stmt (thd=thd@entry=0x1514ec000c68)at /test/12.0_opt/sql/transaction.cc:565
            		 
            #15 0x0000555babf53c22 in mysql_execute_command (thd=thd@entry=0x1514ec000c68, is_called_from_prepared_stmt=<optimized out>)at /test/12.0_opt/sql/sql_parse.cc:5964
            		 
            #16 0x0000555babf4c341 in mysql_parse (thd=thd@entry=0x1514ec000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15154c748430)at /test/12.0_opt/sql/sql_parse.cc:7915
            		 
            #17 0x0000555babf4a7d0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1514ec000c68, packet=packet@entry=0x1514ec0088a9 "INSERT INTO t1 VALUES (0)", packet_length=packet_length@entry=25, blocking=true)at /test/12.0_opt/sql/sql_parse.cc:1902
            		 
            #18 0x0000555babf4c751 in do_command (thd=thd@entry=0x1514ec000c68, blocking=true) at /test/12.0_opt/sql/sql_parse.cc:1415
            		 
            #19 0x0000555bac077f6d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x555bb09aac88, put_in_cache=true)at /test/12.0_opt/sql/sql_connect.cc:1415
            		 
            #20 0x0000555bac077d2f in handle_one_connection (arg=arg@entry=0x555bb09aac88)at /test/12.0_opt/sql/sql_connect.cc:1327
            		 
            #21 0x0000555bac3fce09 in pfs_spawn_thread (arg=0x555bb0957578)at /test/12.0_opt/storage/perfschema/pfs.cc:2198
            		 
            #22 0x000015155289ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
            		 
            #23 0x0000151552929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

            Bug confirmed present in:
            MariaDB: 10.11.12 (dbg), 10.11.12 (opt), 11.4.6 (dbg), 11.4.6 (opt), 11.8.1 (dbg), 11.8.1 (opt), 12.0.0 (dbg), 12.0.0 (opt)

            Bug (or feature/syntax) confirmed not present in:
            MariaDB: 10.5.29 (dbg), 10.5.29 (opt), 10.6.22 (dbg), 10.6.22 (opt)

            Roel Roel Van de Paar added a comment - - edited A different reduced testcase: --source include/have_innodb.inc --source include/have_partition.inc SET innodb_lock_wait_timeout=1; SET SESSION pseudo_slave_mode= ON ; CREATE TABLE t1 (c INT PRIMARY KEY ) ENGINE=InnoDB; XA START 'a' ; --error ER_DUP_ENTRY INSERT INTO t1 VALUES (1),(1); XA END 'a' ; SET foreign_key_checks=0,unique_checks=0; XA PREPARE 'a' ; CREATE TABLE t2 (c INT ) ENGINE=InnoDB PARTITION BY HASH (c) PARTITIONS 4; XA START 'b' ; INSERT INTO t2 VALUES (1); SELECT * FROM t2; INSERT INTO t2 VALUES (0); INSERT INTO t1 VALUES (0); Leading to the same assert: CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 15/02/2025 InnoDB: Failing assertion: trx->roll_limit <= trx->undo_no CS 12.0.0 c92add291e636c797e6d6ddca605905541b2a441 (Optimized) Build 15/02/2025 Core was generated by `/test/MD150225-mariadb-12.0.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44   [Current thread is 1 (LWP 735614)] (gdb) bt #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44 #1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78 #2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89 #3 0x000015155284526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26 #4 0x00001515528288ff in __GI_abort () at ./stdlib/abort.c:79 #5 0x0000555babe01264 in ut_dbg_assertion_failed (expr=0x555bac95cd2e "trx->roll_limit <= trx->undo_no", file=0x555bac95cabd "/test/12.0_opt/storage/innobase/trx/trx0roll.cc", line=line@entry=554) at /test/12.0_opt/storage/innobase/ut/ut0dbg.cc:60 #6 0x0000555bac58781b in trx_rollback_start (trx=0x15154c201680, roll_limit=0)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:554 #7 trx_rollback_step (thr=thr@entry=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:617 #8 0x0000555bac516ecc in que_thr_step (thr=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:559 #9 que_run_threads_low (thr=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:609 #10 que_run_threads (thr=thr@entry=0x1514ec05bf20)at /test/12.0_opt/storage/innobase/que/que0que.cc:629 #11 0x0000555bac586a43 in trx_t::rollback_low (this=0x15154c201680, savept=0x15154c201f98)at /test/12.0_opt/storage/innobase/trx/trx0roll.cc:120 #12 0x0000555bac4a0937 in innobase_rollback (thd=<optimized out>, rollback_trx=<optimized out>)at /test/12.0_opt/storage/innobase/handler/ha_innodb.cc:4772 #13 0x0000555bac1be0df in ha_rollback_trans (thd=thd@entry=0x1514ec000c68, all=false) at /test/12.0_opt/sql/handler.cc:2344 #14 0x0000555bac089aca in trans_rollback_stmt (thd=thd@entry=0x1514ec000c68)at /test/12.0_opt/sql/transaction.cc:565 #15 0x0000555babf53c22 in mysql_execute_command (thd=thd@entry=0x1514ec000c68, is_called_from_prepared_stmt=<optimized out>)at /test/12.0_opt/sql/sql_parse.cc:5964 #16 0x0000555babf4c341 in mysql_parse (thd=thd@entry=0x1514ec000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x15154c748430)at /test/12.0_opt/sql/sql_parse.cc:7915 #17 0x0000555babf4a7d0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1514ec000c68, packet=packet@entry=0x1514ec0088a9 "INSERT INTO t1 VALUES (0)", packet_length=packet_length@entry=25, blocking=true)at /test/12.0_opt/sql/sql_parse.cc:1902 #18 0x0000555babf4c751 in do_command (thd=thd@entry=0x1514ec000c68, blocking=true) at /test/12.0_opt/sql/sql_parse.cc:1415 #19 0x0000555bac077f6d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x555bb09aac88, put_in_cache=true)at /test/12.0_opt/sql/sql_connect.cc:1415 #20 0x0000555bac077d2f in handle_one_connection (arg=arg@entry=0x555bb09aac88)at /test/12.0_opt/sql/sql_connect.cc:1327 #21 0x0000555bac3fce09 in pfs_spawn_thread (arg=0x555bb0957578)at /test/12.0_opt/storage/perfschema/pfs.cc:2198 #22 0x000015155289ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447 #23 0x0000151552929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78 Bug confirmed present in: MariaDB: 10.11.12 (dbg), 10.11.12 (opt), 11.4.6 (dbg), 11.4.6 (opt), 11.8.1 (dbg), 11.8.1 (opt), 12.0.0 (dbg), 12.0.0 (opt) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.5.29 (dbg), 10.5.29 (opt), 10.6.22 (dbg), 10.6.22 (opt)
            Roel Roel Van de Paar made changes -
            Labels regression-10.11
            Roel Roel Van de Paar made changes -
            Labels regression-10.11 not-10.6 regression-10.11
            Roel Roel Van de Paar added a comment -

            Elkin FYI (Ref MDEV-22733)

            Roel Roel Van de Paar added a comment - Elkin FYI (Ref MDEV-22733 )
            Elkin Andrei Elkin made changes -
            Priority Critical [ 2 ] Minor [ 4 ]

            People

              Elkin Andrei Elkin
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.