Percona Server with XtraDB

percona_innodb_kill_idle_trx failed for Percona Server 5.6 with threadpool

Reported by Sergei Glushchenko on 2013-07-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Undecided
Unassigned
5.5
Undecided
Unassigned
5.6
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

lp:~sergei.glushchenko/percona-server/5.6-ps-bug1194097
Merged into lp:percona-server at revision 443
Laurynas Biveinis: Approve on 2013-10-01
Alexey Kopytov: Needs Fixing on 2013-09-25
Vlad Lesin: Needs Fixing (g2) on 2013-08-05
tags: added: kill-idle-trx
tags: added: tp
tags: added: 56qual
Roel Van de Paar (roel11) wrote :

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

tags: removed: 56qual
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers