Assertion `length == 0 || json_binary::parse_binary(ptr, length).is_valid()' failed in sql/field.cc:8975: type_conversion_status Field_json::store_binary(const char*, size_t)
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
** Testcase
# mysqld options required for replay: --sql_mode=
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t0(a int,b int,key using BTREE (a,b),key using BTREE (b)) ENGINE=HEAP;
ALTER TABLE t0 ADD COLUMN utf0k json;
INSERT INTO t0 values(
INSERT INTO t0 VALUES(0,'MySQL Tutorial','DBMS stands for DataBase ...'),(0,'How To Use MySQL Well','After you went through a ...'),(
insert INTO t0 select * FROM t0;
PS : Attached error log with bug bundle.
** How to reproduce :
The attached tarball (1453347541_
$ vi 1453347541_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
$ ./1453347541_init # STEP2: Initializes the data dir
$ ./1453347541_start # STEP3: Starts mysqld
$ ./1453347541_cl # STEP4: To check mysqld is up
$ ./1453347541_
$ ./1453347541_run # OPTIONAL: Run the testcase with the mysql CLI (may not reproduce the issue, as the pquery binary was used for the original testcase reduction)
$ vi /dev/shm/
$ ./1453347541_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1453347541_
** GDB info
#0 0x00007f7882a91741 in pthread_kill () from /lib64/
#1 0x0000000001811a80 in my_write_core (sig=6) at /sda/ps5.
#2 0x0000000000e60b43 in handle_fatal_signal (sig=6) at /sda/ps5.
#3 <signal handler called>
#4 0x00007f7880c1e5f7 in raise () from /lib64/libc.so.6
#5 0x00007f7880c1fce8 in abort () from /lib64/libc.so.6
#6 0x00007f7880c17566 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f7880c17612 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000ec756d in Field_json:
#9 0x0000000000ec7818 in Field_json::store (this=0x7f78458
#10 0x0000000001691e86 in field_conv (to=0x7f78458ae1b0, from=0x7f78458a
#11 0x0000000000f17aa1 in Item_field:
#12 0x0000000000f17b3e in Item::save_in_field (this=0x7f78459
#13 0x000000000148a432 in fill_record (thd=0x7f784581
#14 0x000000000148a707 in fill_record_
#15 0x00000000017062f0 in Query_result_
#16 0x0000000001705f6e in Query_result_
#17 0x00000000014c4053 in end_send (join=0x7f78459
#18 0x00000000014c0d13 in evaluate_
#19 0x00000000014c8c06 in QEP_tmp_
#20 0x00000000014bfd83 in sub_select_op (join=0x7f78459
#21 0x00000000014bfeb6 in sub_select (join=0x7f78459
#22 0x00000000014bfa36 in do_select (join=0x7f78459
#23 0x00000000014bd98b in JOIN::exec (this=0x7f78459
#24 0x0000000001559576 in handle_query (thd=0x7f784581
#25 0x0000000001708bc4 in Sql_cmd_
#26 0x0000000001509669 in mysql_execute_
#27 0x000000000150f32a in mysql_parse (thd=0x7f784581
#28 0x0000000001504341 in dispatch_command (thd=0x7f784581
#29 0x000000000150325b in do_command (thd=0x7f784581
#30 0x000000000163ad13 in handle_connection (arg=0x7f786ebf
#31 0x00000000018b119c in pfs_spawn_thread (arg=0x7f786e3f
#32 0x00007f7882a8cdc5 in start_thread () from /lib64/
#33 0x00007f7880cdf21d in clone () from /lib64/libc.so.6
tags: | added: memory-se |
Please run the testcase with pquery binary to reproduce the issue : ie STEP 5.