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

Assertion `0' failed in Delayed_prelocking_strategy::handle_view

    XMLWordPrintable

Details

    Description

      CREATE TABLE t (a INT) ENGINE=MyISAM;
      CREATE VIEW v AS SELECT * FROM t;
      PREPARE stmt FROM " INSERT DELAYED INTO v VALUES (NULL)";
      DROP VIEW v;
      CREATE TABLE v (a INT) ENGINE=MyISAM;
      EXECUTE stmt;
       
      # Cleanup
      DROP TABLE v, t;
      

      10.4 ba94778d2c438d4c0f93ce031e504f7d78e895e1

      mysqld: /data/bld/10.4-asan/sql/sql_insert.cc:2986: virtual bool Delayed_prelocking_strategy::handle_view(THD*, Query_tables_list*, TABLE_LIST*, bool*): Assertion `0' failed.
      231210 17:03:07 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f3814f74e32 in __GI___assert_fail (assertion=0x55cbd22f2c20 "0", file=0x55cbd22f1060 "/data/bld/10.4-asan/sql/sql_insert.cc", line=2986, function=0x55cbd22f2d00 "virtual bool Delayed_prelocking_strategy::handle_view(THD*, Query_tables_list*, TABLE_LIST*, bool*)") at ./assert/assert.c:101
      #10 0x000055cbd01b4a1e in Delayed_prelocking_strategy::handle_view (this=0x7f380b314b30, thd=0x62c000068228, prelocking_ctx=0x62c00006c098, table_list=0x62c00006ea20, need_prelocking=0x7f380b3145e0) at /data/bld/10.4-asan/sql/sql_insert.cc:2986
      #11 0x000055cbd00d4985 in open_and_process_table (thd=0x62c000068228, tables=0x62c00006ea20, counter=0x7f380b314930, flags=65537, prelocking_strategy=0x7f380b314b30, has_prelocking_list=false, ot_ctx=0x7f380b314820) at /data/bld/10.4-asan/sql/sql_base.cc:4010
      #12 0x000055cbd00d6a64 in open_tables (thd=0x62c000068228, options=..., start=0x7f380b314940, counter=0x7f380b314930, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:4399
      #13 0x000055cbd00dbb7f in open_and_lock_tables (thd=0x62c000068228, options=..., tables=0x62c00006ea20, derived=false, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:5346
      #14 0x000055cbd00bf493 in open_and_lock_tables (thd=0x62c000068228, tables=0x62c00006ea20, derived=false, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.h:270
      #15 0x000055cbd00daa9f in open_n_lock_single_table (thd=0x62c000068228, table_l=0x62c00006ea20, lock_type=TL_WRITE_DELAYED, flags=65537, prelocking_strategy=0x7f380b314b30) at /data/bld/10.4-asan/sql/sql_base.cc:5189
      #16 0x000055cbd01b4aff in Delayed_insert::open_and_lock_table (this=0x62c000068208) at /data/bld/10.4-asan/sql/sql_insert.cc:3011
      #17 0x000055cbd01b5499 in handle_delayed_insert (arg=0x62c000068208) at /data/bld/10.4-asan/sql/sql_insert.cc:3114
      #18 0x000055cbd12ba9fe in pfs_spawn_thread (arg=0x615000010e88) at /data/bld/10.4-asan/storage/perfschema/pfs.cc:1869
      #19 0x00007f3814fc9044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #20 0x00007f381504961c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

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