[MDEV-17019] Server crashes in multi_delete::~multi_delete upon PS deleting from view Created: 2018-08-19  Updated: 2019-11-21  Resolved: 2019-11-21

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Delete, Prepared Statements, Views
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-16755 Server crashes in in multi_delete::~m... Open

 Description   

CREATE TABLE t1 (a INT);
 
CREATE ALGORITHM = MERGE VIEW v1 AS SELECT * FROM t1;
PREPARE stmt FROM 'DELETE A FROM v1 AS A WHERE 0';
EXECUTE stmt;
 
# Cleanup
DROP VIEW v1;
DROP TABLE t1;

10.0 bcc677bb

#3  <signal handler called>
#4  0x00000000009987e6 in multi_delete::~multi_delete (this=0x7f103d4fa280, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_delete.cc:981
#5  0x00000000009988b4 in multi_delete::~multi_delete (this=0x7f103d4fa280, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_delete.cc:989
#6  0x0000000000650165 in mysql_execute_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:3664
#7  0x0000000000670242 in Prepared_statement::execute (this=0x7f103d516470, expanded_query=0x7f1046f52bd0, open_cursor=false) at /data/src/10.0/sql/sql_prepare.cc:3975
#8  0x000000000066f310 in Prepared_statement::execute_loop (this=0x7f103d516470, expanded_query=0x7f1046f52bd0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.0/sql/sql_prepare.cc:3629
#9  0x000000000066d5fe in mysql_sql_stmt_execute (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_prepare.cc:2779
#10 0x000000000064d48b in mysql_execute_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:2567
#11 0x0000000000657d64 in mysql_parse (thd=0x7f103eea2070, rawbuf=0x7f103d4fa088 "EXECUTE stmt", length=12, parser_state=0x7f1046f53640) at /data/src/10.0/sql/sql_parse.cc:6637
#12 0x000000000064a684 in dispatch_command (command=COM_QUERY, thd=0x7f103eea2070, packet=0x7f10403e5071 "EXECUTE stmt", packet_length=12) at /data/src/10.0/sql/sql_parse.cc:1300
#13 0x0000000000649984 in do_command (thd=0x7f103eea2070) at /data/src/10.0/sql/sql_parse.cc:1003
#14 0x000000000076acdc in do_handle_one_connection (thd_arg=0x7f103eea2070) at /data/src/10.0/sql/sql_connect.cc:1377
#15 0x000000000076aa4e in handle_one_connection (arg=0x7f103eea2070) at /data/src/10.0/sql/sql_connect.cc:1292
#16 0x0000000000accef0 in pfs_spawn_thread (arg=0x7f103eda2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861
#17 0x00007f1046b87494 in start_thread (arg=0x7f1046f54700) at pthread_create.c:333
#18 0x00007f1044f4093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Reproducible on all of 5.5-10.3, debug and non-debug builds, with at least MyISAM and InnoDB.


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