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

Assertion `m_extra_cache' failed in ha_partition::late_extra_cache

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (pk INT PRIMARY KEY, a INT);
      INSERT INTO t1 VALUES (1,10),(2,20);
       
      CREATE TABLE t2 (b INT) PARTITION BY KEY (b) PARTITIONS 2;
      INSERT INTO t2 VALUES (1),(2);
       
      DELETE t2 FROM t2 WHERE b BETWEEN 5 AND 9;
      UPDATE t2 JOIN t1 SET b = 5;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      10.0 a2c0376e08

      mysqld: /data/src/10.0/sql/ha_partition.cc:7464: void ha_partition::late_extra_cache(uint): Assertion `m_extra_cache' failed.
      180712 14:36:43 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f4152768ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000000000df8986 in ha_partition::late_extra_cache (this=0x7f414a87f088, partition_id=1) at /data/src/10.0/sql/ha_partition.cc:7464
      #9  0x0000000000df4409 in ha_partition::rnd_next (this=0x7f414a87f088, buf=0x7f414a8284a0 "\375\005") at /data/src/10.0/sql/ha_partition.cc:4976
      #10 0x00000000008404ec in handler::ha_rnd_next (this=0x7f414a87f088, buf=0x7f414a8284a0 "\375\005") at /data/src/10.0/sql/handler.cc:2625
      #11 0x0000000000971827 in rr_sequential (info=0x7f414a94b598) at /data/src/10.0/sql/records.cc:470
      #12 0x00000000006adae4 in sub_select (join=0x7f414a8fb6d0, join_tab=0x7f414a94b4f0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18003
      #13 0x00000000006ad2a4 in do_select (join=0x7f414a8fb6d0, fields=0x7f41547eebd0, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17646
      #14 0x000000000068a01d in JOIN::exec_inner (this=0x7f414a8fb6d0) at /data/src/10.0/sql/sql_select.cc:3116
      #15 0x00000000006874da in JOIN::exec (this=0x7f414a8fb6d0) at /data/src/10.0/sql/sql_select.cc:2402
      #16 0x000000000068a87c in mysql_select (thd=0x7f414c6a8070, rref_pointer_array=0x7f414c6ac3a0, tables=0x7f414a8fa170, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f414a8fb610, unit=0x7f414c6aba08, select_lex=0x7f414c6ac0f8) at /data/src/10.0/sql/sql_select.cc:3341
      #17 0x000000000071b2c3 in mysql_multi_update (thd=0x7f414c6a8070, table_list=0x7f414a8fa170, fields=0x7f414c6ac210, values=0x7f414c6ac6c8, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f414c6aba08, select_lex=0x7f414c6ac0f8, result=0x7f41547ef2e0) at /data/src/10.0/sql/sql_update.cc:1599
      #18 0x000000000064f416 in mysql_execute_command (thd=0x7f414c6a8070) at /data/src/10.0/sql/sql_parse.cc:3378
      #19 0x0000000000657dd6 in mysql_parse (thd=0x7f414c6a8070, rawbuf=0x7f414a8fa088 "UPDATE t2 JOIN t1 SET b = 5", length=27, parser_state=0x7f41547ef640) at /data/src/10.0/sql/sql_parse.cc:6634
      #20 0x000000000064a6f6 in dispatch_command (command=COM_QUERY, thd=0x7f414c6a8070, packet=0x7f414dbe5071 "UPDATE t2 JOIN t1 SET b = 5", packet_length=27) at /data/src/10.0/sql/sql_parse.cc:1297
      #21 0x00000000006499f6 in do_command (thd=0x7f414c6a8070) at /data/src/10.0/sql/sql_parse.cc:1000
      #22 0x000000000076a872 in do_handle_one_connection (thd_arg=0x7f414c6a8070) at /data/src/10.0/sql/sql_connect.cc:1377
      #23 0x000000000076a5e4 in handle_one_connection (arg=0x7f414c6a8070) at /data/src/10.0/sql/sql_connect.cc:1292
      #24 0x0000000000acc722 in pfs_spawn_thread (arg=0x7f414c5a25f0) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #25 0x00007f415446c494 in start_thread (arg=0x7f41547f0700) at pthread_create.c:333
      #26 0x00007f415282593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      No visible effect on non-debug builds.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            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.