Bug #48217 Endless InnoDB warning: trying to read doublewrite buffer page 171
Submitted: 21 Oct 2009 21:35 Modified: 30 Nov 2009 9:49
Reporter: Oleg Petrachev Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.1.36 OS:FreeBSD
Assigned to: CPU Architecture:Any

[21 Oct 2009 21:35] Oleg Petrachev
Description:
I have MySQL 5.1.36 under FreeBSD 7.2/amd64 installed from ports.

At start MySQL complains about InnoDB purge. After several seconds or minutes it starts to write enormous number of warning messages. One thread becomes always busy and takes about 50-80% of one CPU core. MySQL becomes unkillable and can be restarted only by kill -9. 

Databases are accessible though.

As there is no tool for repaiting InnoDB tables, I tried to apply some voodoo like OPTIMIZE/ANALYZE tables, but that did not help :)

Please let me know if I can provide more information about this case.

Messages at startup:
====================

Oct 21 23:49:47 thor mysqld: 091021 23:49:47  InnoDB: Warning: purge reached the head of the history list,
Oct 21 23:49:47 thor mysqld: InnoDB: but its length is still reported as 768871! Make a detailed bug
Oct 21 23:49:47 thor mysqld: InnoDB: report, and submit it to http://bugs.mysql.com

Messages after a while
=======================

Oct 21 23:50:05 thor mysqld: 091021 23:50:05  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:06 thor last message repeated 1368 times
Oct 21 23:50:06 thor mysqld: 091021 23:50:06  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:07 thor last message repeated 99806 times
Oct 21 23:50:07 thor mysqld: 091021 23:50:07  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:08 thor last message repeated 104501 times
Oct 21 23:50:08 thor mysqld: 091021 23:50:08  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:09 thor last message repeated 110875 times
Oct 21 23:50:09 thor mysqld: 091021 23:50:09  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:10 thor last message repeated 74301 times
Oct 21 23:50:10 thor mysqld: 091021 23:50:10  InnoDB: Warning: trying to read doublewrite buffer page 171
Oct 21 23:50:11 thor last message repeated 100729 times

How to repeat:
I do not know what should happen to InnoDB files to produce this behaviour. In my case this bug appears after every MySQL restart.
[22 Oct 2009 3:50] Valeriy Kravchuk
Looks related to bug #45097. Please, try to upgrade to 5.1.37 at least and check if the problem will happen after that.
[23 Nov 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[30 Nov 2009 9:08] Oleg Petrachev
The problem has gone by itself, I can not reproduce it anymore.