MySQL - FATAL ERROR: Upgrade failed
Hallo zusammen, stehe vor einem Rätsel. will MySQL starten und erhalte folgende Meldung: elbe:/ # mysqladmin -u root -h localhost password "rootpassword" mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! elbe:/ # "mysql.sock" existiert scheinbar nicht - jedenfalls nicht in dem Pfad. andere Meldung ist folgende: ####################################### elbe:/ # rcmysql start Updating MySQL privilege database... Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... Running 'mysql_fix_privilege_tables'... ERROR 1005 (HY000) at line 7: Can't create table 'db' (errno: 13) ERROR 1005 (HY000) at line 12: Can't create table 'host' (errno: 13) ERROR 1005 (HY000) at line 15: Can't create table 'user' (errno: 13) ERROR 1005 (HY000) at line 21: Can't create table 'func' (errno: 13) ERROR 1005 (HY000) at line 24: Can't create table 'tables_priv' (errno: 13) ERROR 1005 (HY000) at line 26: Can't create table 'columns_priv' (errno: 13) ERROR 1005 (HY000) at line 29: Can't create table 'help_topic' (errno: 13) ERROR 1005 (HY000) at line 32: Can't create table 'help_category' (errno: 13) ERROR 1005 (HY000) at line 35: Can't create table 'help_relation' (errno: 13) ERROR 1005 (HY000) at line 38: Can't create table 'help_keyword' (errno: 13) ERROR 1005 (HY000) at line 41: Can't create table 'time_zone_name' (errno: 13) ERROR 1005 (HY000) at line 44: Can't create table 'time_zone' (errno: 13) ERROR 1005 (HY000) at line 47: Can't create table 'time_zone_transition' (errno: 13) ERROR 1005 (HY000) at line 50: Can't create table 'time_zone_transition_type' (errno: 13) ERROR 1005 (HY000) at line 53: Can't create table 'time_zone_leap_second' (errno: 13) ERROR 1005 (HY000) at line 56: Can't create table 'proc' (errno: 13) ERROR 1005 (HY000) at line 59: Can't create table 'procs_priv' (errno: 13) ERROR 1017 (HY000) at line 75: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 79: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 81: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 82: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 83: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 86: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 87: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 88: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 94: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 99: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 105: Can't find file: './mysql/tables_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 108: Can't find file: './mysql/tables_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 117: Can't find file: './mysql/tables_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 131: Can't find file: './mysql/columns_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 135: Can't find file: './mysql/columns_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 145: Can't find file: './mysql/columns_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 153: Can't find file: './mysql/func.frm' (errno: 13) ERROR 1017 (HY000) at line 161: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 163: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 174: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 180: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 190: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 193: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 197: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 200: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 201: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 202: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 203: Can't find file: './mysql/func.frm' (errno: 13) ERROR 1017 (HY000) at line 207: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 211: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 236: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 241: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 255: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 259: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 273: Can't find file: './mysql/func.frm' (errno: 13) ERROR 1017 (HY000) at line 275: Can't find file: './mysql/func.frm' (errno: 13) ERROR 1017 (HY000) at line 282: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 287: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 288: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 290: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 291: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 293: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 294: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 299: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 300: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 302: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 303: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 305: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 306: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 311: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 317: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 322: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 323: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 325: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 326: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 328: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 329: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 334: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 335: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 337: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 338: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 340: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 341: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 343: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 344: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 346: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 347: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 352: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 353: Can't find file: './mysql/db.frm' (errno: 13) ERROR 1017 (HY000) at line 354: Can't find file: './mysql/host.frm' (errno: 13) ERROR 1017 (HY000) at line 359: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 366: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 368: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 369: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 370: Can't find file: './mysql/user.frm' (errno: 13) ERROR 1017 (HY000) at line 378: Can't find file: './mysql/procs_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 382: Can't find file: './mysql/procs_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 386: Can't find file: './mysql/procs_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 390: Can't find file: './mysql/procs_priv.frm' (errno: 13) ERROR 1017 (HY000) at line 398: Can't find file: './mysql/proc.frm' (errno: 13) ERROR 1017 (HY000) at line 442: Can't find file: './mysql/proc.frm' (errno: 13) ERROR 1017 (HY000) at line 444: Can't find file: './mysql/proc.frm' (errno: 13) FATAL ERROR: Upgrade failed failed elbe:/ # ########################### Installiert ist MySQL 5.0.45 Was versucht das System zu finden? Was fehlt denn? Scon einmal vielen Dank für die Mühe, bis dann Heiner -- **************************************************** Heiner Gewiehs # Marketing-Fachkfm. Krimhildstr.7 # 63868 Großwallstadt FON:06022-654167 # Fax:06022-656071 **************************************************** -- Um die Liste abzubestellen, schicken Sie eine Mail an: opensuse-de+unsubscribe@opensuse.org Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken Sie eine Mail an: opensuse-de+help@opensuse.org
Hallo, 04.12.2007 10:46,, Heiner Gewiehs wrote::
Hallo zusammen,
stehe vor einem Rätsel.
Dann wollen wir das mal lösen :-)
will MySQL starten und erhalte folgende Meldung:
elbe:/ # mysqladmin -u root -h localhost password "rootpassword" mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! elbe:/ #
"mysql.sock" existiert scheinbar nicht - jedenfalls nicht in dem Pfad.
Das lieht eben daran dass MySQL, also der Server, nicht läuft.
andere Meldung ist folgende:
####################################### elbe:/ # rcmysql start Updating MySQL privilege database...
Das sieht so aus als hätte es ein update von MySQL gegeben, das das Startscript jetzt vervollständigen will.
Looking for 'mysql' in: /usr/bin/mysql Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck Running 'mysqlcheck'... Running 'mysql_fix_privilege_tables'...
... oder die Daten von MySQL sind völlig zersäbelt. Oder die Platte voll...
ERROR 1005 (HY000) at line 7: Can't create table 'db' (errno: 13)
Also krieg' erst mal raus, warum das hier nicht geht. Zuerst mal mit 'ls -l /var/lib/mysql' prüfen ob die zu erwartenden Dateien und Verzeichnisse existieren und auch vom MySQL-User benutzt werden können. Errno 13 ist "Permission denied", also vermute ich dass die Dateien nicht dem MySQL-Benutzer gehören, bzw. du das Startskript als unprivilegierter Benutzer ausführst. ...
FATAL ERROR: Upgrade failed
failed Im Resultat können die MySQL-Datenbanken nicht aktualisiert werden und der Server wird nicht gestartet.
elbe:/ #
###########################
Installiert ist MySQL 5.0.45 Was versucht das System zu finden?
Seine eigenen Dateien.
Was fehlt denn?
Das Recht die zu benutzen. Arno
Scon einmal vielen Dank für die Mühe, bis dann Heiner
-- Arno Lehmann IT-Service Lehmann www.its-lehmann.de -- Um die Liste abzubestellen, schicken Sie eine Mail an: opensuse-de+unsubscribe@opensuse.org Um eine Liste aller verfuegbaren Kommandos zu bekommen, schicken Sie eine Mail an: opensuse-de+help@opensuse.org
participants (2)
-
Arno Lehmann
-
Heiner Gewiehs