2011-12-07 04:21:56 |
Laurynas Biveinis |
bug |
|
|
added bug |
2011-12-07 04:22:06 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.1 |
|
2011-12-07 04:22:06 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.1 |
|
2012-02-07 09:48:54 |
Stewart Smith |
percona-server: importance |
Undecided |
High |
|
2012-02-07 09:48:56 |
Stewart Smith |
percona-server/5.1: importance |
Undecided |
High |
|
2012-09-14 10:16:45 |
Laurynas Biveinis |
summary |
Sporadic percona_innodb_kill_idle_trx failure |
Multiple issues with percona_innodb_kill_idle_trx test |
|
2012-09-14 10:19:46 |
Laurynas Biveinis |
description |
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. |
This test
1) Is inherently unstable due to SLEEP 3; and main thread doing the killing. See below for example failure.
2) Is in the wrong suite (main), should be in innodb_plugin in 5.1 and innodb in 5.5.
3) On 5.1, it checks the wrong InnoDB flavour, i.e. it includes have_innodb.inc instead of have_innodb_plugin.inc.
4) The purpose of the duplicated last "SELECT * FROM t1;" is not clear.
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. |
|
2012-09-14 10:20:41 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.5 |
|
2012-09-14 10:20:41 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.5 |
|
2012-09-14 10:20:49 |
Laurynas Biveinis |
percona-server/5.1: status |
New |
Triaged |
|
2012-09-14 10:20:53 |
Laurynas Biveinis |
percona-server/5.5: status |
New |
Triaged |
|
2012-09-14 13:44:19 |
Laurynas Biveinis |
percona-server/5.1: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
2012-09-14 13:44:24 |
Laurynas Biveinis |
percona-server/5.5: assignee |
|
Laurynas Biveinis (laurynas-biveinis) |
|
2012-09-14 13:44:32 |
Laurynas Biveinis |
percona-server/5.1: status |
Triaged |
In Progress |
|
2012-09-14 13:44:36 |
Laurynas Biveinis |
percona-server/5.5: status |
Triaged |
In Progress |
|
2012-09-14 14:55:53 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug901060 |
|
2012-09-14 14:57:36 |
Laurynas Biveinis |
percona-server/5.1: status |
In Progress |
Fix Committed |
|
2012-09-14 14:57:43 |
Laurynas Biveinis |
percona-server/5.1: milestone |
|
5.1.65-14.1 |
|
2012-09-14 15:14:33 |
Laurynas Biveinis |
percona-server/5.5: status |
In Progress |
Triaged |
|
2012-09-30 12:42:12 |
Laurynas Biveinis |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug901060-5.1 |
|
2012-10-15 21:58:01 |
Stewart Smith |
percona-server/5.1: milestone |
5.1.65-14.1 |
5.1.66-14.2 |
|
2012-12-13 07:02:12 |
Launchpad Janitor |
branch linked |
|
lp:~laurynas-biveinis/percona-server/bug901060-5.5 |
|
2012-12-13 07:05:00 |
Laurynas Biveinis |
percona-server/5.5: status |
Triaged |
Fix Committed |
|
2012-12-13 07:05:08 |
Laurynas Biveinis |
percona-server/5.5: milestone |
|
5.5.29-29.4 |
|
2012-12-14 06:06:48 |
Stewart Smith |
percona-server/5.5: status |
Fix Committed |
Fix Released |
|
2012-12-14 06:06:48 |
Stewart Smith |
percona-server/5.5: milestone |
5.5.29-29.4 |
5.5.29-29.3 |
|
2012-12-14 22:29:06 |
Stewart Smith |
percona-server/5.1: status |
Fix Committed |
Fix Released |
|