Bug #38287 rpl_stm_flsh_tbls failed sporadically on pushbuild: server crash

Submitted: 22 Jul 2008 16:40 Modified: 19 Dec 2008 9:50
Reporter: Sven Sandberg Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:6.0-rpl OS:Any
Assigned to: Sven Sandberg CPU Architecture:Any
Tags: pushbuild, rlp_stm_flsh_tbls, server crash, server has gone away, sporadic, test failure

[22 Jul 2008 16:40] Sven Sandberg
Description:

rpl.rpl_stm_flsh_tbls          [ fail ]

CURRENT_TEST: rpl.rpl_stm_flsh_tbls
mysqltest: In included file ".\extra\rpl_tests\rpl_flsh_tbls.test": At line 53: query 'stop slave' failed with wrong errno 2006: 'MySQL server has gone away', instead of 1192...

The result from queries just before the failure was:
< snip >
rename table t1 to t5, t2 to t1;
flush no_write_to_binlog tables;
SHOW BINLOG EVENTS FROM 657 ;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; rename table t1 to t5, t2 to t1
select * from t3;
a
flush tables;
SHOW BINLOG EVENTS FROM 657 ;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; rename table t1 to t5, t2 to t1
master-bin.000001	#	Query	1	#	use `test`; flush tables
select * from t3;
a
stop slave;
drop table t1;
flush tables with read lock;
start slave;
stop slave;
ERROR HY000: MySQL server has gone away

More results from queries before failure can be found in e:\var-n_mix-100\log\rpl_stm_flsh_tbls.log

Stopping all servers...

How to repeat:
xref: http://tinyurl.com/6maha9

Suggested fix:
Impossible to debug since no logs are left on server. Awaiting fix to BUG#38181.
[22 Jul 2008 16:42] Sven Sandberg
One failure is here:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=27 'vm-win2003-64-b' Win64 VS2005 -max-nt/n_mix
[23 Aug 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[19 Dec 2008 9:50] Sven Sandberg
Setting to "Can't repeat" since this has not happened since July 2008.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.