Test innodb_fts.innodb_fts_misc_debug is unstable

[Laurynas Biveinis]

On 5.6 trunk, intermittently:

innodb_fts.innodb_fts_misc_debug w4 [ fail ]
        Test ended at 2016-12-19 09:04:58

CURRENT_TEST: innodb_fts.innodb_fts_misc_debug
mysqltest: In included file "./include/wait_until_connected_again.inc":
included from ./include/wait_until_connected_again.inc at line 25:
At line 25: Server failed to restart
...
2016-12-19 16:56:34 6757 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 4488207051
2016-12-19 16:56:36 b7203700 InnoDB: Warning: difficult to find free blocks in
InnoDB: the buffer pool (21 search iterations)!
InnoDB: 21 failed attempts to flush a page! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possible that in your Unix version
InnoDB: fsync is very slow, or completely frozen inside
InnoDB: the OS kernel. Then upgrading to a newer version
InnoDB: of your operating system may help. Look at the
InnoDB: number of fsyncs in diagnostic info below.
InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0
InnoDB: 593 OS file reads, 98 OS file writes, 98 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.
...

until it gets killed by timeout.

[Laurynas Biveinis (laurynas-biveinis)]

A new failure with extra diagnostics:

=====================================
2017-02-16 17:50:48 a8e3ab70 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 0 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
----------
MUTEX INFO
----------
Locked mutex: addr 0x96f0f10 thread -1222846752 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/dict/dict0dict.cc line 967
Locked mutex: addr 0x9226ac0 thread -1461474448 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/srv/srv0srv.cc line 1303
Total number of mutexes 683
-------------
RW-LATCH INFO
-------------
RW-LOCK: 0x96fdac4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/btr/btr0cur.cc line 591 S-LOCK
RW-LOCK: 0xb0c07c00
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 S-LOCK
RW-LOCK: 0xb0c07ae4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 X-LOCK
RW-LOCK: 0xb0bd6f10
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0undo.ic line 171 S-LOCK
RW-LOCK: 0xb0bd6df4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0undo.ic line 171 X-LOCK
RW-LOCK: 0xb0bd6c00
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 S-LOCK
RW-LOCK: 0xb0bd6ae4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 X-LOCK
RW-LOCK: 0xb0bd68f0
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 S-LOCK
RW-LOCK: 0xb0bd67d4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0rseg.ic line 70 X-LOCK
RW-LOCK: 0xb0bd65e0
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0undo.ic line 171 S-LOCK
RW-LOCK: 0xb0bd64c4
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0undo.ic line 171 X-LOCK
RW-LOCK: 0xb0bd62d0
Locked: thread 3072120544 file /home/jenkins/workspace/percona-server-5.6-trunk/BUILD_TYPE/debug/Host/debian-wheezy-x32/storage/innobase/include/trx0undo.ic...

[Shahriyar Rzayev (rzayev-sehriyar)]

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