Assertion `inited == INDEX' failed.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
New
|
High
|
Unassigned | |||
5.6 |
New
|
High
|
Unassigned | |||
5.7 |
Triaged
|
High
|
Unassigned |
Bug Description
mysqld: /git/PS-
Core was generated by `/sda/PS240817-
Program terminated with signal 6, Aborted.
#0 0x00007f1a428ee741 in __pthread_kill (threadid=
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=
#1 0x0000000001862e06 in my_write_core (sig=6) at /git/PS-
#2 0x0000000000e8a2af in handle_fatal_signal (sig=6) at /git/PS-
#3 <signal handler called>
#4 0x00007f1a40c821d7 in __GI_raise (sig=sig@entry=6) at ../nptl/
#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=
line=
function=
#7 0x00007f1a40c7b1f2 in __GI___assert_fail (assertion=
file=0x1dda1f0 "/git/PS-
function=
#8 0x0000000000f1c641 in handler:
key=
at /git/PS-
#9 0x00000000014e8190 in check_unique_
#10 0x00000000014e1c35 in end_sj_materialize (join=0x7f19cdc
at /git/PS-
#11 0x00000000014e3cad in evaluate_
at /git/PS-
#12 0x00000000014e30ed in sub_select (join=0x7f19cdc
at /git/PS-
#13 0x00000000014e6007 in join_materializ
#14 0x00000000014e31cd in QEP_TAB:
#15 0x00000000014e2d2f in sub_select_op (join=0x7f19cdc
at /git/PS-
#16 0x00000000014e3cad in evaluate_
at /git/PS-
#17 0x00000000014e30ed in sub_select (join=0x7f19cdc
at /git/PS-
#18 0x00000000014e296e in do_select (join=0x7f19cdc
#19 0x00000000014e08ef in JOIN::exec (this=0x7f19cdc
#20 0x000000000157d9b9 in handle_query (thd=0x7f19cdc1
removed_
#21 0x00000000015313fc in execute_
#22 0x000000000152a551 in mysql_execute_
#23 0x0000000001532408 in mysql_parse (thd=0x7f19cdc1
#24 0x0000000001526fe7 in dispatch_command (thd=0x7f19cdc1
at /git/PS-
#25 0x0000000001525e2d in do_command (thd=0x7f19cdc1
#26 0x000000000166583a in handle_connection (arg=0x7f19cdc1
at /git/PS-
#27 0x00000000018919e5 in pfs_spawn_thread (arg=0x7f1a34fe
#28 0x00007f1a428e9dc5 in start_thread (arg=0x7f1a42ed
#29 0x00007f1a40d4473d in clone () at ../sysdeps/
# mysqld options required for replay: --sql_mode=
DROP DATABASE test; CREATE DATABASE test; USE test;
SET @@join_
SET @@tmp_table_
CREATE TABLE t1(a NATIONAL VARCHAR(16382)) ROW_FORMAT=
INSERT INTO t1 VALUES(0xA7FB);
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES(22387);
SELECT * FROM t1 WHERE a IN(SELECT * FROM t1);
tags: | added: memory-se |
Discussed with Laurynas. Changing the testcase to (only last line changed);
SELECT SQL_BIG_RESULT * FROM (SELECT * FROM t1) AS ta;
Does not crash.
His conclusion;
1) not a showstopper but High triage
2) likely not upstream
3) it’s a MEMORY engine VARCHAR patch, default config will not hit easily (max tmp table size of 1KB) with several workarounds