[MDEV-11598] Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in Field_double::val_real() Created: 2016-12-18  Updated: 2017-01-11  Resolved: 2017-01-11

Status: Closed
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: 10.2
Fix Version/s: 10.2.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-5800 indexes on virtual (not materialized)... Closed

 Description    

CREATE TABLE IF NOT EXISTS X ( 
    f2 DOUBLE NOT NULL DEFAULT '0', 
    f3 DOUBLE NOT NULL DEFAULT '0', 
    f4 DOUBLE, 
    f5 DOUBLE DEFAULT '0',
 
    v4 DOUBLE AS (IF(f4,f3,f2)) VIRTUAL, 
    KEY (f5), 
    KEY (v4) 
);
 
INSERT INTO X (f2,f3,f4,f5) VALUES (5,4,1,0),(5,7,NULL,0);
 
INSERT INTO X (f2,f3,f4,f5) SELECT f2, f3, f5, f3 FROM X;
 
INSERT INTO X (f2,f3,f4,f5) VALUES (5,0,NULL,1);
 
INSERT INTO X (f2,f3,f4,f5) SELECT f2, f5, f5, f3 FROM X;
 
DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9;

10.2 c35b8c46b404d035e54a23d667da5dff6502fc2e

 
mysqld: /data/src/10.2/sql/field.cc:4771: virtual double Field_double::val_real(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
 
161218 18:48:31 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007fc8cc9e9312 in __GI___assert_fail (assertion=0x7fc8cf5726c0 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=0x7fc8cf571e67 "/data/src/10.2/sql/field.cc", line=4771, function=0x7fc8cf575ae0 <Field_double::val_real()::__PRETTY_FUNCTION__> "virtual double Field_double::val_real()") at assert.c:101
 
#8  0x00007fc8ced49bda in Field_double::val_real (this=<optimized out>) at /data/src/10.2/sql/field.cc:4771
 
#9  0x00007fc8ced7ba7c in Item_field::val_real (this=<optimized out>) at /data/src/10.2/sql/item.cc:2740
 
#10 0x00007fc8ced9d027 in Item_func_if::real_op (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_cmpfunc.cc:2425
 
#11 0x00007fc8cedd337a in Item_func_hybrid_field_type::val_real (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_func.cc:902
 
#12 0x00007fc8ced81b8e in Item::save_in_field (this=0x7fc8c3a0af70, field=0x7fc8c3827b58, no_conversions=<optimized out>) at /data/src/10.2/sql/item.cc:6293
 
#13 0x00007fc8cec554be in TABLE::update_virtual_fields (this=0x7fc8c38d5870, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7354
 
#14 0x00007fc8ced6e78c in handler::ha_index_read_map (this=this@entry=0x7fc8c39e0298, buf=0x7fc8c3827588 "\363", '\245' <repeats 24 times>, key=0x7fc8c39e0138 "", keypart_map=1, find_flag=<optimized out>) at /data/src/10.2/sql/handler.cc:2634
 
#15 0x00007fc8ced73ddc in handler::read_range_first (this=0x7fc8c39e0298, start_key=0x7fc8c39e0380, end_key=0x7fc8c39e03a0, eq_range_arg=<optimized out>, sorted=<optimized out>) at /data/src/10.2/sql/handler.cc:5318
 
#16 0x00007fc8cecbdd5e in handler::multi_range_read_next (this=0x7fc8c39e0298, range_info=range_info@entry=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:290
 
#17 0x00007fc8cecbde35 in Mrr_simple_index_reader::get_next (this=0x7fc8c39e0828, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:322
 
#18 0x00007fc8cecbf842 in DsMrr_impl::dsmrr_next (this=0x7fc8c39e06e8, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:1408
 
#19 0x00007fc8cf39d73e in ha_myisam::multi_range_read_next (this=<optimized out>, range_info=<optimized out>) at /data/src/10.2/storage/myisam/ha_myisam.cc:2355
 
#20 0x00007fc8cee809b9 in QUICK_RANGE_SELECT::get_next (this=0x7fc8c38ff140) at /data/src/10.2/sql/opt_range.cc:11189
 
#21 0x00007fc8cee852a8 in QUICK_ROR_UNION_SELECT::reset (this=0x7fc8c3852300) at /data/src/10.2/sql/opt_range.cc:1807
 
#22 0x00007fc8ced66dc5 in find_all_keys (found_rows=0x7fc8c3a9d3f0, pq=0x0, tempfile=0x7fc8cfb8ef30, buffpek_pointers=0x7fc8cfb8f0b0, fs_info=0x7fc8c3a9d200, select=0x7fc8c38656b8, param=0x7fc8cfb8ee90, thd=0x7fc8c3816070) at /data/src/10.2/sql/filesort.cc:776
 
#23 filesort (thd=thd@entry=0x7fc8c3816070, table=table@entry=0x7fc8c38d5870, filesort=filesort@entry=0x7fc8cfb8f790, tracker=0x7fc8c3865b20, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /data/src/10.2/sql/filesort.cc:284
 
#24 0x00007fc8ceec5a4c in mysql_delete (thd=thd@entry=0x7fc8c3816070, table_list=0x7fc8c38641b0, conds=0x7fc8c3864dd0, order_list=order_list@entry=0x7fc8c381a4a8, limit=9, options=<optimized out>, result=0x0) at /data/src/10.2/sql/sql_delete.cc:503
 
#25 0x00007fc8ceb8935b in mysql_execute_command (thd=thd@entry=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:4516
 
#26 0x00007fc8ceb8f2d2 in mysql_parse (thd=thd@entry=0x7fc8c3816070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fc8cfb918e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7790
 
#27 0x00007fc8ceb9155b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc8c3816070, packet=packet@entry=0x7fc8c3858071 "DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9", packet_length=packet_length@entry=59, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
 
#28 0x00007fc8ceb9408d in do_command (thd=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:1359
 
#29 0x00007fc8cec81f4a in do_handle_one_connection (connect=connect@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1354
 
#30 0x00007fc8cec82133 in handle_one_connection (arg=arg@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1260
 
#31 0x00007fc8cef301bf in pfs_spawn_thread (arg=0x7fc8cbc15df0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
 
#32 0x00007fc8ce2830a4 in start_thread (arg=0x7fc8cfb93300) at pthread_create.c:309
 
#33 0x00007fc8ccaa387d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111



 Comments   
Comment by Elena Stepanova [ 2017-01-02 ]

Also reproducible on bb-10.2-monty as of 349d69e2e

Comment by Michael Widenius [ 2017-01-04 ]

Found and fixed 2 problems:

  • Filesort addon fields didn't mark virtual columns properly
  • multi-range-read calculated vcol bitmap but was not using it.
    This caused wrong vcol field to be calculated on read, which caused the assert.
Comment by Michael Widenius [ 2017-01-04 ]

Fix pushed into bb-10.2-monty
Will be pushed soon into 10.2 (after some testing)

Comment by Elena Stepanova [ 2017-01-05 ]

The following test case still produces the same assertion failure, only in Field_varstring::val_str:

--source include/have_innodb.inc
 
 
 
CREATE TABLE t1 ( 
 d DECIMAL(63,0) NOT NULL DEFAULT 0,
 
 c VARCHAR(64) NOT NULL DEFAULT '',
 
 vd DECIMAL(63,0) AS (d) VIRTUAL,
 
 vc VARCHAR(2048) AS (c) VIRTUAL,
 
 pk BIGINT AUTO_INCREMENT,
 
 PRIMARY KEY(pk)
 
 ) ENGINE=InnoDB;
 
 
 
INSERT INTO t1 (d,c) VALUES (0.5,'foo');
 
SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd;

bb-10.2-monty e127bd70e55

 
mysqld: /data/src/bb-10.2-monty/sql/field.cc:7511: virtual String* Field_varstring::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
 
170105 14:56:37 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007fb8cb43f312 in __GI___assert_fail (assertion=0x7fb8cea5a040 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=0x7fb8cea59dd8 "/data/src/bb-10.2-monty/sql/field.cc", line=7511, function=0x7fb8cea5e420 <Field_varstring::val_str(String*, String*)::__PRETTY_FUNCTION__> "virtual String* Field_varstring::val_str(String*, String*)") at assert.c:101
 
#8  0x00007fb8ce16a24a in Field_varstring::val_str (this=0x7fb8a5428a90, val_buffer=0x7fb8cf038d50, val_ptr=0x7fb8cf038d50) at /data/src/bb-10.2-mo#9  0x00007fb8cde5b4ef in Field::val_str (this=0x7fb8a5428a90, str=0x7fb8cf038d50) at /data/src/bb-10.2-monty/sql/field.h:833
 
#10 0x00007fb8ce1754ee in Field::save_in_field_str (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:674
 
#11 0x00007fb8ce17671f in Field_str::save_in_field (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:1655
 
#12 0x00007fb8ce1755da in Field::store_field (this=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field.h:806
 
#13 0x00007fb8ce17db63 in field_conv_incompatible (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:814
 
#14 0x00007fb8ce17dbbf in field_conv (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:827
 
#15 0x00007fb8ce1a9d6b in save_field_in_field (from=0x7fb8a5428a90, null_value=0x7fb8a561130a, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6207
 
#16 0x00007fb8ce1a9f6a in Item_field::save_in_field (this=0x7fb8a5611298, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6253
 
#17 0x00007fb8ce026955 in TABLE::update_virtual_fields (this=0x7fb8a54d7870, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/bb-10.2-monty/sql/table.cc:7381
 
#18 0x00007fb8ce18b0f0 in handler::ha_rnd_next (this=0x7fb8a54b7888, buf=0x7fb8a55a5088 "\374\200") at /data/src/bb-10.2-monty/sql/handler.cc:2583
 
#19 0x00007fb8ce180568 in find_all_keys (thd=0x7fb8a5416070, param=0x7fb8cf039560, select=0x7fb8a54674d0, fs_info=0x7fb8a569e400, buffpek_pointers=0x7fb8cf039770, tempfile=0x7fb8cf0395f0, pq=0x0, found_rows=0x7fb8a569e5f0) at /data/src/bb-10.2-monty/sql/filesort.cc:793
 
#20 0x00007fb8ce17eb97 in filesort (thd=0x7fb8a5416070, table=0x7fb8a54d7870, filesort=0x7fb8a54676b0, tracker=0x7fb8a5467e88, join=0x7fb8a5464df0, first_table_bit=1) at /data/src/bb-10.2-monty/sql/filesort.cc:284
 
#21 0x00007fb8cdf931af in create_sort_index (thd=0x7fb8a5416070, join=0x7fb8a5464df0, tab=0x7fb8a5466b70, fsort=0x7fb8a54676b0) at /data/src/bb-10.2-monty/sql/sql_select.cc:21464
 
#22 0x00007fb8cdf8dc2a in st_join_table::sort_table (this=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19301
 
#23 0x00007fb8cdf8d922 in join_init_read_record (tab=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19248
 
#24 0x00007fb8cdf8b92d in sub_select (join=0x7fb8a5464df0, join_tab=0x7fb8a5466b70, end_of_records=false) at /data/src/bb-10.2-monty/sql/sql_select.cc:18340
 
#25 0x00007fb8cdf8af4d in do_select (join=0x7fb8a5464df0, procedure=0x0) at /data/src/bb-10.2-monty/sql/sql_select.cc:17887
 
#26 0x00007fb8cdf65fc4 in JOIN::exec_inner (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3388
 
#27 0x00007fb8cdf6550e in JOIN::exec (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3199
 
#28 0x00007fb8cdf66665 in mysql_select (thd=0x7fb8a5416070, tables=0x7fb8a5464298, wild_num=1, fields=..., conds=0x7fb8a5464a58, og_num=1, order=0x7fb8a5464cc0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb8a5464dd0, unit=0x7fb8a5419b48, select_lex=0x7fb8a541a278) at /data/src/bb-10.2-monty/sql/sql_select.cc:3584
 
#29 0x00007fb8cdf5b71d in handle_select (thd=0x7fb8a5416070, lex=0x7fb8a5419a80, result=0x7fb8a5464dd0, setup_tables_done_option=0) at /data/src/bb-10.2-monty/sql/sql_select.cc:373
 
#30 0x00007fb8cdf27ec9 in execute_sqlcom_select (thd=0x7fb8a5416070, all_tables=0x7fb8a5464298) at /data/src/bb-10.2-monty/sql/sql_parse.cc:6396
 
#31 0x00007fb8cdf1d9b8 in mysql_execute_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:3426
 
#32 0x00007fb8cdf2b888 in mysql_parse (thd=0x7fb8a5416070, rawbuf=0x7fb8a5464088 "SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd", length=46, parser_state=0x7fb8cf03add0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:7839
 
#33 0x00007fb8cdf1944e in dispatch_command (command=COM_QUERY, thd=0x7fb8a5416070, packet=0x7fb8a5458071 "", packet_length=46, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1799
 
#34 0x00007fb8cdf17e28 in do_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1359
 
#35 0x00007fb8ce05fc46 in do_handle_one_connection (connect=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1354
 
#36 0x00007fb8ce05f9d3 in handle_one_connection (arg=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1260
 
#37 0x00007fb8ce39e582 in pfs_spawn_thread (arg=0x7fb8b83ed770) at /data/src/bb-10.2-monty/storage/perfschema/pfs.cc:1862
 
#38 0x00007fb8cd54c0a4 in start_thread (arg=0x7fb8cf03c300) at pthread_create.c:309
 
#39 0x00007fb8cb4f987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Comment by Michael Widenius [ 2017-01-06 ]

Problem with read_set in filesort found and fixed.

Comment by Michael Widenius [ 2017-01-06 ]

Fix pushed to bb-10.2-monty

Generated at Thu Feb 08 07:51:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.