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
• Status: Closed
• Category: MySQL Server: Partitions
• Severity: S3 (Non-critical)
• Version: 8.0.0-m17
• OS: Any
• 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