[MDEV-6486] Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed with SELECT SQ, TEXT field - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.3.12, 5.5.38, 10.0.12
Fix Version/s: 5.5.55
Component/s: Optimizer
Labels:
None

Sprint:
10.2.5-1

Description

mysqld: 5.5/sql/field.cc:7203: virtual String* Field_blob::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.

140725 11:48:26 [ERROR] mysqld got signal 6 ;

#6  0x00007f954dd8a621 in *__GI___assert_fail (assertion=0xe2c4d0 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=<optimized out>, line=7203, function=0xe2e5e0 "virtual String* Field_blob::val_str(String*, String*)") at assert.c:81

#7  0x00000000007ce43f in Field_blob::val_str (this=0x7f9548859a68, val_buffer=0x7f95493b3330, val_ptr=0x7f95493b3330) at 5.5/sql/field.cc:7203

#8  0x000000000059a485 in Field::val_str (this=0x7f9548859a68, str=0x7f95493b3330) at 5.5/sql/field.h:277

#9  0x00000000007dbfad in do_field_string (copy=0x7f95489818b8) at 5.5/sql/field_conv.cc:369

#10 0x00000000007dba40 in do_copy_null (copy=0x7f95489818b8) at 5.5/sql/field_conv.cc:242

#11 0x000000000069fd7e in store_key_field::copy_inner (this=0x7f9548981890) at 5.5/sql/sql_select.h:1613

#12 0x000000000069fb9b in store_key::copy (this=0x7f9548981890) at 5.5/sql/sql_select.h:1554

#13 0x00000000006920be in cp_buffer_from_ref (thd=0x7f954c749060, table=0x7f95489d4860, ref=0x7f9548981710) at 5.5/sql/sql_select.cc:20319

#14 0x000000000068b357 in join_read_always_key (tab=0x7f9548981500) at 5.5/sql/sql_select.cc:17576

#15 0x00000000006899bb in sub_select (join=0x7f9548992eb0, join_tab=0x7f9548981500, end_of_records=false) at 5.5/sql/sql_select.cc:16836

#16 0x000000000068927b in do_select (join=0x7f9548992eb0, fields=0x7f9548993270, table=0x0, procedure=0x0) at 5.5/sql/sql_select.cc:16501

#17 0x00000000006681af in JOIN::exec (this=0x7f9548992eb0) at 5.5/sql/sql_select.cc:2873

#18 0x000000000087ec1f in subselect_single_select_engine::exec (this=0x7f95489498d8) at 5.5/sql/item_subselect.cc:3231

#19 0x00000000008778b2 in Item_subselect::exec (this=0x7f95489497a0) at 5.5/sql/item_subselect.cc:655

#20 0x0000000000879004 in Item_singlerow_subselect::val_int (this=0x7f95489497a0) at 5.5/sql/item_subselect.cc:1232

#21 0x000000000059bb91 in Item::val_int_result (this=0x7f95489497a0) at 5.5/sql/item.h:977

#22 0x0000000000808cf3 in Item_cache_int::cache_value (this=0x7f9548981f28) at 5.5/sql/item.cc:8854

#23 0x0000000000810232 in Item_cache_wrapper::cache (this=0x7f9548981e70) at 5.5/sql/item.cc:7658

#24 0x0000000000805a7f in Item_cache_wrapper::val_int (this=0x7f9548981e70) at 5.5/sql/item.cc:7712

#25 0x000000000059bb91 in Item::val_int_result (this=0x7f9548981e70) at 5.5/sql/item.h:977

#26 0x00000000007e0bd4 in make_sortkey (param=0x7f95493b40d0, to=0x7f954880e3c0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245h4z\025\245\245\245\245\245\245\245\245ZZZZZZZZ"..., ref_pos=0x7f9548859c00 "") at 5.5/sql/filesort.cc:969

#27 0x00000000007e0278 in find_all_keys (param=0x7f95493b40d0, select=0x7f9548980968, sort_keys=0x7f954880e360, sort_keys_buf=0x7f954880e3c0 "\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245h4z\025\245\245\245\245\245\245\245\245ZZZZZZZZ"..., buffpek_pointers=0x7f95493b42e0, tempfile=0x7f95493b4150) at 5.5/sql/filesort.cc:748

#28 0x00000000007deaec in filesort (thd=0x7f954c749060, table=0x7f95489d9860, sortorder=0x7f95489b56b8, s_length=1, select=0x7f9548980968, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x7f95493b4578) at 5.5/sql/filesort.cc:241

#29 0x0000000000690d23 in create_sort_index (thd=0x7f954c749060, join=0x7f9548992740, order=0x7f9548992640, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=true) at 5.5/sql/sql_select.cc:19785

#30 0x0000000000667f9e in JOIN::exec (this=0x7f9548992740) at 5.5/sql/sql_select.cc:2843

#31 0x00000000006689b9 in mysql_select (thd=0x7f954c749060, rref_pointer_array=0x7f954c74ccc8, tables=0x7f9548992078, wild_num=0, fields=..., conds=0x7f9548949df0, og_num=1, order=0x0, group=0x7f9548992640, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9548992720, unit=0x7f954c74c380, select_lex=0x7f954c74ca58) at 5.5/sql/sql_select.cc:3094

#32 0x000000000065f489 in handle_select (thd=0x7f954c749060, lex=0x7f954c74c2d0, result=0x7f9548992720, setup_tables_done_option=0) at 5.5/sql/sql_select.cc:319

#33 0x0000000000638a9f in execute_sqlcom_select (thd=0x7f954c749060, all_tables=0x7f9548992078) at 5.5/sql/sql_parse.cc:4688

#34 0x0000000000631c81 in mysql_execute_command (thd=0x7f954c749060) at 5.5/sql/sql_parse.cc:2233

#35 0x000000000063b1ae in mysql_parse (thd=0x7f954c749060, rawbuf=0x7f9548948078 "SELECT ( SELECT COUNT(*) FROM t1 WHERE a = c ) AS field, COUNT( DISTINCT c ) FROM t2 WHERE b <= 'quux' GROUP BY field", length=117, parser_state=0x7f95493b5630) at 5.5/sql/sql_parse.cc:5799

#36 0x000000000062f1f9 in dispatch_command (command=COM_QUERY, thd=0x7f954c749060, packet=0x7f9549afa061 "SELECT ( SELECT COUNT(*) FROM t1 WHERE a = c ) AS field, COUNT( DISTINCT c ) FROM t2 WHERE b <= 'quux' GROUP BY field", packet_length=117) at 5.5/sql/sql_parse.cc:1079

#37 0x000000000062e385 in do_command (thd=0x7f954c749060) at 5.5/sql/sql_parse.cc:793

#38 0x000000000072ffea in do_handle_one_connection (thd_arg=0x7f954c749060) at 5.5/sql/sql_connect.cc:1266

#39 0x000000000072faa9 in handle_one_connection (arg=0x7f954c749060) at 5.5/sql/sql_connect.cc:1181

#40 0x0000000000b64f09 in pfs_spawn_thread (arg=0x7f954a7fa8e0) at 5.5/storage/perfschema/pfs.cc:1015

#41 0x00007f954f2eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#42 0x00007f954de39a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Stack trace from

revision-id: jplindst@mariadb.org-20140725063405-65apg29t9bnlif5w

revno: 4238

branch-nick: 5.5

Test case:

CREATE TABLE t1 (a VARCHAR(8), KEY(a)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('foo'),( 'bar');

CREATE TABLE t2 (b VARCHAR(8), c TINYTEXT, KEY(b)) ENGINE=MyISAM;

INSERT INTO t2 VALUES ('baz','baz'),('qux', 'qux');

EXPLAIN EXTENDED

SELECT ( SELECT COUNT(*) FROM t1 WHERE a = c ) AS field, COUNT( DISTINCT c ) FROM t2 WHERE b <= 'quux' GROUP BY field;

SELECT ( SELECT COUNT(*) FROM t1 WHERE a = c ) AS field, COUNT( DISTINCT c ) FROM t2 WHERE b <= 'quux' GROUP BY field;

EXPLAIN:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

1	PRIMARY	t2	range	b	b	11	NULL	1	100.00	Using index condition; Using filesort

2	DEPENDENT SUBQUERY	t1	ref	a	a	11	test.t2.c	2	100.00	Using where; Using index

Warnings:

Note	1276	Field or reference 'test.t2.c' of SELECT #2 was resolved in SELECT #1

Note	1003	select <expr_cache><`test`.`t2`.`c`>((select count(0) from `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`c`))) AS `field`,count(distinct `test`.`t2`.`c`) AS `COUNT( DISTINCT c )` from `test`.`t2` where (`test`.`t2`.`b` <= 'quux') group by <expr_cache><`test`.`t2`.`c`>((select count(0) from `test`.`t1` where (`test`.`t1`.`a` = `test`.`t2`.`c`)))

Attachments

Issue Links

relates to

MDEV-10053 Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in Field_long::val_int()

Closed

Activity

Transition	Time In Source Status	Execution Times

Varun Gupta (Inactive) made transition - 2017-02-17 20:45

Open

In Progress

938d 9h 34m

Varun Gupta (Inactive) made transition - 2017-02-20 16:02

In Progress

Stalled

2d 19h 17m

Varun Gupta (Inactive) made transition - 2017-02-28 15:45

Stalled

In Progress

7d 23h 43m

Varun Gupta (Inactive) made transition - 2017-03-11 04:26

In Progress

In Review

10d 12h 40m

Sergei Petrunia made transition - 2017-03-13 17:57

In Review

Stalled

2d 13h 31m

Varun Gupta (Inactive) made transition - 2017-03-14 12:05

Stalled

Closed

18h 8m

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2014-07-25 11:10

Updated:: 2017-03-14 12:05

Resolved:: 2017-03-14 12:05

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration