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

Assertion `!sys_trx_start && !sys_trx_end' failed in create_tmp_table

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (i INT) WITH SYSTEM VERSIONING;
      INSERT INTO t1 VALUES  (1),(2);
      INSERT INTO t1 (sys_trx_end) SELECT sys_trx_start FROM t1;
      

      bb-10.3-temporal 79dd77e6aebc861b

      mysqld: /data/src/bb-10.3-temporal/sql/sql_select.cc:17624: TABLE* create_tmp_table(THD*, TMP_TABLE_PARAM*, List<Item>&, ORDER*, bool, bool, ulonglong, ha_rows, const char*, bool, bool): Assertion `!sys_trx_start && !sys_trx_end' failed.
      171212 14:12:35 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007efc056c0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000563bd76f83ca in create_tmp_table (thd=0x7efbe4000b00, param=0x7efbe4018800, fields=..., group=0x0, distinct=false, save_sum_fields=false, select_options=3490056960, rows_limit=18446744073709551615, table_alias=0x563bd821ab15 "", do_not_open=true, keep_row_order=false) at /data/src/bb-10.3-temporal/sql/sql_select.cc:17624
      #9  0x0000563bd76d254b in JOIN::create_postjoin_aggr_table (this=0x7efbe4015dc0, tab=0x7efbe4017f18, table_fields=0x7efbe40160e0, table_group=0x0, save_sum_fields=false, distinct=false, keep_row_order=false) at /data/src/bb-10.3-temporal/sql/sql_select.cc:3317
      #10 0x0000563bd76d0ca9 in JOIN::make_aggr_tables_info (this=0x7efbe4015dc0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:2925
      #11 0x0000563bd76cf833 in JOIN::optimize_stage2 (this=0x7efbe4015dc0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:2603
      #12 0x0000563bd76cd391 in JOIN::optimize_inner (this=0x7efbe4015dc0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1921
      #13 0x0000563bd76cbb90 in JOIN::optimize (this=0x7efbe4015dc0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:1493
      #14 0x0000563bd76d52d0 in mysql_select (thd=0x7efbe4000b00, tables=0x7efbe4015640, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3489925888, result=0x7efbe4015d18, unit=0x7efbe4004870, select_lex=0x7efbe4004fd0) at /data/src/bb-10.3-temporal/sql/sql_select.cc:4179
      #15 0x0000563bd76c759e in handle_select (thd=0x7efbe4000b00, lex=0x7efbe40047a8, result=0x7efbe4015d18, setup_tables_done_option=1073741824) at /data/src/bb-10.3-temporal/sql/sql_select.cc:380
      #16 0x0000563bd768c0fe in mysql_execute_command (thd=0x7efbe4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:4820
      #17 0x0000563bd76960ec in mysql_parse (thd=0x7efbe4000b00, rawbuf=0x7efbe4014c58 "INSERT INTO t1 (sys_trx_end) SELECT sys_trx_start FROM t1", length=57, parser_state=0x7efc001305f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7985
      #18 0x0000563bd768385a in dispatch_command (command=COM_QUERY, thd=0x7efbe4000b00, packet=0x7efbe411dbf1 "INSERT INTO t1 (sys_trx_end) SELECT sys_trx_start FROM t1", packet_length=57, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1829
      #19 0x0000563bd768227b in do_command (thd=0x7efbe4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
      #20 0x0000563bd77e896e in do_handle_one_connection (connect=0x563bda3da610) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
      #21 0x0000563bd77e86fb in handle_one_connection (arg=0x563bda3da610) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
      #22 0x0000563bd7c7e094 in pfs_spawn_thread (arg=0x563bda3e2580) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
      #23 0x00007efc07397494 in start_thread (arg=0x7efc00131700) at pthread_create.c:333
      #24 0x00007efc0577d93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

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