MySQL Bugs: #37248: Some 'Big' tests failing on 6.0

Bug #37248	Some 'Big' tests failing on 6.0
Submitted:	6 Jun 2008 15:10	Modified:	15 Oct 2012 14:05
Reporter:	Patrick Crews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	big-test, disabled, mysql-test-run, Tests

Description:
The following 'big' tests are failing in the 6.0 test suite:
main.alter_table-big 
main.create-big 
main.merge-big 
main.variables-big

It appears that alter_table and create are failing for a similar root cause:
'master-bin.000001' from 106' failed: 1220: Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error

merge and variables seem to be failing for other reasons (5.1 -> 6.0 changes, tests that need repair, etc).

How to repeat:
In a 6.0 tree, execute the following commands from the mysql-test directory

./mysql-test-run --force --do-test big
You can expect to see the previously listed 4 errors.

Suggested fix:
Determine whether this is an actual server issue, a legitimate change that requires a test update, or a broken test (uncommented lines, etc).

It would seem that the --big-test options should be run prior to checking in code so that test-breaking changes can be caught and dealt with earlier.  (As indicated in Bug #32052 (Verified): Small inconsistency with the big_test and ndb_extra test options)

note:

main.variables-big is fixed in maria tree and will be merged to 6.0 shortly

Before fixing things in 6.0, first fix the problems in 5.1 reported in Bug#37635

create-big.test and alter_table-big.test are out of date.
They rely on debug sleeps that are no longer present in the 
code. Since the sleeps are long gone, fixing the problem doesn't 
involve just updating the result file or using macro 
"show_binlog_events2.inc" instead of "show binlog events" 
statement. The tests need to be rewritten using debug sync 
points, and results then need to be updated.

Partial fix attached.

A partial patch for create-big and alter_table-big tests.

Attachment: cb.diff (text/x-diff), 5.10 KiB.

Fixed in 5.5.20