Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4
-
None
Description
Note: It's quite possible that the problem has nothing to do with versioning, but the test case demands it, I don't have a different one so far. See also MDEV-18870 which has a similar test case, but a different crash.
--source include/have_innodb.inc
|
|
|
CREATE OR REPLACE TABLE t1 ( |
s DATE, |
e DATE, |
PERIOD FOR app(s,e), |
row_start BIGINT UNSIGNED AS ROW START, |
row_end BIGINT UNSIGNED AS ROW END, |
PERIOD FOR SYSTEM_TIME(row_start,row_end) |
) ENGINE=InnoDB WITH SYSTEM VERSIONING; |
|
|
INSERT INTO t1 (s,e) VALUES ('2020-08-03','2025-01-05'),('2020-08-03','2025-01-05'); |
DELETE FROM t1 ORDER BY s LIMIT 1; |
INSERT INTO t1 (s,e) VALUES ('2020-08-03','2025-01-05'),('2019-11-30','2021-10-17'); |
DELETE FROM t1 FOR PORTION OF app FROM '2019-02-10' TO '2021-09-29'; |
DELETE FROM t1; |
DELETE HISTORY FROM t1; |
DROP TABLE t1; |
|
10.4 5a796f1f |
2019-03-09 18:30:25 0x7fd52cc03700 InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/que/que0que.cc line 558
|
InnoDB: We intentionally generate a memory trap.
|
|
|
#5 0x00007fd5338e23fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x000055b9646b58f8 in ut_dbg_assertion_failed (expr=0x0, file=0x55b964c952d0 "/data/src/10.4/storage/innobase/que/que0que.cc", line=558) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
|
#7 0x000055b964599a3c in que_graph_free_recursive (node=0x7fd4d4152630) at /data/src/10.4/storage/innobase/que/que0que.cc:558
|
#8 0x000055b9645f3cc5 in row_prebuilt_free (prebuilt=0x7fd4d4151808, dict_locked=0) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1006
|
#9 0x000055b96448b82e in ha_innobase::close (this=0x7fd4d41500d8) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:6558
|
#10 0x000055b9641517e6 in handler::ha_close (this=0x7fd4d41500d8) at /data/src/10.4/sql/handler.cc:2968
|
#11 0x000055b963f28928 in closefrm (table=0x7fd4d400d200) at /data/src/10.4/sql/table.cc:3993
|
#12 0x000055b96407442d in intern_close_table (table=0x7fd4d400d200) at /data/src/10.4/sql/table_cache.cc:222
|
#13 0x000055b96407730f in tdc_remove_table (thd=0x7fd4d4000b00, remove_type=TDC_RT_REMOVE_ALL, db=0x7fd4d4015c28 "test", table_name=0x7fd4d4015548 "t1", kill_delayed_threads=false) at /data/src/10.4/sql/table_cache.cc:1151
|
#14 0x000055b963edb1a0 in mysql_rm_table_no_locks (thd=0x7fd4d4000b00, tables=0x7fd4d4015580, if_exists=false, drop_temporary=false, drop_view=false, drop_sequence=false, dont_log_query=false, dont_free_locks=false) at /data/src/10.4/sql/sql_table.cc:2488
|
#15 0x000055b963eda2a5 in mysql_rm_table (thd=0x7fd4d4000b00, tables=0x7fd4d4015580, if_exists=false, drop_temporary=false, drop_sequence=false) at /data/src/10.4/sql/sql_table.cc:2114
|
#16 0x000055b963e0a5bc in mysql_execute_command (thd=0x7fd4d4000b00) at /data/src/10.4/sql/sql_parse.cc:5158
|
#17 0x000055b963e14b63 in mysql_parse (thd=0x7fd4d4000b00, rawbuf=0x7fd4d40154c8 "DROP TABLE t1", length=13, parser_state=0x7fd52cc02180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8204
|
#18 0x000055b963e001a5 in dispatch_command (command=COM_QUERY, thd=0x7fd4d4000b00, packet=0x7fd4d413a1a1 "DROP TABLE t1", packet_length=13, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#19 0x000055b963dfe98b in do_command (thd=0x7fd4d4000b00) at /data/src/10.4/sql/sql_parse.cc:1358
|
#20 0x000055b963f78703 in do_handle_one_connection (connect=0x55b9671744a0) at /data/src/10.4/sql/sql_connect.cc:1399
|
#21 0x000055b963f78474 in handle_one_connection (arg=0x55b9671744a0) at /data/src/10.4/sql/sql_connect.cc:1302
|
#22 0x000055b96446e031 in pfs_spawn_thread (arg=0x55b9671ba310) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#23 0x00007fd5355b0494 in start_thread (arg=0x7fd52cc03700) at pthread_create.c:333
|
#24 0x00007fd53399693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Non-debug crashes the same way.