[MDEV-18852] Server crashes in reinit_stmt_before_use upon UPDATE .. FOR PORTION via prepared statement Created: 2019-03-08  Updated: 2019-04-02  Resolved: 2019-04-02

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update, Prepared Statements, Versioned Tables
Affects Version/s: 10.4
Fix Version/s: 10.4.4

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Fixed Votes: 0
Labels: affects-tests

Issue Links:
Relates
relates to MDEV-18853 Assertion `0' failed in Protocol::end... Closed

 Description   

$ perl ./mtr  --ps-protocol period.update

10.4 7b9981fb

#3  <signal handler called>
#4  0x000055d315445a6a in reinit_stmt_before_use (thd=0x7fc5bc000b00, lex=0x7fc5bc13a2b8) at /data/src/10.4/sql/sql_prepare.cc:2968
#5  0x000055d31544a6f9 in Prepared_statement::execute (this=0x7fc5bc009ce0, expanded_query=0x7fc60df0aef0, open_cursor=false) at /data/src/10.4/sql/sql_prepare.cc:4718
#6  0x000055d315448dc4 in Prepared_statement::execute_loop (this=0x7fc5bc009ce0, expanded_query=0x7fc60df0aef0, open_cursor=false, packet=0x7fc5bc1a074a "", packet_end=0x7fc5bc1a074a "") at /data/src/10.4/sql/sql_prepare.cc:4229
#7  0x000055d3154465f3 in mysql_stmt_execute_common (thd=0x7fc5bc000b00, stmt_id=10, packet=0x7fc5bc1a074a "", packet_end=0x7fc5bc1a074a "", cursor_flags=0, bulk_op=false, read_types=false) at /data/src/10.4/sql/sql_prepare.cc:3238
#8  0x000055d31544618c in mysqld_stmt_execute (thd=0x7fc5bc000b00, packet_arg=0x7fc5bc1a0741 "\n", packet_length=9) at /data/src/10.4/sql/sql_prepare.cc:3136
#9  0x000055d315417030 in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7fc5bc000b00, packet=0x7fc5bc1a0741 "\n", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1751
#10 0x000055d315415d55 in do_command (thd=0x7fc5bc000b00) at /data/src/10.4/sql/sql_parse.cc:1358
#11 0x000055d31558fb0d in do_handle_one_connection (connect=0x55d3184d48b0) at /data/src/10.4/sql/sql_connect.cc:1399
#12 0x000055d31558f87e in handle_one_connection (arg=0x55d3184d48b0) at /data/src/10.4/sql/sql_connect.cc:1302
#13 0x000055d315a85bf7 in pfs_spawn_thread (arg=0x55d31851a790) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#14 0x00007fc61a8f5494 in start_thread (arg=0x7fc60df0c700) at pthread_create.c:333
#15 0x00007fc618cdb93f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Sergei Golubchik [ 2019-03-08 ]

please add the period suite to the mtr default list after ensuring that is passes in normal and --ps modes.

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