Bug #38558 rpl_blob_innodb_row fails sporadically in pushbuild: Lost connection to server
Submitted: 5 Aug 2008 7:58 Modified: 30 Aug 2009 13:11
Reporter: Sven Sandberg Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:6.0,5.4 OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: lost connection to mysql server, pushbuild, rpl_blob_innodb_row, sporadic, test failure

[5 Aug 2008 7:58] Sven Sandberg
Description:
pl.rpl_row_blob_innodb 'row'  [ fail ]

mysqldump: Got error: 2013: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2 when trying to connect
mysqltest: In included file ".\extra\rpl_tests\rpl_row_blob.test": At line 176: command "$MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql" failed

The result from queries just before the failure was:
< snip >
FROM test.t2 WHERE c1=1;
c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1	20000	b2	30000	dd2
SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
FROM test.t2 WHERE c1=2;
c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
2	2256	b1	3000	dd1

**** Data Update Validation Slave Section test.t2 ****

SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
FROM test.t2 WHERE c1=1;
c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
1	20000	b2	30000	dd2
SELECT c1, LENGTH(c2), SUBSTR(c2,1+2*900,2), LENGTH(c4), SUBSTR(c4,1+3*900,3)
FROM test.t2 WHERE c1=2;
c1	LENGTH(c2)	SUBSTR(c2,1+2*900,2)	LENGTH(c4)	SUBSTR(c4,1+3*900,3)
2	2256	b1	3000	dd1

exec of 'e:\pb\bzr_mysql-6.0-bugteam\70\mysql-6.0.7-alpha-pb70\client\relwithdebinfo\\mysqldump.exe --no-defaults -uroot --debug-check --port=10052 --socket=c:/tmp/pbtmp-rpl_binlog_row-5/slave.sock --password= --compact --order-by-primary --skip-extended-insert --no-create-info test > e:/pb/bzr_mysql-6.0-bugteam/70/mysql-6.0.7-alpha-pb70/mysql-test/var-rpl_binlog_row-5/tmp/rpl_row_blob_slave.sql' failed, error: 2, status: 2, errno: 0

More results from queries before failure can be found in e:\pb\bzr_mysql-6.0-bugteam\70\mysql-6.0.7-alpha-pb70\mysql-test\var-rpl_binlog_row-5\log\rpl_row_blob_innodb.log

Stopping All Servers

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

one example: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-bugteam&order=70 win2003-x86/rpl_binlog_row