Bug #21297 rpl_insert fails randomly
Submitted: 26 Jul 2006 12:25 Modified: 28 Jul 2006 20:21
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Solaris (Solaris 10)
Assigned to: Magnus Blåudd CPU Architecture:Any

[26 Jul 2006 12:25] Magnus Blåudd
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 12: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 8:07] Magnus Blåudd
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 8:08] Magnus Blåudd
rpl_insert                     [ fail ]

Errors are (from /export/home/mysqldev/users/magnus/mysql-5.1.12-beta-pb37/mysql-test/var/log/mysqltest-time) :
/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 8: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 12:10] Magnus Blåudd
Pushed to 5.1.12
[28 Jul 2006 20: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.