percona_innodb_kill_idle_trx failed for Percona Server 5.6 with threadpool

Bug #1201440 reported by Sergei Glushchenko
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Sergei Glushchenko
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Fix Released
High
Sergei Glushchenko

Bug Description

Stacktrace

_StringException: Text attachment: traceback
------------
Timeout after 900 seconds

Test case timeout after 900 seconds

== /mnt/workspace/percona-server-5.6-param/BUILD_TYPE/debug/Host/ubuntu-lucid-64bit/Percona-Server/build/mysql-test/var/1/log/percona_innodb_kill_idle_trx.log ==
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);
SELECT * FROM t1;
a
1
2
3

 == /mnt/workspace/percona-server-5.6-param/BUILD_TYPE/debug/Host/ubuntu-lucid-64bit/Percona-Server/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/tmp/6PPuA43GIu/1/mysqld.1.sock' (111)

Related branches

tags: added: kill-idle-trx
tags: added: tp
tags: added: 56qual
Revision history for this message
Roel Van de Paar (roel11) wrote :

tp beta so --56qual but bugfix targeted for GA

tags: removed: 56qual
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-691

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.