[MDEV-15319] [SQL Layer] Server crashes in Field::set_null / myrocks::ha_rocksdb::convert_record_from_storage_format Created: 2018-02-14  Updated: 2018-06-13  Resolved: 2018-06-13

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.2, 10.3
Fix Version/s: 10.2.16

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-15318 CREATE .. SELECT VALUES produces inva... Closed

 Description   

Note: The problem is probably a side-effect of MDEV-15318 and will go away after it's fixed, but it's better to have it for the record, searchable in JIRA. Also, please note that MyISAM and InnoDB don't crash in the same situation.

INSTALL SONAME 'ha_rocksdb';
 
CREATE TABLE t1 (i INT);
INSERT INTO t1 VALUES (1);
CREATE TABLE t2 ENGINE=RocksDB AS SELECT VALUES(i) AS a FROM t1;
DELETE FROM t2;
 
# Cleanup
DROP TABLE IF EXISTS t1, t2;
UNINSTALL SONAME 'ha_rocksdb';

10.2 49bcc82686

#3  <signal handler called>
#4  0x00007f2eff6641d3 in Field::set_null (this=0x7f2f04378f88, row_offset=0) at /data/src/10.2/sql/./field.h:1135
#5  0x00007f2eff6425a7 in myrocks::ha_rocksdb::convert_record_from_storage_format (this=0x7f2f04378758, key=0x7f2f14244ba0, value=0x7f2f14244b40, buf=0x7f2f04378f68 "\377", '\245' <repeats 15 times>, "\210\217\067\004/\177") at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:5345
#6  0x00007f2eff641da8 in myrocks::ha_rocksdb::convert_record_from_storage_format (this=0x7f2f04378758, key=0x7f2f14244ba0, buf=0x7f2f04378f68 "\377", '\245' <repeats 15 times>, "\210\217\067\004/\177") at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:5150
#7  0x00007f2eff64ef04 in myrocks::ha_rocksdb::rnd_next_with_direction (this=0x7f2f04378758, buf=0x7f2f04378f68 "\377", '\245' <repeats 15 times>, "\210\217\067\004/\177", move_forward=true) at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:9352
#8  0x00007f2eff64e9cc in myrocks::ha_rocksdb::rnd_next (this=0x7f2f04378758, buf=0x7f2f04378f68 "\377", '\245' <repeats 15 times>, "\210\217\067\004/\177") at /data/src/10.2/storage/rocksdb/ha_rocksdb.cc:9251
#9  0x000055de70bc0c67 in handler::ha_rnd_next (this=0x7f2f04378758, buf=0x7f2f04378f68 "\377", '\245' <repeats 15 times>, "\210\217\067\004/\177") at /data/src/10.2/sql/handler.cc:2576
#10 0x000055de70d2cd8c in rr_sequential (info=0x7f2f14244ed0) at /data/src/10.2/sql/records.cc:485
#11 0x000055de70d5862c in mysql_delete (thd=0x7f2f04000b00, table_list=0x7f2f040125c0, conds=0x0, order_list=0x7f2f04005040, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559
#12 0x000055de7094d230 in mysql_execute_command (thd=0x7f2f04000b00) at /data/src/10.2/sql/sql_parse.cc:4616
#13 0x000055de709575f1 in mysql_parse (thd=0x7f2f04000b00, rawbuf=0x7f2f040124f8 "DELETE FROM t2", length=14, parser_state=0x7f2f14246200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902
#14 0x000055de70945511 in dispatch_command (command=COM_QUERY, thd=0x7f2f04000b00, packet=0x7f2f0416b561 "DELETE FROM t2", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806
#15 0x000055de70943e74 in do_command (thd=0x7f2f04000b00) at /data/src/10.2/sql/sql_parse.cc:1360
#16 0x000055de70a9264a in do_handle_one_connection (connect=0x55de72f433e0) at /data/src/10.2/sql/sql_connect.cc:1335
#17 0x000055de70a923d7 in handle_one_connection (arg=0x55de72f433e0) at /data/src/10.2/sql/sql_connect.cc:1241
#18 0x000055de70eb19a4 in pfs_spawn_thread (arg=0x55de72f1dea0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#19 0x00007f2f1bc41494 in start_thread (arg=0x7f2f14247700) at pthread_create.c:333
#20 0x00007f2f1a02793f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Sergei Petrunia [ 2018-06-13 ]

Fixed by fix for MDEV-131318. Added a testcase.

Generated at Thu Feb 08 08:20:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.