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

Assertion `m_extra_cache' failed in ha_partition::late_extra_cache(uint)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 5.5.55
    • Partitioning
    • None
    • 10.2.2-3, 5.5.54, 5.5.55

    Description

      mysqld: /data/src/10.1/sql/ha_partition.cc:7426: void ha_partition::late_extra_cache(uint): Assertion `m_extra_cache' failed.
      160722 16:20:42 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f32289d6266 in __assert_fail_base (fmt=0x7f3228b0f238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f322bcce324 "m_extra_cache", file=file@entry=0x7f322bccc360 "/data/src/10.1/sql/ha_partition.cc", line=line@entry=7426, function=function@entry=0x7f322bccffa0 <ha_partition::late_extra_cache(unsigned int)::__PRETTY_FUNCTION__> "void ha_partition::late_extra_cache(uint)") at assert.c:92
      #7  0x00007f32289d6312 in __GI___assert_fail (assertion=0x7f322bcce324 "m_extra_cache", file=0x7f322bccc360 "/data/src/10.1/sql/ha_partition.cc", line=7426, function=0x7f322bccffa0 <ha_partition::late_extra_cache(unsigned int)::__PRETTY_FUNCTION__> "void ha_partition::late_extra_cache(uint)") at assert.c:101
      #8  0x00007f322ba39524 in ha_partition::late_extra_cache (this=0x7f31fbc9a088, partition_id=0) at /data/src/10.1/sql/ha_partition.cc:7426
      #9  0x00007f322ba34ac4 in ha_partition::rnd_init (this=0x7f31fbc9a088, scan=true) at /data/src/10.1/sql/ha_partition.cc:4787
      #10 0x00007f322b16c40c in handler::ha_rnd_init (this=0x7f31fbc9a088, scan=true) at /data/src/10.1/sql/handler.h:2782
      #11 0x00007f322b4196d9 in handler::read_first_row (this=0x7f31fbc9a088, buf=0x7f31fbc4f098 "\377\217\217\217\217\245\245\245\377\b", primary_key=64) at /data/src/10.1/sql/handler.cc:2770
      #12 0x00007f322b25c847 in handler::ha_read_first_row (this=0x7f31fbc9a088, buf=0x7f31fbc4f098 "\377\217\217\217\217\245\245\245\377\b", primary_key=64) at /data/src/10.1/sql/sql_class.h:5424
      #13 0x00007f322b2468f5 in join_read_system (tab=0x7f31fbc23060) at /data/src/10.1/sql/sql_select.cc:18846
      #14 0x00007f322b2464d9 in join_read_const_table (thd=0x7f3204f56070, tab=0x7f31fbc23060, pos=0x7f31fbc235b0) at /data/src/10.1/sql/sql_select.cc:18742
      #15 0x00007f322b22169a in make_join_statistics (join=0x7f31fbc22940, tables_list=..., keyuse_array=0x7f31fbc22c70) at /data/src/10.1/sql/sql_select.cc:3776
      #16 0x00007f322b218fa2 in JOIN::optimize_inner (this=0x7f31fbc22940) at /data/src/10.1/sql/sql_select.cc:1374
      #17 0x00007f322b217e56 in JOIN::optimize (this=0x7f31fbc22940) at /data/src/10.1/sql/sql_select.cc:1036
      #18 0x00007f322b2204ca in mysql_select (thd=0x7f3204f56070, rref_pointer_array=0x7f3204f5a400, tables=0x7f31fbc22258, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f31fbc22920, unit=0x7f3204f59a88, select_lex=0x7f3204f5a188) at /data/src/10.1/sql/sql_select.cc:3437
      #19 0x00007f322b21602c in handle_select (thd=0x7f3204f56070, lex=0x7f3204f599c0, result=0x7f31fbc22920, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
      #20 0x00007f322b1e6382 in execute_sqlcom_select (thd=0x7f3204f56070, all_tables=0x7f31fbc22258) at /data/src/10.1/sql/sql_parse.cc:5894
      #21 0x00007f322b1dc28f in mysql_execute_command (thd=0x7f3204f56070) at /data/src/10.1/sql/sql_parse.cc:2960
      #22 0x00007f322b1e9aba in mysql_parse (thd=0x7f3204f56070, rawbuf=0x7f31fbc22088 "SELECT * FROM t2", length=16, parser_state=0x7f322c10d630) at /data/src/10.1/sql/sql_parse.cc:7314
      #23 0x00007f322b1d84e4 in dispatch_command (command=COM_QUERY, thd=0x7f3204f56070, packet=0x7f3204ebb071 "SELECT * FROM t2", packet_length=16) at /data/src/10.1/sql/sql_parse.cc:1486
      #24 0x00007f322b1d721b in do_command (thd=0x7f3204f56070) at /data/src/10.1/sql/sql_parse.cc:1107
      #25 0x00007f322b30ce63 in do_handle_one_connection (thd_arg=0x7f3204f56070) at /data/src/10.1/sql/sql_connect.cc:1350
      #26 0x00007f322b30cbc7 in handle_one_connection (arg=0x7f3204f56070) at /data/src/10.1/sql/sql_connect.cc:1262
      #27 0x00007f322a8d80a4 in start_thread (arg=0x7f322c10eb00) at pthread_create.c:309
      #28 0x00007f3228a9087d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      --source include/have_partition.inc
       
      CREATE TABLE t1 (f1 INT) ENGINE=MyISAM;
      INSERT INTO t1 VALUES (1),(2);
       
      CREATE TABLE t2 (f2 INT) ENGINE=MyISAM PARTITION BY RANGE(f2) (PARTITION pmax VALUES LESS THAN MAXVALUE);
      INSERT INTO t2 VALUES (8);
       
      CREATE ALGORITHM = MERGE VIEW v AS SELECT f2 FROM t2, t1;
      UPDATE v SET f2 = 1;
       
      SELECT * FROM t2;
      

      Also reproducible on current 10.2 and on previous versions of MariaDB.
      Not reproducible on current MySQL 5.5 and 5.7.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Alexey Botchkov made transition -
          Open In Progress
          6d 20h 15m 1
          Alexey Botchkov made transition -
          Stalled In Progress
          62d 2h 18m 1
          Alexey Botchkov made transition -
          In Progress In Review
          143d 11h 43m 2
          Sergei Golubchik made transition -
          In Review Stalled
          1d 14h 36m 2
          Alexey Botchkov made transition -
          Stalled Closed
          7h 37m 1

          People

            holyfoot Alexey Botchkov
            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.