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

[draft] Assertion `table->part_info->vers_info' failed in vers_create_partitions

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Versioned Tables
    • None

    Description

       
      mysqld: /11.0/sql/partition_info.cc:922: bool vers_create_partitions(THD*, TABLE_LIST*, uint): Assertion `table->part_info->vers_info' failed.
      230616 11:36:42 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.0.3-MariaDB-debug-log source revision: 5fb2c031f7c624dfdd49bb35faad58ea35d238af
       
      linux/raise.c:51(__GI_raise)[0x7f721e0ba8eb]
      stdlib/abort.c:81(__GI_abort)[0x7f721e0a5535]
      sql/partition_info.cc:923(vers_create_partitions(THD*, TABLE_LIST*, unsigned int))[0x559ff4c4faa0]
      sql/sql_base.cc:3480(Open_table_context::recover_from_failed_open())[0x559ff4655b72]
      sql/sql_base.cc:4625(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x559ff465be19]
      sql/sql_base.h:480(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int))[0x559ff462f836]
      sql/sql_update.cc:410(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x559ff4b7c07c]
      sql/sql_parse.cc:4412(mysql_execute_command(THD*, bool))[0x559ff48051c5]
      sql/sql_parse.cc:8014(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x559ff481e6bb]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x559ff47f4ca0]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x559ff47f1993]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x559ff4cb5770]
      sql/sql_connect.cc:1320(handle_one_connection)[0x559ff4cb50c6]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x559ff5962867]
      nptl/pthread_create.c:487(start_thread)[0x7f721e572fa3]
      x86_64/clone.S:97(clone)[0x7f721e17c06f]
       
      Query (0x6290004742a8): UPDATE  test.t_vers_12380_8 AS tbl1 SET tbl1.`col1` = 0 WHERE tbl1.`col1` >= tbl1.`col1` AND tbl1.`col1` > tbl1.`col1` ORDER BY 1
      

      mysqld: /sql/partition_info.cc:918: bool vers_create_partitions(THD*, TABLE_LIST*, uint): Assertion `table->part_info' failed.
      240912 15:43:52 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.5.0-MariaDB-debug-log source revision: 08bd74e8860f473896b49ad7b42f4343de8dfc82
       
      linux/raise.c:51(__GI_raise)[0x7fd6b9e6c8eb]
      stdlib/abort.c:81(__GI_abort)[0x7fd6b9e57535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fd6b9e5740f]
      /lib/x86_64-linux-gnu/libc.so.6(+0x301a2)[0x7fd6b9e651a2]
      sql/partition_info.cc:919(vers_create_partitions(THD*, TABLE_LIST*, unsigned int))[0x56315581664a]
      sql/sql_base.cc:3539(Open_table_context::recover_from_failed_open())[0x563155205ad3]
      sql/sql_base.cc:4684(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x56315520bd8f]
      sql/sql_base.h:272(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5631551f2a3f]
      sql/sql_base.cc:5768(open_tables_for_query(THD*, TABLE_LIST*, unsigned int*, unsigned int, DML_prelocking_strategy*))[0x563155211c61]
      sql/sql_select.cc:33492(Sql_cmd_dml::prepare(THD*))[0x56315559d848]
      sql/sql_select.cc:33554(Sql_cmd_dml::execute(THD*))[0x56315559db88]
      sql/sql_parse.cc:4392(mysql_execute_command(THD*, bool))[0x5631553bc488]
      sql/sql_parse.cc:7815(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5631553d448c]
      sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5631553abe83]
      sql/sql_parse.cc:1406(do_command(THD*, bool))[0x5631553a8b41]
      sql/sql_connect.cc:1437(do_handle_one_connection(CONNECT*, bool))[0x56315587c827]
      sql/sql_connect.cc:1341(handle_one_connection)[0x56315587c17d]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x563156577e5d]
      nptl/pthread_create.c:487(start_thread)[0x7fd6ba324fa3]
      x86_64/clone.S:97(clone)[0x7fd6b9f2e06f]
       
      Query (0x62900031b2a8): UPDATE IGNORE `t_vers1` SET `col1` = DEFAULT ORDER BY `col1` LIMIT 4
      

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              alice Alice Sherepa
              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.