MySQL sigue fallando: InnoDB: No se puede bloquear ./ibdata1, error: 11

Pregunta:

Tengo un servidor web simple (Debian 6.0 x86, DirectAdmin con 1 GB de memoria y aún 10 GB de espacio libre, mySQl versión 5.5.9), sin embargo, el servidor mySQL sigue fallando y necesito eliminar todos los procesos mySQL para poder reiniciarlo. de nuevo.

Salida de /var/log/mysql-error.log :

130210 21:04:26 InnoDB: Using Linux native AIO
130210 21:04:34 InnoDB: Initializing buffer pool, size = 128.0M
130210 21:05:42 InnoDB: Completed initialization of buffer pool
130210 21:05:48 InnoDB: Initializing buffer pool, size = 128.0M
130210 21:06:22 InnoDB: Initializing buffer pool, size = 128.0M
130210 21:06:27 mysqld_safe mysqld from pid file /usr/local/mysql/data/website.pid ended
130210 21:06:29 mysqld_safe mysqld from pid file /usr/local/mysql/data/website.pid ended
130210 21:07:22 InnoDB: Completed initialization of buffer pool
130210 21:07:51 mysqld_safe mysqld from pid file /usr/local/mysql/data/website.pid ended
130210 21:08:33 InnoDB: Completed initialization of buffer pool
130210 21:12:03 [Note] Plugin 'FEDERATED' is disabled.
130210 21:12:47 InnoDB: The InnoDB memory heap is disabled
130210 21:12:47 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
130210 21:12:47 InnoDB: Compressed tables use zlib 1.2.3
130210 21:12:47 InnoDB: Using Linux native AIO
130210 21:13:11 InnoDB: highest supported file format is Barracuda.
130210 21:13:23 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130210 21:14:05  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130210 21:17:53  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
130210 21:17:53  InnoDB: Operating system error number 11 in a file operation.

Encontré un tema en el sitio web mySQL aquí, sin embargo, no hay solución para él.

¿Alguna idea alguien?

Respuesta:

otro enfoque de un comentario en el mismo blog:

esto me ayudó:

lsof -i: 3306

Entonces mátalo (el número de proceso)

kill -9 PROCESO

por ejemplo, matar -9 13498

Luego intente reiniciar MySQL nuevamente.

a través de http://www.webhostingtalk.com/archive/index.php/t-1070293.html

Leave a Comment

Your email address will not be published.

Scroll to Top

istanbul avukat

-

web tasarım