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

Assertion `!create_info->versioned() || (row_start_field && row_end_field)' failed

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.4, 11.8, 12.3, 13.0, 13.2
    • 10.11, 11.4, 11.8, 12.3, 13.0
    • Server
    • None
    • Can result in hang or crash

    Description

      CREATE TABLE t1(c INT UNIQUE WITH SYSTEM VERSIONING WITHOUT SYSTEM VERSIONING,PERIOD FOR SYSTEM_TIME(a,b));
      

      Leads to:

      CS 12.3.3 881b64e8add374802e1871814dd0a3a673a9b3e6 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      mariadbd: /test/12.3_dbg/sql/sql_table.cc:4354: int append_system_key_parts(THD *, HA_CREATE_INFO *, Key *): Assertion `!create_info->versioned() || (row_start_field && row_end_field)' failed.
      

      CS 12.3.3 881b64e8add374802e1871814dd0a3a673a9b3e6 (Debug, Clang 22.1.8-20260621) Build 25/09/2026

      Core was generated by `/test/MD250926-mariadb-12.3.3-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
      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 1970024)]
      (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  0x00007be05204527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007be0520288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007be05202881b in __assert_fail_base (fmt=0x7be0521d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6555298dc9e8 "!create_info->versioned() || (row_start_field && row_end_fiel
      d)", file=file@entry=0x6555298dac61 "/test/12.3_dbg/sql/sql_table.cc", line=line@entry=4354, function=function@entry=0x6555298dca28 "int append_system_key_parts(THD *, HA_CREATE_INFO *, Key *)") at ./assert/assert
      .c:96
      #6  0x00007be05203b517 in __assert_fail (assertion=0x6555298dc9e8 "!create_info->versioned() || (row_start_field && row_end_field)", file=0x6555298dac61 "/test/12.3_dbg/sql/sql_table.cc", line=4354, function=0x655
      5298dca28 "int append_system_key_parts(THD *, HA_CREATE_INFO *, Key *)") at ./assert/assert.c:105
      #7  0x0000655528a2760c in append_system_key_parts (thd=0x73df38000d60, create_info=0x7be02b959fa8, key=0x73df3801b120)at /test/12.3_dbg/sql/sql_table.cc:4354
      #8  0x0000655528a2681f in init_key_info (thd=0x73df38000d60, alter_info=0x7be02b959e30, create_info=0x7be02b959fa8, file=0x73df3801b4e0)at /test/12.3_dbg/sql/sql_table.cc:3154
      #9  0x0000655528a099e2 in mysql_prepare_create_table_finalize (thd=0x73df38000d60, create_info=0x7be02b959fa8, alter_info=0x7be02b959e30, db_options=0x7be02b958784, file=0x73df3801b4e0, key_info_buffer=0x7be02b959
      7e0, key_count=0x7be02b9597dc, create_table_mode=0) at /test/12.3_dbg/sql/sql_table.cc:3487
      #10 0x0000655528a08ca6 in mysql_create_frm_image (thd=0x73df38000d60, create_info=0x7be02b959fa8, alter_info=0x7be02b959e30, create_table_mode=0, key_info=0x7be02b9597e0, key_count=0x7be02b9597dc, frm=0x7be02b9597
      b0) at /test/12.3_dbg/sql/sql_table.cc:4633
      #11 0x0000655528a0ca2d in create_table_impl (thd=0x73df38000d60, ddl_log_state_create=0x7be02b959b88, ddl_log_state_rm=0x7be02b959b68, orig_db=@0x73df3801a7b0: {<Lex_ident_fs> = {<Lex_ident<Compare_table_names>> =
       {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x73df3801a770 "test", length = 4}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, orig_table_name=@0x73df3801a7c0: {<Lex_ident_
      fs> = {<Lex_ident<Compare_table_names>> = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x73df3801a730 "t1", length = 2}, <No data fields>}, <No data fields>}, <No data fields>}, <No data fields>}, db=@0x
      73df3801a7b0: {str = 0x73df3801a770 "test", length = 4}, table_name=@0x73df3801a7c0: {str = 0x73df3801a730 "t1", length = 2}, path=@0x7be02b959798: {str = 0x7be02b959820 "./test/t1", length = 9}, options={m_option
      s = DDL_options_st::OPT_NONE}, create_info=0x7be02b959fa8, alter_info=0x7be02b959e30, create_table_mode=0, is_trans=0x7be02b959b5f, key_info=0x7be02b9597e0, key_count=0x7be02b9597dc, frm=0x7be02b9597b0)at /test/12
      .3_dbg/sql/sql_table.cc:4964
      #12 0x0000655528a0bc95 in mysql_create_table_no_lock (thd=0x73df38000d60, ddl_log_state_create=0x7be02b959b88, ddl_log_state_rm=0x7be02b959b68, create_info=0x7be02b959fa8, alter_info=0x7be02b959e30, is_trans=0x7be
      02b959b5f, create_table_mode=0, table_list=0x73df3801a790)at /test/12.3_dbg/sql/sql_table.cc:5088
      #13 0x0000655528a25d2d in mysql_create_table (thd=0x73df38000d60, create_table=0x73df3801a790, create_info=0x7be02b959fa8, alter_info=0x7be02b959e30) at /test/12.3_dbg/sql/sql_table.cc:5334
      #14 0x0000655528a2438e in Sql_cmd_create_table_like::execute (this=0x73df3801a6f0, thd=0x73df38000d60)at /test/12.3_dbg/sql/sql_table.cc:13980
      #15 0x0000655528908a92 in mysql_execute_command (thd=0x73df38000d60, is_called_from_prepared_stmt=false) at /test/12.3_dbg/sql/sql_parse.cc:5895
      #16 0x00006555288f9cc8 in mysql_parse (thd=0x73df38000d60, rawbuf=0x73df3801a5b0 "CREATE TABLE t1(c INT UNIQUE WITH SYSTEM VERSIONING WITHOUT SYSTEM VERSIONING,PERIOD FOR SYSTEM_TIME(a,b))", length=106, parser_sta
      te=0x7be02b95b9f0) at /test/12.3_dbg/sql/sql_parse.cc:7932
      #17 0x00006555288f74ae in dispatch_command (command=COM_QUERY, thd=0x73df38000d60, packet=0x73df3800b621 "CREATE TABLE t1(c INT UNIQUE WITH SYSTEM VERSIONING WITHOUT SYSTEM VERSIONING,PERIOD FOR SYSTEM_TIME(a,b))"
      , packet_length=106, blocking=true) at /test/12.3_dbg/sql/sql_parse.cc:1903
      #18 0x00006555288fa74a in do_command (thd=0x73df38000d60, blocking=true)at /test/12.3_dbg/sql/sql_parse.cc:1437
      #19 0x0000655528acb8be in do_handle_one_connection (connect=0x65554bc849b0, put_in_cache=true) at /test/12.3_dbg/sql/sql_connect.cc:1514
      #20 0x0000655528acb6a1 in handle_one_connection (arg=0x65554bc69b40)at /test/12.3_dbg/sql/sql_connect.cc:1426
      #21 0x00007be05209cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #22 0x00007be052129ecc 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  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|m
      ysql_create_frm_image
      CS  10.11  opt  250926  307a82c97316ea0ed3fde318d19c0770ab898d89  No bug found
      CS  11.4   dbg  250926  511d7527eb356aab52fa183456333c5ba9741bcf  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|m
      ysql_create_frm_image
      CS  11.4   opt  250926  511d7527eb356aab52fa183456333c5ba9741bcf  No bug found
      CS  11.8   dbg  250926  e87b958d2e411af8e088d1716f99d06534e932f3  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      CS  11.8   opt  250926  e87b958d2e411af8e088d1716f99d06534e932f3  No bug found
      CS  12.3   dbg  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      CS  12.3   opt  250926  881b64e8add374802e1871814dd0a3a673a9b3e6  No bug found
      CS  13.0   dbg  250926  620a4b5624222048fece7fe1789978ae0675cae2  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      CS  13.0   opt  250926  620a4b5624222048fece7fe1789978ae0675cae2  No bug found
      CS  13.2   dbg  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      CS  13.2   opt  250926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found
      ES  10.6   dbg  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table|mysql_create_frm_image
      ES  10.6   opt  250926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  No bug found
      ES  11.4   dbg  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      ES  11.4   opt  250926  5fa1ee1c7342644dda74ff137ff55c4df79939cf  No bug found
      ES  11.8   dbg  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      ES  11.8   opt  250926  1eae6f8f0c743cbff67675ae3e5cf9d25a5d8f61  No bug found
      ES  12.3   dbg  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  !create_info->versioned() || (row_start_field && row_end_field)|SIGABRT|append_system_key_parts|init_key_info|mysql_prepare_create_table_finalize|mysql_create_frm_image
      ES  12.3   opt  250926  f46597716bc5fbf9081c0fa17bd3e0d6c9e9db1d  No bug found
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1.5h
                1.5h

                Git Integration

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