handle_fatal_signal (sig=11) in set_null from set_field_to_null_with_conversions
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
High
|
Unassigned | |||
5.6 |
New
|
High
|
Unassigned | |||
5.7 |
New
|
High
|
Unassigned |
Bug Description
+bt
#0 0x00007fbf2b19f741 in __pthread_kill (threadid=
#1 0x00000000007f9078 in my_write_core (sig=11) at /git/percona-
#2 0x00000000006b9296 in handle_fatal_signal (sig=11) at /git/percona-
#3 <signal handler called>
#4 0x00000000006b479c in set_null (row_offset=0, this=0x7fbf0800
#5 set_field_
#6 0x00000000006cbd20 in Item::save_in_field (this=0x7fbf080
#7 0x0000000000552202 in fill_record (thd=thd@
#8 0x00000000005522a9 in fill_record_
#9 0x000000000057dc57 in select_
#10 0x000000000058047c in select_
#11 0x00000000005df7c3 in JOIN::exec (this=this@
#12 0x00000000005db8f3 in mysql_select (thd=thd@
#13 0x00000000005dbb31 in handle_select (thd=thd@
#14 0x000000000059716d in mysql_execute_
#15 0x000000000059dc13 in mysql_parse (thd=thd@
#16 0x000000000059f617 in dispatch_command (command=
#17 0x00000000005a142f in do_command (thd=0x34f9a30) at /git/percona-
#18 0x000000000064f906 in do_handle_
#19 0x000000000064f9fc in handle_
#20 0x00007fbf2b19adc5 in start_thread (arg=0x7fbf2412
#21 0x00007fbf29a1721d in clone () at ../sysdeps/
The attached tarball (1463364118_
$ vi 1463364118_mybase # STEP1: Update the base path in this file (usually the only change required!). If you use a non-binary distribution, please update SOURCE_DIR location also
$ ./1463364118_init # STEP2: Initializes the data dir
$ ./1463364118_start # STEP3: Starts mysqld
$ ./1463364118_cl # STEP4: To check mysqld is up
$ ./1463364118_
$ vi /dev/shm/
$ ./1463364118_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1463364118_
Note ./1463364118_run (Run the testcase with the mysql CLI) will not reproduce the issue! It only reproduces using the pquery binary
Note that the reference to TokuDB engine in 1463364118.sql in the tarball is coincidental; you can just change the engine name to "DOESNOTEXIST".
SQL testcase (needs to be executed through pquery binary (included in tarball) as per above):
DROP DATABASE test;CREATE DATABASE test;USE test; COMPRESSED KEY_BLOCK_SIZE=16; NULL),( NULL); NULL,NULL, NULL),GREATEST( NULL,NULL) ;
CREATE TABLE t1(c1 INT KEY,c2 INT,INDEX x(c2)) ENGINE=DOESNOTEXIST ROW_FORMAT=
INSERT INTO t VALUES(
ALTER TABLE t1 PARTITION BY KEY(c1)PARTITIONS 5;
CREATE TABLE t2 ENGINE=MEMORY AS SELECT COALESCE(