Comment 0 for bug 901060

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote : Sporadic percona_innodb_kill_idle_trx failure

http://jenkins.percona.com/job/percona-server-5.1-param/209/BUILD_TYPE=release,Host=centos5-32/testReport/junit/%28root%29/main/percona_innodb_kill_idle_trx/ :

_StringException: Text attachment: traceback
------------
Comment:

Logfile:
CURRENT_TEST: main.percona_innodb_kill_idle_trx
mysqltest: At line 24: query 'SELECT * FROM t1' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 2006...

The result from queries just before the failure was:
< snip >
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_kill_idle_transaction';
VARIABLE_NAME VARIABLE_VALUE
INNODB_KILL_IDLE_TRANSACTION 0
SET GLOBAL innodb_kill_idle_transaction=1;
SHOW GLOBAL VARIABLES LIKE 'innodb_kill_idle_transaction';
Variable_name Value
innodb_kill_idle_transaction 1
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_kill_idle_transaction';
VARIABLE_NAME VARIABLE_VALUE
INNODB_KILL_IDLE_TRANSACTION 1
BEGIN;
INSERT INTO t1 VALUES (1),(2),(3);
COMMIT;
SELECT * FROM t1;
a
1
2
3
BEGIN;
INSERT INTO t1 VALUES (4),(5),(6);

More results from queries before failure can be found in /home/jenkins/workspace/percona-server-5.1-param/BUILD_TYPE/release/Host/centos5-32/Percona-Server/mysql-test/var/1/log/percona_innodb_kill_idle_trx.log
------------

Might be related to bug 871722.