Bug #1501 Inconsistent page in the doublewrite buffer
Submitted: 8 Oct 2003 0:23 Modified: 8 Oct 2003 3:13
Reporter: Ken Ray Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 Alpha OS:Windows (Windows 2003)
Assigned to: CPU Architecture:Any

[8 Oct 2003 0:23] Ken Ray 
Description:
I am trying to connect to the database from another machine on the network. The application logon is taking 90 seconds. I started to debug it and found that there are numerous error messages in the err files.

I have several hundred of these in the Servername.err file
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 3057247106 page number 0, 0'th page in dblwr buf.
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 3380526221 page number 1, 1'th page in dblwr buf.
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 1314137728 page number 2, 2'th page in dblwr buf.
InnoDB: Warning: an inconsistent page in the doublewrite buffer

In the mysql.err file I have this

031003 12:32:52  mysql.user table is not updated to new password format;  Disabling new password usage until mysql_fix_privilege_tables is run
MySql: ready for connections.
Version: '4.1.0-alpha-max-nt'  socket: ''  port: 3306
031004 19:09:09  MySql: Normal shutdown

How to repeat:
All I did was try to access information in the database from another machine using the ODBC 3.51
[8 Oct 2003 3:13] Heikki Tuuri 
Hi!

You have probably run 4.0.14 or 4.0.15 and then 'downgraded' to an earlier release 4.1.0-alpha.

"
MySQL/InnoDB-4.0.14, July 21, 2003 
...
Fixed the checksum calculation of data pages. Previously most OS file system corruption went unnoticed. Note that if you downgrade from version >= 4.0.14 to an earlier version < 4.0.14 then in the first startup(s) InnoDB will print warnings: 
InnoDB: Warning: an inconsistent page in the doublewrite buffer
InnoDB: space id 2552202359 page number 8245, 127'th page in dblwr buf.

but that is not dangerous and can be ignored. 
"

You can ignore the warnings, no problem.

Best regards,

Heikki