[MDEV-15979] DELETE HISTORY from a table with transaction-precise versioning causes Assertion `table_list->vers_conditions.type == SYSTEM_TIME_BEFORE' failure Created: 2018-04-22  Updated: 2018-05-17  Resolved: 2018-05-17

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3
Fix Version/s: 10.3.7

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

Issue Links:
Blocks
is blocked by MDEV-15893 Rename VTQ to TRT Closed

 Description   

--source include/have_innodb.inc
 
create or replace table t1 (
  a int, 
  s bigint unsigned as row start, 
  e bigint unsigned as row end,
  period for system_time (s,e)
) engine=InnoDB with system versioning;
 
insert into t1 (a) values (1);
delete history from t1;
 
# Cleanup
drop table t1;
truncate table mysql.transaction_registry;

10.3 9f84451d87b

mysqld: /data/src/10.3/sql/sql_delete.cc:331: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table_list->vers_conditions.type == SYSTEM_TIME_BEFORE' failed.
180423  1:08:59 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f6b6e235ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x00005595aee7ae82 in mysql_delete (thd=0x7f6b1c000b00, table_list=0x7f6b1c014e30, conds=0x0, order_list=0x7f6b1c005338, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:331
#9  0x00005595ae9fd820 in mysql_execute_command (thd=0x7f6b1c000b00) at /data/src/10.3/sql/sql_parse.cc:4922
#10 0x00005595aea072a8 in mysql_parse (thd=0x7f6b1c000b00, rawbuf=0x7f6b1c014d58 "delete history from t1", length=22, parser_state=0x7f6b635545d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001
#11 0x00005595ae9f4a8b in dispatch_command (command=COM_QUERY, thd=0x7f6b1c000b00, packet=0x7f6b1c125fc1 "delete history from t1", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
#12 0x00005595ae9f34ca in do_command (thd=0x7f6b1c000b00) at /data/src/10.3/sql/sql_parse.cc:1391
#13 0x00005595aeb55fbd in do_handle_one_connection (connect=0x5595b2321ab0) at /data/src/10.3/sql/sql_connect.cc:1402
#14 0x00005595aeb55d4a in handle_one_connection (arg=0x5595b2321ab0) at /data/src/10.3/sql/sql_connect.cc:1308
#15 0x00005595aefd99bb in pfs_spawn_thread (arg=0x5595b232a1a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#16 0x00007f6b6ff0c494 in start_thread (arg=0x7f6b63555700) at pthread_create.c:333
#17 0x00007f6b6e2f293f in clone () from /lib/x86_64-linux-gnu/libc.so.6



 Comments   
Comment by Aleksey Midenkov [ 2018-04-25 ]

Please, review.

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