Dieses Projekt wird in seiner aktuellen Form die Tore bald schließen.
Hier mehr erfahren: Unsere Zukunft innerhalb des WoltLab-Ökosystems
  • Hallo,


    ich wollte eben meinen Mysql-Server neustarten, weil sich einige Tabellen im laufendem Betrieb nicht mehr abrufen ließen.


    Jetzt startet der Server aber nicht mehr und das steht im Syslog:


    Dec 6 12:18:11 vps mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 [Note] Plugin 'FEDERATED' is disabled.
    Dec 6 12:18:11 vps mysqld: /usr/sbin/mysqld: Table './mysql/plugin' is marked as crashed and last (automatic?) repair failed
    Dec 6 12:18:11 vps mysqld: /usr/sbin/mysqld: Table 'plugin' is marked as crashed and last (automatic?) repair failed
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: The InnoDB memory heap is disabled
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Compressed tables use zlib 1.2.7
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Using Linux native AIO
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Initializing buffer pool, size = 128.0M
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Completed initialization of buffer pool
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: highest supported file format is Barracuda.
    Dec 6 12:18:11 vps mysqld: 141206 12:18:11 InnoDB: Waiting for the background threads to start
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 InnoDB: 5.5.40 started; log sequence number 35865429050
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 [Note] - '0.0.0.0' resolves to '0.0.0.0';
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 [Note] Server socket created on IP: '0.0.0.0'.
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 [ERROR] /usr/sbin/mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
    Dec 6 12:18:12 vps mysqld: 141206 12:18:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed
    Dec 6 12:18:12 vps mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
    Dec 6 12:18:25 vps /etc/init.d/mysql[3660]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
    Dec 6 12:18:25 vps /etc/init.d/mysql[3660]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
    Dec 6 12:18:25 vps /etc/init.d/mysql[3660]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Dec 6 12:18:25 vps /etc/init.d/mysql[3660]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
    Dec 6 12:18:25 vps /etc/init.d/mysql[3660]:


    Wenn ich die Meldung in das Code Tag packe, wird es nur seitlich in einer langen leiste dargestellt, deswegen so!


    PS: Die Uhr geht falsch, anscheinend wegen Falscher Zeitzone.



    Danke im Voraus!

    • Offizieller Beitrag

    Da haben sich ein paar Tabellen in der Datenbank, in welcher die Zugangsdaten u. Ä. gespeichert werden, verabschiedet. Am besten mit einem Backup wiederherstellen, sofern vorhanden.


    Alternativ kannst du auch das mal versuchen, was in der Fehlermeldung steht: Please run mysql_upgrade to create it.
    Siehe dazu: http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html