Bug #78638 parts.partition_alter2_1_1_innodb run into assertion
Submitted: 30 Sep 2015 8:03 Modified: 23 Nov 2015 10:04
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:8.0.0-m17 OS:Any
Assigned to: CPU Architecture:Any

[30 Sep 2015 8:03] Horst Hunger
Description:
The test run into an assertion. 

The result from queries just before the failure was:
< snip >
SELECT CAST(f_int1 AS CHAR),
CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1
ORDER BY f_int1;
DROP TRIGGER trg_3;
	
# check trigger-12 success: 	1
DELETE FROM t1
WHERE f_int1 <> CAST(f_char1 AS SIGNED INT)
AND f_int2 <> CAST(f_char1 AS SIGNED INT)
AND f_charbig = '####updated per insert trigger####';
ANALYZE  TABLE t1;
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
CHECK    TABLE t1 EXTENDED;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
CHECKSUM TABLE t1 EXTENDED;
Table	Checksum
test.t1	<some_value>

See backtrace
1405a93b5    mysqld-debug.exe!my_sigabrt_handler()[my_thr_init.c:450]
140f4a3ef    mysqld-debug.exe!raise()[winsig.c:594]
140f48580    mysqld-debug.exe!abort()[abort.c:82]
140859a8f    mysqld-debug.exe!ut_dbg_assertion_failed()[ut0dbg.cc:68]
1408a6ef5    mysqld-debug.exe!fil_op_write_log()[fil0fil.cc:2028]
1408a7272    mysqld-debug.exe!fil_name_write()[fil0fil.cc:2117]
1408a72ce    mysqld-debug.exe!fil_name_write()[fil0fil.cc:2133]
1408a913b    mysqld-debug.exe!fil_names_write()[fil0fil.cc:6244]
1408a211c    mysqld-debug.exe!fil_names_clear()[fil0fil.cc:6334]
1407cb411    mysqld-debug.exe!log_checkpoint()[log0log.cc:1744]
1406afecd    mysqld-debug.exe!srv_master_do_active_tasks()[srv0srv.cc:2042]
1406ad2fc    mysqld-debug.exe!srv_master_thread()[srv0srv.cc:2251]
772b5a4d    kernel32.dll!BaseThreadInitThunk()

More infos:
http://pb2.no.oracle.com/?action=archive_download&archive_id=16591967&pretty=please

How to repeat:
Difficult as retries passed.
[23 Nov 2015 9:56] Erlend Dahl
Fixed in 5.7.11 under the heading of Bug#21549928 RACE CONDITION BETWEEN FIL_NAMES_WRITE() AND FIL_RENAME_TABLESPACE_IN_MEM()
[23 Nov 2015 10:04] Erlend Dahl
Fixed under the heading of 
 
Bug#21549928 	RACE CONDITION BETWEEN FIL_NAMES_WRITE() AND FIL_RENAME_TABLESPACE_IN_MEM()
[18 Jun 2016 21:28] Omer Barnir
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0