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

InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q4/2025 Server Maintenance

    Description

      set sql_mode='';
      CREATE TABLE t (c INT KEY,c2 BLOB UNIQUE)Engine=InnoDB;
      INSERT INTO t VALUES (0,'');
      REPLACE INTO t (c2) VALUES (0);
      

      Leads to:

      CS 10.11.15 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a (Optimized, Clang) Build 07/08/2025

      InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON
      

      CS 10.11.15 3e43606de6a5c6a0ee180d9c6a0ee73b2480909a (Optimized, Clang) Build 07/08/2025

      Core was generated by `/test/MD070825-mariadb-10.11.15-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.
      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 4186027)]
      (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  0x0000744e6584527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x0000744e658288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000063f742798aba in ut_dbg_assertion_failed (expr=0x63f7432a11fa "node->pcur->rel_pos == BTR_PCUR_ON", file=0x63f7432a0c87 "/test/10.11_opt/storage/innobase/row/row0mysql.cc", line=line@entry=1640) at /test/10.11_opt/storage/innobase/ut/ut0dbg.cc:60
      #6  0x000063f742eaedc6 in row_update_for_mysql (prebuilt=0x744d78025c90)at /test/10.11_opt/storage/innobase/row/row0mysql.cc:1640
      #7  0x000063f742df3c73 in ha_innobase::update_row (this=0x744d780211e8, old_row=0x744d78021a00 "p", new_row=0x744d780219e8 <incomplete sequence \374>)at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:8621
      #8  0x000063f742b3ab23 in handler::ha_update_row (this=0x744d780211e8, old_data=0x744d78021a00 "p", new_data=0x744d780219e8 <incomplete sequence \374>)at /test/10.11_opt/sql/handler.cc:7832
      #9  0x000063f7428aee31 in Write_record::replace_row (this=this@entry=0x744e645c7a60, inserted=inserted@entry=0x744e645c7a38, deleted=deleted@entry=0x744e645c7a40)at /test/10.11_opt/sql/sql_insert.cc:2117
      #10 0x000063f7428ae20f in Write_record::write_record (this=this@entry=0x744e645c7a60) at /test/10.11_opt/sql/sql_insert.cc:2364
      #11 0x000063f7428abf62 in mysql_insert (thd=thd@entry=0x744d78000c68, table_list=0x744d78010d38, fields=@0x744d78005e98: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x744d78011570, last = 0x744d78011570, elements = 1}, <No data fields>}, values_list=@0x744d78005ee0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x744d78011af0, last = 0x744d78011af0, elements = 1}, <No data fields>}, update_fields=@0x744d78005ec8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x63f743aad350 <end_of_list>, last = 0x744d78005ec8, elements = 0}, <No data fields>}, update_values=@0x744d78005eb0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x63f743aad350 <end_of_list>, last = 0x744d78005eb0, elements = 0}, <No data fields>}, duplic=DUP_REPLACE, ignore=<optimized out>, result=0x0)at /test/10.11_opt/sql/sql_insert.cc:1217
      #12 0x000063f7428e80ee in mysql_execute_command (thd=thd@entry=0x744d78000c68, is_called_from_prepared_stmt=<optimized out>)at /test/10.11_opt/sql/sql_parse.cc:4628
      #13 0x000063f7428e09b1 in mysql_parse (thd=thd@entry=0x744d78000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x744e645c8480)at /test/10.11_opt/sql/sql_parse.cc:8180
      #14 0x000063f7428dee6c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x744d78000c68, packet=packet@entry=0x744d780086d9 "REPLACE INTO t (c2) VALUES (0)", packet_length=packet_length@entry=30, blocking=true)at /test/10.11_opt/sql/sql_parse.cc:1906
      #15 0x000063f7428e0dc1 in do_command (thd=thd@entry=0x744d78000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1419
      #16 0x000063f742a04e4d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x63f761ecc658, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1386
      #17 0x000063f742a04c13 in handle_one_connection (arg=arg@entry=0x63f761ecc658)at /test/10.11_opt/sql/sql_connect.cc:1298
      #18 0x000063f742d64e5e in pfs_spawn_thread (arg=0x63f761ef8298)at /test/10.11_opt/storage/perfschema/pfs.cc:2201
      #19 0x0000744e6589caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #20 0x0000744e65929c3c 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  060825  df1eb3fbb2e27dd5b401ec349a72c39d221c0cb9  No bug found
      CS  10.6   opt  060825  df1eb3fbb2e27dd5b401ec349a72c39d221c0cb9  No bug found
      CS  10.11  dbg  070825  3e43606de6a5c6a0ee180d9c6a0ee73b2480909a  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::update_row|handler::ha_update_row
      CS  10.11  opt  070825  3e43606de6a5c6a0ee180d9c6a0ee73b2480909a  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::update_row|handler::ha_update_row
      CS  11.4   dbg  070725  dbeef00562dd7088a9f0163268f9eb5e5ba072fe  No bug found
      CS  11.4   opt  070725  dbeef00562dd7088a9f0163268f9eb5e5ba072fe  No bug found
      CS  11.8   dbg  070725  9a4a30aec003a8efdf9d35d3ac669385286ba4b4  No bug found
      CS  11.8   opt  070725  9a4a30aec003a8efdf9d35d3ac669385286ba4b4  No bug found
      CS  12.0   dbg  070725  107291bf980822fcc3c02bd4e01ecbc4db7fd192  No bug found
      CS  12.0   opt  070725  107291bf980822fcc3c02bd4e01ecbc4db7fd192  No bug found
      CS  12.1   dbg  070725  d4d0dd00b761b3e94454dff9aa93e2e17232339e  No bug found
      CS  12.1   opt  070725  d4d0dd00b761b3e94454dff9aa93e2e17232339e  No bug found
      ES  10.5   dbg  070725  70586522eacf09d04d49962072e14325a75d8155  No bug found
      ES  10.5   opt  070725  70586522eacf09d04d49962072e14325a75d8155  No bug found
      ES  10.6   dbg  070725  6879c0c0bcdd1b7a88de65dd581cf86195a2cd11  No bug found
      ES  10.6   opt  070725  6879c0c0bcdd1b7a88de65dd581cf86195a2cd11  No bug found
      ES  11.4   dbg  070725  6ac3c1547652a4391fe0b1210ec241a804293567  No bug found
      ES  11.4   opt  070725  6ac3c1547652a4391fe0b1210ec241a804293567  No bug found
      ES  11.8   dbg  070725  e09b21aaddefcf0d7ddd96eca5b1d48c1d688de5  No bug found
      ES  11.8   opt  070725  e09b21aaddefcf0d7ddd96eca5b1d48c1d688de5  No bug found
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              saahil Saahil Alam
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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