[MDEV-14741] Assertion `(trx)->start_file == 0' failed in row_truncate_table_for_mysql Created: 2017-12-21  Updated: 2017-12-27  Resolved: 2017-12-22

Status: Closed
Project: MariaDB Server
Component/s: 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: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-14742 Assertion `0' failed in Protocol::end... Closed

 Description   

--source include/have_innodb.inc
--source include/have_partition.inc
 
CREATE OR REPLACE TABLE t1 (i INT) ENGINE=InnoDB WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 1 HOUR (PARTITION p1 HISTORY, PARTITION pn CURRENT);
SET AUTOCOMMIT = OFF;
TRUNCATE TABLE t1;
 
# Cleanup
DROP TABLE t1;

bb-10.3-temporal e6c5eb5c583b

mysqld: /data/src/bb-10.3-temporal/storage/innobase/row/row0trunc.cc:1805: dberr_t row_truncate_table_for_mysql(dict_table_t*, trx_t*): Assertion `(trx)->start_file == 0' failed.
171221 20:41:34 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fe9bf955ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055d96339927e in row_truncate_table_for_mysql (table=0x7fe9600a0068, trx=0x7fe9b985a0d8) at /data/src/bb-10.3-temporal/storage/innobase/row/row0trunc.cc:1805
#9  0x000055d9631fa7e1 in ha_innobase::truncate (this=0x7fe960073188) at /data/src/bb-10.3-temporal/storage/innobase/handler/ha_innodb.cc:13381
#10 0x000055d962ebfd2f in handler::ha_truncate (this=0x7fe960073188) at /data/src/bb-10.3-temporal/sql/handler.cc:4284
#11 0x000055d963658597 in ha_partition::truncate (this=0x7fe960072918) at /data/src/bb-10.3-temporal/sql/ha_partition.cc:4588
#12 0x000055d962ebfd2f in handler::ha_truncate (this=0x7fe960072918) at /data/src/bb-10.3-temporal/sql/handler.cc:4284
#13 0x000055d9630a0f78 in Sql_cmd_truncate_table::handler_truncate (this=0x7fe960015350, thd=0x7fe960000b00, table_ref=0x7fe960014d18, is_tmp_table=false) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:247
#14 0x000055d9630a1642 in Sql_cmd_truncate_table::truncate_table (this=0x7fe960015350, thd=0x7fe960000b00, table_ref=0x7fe960014d18) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:446
#15 0x000055d9630a17b4 in Sql_cmd_truncate_table::execute (this=0x7fe960015350, thd=0x7fe960000b00) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:502
#16 0x000055d962bda81a in mysql_execute_command (thd=0x7fe960000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6261
#17 0x000055d962bdf358 in mysql_parse (thd=0x7fe960000b00, rawbuf=0x7fe960014c48 "TRUNCATE TABLE t1", length=17, parser_state=0x7fe9b855d5f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7991
#18 0x000055d962bccaf9 in dispatch_command (command=COM_QUERY, thd=0x7fe960000b00, packet=0x7fe9601200b1 "TRUNCATE TABLE t1", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1825
#19 0x000055d962bcb52d in do_command (thd=0x7fe960000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1370
#20 0x000055d962d331dc in do_handle_one_connection (connect=0x55d966962b70) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#21 0x000055d962d32f69 in handle_one_connection (arg=0x55d966962b70) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#22 0x000055d9631cdb92 in pfs_spawn_thread (arg=0x55d966a05590) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#23 0x00007fe9c162c494 in start_thread (arg=0x7fe9b855e700) at pthread_create.c:333
#24 0x00007fe9bfa1293f in clone () from /lib/x86_64-linux-gnu/libc.so.6

It was reproducible on a previous build as well.


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