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

Assertion `newtrn->used_instances != (void*) tbl' failed in _ma_set_trn_for_table

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (a INT) ENGINE=Aria ;
      CREATE TABLE t2 (
        pk INT,
        b CHAR(255) CHARACTER SET utf8,
        c VARCHAR(255) CHARACTER SET utf8,
        PRIMARY KEY (pk)
      ) ENGINE=Aria PARTITION BY key (pk) partitions 2;
      CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2 ;
      INSERT IGNORE INTO t2 VALUES (1,'foo','bar'),(2,'qux','foobar');
      LOCK TABLES v2 WRITE CONCURRENT, t1 WRITE CONCURRENT, t2 WRITE;
      ALTER IGNORE TABLE t2 CHANGE COLUMN IF EXISTS f1 f2 INT;
       
      # Cleanup
      UNLOCK TABLES;
      DROP VIEW v2;
      DROP TABLE t1, t2;
      

      10.3 non-ASAN debug 4946eb7b

      mysqld: /data/src/10.3/storage/maria/ma_trnman.h:33: void _ma_set_trn_for_table(MARIA_HA*, TRN*): Assertion `newtrn->used_instances != (void*) tbl' failed.
      190222 20:13:22 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f06c96f2ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000561cec6a1f7b in _ma_set_trn_for_table (tbl=0x7f06a80ac180, newtrn=0x7f06a804ca50) at /data/src/10.3/storage/maria/ma_trnman.h:33
      #9  0x0000561cec6a453f in maria_create_trn_for_mysql (info=0x7f06a80ac180) at /data/src/10.3/storage/maria/ha_maria.cc:937
      #10 0x0000561cec6930a7 in _ma_setup_live_state (info=0x7f06a80ac180) at /data/src/10.3/storage/maria/ma_state.c:65
      #11 0x0000561cec694573 in _ma_block_start_trans (param=0x7f06a80ac180) at /data/src/10.3/storage/maria/ma_state.c:680
      #12 0x0000561cecc43865 in thr_multi_lock (data=0x7f06a8175810, count=2, owner=0x7f06a8002600, lock_wait_timeout=31536000) at /data/src/10.3/mysys/thr_lock.c:1318
      #13 0x0000561cec5c026d in mysql_lock_tables (thd=0x7f06a8000b00, sql_lock=0x7f06a81757e0, flags=18539) at /data/src/10.3/sql/lock.cc:355
      #14 0x0000561cec5c006e in mysql_lock_tables (thd=0x7f06a8000b00, tables=0x7f06a80b46f8, count=1, flags=18539) at /data/src/10.3/sql/lock.cc:304
      #15 0x0000561cec10c417 in Locked_tables_list::reopen_tables (this=0x7f06a8004800, thd=0x7f06a8000b00, need_reopen=true) at /data/src/10.3/sql/sql_base.cc:2521
      #16 0x0000561cec1a4af9 in mysql_execute_command (thd=0x7f06a8000b00) at /data/src/10.3/sql/sql_parse.cc:6318
      #17 0x0000561cec1a9a69 in mysql_parse (thd=0x7f06a8000b00, rawbuf=0x7f06a8014ce8 "ALTER IGNORE TABLE t2 CHANGE COLUMN IF EXISTS f1 f2 INT", length=55, parser_state=0x7f06c409a5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8095
      #18 0x0000561cec196c1d in dispatch_command (command=COM_QUERY, thd=0x7f06a8000b00, packet=0x7f06a800b1f1 "ALTER IGNORE TABLE t2 CHANGE COLUMN IF EXISTS f1 f2 INT", packet_length=55, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1854
      #19 0x0000561cec1955f5 in do_command (thd=0x7f06a8000b00) at /data/src/10.3/sql/sql_parse.cc:1396
      #20 0x0000561cec2fdd07 in do_handle_one_connection (connect=0x561cefb64f80) at /data/src/10.3/sql/sql_connect.cc:1403
      #21 0x0000561cec2fda8b in handle_one_connection (arg=0x561cefb64f80) at /data/src/10.3/sql/sql_connect.cc:1309
      #22 0x0000561cec799c1f in pfs_spawn_thread (arg=0x561cefb6d670) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #23 0x00007f06cb3c9494 in start_thread (arg=0x7f06c409b700) at pthread_create.c:333
      #24 0x00007f06c97af93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      No visible effect on a non-debug build and, strangely, on a debug ASAN build.
      Not reproducible on 10.4.
      10.2 crashes with MDEV-10748 instead.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              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.