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

Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno on RENAME

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      On debug build with gtid_strict_mode=1 RENAME TABLE crashes.

      # mysqld options required for replay:  --log_bin=binlog --binlog_format=ROW
      CREATE TABLE t (a INT KEY,b TEXT);
      SET gtid_seq_no=1;
      SET GLOBAL gtid_strict_mode=1;
      RENAME TABLE t TO t4;
      

      Leads to:

      CS 13.0.1 3a2f8e27981b76b99d2b87cc3bcec5ef022b2b23 (Debug, Clang 21.1.3-20250923) Build 10/04/2026

      mariadbd: /test/13.0_dbg/sql/sql_error.h:1087: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed.
      

      CS 13.0.1 3a2f8e27981b76b99d2b87cc3bcec5ef022b2b23 (Debug, Clang 21.1.3-20250923) Build 10/04/2026

      Core was generated by `/test/MD100426-mariadb-13.0.1-linux-x86_64-dbg/bin/mariadbd --no-defaults --log'.
      Program terminated with signal SIGABRT, Aborted.
      Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 2823732)]
      (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  0x000079212804526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007921280288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000079212802881b in __assert_fail_base (fmt=0x7921281d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x588827609338 "m_status == DA_ERROR", file=file@entry=0x5888277108d7 "/test/13.0_dbg/sql/sql_error.h", line=line@entry=1087, function=function@entry=0x58882762ace6 "uint Diagnostics_area::sql_errno() const") at ./assert/assert.c:94
      #6  0x000079212803b507 in __assert_fail (assertion=0x588827609338 "m_status == DA_ERROR", file=0x5888277108d7 "/test/13.0_dbg/sql/sql_error.h", line=1087, function=0x58882762ace6 "uint Diagnostics_area::sql_errno() const")at ./assert/assert.c:103
      #7  0x0000588827e7cbb8 in Diagnostics_area::sql_errno (this=0x712084008098)at /test/13.0_dbg/sql/sql_error.h:1087
      #8  0x0000588827e67125 in MYSQL_BIN_LOG::write_gtid_event (this=0x5888293d5ea8 <mysql_bin_log>, thd=0x712084001cf8, cache_data=0x0, standalone=true, is_transactional=false, commit_id=0, commit_by_rotate=false, has_xid=false, is_ro_1pc=false)at /test/13.0_dbg/sql/log.cc:8349
      #9  0x0000588827e68698 in MYSQL_BIN_LOG::write (this=0x5888293d5ea8 <mysql_bin_log>, event_info=0x79212406ae40, with_annotate=0x0) at /test/13.0_dbg/sql/log.cc:8827
      #10 0x00005888281d5fa9 in THD::binlog_query (this=0x712084001cf8, qtype=THD::STMT_QUERY_TYPE, query_arg=0x71208401a7a0 "RENAME TABLE t TO t4", query_len=20, is_trans=false, direct=false, suppress_use=false, errcode=0)at /test/13.0_dbg/sql/sql_class.cc:8302
      #11 0x000058882842f806 in write_bin_log (thd=0x712084001cf8, clear_error=true, query=0x71208401a7a0 "RENAME TABLE t TO t4", query_length=20, is_trans=false) at /test/13.0_dbg/sql/sql_table.cc:1087
      #12 0x000058882835b03a in mysql_rename_tables (thd=0x712084001cf8, table_list=0x71208401a8a8, silent=false, if_exists=false)at /test/13.0_dbg/sql/sql_rename.cc:203
      #13 0x00005888283100ff in mysql_execute_command (thd=0x712084001cf8, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:4378
      #14 0x00005888283079c8 in mysql_parse (thd=0x712084001cf8, rawbuf=0x71208401a7a0 "RENAME TABLE t TO t4", length=20, parser_state=0x79212406c9f0) at /test/13.0_dbg/sql/sql_parse.cc:7941
      #15 0x000058882830511e in dispatch_command (command=COM_QUERY, thd=0x712084001cf8, packet=0x71208400bcc9 "RENAME TABLE t TO t4", packet_length=20, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1898
      #16 0x000058882830844a in do_command (thd=0x712084001cf8, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1432
      #17 0x000058882850b70e in do_handle_one_connection (connect=0x58882b2ed6a8, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1503
      #18 0x000058882850b4f1 in handle_one_connection (arg=0x58882b2ed6a8)at /test/13.0_dbg/sql/sql_connect.cc:1415
      #19 0x000079212809ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #20 0x0000792128129c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.6   dbg  100426  f39b634db715cd9dc1835653d1ce544df2aa1613  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  10.6   opt  100426  f39b634db715cd9dc1835653d1ce544df2aa1613  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  10.11  dbg  100426  ba774a0a90fac0163babe9d7a964aa36503e1711  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      CS  10.11  opt  100426  ba774a0a90fac0163babe9d7a964aa36503e1711  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  11.4   dbg  100426  dc89915ad9bf3dcb67e66d2844c77ec0403373de  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      CS  11.4   opt  100426  dc89915ad9bf3dcb67e66d2844c77ec0403373de  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  11.8   dbg  100426  e47db94aea7f0d6e0177e948486fc8860331f05f  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      CS  11.8   opt  100426  e47db94aea7f0d6e0177e948486fc8860331f05f  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  12.3   dbg  100426  f5bb9922107672e88f7b5cbdb3d25151cc5744bb  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      CS  12.3   opt  100426  f5bb9922107672e88f7b5cbdb3d25151cc5744bb  MARIADB_ERROR_CODE|MariaDB error code: 2003
      CS  13.0   dbg  100426  3a2f8e27981b76b99d2b87cc3bcec5ef022b2b23  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      CS  13.0   opt  100426  3a2f8e27981b76b99d2b87cc3bcec5ef022b2b23  MARIADB_ERROR_CODE|MariaDB error code: 2003
      ES  10.6   dbg  100426  84a80c8b38208d362225496da08d86d8d454e453  MARIADB_ERROR_CODE|MariaDB error code: 2003
      ES  10.6   opt  100426  84a80c8b38208d362225496da08d86d8d454e453  MARIADB_ERROR_CODE|MariaDB error code: 2003
      ES  11.4   dbg  100426  8b2bf17b733262409422ce7d039a0c021fc47077  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      ES  11.4   opt  100426  8b2bf17b733262409422ce7d039a0c021fc47077  MARIADB_ERROR_CODE|MariaDB error code: 2003
      ES  11.8   dbg  100426  854cae81f52e477c7777a51db26ba640d8755b81  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      ES  11.8   opt  100426  854cae81f52e477c7777a51db26ba640d8755b81  MARIADB_ERROR_CODE|MariaDB error code: 2003
      ES  12.3   dbg  220426  613a6253fe9efc12e166f83a97663ba263db8317  m_status == DA_ERROR|SIGABRT|Diagnostics_area::sql_errno|MYSQL_BIN_LOG::write_gtid_event|MYSQL_BIN_LOG::write|THD::binlog_query
      ES  12.3   opt  220426  613a6253fe9efc12e166f83a97663ba263db8317  MARIADB_ERROR_CODE|MariaDB error code: 2003
      MS  5.5    dbg  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  SLAVE_ERROR|Slave I/O: error  
      MS  5.5    opt  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  SLAVE_ERROR|Slave I/O: error  
      MS  5.6    dbg  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  SLAVE_ERROR|Slave I/O: error  
      MS  5.6    opt  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  SLAVE_ERROR|Slave I/O: error  
      MS  5.7    dbg  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  5.7    opt  070525  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  8.0    dbg  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  8.0    opt  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  9.1    dbg  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      MS  9.1    opt  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      

      Attachments

        Activity

          People

            bnestere Brandon Nesterenko
            susil.behera Susil Behera
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.