[MDEV-20207] Assertion `! is_set()' failed in Diagnostics_area::set_eof_status upon HANDLER READ Created: 2019-07-29  Updated: 2022-04-26  Resolved: 2022-04-26

Status: Closed
Project: MariaDB Server
Component/s: GIS, Server
Affects Version/s: 5.5, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.2.44, 10.3.35, 10.4.25

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Rucha Deodhar
Resolution: Fixed Votes: 0
Labels: affects-tests


 Description   

CREATE TABLE t1 (a POINT, KEY(a));
HANDLER t1 OPEN h;
HANDLER h READ a = (0);
 
# Cleanup
HANDLER h CLOSE;
DROP TABLE t1;

10.1 403e6615

mysqld: /data/src/10.1/sql/sql_error.cc:407: void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
190730  2:02:43 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f678427bf12 in __GI___assert_fail (assertion=0x55cd515074e8 "! is_set()", file=0x55cd51507420 "/data/src/10.1/sql/sql_error.cc", line=407, function=0x55cd51507860 <Diagnostics_area::set_eof_status(THD*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_eof_status(THD*)") at assert.c:101
#8  0x000055cd50b3f975 in Diagnostics_area::set_eof_status (this=0x7f677d3d2010, thd=0x7f677d3cd070) at /data/src/10.1/sql/sql_error.cc:407
#9  0x000055cd50ab6757 in my_eof (thd=0x7f677d3cd070) at /data/src/10.1/sql/sql_class.h:4210
#10 0x000055cd50b43bf0 in mysql_ha_read (thd=0x7f677d3cd070, tables=0x7f677b4fa1f0, mode=RNEXT_SAME, keyname=0x7f677b4fa7e8 "a", key_expr=0x7f677b4fa7f0, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /data/src/10.1/sql/sql_handler.cc:959
#11 0x000055cd50b6efd6 in mysql_execute_command (thd=0x7f677d3cd070) at /data/src/10.1/sql/sql_parse.cc:4752
#12 0x000055cd50b76159 in mysql_parse (thd=0x7f677d3cd070, rawbuf=0x7f677b4fa088 "HANDLER h READ a = (0)", length=22, parser_state=0x7f6785ca41e0) at /data/src/10.1/sql/sql_parse.cc:7209
#13 0x000055cd50b6530f in dispatch_command (command=COM_QUERY, thd=0x7f677d3cd070, packet=0x7f677f3f0071 "", packet_length=22) at /data/src/10.1/sql/sql_parse.cc:1499
#14 0x000055cd50b640cd in do_command (thd=0x7f677d3cd070) at /data/src/10.1/sql/sql_parse.cc:1131
#15 0x000055cd50ca10b5 in do_handle_one_connection (thd_arg=0x7f677d3cd070) at /data/src/10.1/sql/sql_connect.cc:1331
#16 0x000055cd50ca0de6 in handle_one_connection (arg=0x7f677d3cd070) at /data/src/10.1/sql/sql_connect.cc:1242
#17 0x000055cd510d577a in pfs_spawn_thread (arg=0x7f6783839c70) at /data/src/10.1/storage/perfschema/pfs.cc:1861
#18 0x00007f67859224a4 in start_thread (arg=0x7f6785ca5700) at pthread_create.c:456
#19 0x00007f6784338d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

No crash on a non-debug build.

5.5 crashes with SIGSEGV instead:

5.5 f8a1a262

#3  <signal handler called>
#4  __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:284
#5  0x00005583b70470ba in Field_blob::get_key_image (this=0x7f1c25456fa8, buff=0x7f1c25549899 "\031", length=25, type_arg=Field::itRAW) at /data/src/5.5/sql/field.cc:7361
#6  0x00005583b71176f3 in key_copy (to_key=0x7f1c25549899 "\031", from_record=0x7f1c25456f78 "\376", '\245' <repeats 15 times>, "\377", '\245' <repeats 15 times>, "\250oE%\034\177", key_info=0x7f1c25457080, key_length=25, with_zerofill=false) at /data/src/5.5/sql/key.cc:149
#7  0x00005583b6e885af in mysql_ha_read (thd=0x7f1c2626f060, tables=0x7f1c255491e8, mode=RKEY, keyname=0x7f1c255497c0 "a", key_expr=0x7f1c255497c8, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /data/src/5.5/sql/sql_handler.cc:898
#8  0x00005583b6ead118 in mysql_execute_command (thd=0x7f1c2626f060) at /data/src/5.5/sql/sql_parse.cc:3808
#9  0x00005583b6eb25ef in mysql_parse (thd=0x7f1c2626f060, rawbuf=0x7f1c25549078 "HANDLER h READ a = (0)", length=22, parser_state=0x7f1c2c060620) at /data/src/5.5/sql/sql_parse.cc:5929
#10 0x00005583b6ea5eab in dispatch_command (command=COM_QUERY, thd=0x7f1c2626f060, packet=0x7f1c263e8061 "", packet_length=22) at /data/src/5.5/sql/sql_parse.cc:1067
#11 0x00005583b6ea50bb in do_command (thd=0x7f1c2626f060) at /data/src/5.5/sql/sql_parse.cc:793
#12 0x00005583b6fab211 in do_handle_one_connection (thd_arg=0x7f1c2626f060) at /data/src/5.5/sql/sql_connect.cc:1268
#13 0x00005583b6faaf80 in handle_one_connection (arg=0x7f1c2626f060) at /data/src/5.5/sql/sql_connect.cc:1184
#14 0x00005583b732fb4e in pfs_spawn_thread (arg=0x7f1c2627eb60) at /data/src/5.5/storage/perfschema/pfs.cc:1015
#15 0x00007f1c2bc924a4 in start_thread (arg=0x7f1c2c061700) at pthread_create.c:456
#16 0x00007f1c2a6a8d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97



 Comments   
Comment by Roel Van de Paar [ 2020-05-21 ]

Generic unique bug ID; may mask other bugs.

! is_set()|SIGABRT|Diagnostics_area::set_eof_status|my_eof|mysql_ha_read|mysql_execute_command

Comment by Rucha Deodhar [ 2020-08-04 ]

Patch: https://github.com/MariaDB/server/commit/5f8ffc7271a2139cdfabb623ac34a4555554ab4e

Comment by Rucha Deodhar [ 2022-04-26 ]

Pushed to 10.2 like said in review.

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