MySQL Bugs: #18980: Test 'rpl_row_blob

Bug #18980	Test 'rpl_row_blob_innodb' fails randomly
Submitted:	10 Apr 2006 19:04	Modified:	4 May 2007 14:01
Reporter:	Kent Boortz	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Row Based Replication ( RBR )	Severity:	S3 (Non-critical)
Version:	5.1-bk	OS:	Linux (SuSE SLES9 x86)
Assigned to:	Chuck Bell	CPU Architecture:	Any

Description:
Test 'rpl_row_blob_innodb' fails randomly with

 mysqltest: In included file "./extra/rpl_tests/rpl_row_blob.test":
 At line 42: could not sync with master
 ('select master_pos_wait('master-bin.000001', 18169)' returned NULL)

How to repeat:
Run the test case

Run the test on Fedora Core 5/i386 in a loop for an estimated 3000 times without failure.  It looks as if this one might have gone away or gone into hiding.  It doesn't sound very likely that it's related to the specific Linux distro.

Test was run with:

 ./mysql-test-run --mysqld="--binlog-format=row" --skip-ndb rpl_row_blob_innodb

Repeated on sles9-x86, where the test failed immediately.  This is an assertion failure:

mysqld: field.cc:3565: virtual longlong Field_long::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.

Initially, cannot reproduce errors on SUSE or Windows using clone from mysql-5.1-new-rpl. A new error occurred on line #182 during the diff of the output of the master versus the slave.

The new error from the test is:

Errors are (from d:/source/c++/mysql-5.1-new-rpl/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file ".\extra\rpl_tests\rpl_row_blob.test": At line 182:
command "diff $MYSQLTEST_VARDIR/tmp/rpl_row_blob_master.sql $MYSQLTEST_VARDIR/tmp/rpl_row_blob_slave.sql" failed

I have added test files for reproducing the error with the rpl_row_blob_innodb test. See attached files.

Correct results for test. Place in ./mysql-test/r.

Attachment: rpl_bug_18980.result (text/plain), 3.32 KiB.

Test include file (contains actual test). Place in ./mysql-test/extra/rpl_tests.

Attachment: rpl_row_blob_bug_18980.test (application/octet-stream, text), 3.54 KiB.

Option file (required). Place in ./mysql-test/t.

Attachment: rpl_bug_18980-slave.opt (text/plain), 9 bytes.

Test file. Place in ./mysql-test/t. Run with --mysqld=--binlog-format=row

Attachment: rpl_bug_18980.test (application/octet-stream, text), 478 bytes.

I have tested this bug usng the attached test files on Windows XP, Windows 2003 64-bit, and SUSE 10.0. Please verify bug exists on 64-bit Linux platforms. The result should be a failed test with incorrect output on the slave.

This bug is fixed in BUG#24403. Please refer to BUG#24403 for more details.

Test case change. No changelog entry needed.

Per Jani Tolonen's email on 20 Mar 2007. Reevaluation of bug shows the problem has not been corrected. Bug report reopened.

This bug was tested with the latest clone from mysql-5.1-new-rpl. The bug described was not reproduced. Platforms tested include Windows XP Pro, Windows 2003 Server, SUSE 10.0, and Fedora Core 4. 

A patch was pushed that enabled the test in the disabled.def file.

Pushed into 5.1.20-beta