Dear Friends:
since 2 weeks ago the mysql is stoping sudenly, and into the error log
is as lines below, "Database page corruption on disk or a failed" ,
"file read of page 34",
how I can know what table is in page 34 ?
I've used mysqlcheck, without any result, all is OK for it,
mysql 4.01 is running on windows 2003 and the ibdata1of innodb is 20 GB
Thanks in advance
Jaime
070228 17:44:04 InnoDB: Page checksum 75769562, prior-to-4.0.14-form
checksum 3189442283
InnoDB: stored checksum 4088203197, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 36808, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 34,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 34.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
070228 17:45:07 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070228 17:45:07 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 29 4030208738.
InnoDB: Doing recovery: scanned up to log sequence number 29 4030343563
070228 17:45:07 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
070228 17:45:09 InnoDB: Flushing modified pages from the buffer pool...
070228 17:45:09 InnoDB: Started; log sequence number 29 4030343563
