MySQL startet nicht

Einrichten des lokalen Netzes, Verbindung zu anderen Computern und Diensten.
Antworten
_ash
Beiträge: 1196
Registriert: 13.05.2005 12:35:02

MySQL startet nicht

Beitrag von _ash » 10.10.2016 20:37:08

Ich musste einen V-Server (Debian stable) neu starten, und nun startet MySQL nicht mehr. Folgende Fehler werden ausgespuckt:

Code: Alles auswählen

# service mysql start
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

Code: Alles auswählen

# systemctl status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Mon 2016-10-10 20:31:41 CEST; 18s ago
  Process: 18393 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 19233 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Oct 10 20:31:11 host systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Oct 10 20:31:41 host /etc/init.d/mysql[19962]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc...ed in
Oct 10 20:31:41 host /etc/init.d/mysql[19962]: [61B blob data]
Oct 10 20:31:41 host /etc/init.d/mysql[19962]: error: 'Can't connect to local MySQL server through socket '/va... (2)'
Oct 10 20:31:41 host /etc/init.d/mysql[19962]: Check that mysqld is running and that the socket: '/var/run/mys...ists!
Oct 10 20:31:41 host /etc/init.d/mysql[19962]: 
Oct 10 20:31:41 host mysql[19233]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . ....ailed!
Oct 10 20:31:41 host systemd[1]: mysql.service: control process exited, code=exited status=1
Oct 10 20:31:41 host systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Oct 10 20:31:41 host systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
Jemand eine Idee, was hier falsch läuft??

_ash
Beiträge: 1196
Registriert: 13.05.2005 12:35:02

Re: MySQL startet nicht

Beitrag von _ash » 10.10.2016 20:40:27

Hier noch die Log Files von MySQL:

Code: Alles auswählen

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
161010 20:37:20  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
161010 20:37:20  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
161010 20:37:20 InnoDB: Could not open or create data files.
161010 20:37:20 InnoDB: If you tried to add new data files, and it failed here,
161010 20:37:20 InnoDB: you should now edit innodb_data_file_path in my.cnf back
161010 20:37:20 InnoDB: to what it was, and remove the new ibdata files InnoDB created
161010 20:37:20 InnoDB: in this failed attempt. InnoDB only wrote those files full of
161010 20:37:20 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
161010 20:37:20 InnoDB: remove old data files which contain your precious data!
161010 20:37:20 [ERROR] Plugin 'InnoDB' init function returned error.
161010 20:37:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161010 20:37:20 [ERROR] Unknown/unsupported storage engine: InnoDB
161010 20:37:20 [ERROR] Aborting

161010 20:37:20 [Note] /usr/sbin/mysqld: Shutdown complete

161010 20:37:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

DeletedUserReAsG

Re: MySQL startet nicht

Beitrag von DeletedUserReAsG » 10.10.2016 20:43:39

Und hast du mal geprüft, ob etwas, und wenn ja, was auf die besagte Datei zugreift?

_ash
Beiträge: 1196
Registriert: 13.05.2005 12:35:02

Re: MySQL startet nicht

Beitrag von _ash » 10.10.2016 20:46:10

Hab's. Ein anderer MySQL Prozess hat darauf zugegriffen, habe den beendet und den Dienst neu gestartet, jetzt geht es wieder. Danke.

Antworten