Bug #17181 mysqlslap test server crash
Submitted: 7 Feb 2006 9:19 Modified: 4 Mar 2006 1:12
Reporter: Kristian Nielsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.1.7 OS:Linux (Linux)
Assigned to: Mats Kindahl CPU Architecture:Any

[7 Feb 2006 9:19] Kristian Nielsen
Description:
Pushbuild detected failure in the mysqlslap test case (looks like a server crash).

The error happens only sporadically, but it is easy to repeat by running the test in a loop.

The problem appears to only occur when running the server in row-based binlogging mode (--mysqld=--binlog-format=row), it does not occur with statement-based binlogging.

I've only seen the problem in SUSE Linux. This may be because the problem is specific to that problem, but may also be due to not running tests with row-based binlogging on very many platforms currently.

Here is the output from the failing test run:

mysqlslap                      [ fail ]

Errors are (from /data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/mysql-test/var/log/mysqltest-time) :
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,846930886,'xvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBLb','97RGHZ65mNzkSrYT3zWoSbg9cNePQr1bzSk81qDgE4Oanw3rnPfGsBHSbnu1evTdFDe83ro9w4jjteQg4yoo9xHck3WNqzs54W5zEm92ikdRF48B2oz3m8gMBAl11W','y50w46i58Giekxik0cYzfA8BZBLADEg3JhzGfZDoqvQQk0Akcic7lcJInYSsf9wqin6LDC1vzJLkJXKn5onqOy04MTw1WksCYqPl2Jg2eteqOqTLfGCvE4zTZwWvgM') ERROR : Lost connection to MySQL server during query
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,846930886,'xvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBLb','97RGHZ65mNzkSrYT3zWoSbg9cNePQr1bzSk81qDgE4Oanw3rnPfGsBHSbnu1evTdFDe83ro9w4jjteQg4yoo9xHck3WNqzs54W5zEm92ikdRF48B2oz3m8gMBAl11W','y50w46i58Giekxik0cYzfA8BZBLADEg3JhzGfZDoqvQQk0Akcic7lcJInYSsf9wqin6LDC1vzJLkJXKn5onqOy04MTw1WksCYqPl2Jg2eteqOqTLfGCvE4zTZwWvgM') ERROR : Lost connection to MySQL server during query
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,846930886,'xvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBLb','97RGHZ65mNzkSrYT3zWoSbg9cNePQr1bzSk81qDgE4Oanw3rnPfGsBHSbnu1evTdFDe83ro9w4jjteQg4yoo9xHck3WNqzs54W5zEm92ikdRF48B2oz3m8gMBAl11W','y50w46i58Giekxik0cYzfA8BZBLADEg3JhzGfZDoqvQQk0Akcic7lcJInYSsf9wqin6LDC1vzJLkJXKn5onqOy04MTw1WksCYqPl2Jg2eteqOqTLfGCvE4zTZwWvgM') ERROR : Lost connection to MySQL server during query
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,846930886,'xvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBLb','97RGHZ65mNzkSrYT3zWoSbg9cNePQr1bzSk81qDgE4Oanw3rnPfGsBHSbnu1evTdFDe83ro9w4jjteQg4yoo9xHck3WNqzs54W5zEm92ikdRF48B2oz3m8gMBAl11W','y50w46i58Giekxik0cYzfA8BZBLADEg3JhzGfZDoqvQQk0Akcic7lcJInYSsf9wqin6LDC1vzJLkJXKn5onqOy04MTw1WksCYqPl2Jg2eteqOqTLfGCvE4zTZwWvgM') ERROR : Lost connection to MySQL server during query
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot run query INSERT INTO t1 VALUES (1804289383,846930886,'xvtvmC9127qJNm06sGB8R92q2j7vTiiITRDGXM9ZLzkdekbWtmXKwZ2qG1llkRw5m9DHOFilEREk3q7oce8O3BEJC0woJsm6uzFAEynLH2xCsw1KQ1lT4zg9rdxBLb','97RGHZ65mNzkSrYT3zWoSbg9cNePQr1bzSk81qDgE4Oanw3rnPfGsBHSbnu1evTdFDe83ro9w4jjteQg4yoo9xHck3WNqzs54W5zEm92ikdRF48B2oz3m8gMBAl11W','y50w46i58Giekxik0cYzfA8BZBLADEg3JhzGfZDoqvQQk0Akcic7lcJInYSsf9wqin6LDC1vzJLkJXKn5onqOy04MTw1WksCYqPl2Jg2eteqOqTLfGCvE4zTZwWvgM') ERROR : Lost connection to MySQL server during query
/data0/tmp/users/knielsen/mysql-5.1.7-beta-standard/client/mysqlslap: Cannot drop database 'mysqlslap' ERROR : MySQL server has gone away
mysqltest: At line 5: command "$MYSQL_SLAP --silent --concurrency=5 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql" failed

How to repeat:
Run the mysqlslap test in a loop on SUSE linux x86, it usually fails within the first 10 runs. For example:

cd mysql-test
(for i in `seq 1 200`; do echo XXXXX $i XXXXX; MTR_BUILD_THREAD=4 ./mysql-test-run.pl --mysqld=--binlog-format=row --timer mysqlslap --skip-ndb || exit $?; done)
[14 Feb 2006 2:49] Brian Aker
Probably a concurrency issue. Raising the priority on this.
[15 Feb 2006 15:00] 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/2654
[15 Feb 2006 16:55] Lars Thalmann
This one is tricky.  It seems table share and table ids are changing in other threads.  I continue to investigate this...
[17 Feb 2006 21:25] Brian Pontz
Tried with gcc 3.3.3, same results. Also tried reducing optimization (make AM_CFLAGS='-O0 -g' AM_CXXFLAGS='-O0 -g') in sql/ directory, same problem.
[23 Feb 2006 12:34] 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/3060
[23 Feb 2006 14:11] Mats Kindahl
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/
[4 Mar 2006 1:12] Paul DuBois
No changelog entry needed.