  |
 InnoDb Problem |
 Jan 22 2007, 07:21 PM
Post
#1
|
|
|
Celery  Group: Members Posts: 32 Joined: 7-May 04 Member No.: 13,359  |
Hello, we have started having this errors in mysql which hangs the mysql.
-------------------------------------------------------------------------------------------- 070122 20:41:17 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... 070122 20:41:17 InnoDB: Operating system error number 1453 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operatin...rror_codes.html InnoDB: File name .\ibdata1 InnoDB: File operation call: 'aio read'. InnoDB: Cannot continue operation. ---------------------------------------------------------------------------------------------- 1453 is a disk quata error but it seems that it is not a disk quata issue as psaadm has unlimited psaadm which I know to be the mysql files owner in windows.I also dont understand why database was not shut down normally.Is it Innodb database, or a database using Innodb. Regards. |
 |
 
|
|
Jan 22 2007, 08:26 PM
Post
#2
|
|
 SuperGeek Group: Members Posts: 2,154 Joined: 15-August 02 From: España - Perú Member No.: 3,565 |
QUOTE (ceyhost @ Jan 23 2007, 01:21 AM)  Hello, we have started having this errors in mysql which hangs the mysql. -------------------------------------------------------------------------------------------- 070122 20:41:17 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... 070122 20:41:17 InnoDB: Operating system error number 1453 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/mysql/en/Operatin...rror_codes.html InnoDB: File name .\ibdata1 InnoDB: File operation call: 'aio read'. InnoDB: Cannot continue operation. ---------------------------------------------------------------------------------------------- 1453 is a disk quata error but it seems that it is not a disk quata issue as psaadm has unlimited psaadm which I know to be the mysql files owner in windows.I also dont understand why database was not shut down normally.Is it Innodb database, or a database using Innodb. Regards. How many domains hosted? -------------------- ideasmultiples.com Especialistas en virtualización.
Parallels Silver Partner www.im-global.net Instalación, soporte y administración de Virtuozzo. Plataformas multiservidor para hosting, monitoreo y administración de servidores. |
|
|
|
|
| Lo-Fi Version | Time is now: 9th February 2010 - 10:16 AM |
