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

Assertion failure upon DML on table with vector under lock

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t (a INT, v BLOB NOT NULL, VECTOR(v)) ENGINE=InnoDB;
      INSERT INTO t VALUES (1,x'00000000'),(2,x'00000000');
      LOCK TABLE t WRITE;
      DELETE FROM t;
       
      # Cleanup
      DROP TABLE t;
      

      bb-11.6-MDEV-32887-vector 6651768a1db08b3887c68c735688715697a38732

      mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:619: static MHNSW_Trx* MHNSW_Trx::get_from_thd(TABLE*, bool): Assertion `!table->mdl_ticket || table->mdl_ticket->m_duration == MDL_TRANSACTION' failed.
      241002 12:22:39 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f34ff853e32 in __GI___assert_fail (assertion=0x55ec10b74d80 "!table->mdl_ticket || table->mdl_ticket->m_duration == MDL_TRANSACTION", file=0x55ec10b74b80 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc", line=619, function=0x55ec10b74e00 "static MHNSW_Trx* MHNSW_Trx::get_from_thd(TABLE*, bool)") at ./assert/assert.c:101
      #10 0x000055ec0ef3344a in MHNSW_Trx::get_from_thd (table=0x6190000ccb98, for_update=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:619
      #11 0x000055ec0ef3390e in MHNSW_Share::acquire (ctx=0x7f34f031fff0, table=0x6190000ccb98, for_update=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:657
      #12 0x000055ec0ef3e141 in mhnsw_invalidate (table=0x6190000ccb98, rec=0x6190000cd0c8 "\376\001", keyinfo=0x6190000cd330) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1385
      #13 0x000055ec0dfd6614 in TABLE::hlindexes_on_delete (this=0x6190000ccb98, buf=0x6190000cd0c8 "\376\001") at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:9944
      #14 0x000055ec0eb2e2d9 in handler::ha_delete_row (this=0x61d000302ab8, buf=0x6190000cd0c8 "\376\001") at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:8288
      #15 0x000055ec0e07a768 in TABLE::delete_row (this=0x6190000ccb98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_delete.cc:295
      #16 0x000055ec0e06d7a4 in Sql_cmd_delete::delete_from_single_table (this=0x6290000fb188, thd=0x62c0001e0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_delete.cc:854
      #17 0x000055ec0e077a27 in Sql_cmd_delete::execute_inner (this=0x6290000fb188, thd=0x62c0001e0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_delete.cc:1835
      #18 0x000055ec0e3552ee in Sql_cmd_dml::execute (this=0x6290000fb188, thd=0x62c0001e0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:33798
      #19 0x000055ec0e16d790 in mysql_execute_command (thd=0x62c0001e0218, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:4402
      #20 0x000055ec0e185bfa in mysql_parse (thd=0x62c0001e0218, rawbuf=0x6290000fa238 "DELETE FROM t", length=13, parser_state=0x7f34f03219f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
      #21 0x000055ec0e15cc1c in dispatch_command (command=COM_QUERY, thd=0x62c0001e0218, packet=0x629000280219 "DELETE FROM t", packet_length=13, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
      #22 0x000055ec0e159930 in do_command (thd=0x62c0001e0218, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
      #23 0x000055ec0e649189 in do_handle_one_connection (connect=0x6080000048b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
      #24 0x000055ec0e648b4a in handle_one_connection (arg=0x608000004838) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
      #25 0x000055ec0f2ec520 in pfs_spawn_thread (arg=0x617000008218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
      #26 0x00007f34ff8a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #27 0x00007f34ff92861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              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.