Ver Mensaje Individual
  #1 (permalink)  
Antiguo 04/04/2013, 09:34
Avatar de henrri
henrri
 
Fecha de Ingreso: enero-2011
Mensajes: 40
Antigüedad: 13 años, 3 meses
Puntos: 3
Bd se detiene solo

al leer los datos del log


130404 9:52:54 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/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name C:\xampp\mysql\data\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
130404 9:53:05 [Note] Plugin 'FEDERATED' is disabled.
130404 9:53:05 InnoDB: The InnoDB memory heap is disabled
130404 9:53:05 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130404 9:53:05 InnoDB: Compressed tables use zlib 1.2.3
130404 9:53:05 InnoDB: Initializing buffer pool, size = 16.0M
130404 9:53:05 InnoDB: Completed initialization of buffer pool
130404 9:53:05 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130404 9:53:05 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...
130404 9:53:07 InnoDB: Waiting for the background threads to start
130404 9:53:08 InnoDB: 1.1.8 started; log sequence number 2873832
130404 9:53:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130404 9:53:08 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130404 9:53:08 [Note] Server socket created on IP: '0.0.0.0'.
130404 9:53:08 [Note] Event Scheduler: Loaded 0 events
130404 9:53:08 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a' socket: '' port: 3306 MySQL Community Server (GPL)




ayuda con ello, administro desde el phpmyadmin, al entrar en una BD en especifica mi servidor se detiene .

Error
consulta SQL: Editar

SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'sicci'
AND table_name = ''
AND column_name = '(db_comment)'

MySQL ha dicho:

#2006 - MySQL server has gone away

ademas ese error me sale en el phpmyadmin, ayudenme por favor... la empresa esta detenida por ese error.
El servidor es windows server 2003...

Última edición por henrri; 04/04/2013 a las 09:49