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

Assertion `!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()' failed in mysql_prepare_update on UPDATE ... FOR SYSTEM_TIME AS OF ... WHERE

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      CREATE TABLE t1 (c1 INT);
      UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1;
      

      Leads to:

      CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026

      mariadbd: /test/10.11_dbg/sql/sql_update.cc:1498: bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *): Assertion `!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()' failed.
      

      CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026

      Core was generated by `/test/MD140926-mariadb-10.11.19-linux-x86_64-dbg/bin/mariadbd --no-defaults --l'.
      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 1893950)]
      (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  0x00007d8aa7e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007d8aa7e288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007d8aa7e2881b in __assert_fail_base (fmt=0x7d8aa7fd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x618807eee60d "!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()", file=file@entry=0x618807f0fc1a "/test/10.11_dbg/sql/sql_update.cc", line=line@entry=1498, function=function@entry=0x618807f0fddf "bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *)") at ./assert/assert.c:96
      #6  0x00007d8aa7e3b517 in __assert_fail (assertion=0x618807eee60d "!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()", file=0x618807f0fc1a "/test/10.11_dbg/sql/sql_update.cc", line=1498, function=0x618807f0fddf "bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *)") at ./assert/assert.c:105
      #7  0x0000618807057043 in mysql_prepare_update (thd=0x7589c4000d58, table_list=0x7589c40136b0, conds=0x7d8aa42f3290, order_num=0, order=0x0)at /test/10.11_dbg/sql/sql_update.cc:1497
      #8  0x0000618807052ca1 in mysql_update (thd=0x7589c4000d58, table_list=0x7589c40136b0, fields=@0x7589c4005b20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7589c4013f80, last = 0x7589c4013f80, elements = 1}, <No data fields>}, values=@0x7589c4005f88: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7589c4013f90, last = 0x7589c4013f90, elements = 1}, <No data fields>}, conds=0x7589c4013fa8, order_num=0, order=0x0, limit=18446744073709551615, ignore=false, found_return=0x7d8aa42f4158, updated_return=0x7d8aa42f4150)at /test/10.11_dbg/sql/sql_update.cc:485
      #9  0x0000618806ef856b in mysql_execute_command (thd=0x7589c4000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:4497
      #10 0x0000618806eee5b4 in mysql_parse (thd=0x7589c4000d58, rawbuf=0x7589c40134c0 "UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1", length=54, parser_state=0x7d8aa42f4ae0)at /test/10.11_dbg/sql/sql_parse.cc:8210
      #11 0x0000618806eebaa9 in dispatch_command (command=COM_QUERY, thd=0x7589c4000d58, packet=0x7589c400af49 "UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1", packet_length=54, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1924
      #12 0x0000618806eef163 in do_command (thd=0x7589c4000d58, blocking=true)at /test/10.11_dbg/sql/sql_parse.cc:1434
      #13 0x00006188070d0a99 in do_handle_one_connection (connect=0x618846663008, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1486
      #14 0x00006188070d0832 in handle_one_connection (arg=0x6188467441c8)at /test/10.11_dbg/sql/sql_connect.cc:1398
      #15 0x00007d8aa7e9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #16 0x00007d8aa7f29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed
      CS  10.11  dbg  140926  6ab0036cf354c5b79284fd0007993a1171b94f6c  !table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()|SIGABRT|mysql_prepare_update|mysql_update|mysql_execute_command|mysql_parse
      CS  10.11  opt  140926  6ab0036cf354c5b79284fd0007993a1171b94f6c  No bug found
      CS  11.4   dbg  140926  03acdd67d599ab7136ef18c36f3479a306870290  No bug found
      CS  11.4   opt  140926  03acdd67d599ab7136ef18c36f3479a306870290  No bug found
      CS  11.8   dbg  140926  08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3  No bug found
      CS  11.8   opt  140926  08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3  No bug found
      CS  12.3   dbg  140926  0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f  No bug found
      CS  12.3   opt  140926  0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f  No bug found
      CS  13.1   dbg  140926  e30f2bd21e463d5f5f9f9210b75193a0257b8a8c  No bug found
      CS  13.1   opt  140926  e30f2bd21e463d5f5f9f9210b75193a0257b8a8c  No bug found
      CS  13.2   dbg  240926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found
      CS  13.2   opt  240926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found
      ES  11.4   dbg  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found
      ES  11.4   opt  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found
      ES  11.8   dbg  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found
      ES  11.8   opt  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found
      ES  12.3   dbg  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found
      ES  12.3   opt  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found
      

      Attachments

        Activity

          People

            midenok Aleksey Midenkov
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 0d
                0d
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.5h
                0.5h

                Git Integration

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