Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1114

LP #1713700: Assertion `inited == INDEX' failed.

    Details

      Description

      **Reported in Launchpad by Roel Van de Paar last update 22-11-2017 08:06:50

      mysqld: /git/PS-5.7.19_dbg/sql/handler.cc:3226: int handler::ha_index_read_map(uchar*, const uchar*, key_part_map, ha_rkey_function): Assertion `inited == INDEX' failed.

      Core was generated by `/sda/PS240817-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqld --no-defau'.
      Program terminated with signal 6, Aborted.
      #0 0x00007f1a428ee741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
      (gdb) t
      [Current thread is 1 (Thread 0x7f1a42eda700 (LWP 31553))]
      (gdb) bt
      #0 0x00007f1a428ee741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1 0x0000000001862e06 in my_write_core (sig=6) at /git/PS-5.7.19_dbg/mysys/stacktrace.c:249
      #2 0x0000000000e8a2af in handle_fatal_signal (sig=6) at /git/PS-5.7.19_dbg/sql/signal_handler.cc:223
      #3 <signal handler called>
      #4 0x00007f1a40c821d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5 0x00007f1a40c838c8 in __GI_abort () at abort.c:90
      #6 0x00007f1a40c7b146 in __assert_fail_base (fmt=0x7f1a40dcc3a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
      assertion=assertion@entry=0x1ddb0fd "inited == INDEX", file=file@entry=0x1dda1f0 "/git/PS-5.7.19_dbg/sql/handler.cc",
      line=line@entry=3226,
      function=function@entry=0x1ddd720 <handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)::_PRETTY_FUNCTION_> "int handler::ha_index_read_map(uchar*, const uchar*, key_part_map, ha_rkey_function)") at assert.c:92
      #7 0x00007f1a40c7b1f2 in _GI__assert_fail (assertion=0x1ddb0fd "inited == INDEX",
      file=0x1dda1f0 "/git/PS-5.7.19_dbg/sql/handler.cc", line=3226,
      function=0x1ddd720 <handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function)::_PRETTY_FUNCTION_> "int handler::ha_index_read_map(uchar*, const uchar*, key_part_map, ha_rkey_function)") at assert.c:101
      #8 0x0000000000f1c641 in handler::ha_index_read_map (this=0x7f19cdc2a830, buf=0x7f19cdefe040 "\377\376",
      key=0x7f19cdef2032 "tW\267\255)\016\232\207\005", keypart_map=18446744073709551615, find_flag=HA_READ_KEY_EXACT)
      at /git/PS-5.7.19_dbg/sql/handler.cc:3226
      #9 0x00000000014e8190 in check_unique_constraint (table=0x7f19ce171030) at /git/PS-5.7.19_dbg/sql/sql_executor.cc:3333
      #10 0x00000000014e1c35 in end_sj_materialize (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a4a0, end_of_records=false)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:622
      #11 0x00000000014e3cad in evaluate_join_record (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a328)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1639
      #12 0x00000000014e30ed in sub_select (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a328, end_of_records=false)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1291
      #13 0x00000000014e6007 in join_materialize_semijoin (tab=0x7f19cdc7a1b0) at /git/PS-5.7.19_dbg/sql/sql_executor.cc:2533
      #14 0x00000000014e31cd in QEP_TAB::prepare_scan (this=0x7f19cdc7a1b0) at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1325
      #15 0x00000000014e2d2f in sub_select_op (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a1b0, end_of_records=false)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1068
      #16 0x00000000014e3cad in evaluate_join_record (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a038)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1639
      #17 0x00000000014e30ed in sub_select (join=0x7f19cdcf8828, qep_tab=0x7f19cdc7a038, end_of_records=false)
      at /git/PS-5.7.19_dbg/sql/sql_executor.cc:1291
      #18 0x00000000014e296e in do_select (join=0x7f19cdcf8828) at /git/PS-5.7.19_dbg/sql/sql_executor.cc:944
      #19 0x00000000014e08ef in JOIN::exec (this=0x7f19cdcf8828) at /git/PS-5.7.19_dbg/sql/sql_executor.cc:199
      #20 0x000000000157d9b9 in handle_query (thd=0x7f19cdc12000, lex=0x7f19cdc145e8, result=0x7f19cdf3fd38, added_options=0,
      removed_options=0) at /git/PS-5.7.19_dbg/sql/sql_select.cc:185
      #21 0x00000000015313fc in execute_sqlcom_select (thd=0x7f19cdc12000, all_tables=0x7f19cdf3f268)
      #22 0x000000000152a551 in mysql_execute_command (thd=0x7f19cdc12000, first_level=true) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:2942
      #23 0x0000000001532408 in mysql_parse (thd=0x7f19cdc12000, parser_state=0x7f1a42ed94e0) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:5891
      #24 0x0000000001526fe7 in dispatch_command (thd=0x7f19cdc12000, com_data=0x7f1a42ed9c90, command=COM_QUERY)
      at /git/PS-5.7.19_dbg/sql/sql_parse.cc:1493
      #25 0x0000000001525e2d in do_command (thd=0x7f19cdc12000) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:1021
      #26 0x000000000166583a in handle_connection (arg=0x7f19cdc11040)
      at /git/PS-5.7.19_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #27 0x00000000018919e5 in pfs_spawn_thread (arg=0x7f1a34fec520) at /git/PS-5.7.19_dbg/storage/perfschema/pfs.cc:2188
      #28 0x00007f1a428e9dc5 in start_thread (arg=0x7f1a42eda700) at pthread_create.c:308
      #29 0x00007f1a40d4473d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

      1. mysqld options required for replay: --sql_mode=
        DROP DATABASE test; CREATE DATABASE test; USE test;
        SET @@join_buffer_size=8192;
        SET @@tmp_table_size=1024;
        CREATE TABLE t1(a NATIONAL VARCHAR(16382)) ROW_FORMAT=COMPRESSED ENGINE=InnoDB;
        INSERT INTO t1 VALUES(0xA7FB);
        INSERT INTO t1 VALUES('a');
        INSERT INTO t1 VALUES(22387);
        SELECT * FROM t1 WHERE a IN(SELECT * FROM t1);

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  lpjirasync lpjirasync (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: