Re: OT - Apagón de luz ---> Drupal crashed
El sáb, 21-05-2005 a las 20:15 +0200, Armando Paz escribió:
> Hola.
>
> Se apagó el PC y... (aún teniendo ext3)... el drupal no me funciona y recibo
> estos mails:
>
> From: root <root@alpechin>
> Subject: WARNING: mysqlcheck has found corrupt tables
> Date: Sat, 21 May 2005 12:09:28 +0200
> To: root@alpechin
>
> drupal.cache
> warning : Table is marked as crashed
> warning : 1 client is using or hasn't closed the table properly
> error : Record at pos: 10512 is not remove-marked
> error : record delete-link-chain corrupted
> error : Corrupt
> drupal.sessions
> warning : Table is marked as crashed
> warning : 1 client is using or hasn't closed the table properly
> error : Found 294 keys of 293
> error : Corrupt
> drupal.watchdog
> warning : Table is marked as crashed
> warning : 1 client is using or hasn't closed the table properly
> warning : Size of datafile is: 46711500 Should be: 46711428
> error : Found 54720 keys of 54719
> error : Corrupt
>
> Improperly closed tables are also reported if clients are accessing
> the tables *now*. A list of current connections is below.
>
> +----+------------------+-----------+----+---------+------+-------+------------------+
> | Id | User | Host | db | Command | Time | State | Info
> |
> +----+------------------+-----------+----+---------+------+-------+------------------+
> | 5 | debian-sys-maint | localhost | | Query | 0 | | show
> processlist |
> +----+------------------+-----------+----+---------+------+-------+------------------+
> Uptime: 6 Threads: 1 Questions: 64 Slow queries: 0 Opens: 54 Flush
> tables: 1 Open
> +tables: 45 Queries per second avg: 10.667
> ...
>
> Y cuando intento acceder a la página de inicio, con el firefox -como siempre
> he hecho-, recibo esto:
>
> Fatal error: Can't open file: 'sessions.MYI'. (errno: 145) query: SELECT u.*,
> s.*, r.name AS role FROM users u INNER JOIN sessions s ON u.uid = s.uid LEFT
> JOIN role r ON u.rid = r.rid WHERE s.sid = '4a5d8418c9a5e209313ff1dafb049208'
> AND u.status < 3 LIMIT 0, 1 in /usr/share/drupal/includes/database.mysql.inc
> on line 97
>
Tiene toda la pinta que se ha "roto" una tabla.
Puedes intentar recuperarlo haciendo un e2fsck para checkear la
partición y con un poco de suerte encontrarás algún archivo en lost
+found.
Si no es posible y tienes una copia de seguridad (volcado mysql)
restaura sólo la tabla sessions de la base de datos de drupal....
> ....
>
> ¿A alguien le ha ocurrido algo parecido? ¿Cuál es la mejor forma de
> solucionarlo? ¿Por donde empiezo?
>
> Muchas gracias.
>
Reply to: