Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
The test case is non-deterministic. It fails very quickly for me, usually from the first attempt, but it can vary on different machines and builds, run with --repeat=N if it doesn't fail right away.
I'm not sure the application period is important here, but I couldn't get rid of it.
The failure is rr-able.
Could not reproduce on the baseline.
--source include/have_log_bin.inc
|
--source include/have_binlog_format_row.inc
|
|
CREATE TABLE t (id INT, s DATE, e DATE, PERIOD FOR p(s,e), UNIQUE(id, p WITHOUT OVERLAPS)) ENGINE=Aria; |
|
--connect (con1,localhost,root,,)
|
--send
|
ALTER TABLE t FORCE; |
|
--connection default
|
INSERT INTO t VALUES (1,'1971-01-01','1971-01-02'); |
DELETE FROM t; |
|
# Cleanup
|
--connection con1
|
--reap
|
DROP TABLE t; |
--disconnect con1 |
bb-11.0-oalter fd06124e66 |
#5 0x00007fd459853df2 in __GI___assert_fail (assertion=0x5565e080d0f3 "share->now_transactional",
|
file=0x5565e0808888 "/src/storage/maria/ma_loghandler.c", line=6435,
|
function=0x5565e080f8b0 <__PRETTY_FUNCTION__.29> "translog_write_record") at ./assert/assert.c:101
|
#6 0x00005565df7f122f in translog_write_record (lsn=0x7fd44eff4430, type=LOGREC_INCOMPLETE_LOG, trn=0x5565e202c940 <dummy_transaction_object>,
|
tbl_info=0x7fd43c2cbca8, rec_len=2, part_no=3, parts_data=0x7fd44eff4460, store_share_id=0x7fd44eff442e "", hook_arg=0x0)
|
at /src/storage/maria/ma_loghandler.c:6435
|
#7 0x00005565df82c43b in _ma_tmp_disable_logging_for_table (info=0x7fd43c2cbca8, log_incomplete=1 '\001')
|
at /src/storage/maria/ma_recovery.c:3615
|
#8 0x00005565df7c2fd4 in ha_maria::external_lock (this=0x7fd43c0173d8, thd=0x7fd43c000dc8, lock_type=0)
|
at /src/storage/maria/ha_maria.cc:2958
|
#9 0x00005565df3f4822 in handler::ha_external_lock (this=0x7fd43c0173d8, thd=0x7fd43c000dc8, lock_type=0) at /src/sql/handler.cc:7324
|
#10 0x00005565df3da5c8 in handler::create_lookup_handler (this=0x7fd43c2546a0) at /src/sql/handler.cc:3276
|
#11 0x00005565df3f7e0a in handler::prepare_for_insert (this=0x7fd43c2546a0, do_create=true) at /src/sql/handler.cc:7773
|
#12 0x00005565df6d89d2 in Rows_log_event::do_apply_event (this=0x7fd43c073df8, rgi=0x7fd44eff5f60) at /src/sql/log_event_server.cc:5004
|
#13 0x00005565df6b0290 in Log_event::apply_event (this=0x7fd43c073df8, rgi=0x7fd44eff5f60) at /src/sql/log_event.cc:3856
|
#14 0x00005565deec5b39 in online_alter_read_from_binlog (thd=0x7fd43c000dc8, rgi=0x7fd44eff5f60, log=0x7fd43c25e1b0)
|
at /src/sql/sql_table.cc:11520
|
#15 0x00005565deec9430 in copy_data_between_tables (thd=0x7fd43c000dc8, from=0x7fd43c2bfe28, to=0x7fd43c253d98, create=..., ignore=false, order_num=0, order=0x0,
|
copied=0x7fd44eff9e50, deleted=0x7fd44eff9e58, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7fd44effb420, online=true)
|
at /src/sql/sql_table.cc:11958
|
#16 0x00005565deec2106 in mysql_alter_table (thd=0x7fd43c000dc8, new_db=0x7fd43c005ae0, new_name=0x7fd43c005f28, create_info=0x7fd44effc240,
|
table_list=0x7fd43c0156c0, recreate_info=0x7fd44effc110, alter_info=0x7fd44effc150, order_num=0, order=0x0, ignore=false, if_exists=false)
|
at /src/sql/sql_table.cc:10986
|
#17 0x00005565df01ff0d in Sql_cmd_alter_table::execute (this=0x7fd43c015de0, thd=0x7fd43c000dc8) at /src/sql/sql_alter.cc:563
|
#18 0x00005565dec97965 in mysql_execute_command (thd=0x7fd43c000dc8, is_called_from_prepared_stmt=false) at /src/sql/sql_parse.cc:6001
|
#19 0x00005565deca3489 in mysql_parse (thd=0x7fd43c000dc8, rawbuf=0x7fd43c0155f0 "ALTER TABLE t FORCE", length=19, parser_state=0x7fd44effd370)
|
at /src/sql/sql_parse.cc:8000
|
#20 0x00005565dec79a3d in dispatch_command (command=COM_QUERY, thd=0x7fd43c000dc8, packet=0x7fd43c12b8e9 "", packet_length=19, blocking=true)
|
at /src/sql/sql_parse.cc:1894
|
#21 0x00005565dec76b82 in do_command (thd=0x7fd43c000dc8, blocking=true) at /src/sql/sql_parse.cc:1407
|
#22 0x00005565df00a395 in do_handle_one_connection (connect=0x5565e39a1c38, put_in_cache=true) at /src/sql/sql_connect.cc:1416
|
#23 0x00005565df009dc0 in handle_one_connection (arg=0x5565e39b0198) at /src/sql/sql_connect.cc:1318
|
#24 0x00005565df944af7 in pfs_spawn_thread (arg=0x5565e3962d48) at /src/storage/perfschema/pfs.cc:2201
|
--Type <RET> for more, q to quit, c to continue without paging--
|
#25 0x00007fd4598a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#26 0x00007fd4599278d0 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
|
Attachments
Issue Links
- is caused by
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed
- relates to
-
MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part
- Closed