Bug #21297 rpl_insert fails randomly
Submitted: 26 Jul 2006 14:25 Modified: 28 Jul 2006 22:21
Reporter: Magnus Svensson
Status: Closed
Category:Server: Tests Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Sun Solaris (Solaris 10)
Assigned to: Magnus Svensson Target Version:

[26 Jul 2006 14:25] Magnus Svensson 
Description:
The test case rpl_insert fails randomly, mainly on Solaris machines. It looks like the
mysqlslap client that should insert 5000 records using INSERT DELAYED into the table fails
to do so properly under some circumstances.

How to repeat:
./mysql-test-run.pl --do-test=rpl_insert
Aslos look in PushBuild
[26 Jul 2006 14:27] Bugs System 
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/9584
[27 Jul 2006 10:07] Magnus Svensson 
I have diagnosed this to be a problem with mysqlslap. It seems like one of it's threads
looses the connection to the server and thus all 5000 records are not inserted properly.
[27 Jul 2006 10:08] Magnus Svensson 
rpl_insert                     [ fail ]

Errors are (from
/export/home/mysqldev/users/magnus/mysql-5.1.12-beta-pb37/mysql-test/var/log/mysqltest-tim
e) :
/export/home/mysqldev/users/magnus/mysql-5.1.12-beta-pb37/client/.libs/mysqlslap: Can't
connect to local MySQL server through socket
'/export/home/mysqldev/users/magnus/mysql-5.1.12-beta-pb37/mysql-test/var/tmp/master.sock'
(146)
mysqltest: At line 31: query 'Number of records in t1 didnt reach 5000' failed: 1064: You
have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'Number of records in t1 didnt reach 5000' at
line 1
(the last lines may be the most important ones)
Result from queries before failure can be found in r/rpl_insert.log

Aborting: rpl_insert failed in default mode. To continue, re-run with '--force'.Stopping
All Servers
[27 Jul 2006 10:54] Bugs System 
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/9653
[27 Jul 2006 14:10] Magnus Svensson 
Pushed to 5.1.12
[28 Jul 2006 22:21] Paul DuBois 
Noted in 5.1.12 changelog.

mysqlslap threads now try to connect up to 10 times if the initial
connect attempt fails.