Fatal error: Can't open and lock privilege tables: Table 'host' is read only

[andreas balke]

hey again,

this was quick. i chose the hardcore version and re-formatted the second 
harddrive using this tutorial:
http://wiki.hetzner.de/index.php/Zweite_Platte

after this one all works well :)

best regards,
andi

andreas balke schrieb:
> hello all,
>
> i have a - to me - heavy problem with mysql; using debian and version:
> mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i386) using 
> readline 4.3
>
> we have two harddisks in our server where i tried to move the data-dir 
> to the second drive to improve performance. i stopped mysql, copied 
> all (Rp) from /var/lib/mysql to the new drive and symlinked it back to 
> /var/lib/mysql.
>
> when i try starting mysql now i got the following errors in syslog:
>
> Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00  InnoDB: 
> Started; log sequence number 2 186695629
> Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] 
> Recovering after a crash using /var/log/mysql/mysql-bin
> Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] 
> Starting crash recovery...
> Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [Note] Crash 
> recovery finished.
> Mar 21 20:11:00 localhost mysqld[29689]: 070321 20:11:00 [ERROR] Fatal 
> error: Can't open and lock privilege tables: Table 'host' is read only
> Mar 21 20:11:00 localhost mysqld_safe[29700]: ended
> Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: 0 processes alive 
> and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' 
> resulted in
> Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: 
> ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
> Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: error: 'Can't 
> connect to local MySQL server through socket 
> '/var/run/mysqld/mysqld.sock' (2)'
> Mar 21 20:11:14 localhost /etc/init.d/mysql[29840]: Check that mysqld 
> is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
>
> the crazy thing on it is that if i copy the data-dir *the same way* to 
> a directory on the first harddrive (where it comes from), set link it 
> the same way etc., everything works as expected. the drives are 
> mounted with the identical options in /etc/fstab, both contain ext3 as 
> filesystem.
>
> it would be great if somebody of you can give me a hint since google 
> gives me only 3 hits.
>
> best regards,
> andi
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Allgemeine Infos zur Liste: http://www.4t2.com/mysql/
> Verwaltung: https://lists.4t2.com/cgi-bin/mailman/listinfo/mysql-de
>   


-- 
 Andreas Balke (Web Development)
Digiden GmbH • Agentur für Kommunikationslösungen
In der Backfabrik • Saarbrückerstraße 37b • D-10405 Berlin 
Fon: +49 (30) 446 749 425 • Fax: +49 (30) 446 749 479
www.digiden.de


-------------- nächster Teil --------------
Ein Dateianhang mit Binärdaten wurde abgetrennt...
Dateiname   : smime.p7s
Dateityp    : application/x-pkcs7-signature
Dateigröße  : 3236 bytes
Beschreibung: S/MIME Cryptographic Signature
URL         : http://lists.mushaake.org/pipermail/mysql-de/attachments/20070321/4d315515/attachment.bin 
-------------- nächster Teil --------------
_______________________________________________
Allgemeine Infos zur Liste: http://www.4t2.com/mysql/
Verwaltung: https://lists.4t2.com/cgi-bin/mailman/listinfo/mysql-de