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: | |
| 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
[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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.