[MDEV-14742] Assertion `0' failed in Protocol::end_statement Created: 2017-12-21  Updated: 2017-12-27  Resolved: 2017-12-22

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Partitioning, Versioned Tables
Affects Version/s: N/A
Fix Version/s: 10.3.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-14741 Assertion `(trx)->start_file == 0' fa... Closed

 Description   

--source include/have_innodb.inc
--source include/have_partition.inc
 
CREATE OR REPLACE TABLE t1 (f INT) ENGINE=InnoDB WITH SYSTEM VERSIONING;
 
--connect (con1,localhost,root,,test)
SET AUTOCOMMIT= OFF;
INSERT INTO t1 VALUES (1),(2);
SET system_versioning_alter_history=KEEP;
ALTER TABLE t1 PARTITION BY system_time INTERVAL 1 MONTH (PARTITION p1 HISTORY, PARTITION pn CURRENT);
--error ER_NOT_ALLOWED_COMMAND
DELETE HISTORY FROM t1 BEFORE system_time CURRENT_TIMESTAMP;
 
--connection default
SET innodb_lock_wait_timeout= 1;
UPDATE t1 SET f= 3;
 
# Cleanup
--disconnect con1
DROP TABLE t1;

bb-10.3-temporal e6c5eb5c583b

mysqld: /data/src/bb-10.3-temporal/sql/protocol.cc:587: void Protocol::end_statement(): Assertion `0' failed.
171221 23:29:04 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fc2ce2abee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x00005632e016e23c in Protocol::end_statement (this=0x7fc2780010a0) at /data/src/bb-10.3-temporal/sql/protocol.cc:587
#9  0x00005632e024b6b0 in dispatch_command (command=COM_QUERY, thd=0x7fc278000b00, packet=0x7fc278120041 "UPDATE t1 SET f= 3", packet_length=18, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:2380
#10 0x00005632e024852d in do_command (thd=0x7fc278000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
#11 0x00005632e03b01dc in do_handle_one_connection (connect=0x5632e2ef8e00) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#12 0x00005632e03aff69 in handle_one_connection (arg=0x5632e2ef8e00) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#13 0x00005632e084ab92 in pfs_spawn_thread (arg=0x5632e2f9b5d0) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#14 0x00007fc2cff82494 in start_thread (arg=0x7fc2c811a700) at pthread_create.c:333
#15 0x00007fc2ce36893f in clone () from /lib/x86_64-linux-gnu/libc.so.6


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