MySQL Forums
Forum List  »  Spanish

MySQL corrupto
Posted by: Marcos Hurtado
Date: November 08, 2012 01:58AM

Buenos días,

Tengo la versión 5.0.19 de MySQL instalado en un Windows XP Embebido y tengo varias aplicaciones en .Net (versión de Framework 2.0) que funcionan sin problemas en varios clientes desde hace ya años.

Pero en un cliente en concreto, en ordenadores distintos y en locales distintos, el MySQL llega un día que se corrompe y ya no arranca.

En los logs de MySQL muestra lo siguiente:

121107 14:08:37 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...
121107 14:08:37 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 1156775097.
InnoDB: Doing recovery: scanned up to log sequence number 0 1156905022
121107 14:08:37 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
121107 14:08:37 InnoDB: Started; log sequence number 0 1156905022
121107 14:08:37 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.19-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
121107 14:08:38 InnoDB: Operating system error number 23 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.


Buscando en Internet he leído que se ha quedado corrupto el fichero ibdata1, reinstalando el MySQL se soluciona pero quiero saber la causa para que esto no me vuelva a pasar.

Espero que alguien pueda ayudarme.

Muchas gracias.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL corrupto
1941
November 08, 2012 01:58AM
953
November 08, 2012 12:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.