MySQL Bugs: #42140: falcon_bug_34351

Bug #42140	falcon_bug_34351_B fails; sometimes
Submitted:	15 Jan 2009 20:03	Modified:	26 May 2010 17:47
Reporter:	Hakan Küçükyılmaz	Email Updates:
Status:	Unsupported
Category:	Server: Falcon	Severity:	S3 (Non-critical)
Version:	6.0-falcon-team	OS:	Linux
Assigned to:	Kevin Lewis	Target Version:
Tags:	F_TEST
Triage:	Triaged: D2 (Serious)

Description:
falcon_bug_34351_B fails; sometimes. On a single core machine is fails more often than on
a 64-bit machine.

How to repeat:
Run falcon_bug_34351_B several times.

Linux 64-bit dual-core:
./mysql-test-run.pl --force --mem --skip-ndb --suite=falcon  falcon_bug_34351_B
falcon_bug_34351_B falcon_bug_34351_B ...

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon.falcon_bug_34351_B      [ fail ]
...
...
...
falcon.falcon_bug_34351_B      [ pass ]           1005
falcon.falcon_bug_34351_B      [ pass ]           1010
-------------------------------------------------------
Stopping All Servers
Failed 20/76 tests, 73.68% were successful.

Linux 32-bit single core:
./mysql-test-run.pl --force --mem --skip-ndb --suite=falcon falcon_bug_34351_B
falcon_bug_34351_B ...
...
...
...

-------------------------------------------------------
Stopping All Servers
Failed 50/60 tests, 16.67% were successful.

Thank you for the bug report. Verified on Suse 11.1 64-bit:

falcon.falcon_bug_34351_B      [ fail ]

mysqltest: At line 60: query 'reap' succeeded - should have failed with errno 1020...

The result from queries just before the failure was:

Assigning to Olav since he just debugged 
#41357 falcon.falcon_bug_34351_C fails with assertion IS_CONSISTENT_READ

This test case is failing sporadically only because the timing between the two connections
in MTR is not controlled very well.  If I add an extra select and --real_sleep 1, it works
consistently.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/76614

2735 Kevin Lewis	2009-06-18
      Bug#42140 - Move tests from falcon_team to falcon suite

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/76615

2734 Kevin Lewis	2009-06-18
      Bug#42140 - Add some sleeps and an extra select to better assure the timing between
connections.