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)