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 <[EMAIL PROTECTED]> > Subject: WARNING: mysqlcheck has found corrupt tables > Date: Sat, 21 May 2005 12:09:28 +0200 > To: [EMAIL PROTECTED] > > 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. > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]