Bug #39913 rpl.rpl_row_blob_myisam crashes the server sporadically on windows in row mode
Submitted: 7 Oct 2008 16:12 Modified: 23 Jul 2010 9:15
Reporter: Alexander Nozdrin Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:6.0-TRUNK OS:Windows (win2003-x86)
Assigned to: Daogang Qu CPU Architecture:Any
Tags: crash, pushbuild, sporadic, test failure

[7 Oct 2008 16:12] Alexander Nozdrin
Description:
Symptoms are:
--------------------------------------------------
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\71\mysql-6.0.8-alpha-pb71\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/71/mysql-6.0.8-alpha-pb71/mysql-test/var-rpl_binlog_row-5/tmp/rpl_row_blob_slave.sql' failed, error: 2, status: 2, errno: 0
--------------------------------------------------

This bug reported after failure on Tue Oct 7 09:08:31 2008 in mysql-6.0:
http://tinyurl.com/4qbxyr

How to repeat:
XRef: http://tinyurl.com/4huqny