Test innodb_fts.innodb_fts_misc_debug is unstable
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
New
|
Medium
|
Unassigned |
Bug Description
On 5.6 trunk, intermittently:
innodb_
Test ended at 2016-12-19 09:04:58
CURRENT_TEST: innodb_
mysqltest: In included file "./include/
included from ./include/
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.
tags: | added: ci innodb |
A new failure with extra diagnostics:
======= ======= ======= ======= ======= == ======= ======= ======= ======= == workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ dict/dict0dict. cc line 967 workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ srv/srv0srv. cc line 1303 workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ btr/btr0cur. cc line 591 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 X-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0undo. ic line 171 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0undo. ic line 171 X-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 X-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0rseg. ic line 70 X-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0undo. ic line 171 S-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0undo. ic line 171 X-LOCK workspace/ percona- server- 5.6-trunk/ BUILD_TYPE/ debug/Host/ debian- wheezy- x32/storage/ innobase/ include/ trx0undo. ic...
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/
Locked mutex: addr 0x9226ac0 thread -1461474448 file /home/jenkins/
Total number of mutexes 683
-------------
RW-LATCH INFO
-------------
RW-LOCK: 0x96fdac4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0c07c00
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0c07ae4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd6f10
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd6df4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd6c00
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd6ae4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd68f0
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd67d4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd65e0
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd64c4
Locked: thread 3072120544 file /home/jenkins/
RW-LOCK: 0xb0bd62d0
Locked: thread 3072120544 file /home/jenkins/