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

DELETE HISTORY in prepared stmt crash

    XMLWordPrintable

Details

    Description

      Assertion `s && s->versioned' failed in TABLE::vers_end_field()

      CREATE OR REPLACE TABLE t1 (f INT);
      PREPARE stmt FROM 'TRUNCATE t1 TO system_time NOW()';
      EXECUTE stmt;
       
      # Cleanup
      DROP TABLE t1;
      

      bb-10.3-temporal 2ae2876a6ce4b1

      mysqld: /data/src/bb-10.3-temporal/sql/table.h:1547: Field* TABLE::vers_end_field() const: Assertion `s && s->versioned' failed.
      171217  2:02:45 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007ff90519eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055cc55ea97b6 in TABLE::vers_end_field (this=0x7ff8e400cad0) at /data/src/bb-10.3-temporal/sql/table.h:1547
      #9  0x000055cc563784fe in mysql_delete (thd=0x7ff8e4000b00, table_list=0x7ff8e40824a8, conds=0x0, order_list=0x0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:333
      #10 0x000055cc563b08b4 in Sql_cmd_truncate_table::execute (this=0x7ff8e4082bd8, thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:503
      #11 0x000055cc55eef5a5 in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6258
      #12 0x000055cc55f11cad in Prepared_statement::execute (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4682
      #13 0x000055cc55f100ca in Prepared_statement::execute_loop (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4111
      #14 0x000055cc55f0dd18 in mysql_sql_stmt_execute (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:3218
      #15 0x000055cc55ee6e3b in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3765
      #16 0x000055cc55ef40e4 in mysql_parse (thd=0x7ff8e4000b00, rawbuf=0x7ff8e4014c48 "EXECUTE stmt", length=12, parser_state=0x7ff9003b35f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
      #17 0x000055cc55ee18a7 in dispatch_command (command=COM_QUERY, thd=0x7ff8e4000b00, packet=0x7ff8e411ee21 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
      #18 0x000055cc55ee02db in do_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
      #19 0x000055cc56046ada in do_handle_one_connection (connect=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
      #20 0x000055cc56046867 in handle_one_connection (arg=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
      #21 0x000055cc564dccfc in pfs_spawn_thread (arg=0x55cc586e8590) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
      #22 0x00007ff906e75494 in start_thread (arg=0x7ff9003b4700) at pthread_create.c:333
      #23 0x00007ff90525b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Reproducible with InnoDB and MyISAM.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.