MySQL Server Probleme beim start

O

orofino

Member
Hallo,

ich hatte folgendes Problem...

der MySQL Server lies sich vorgestern Abend plötzlich nicht mehr starten, ohne dass ich am System was geändert bzw. eine Update gemacht habe.

Code: 
root@serverxxx ~ # service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

Code: 
root@serverxxx ~ # systemctl status mysql.service 
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2016-12-26 22:41:05 CET; 11s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 31455 ExecStop=/etc/init.d/mysql stop (code=exited, status=1/FAILURE)
  Process: 2572 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
   CGroup: /system.slice/mysql.service
           ├─1590 /bin/bash /usr/bin/mysqld_safe
           ├─1779 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --skip-log-error --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
           └─1780 logger -t mysqld -p daemon error

Dec 26 22:40:35 server-101 systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Dec 26 22:40:35 server-101 mysql[2572]:  * Starting MariaDB database server mysqld
Dec 26 22:41:05 server-101 mysql[2572]:    ...fail!
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Control process exited, code=exited status=1
Dec 26 22:41:05 server-101 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Unit entered failed state.
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Failed with result 'exit-code'.

Code: 
root@serverxxx ~ # journalctl -xe
Dec 26 22:40:12 server-101 dovecot[30462]: auth-worker(2408): Error: sql([email protected],88.68.56.16): Password query failed: Not connected to database
Dec 26 22:40:12 server-101 dovecot[30462]: auth-worker(2408): Warning: Auth master disconnected us while handling request for [email protected] for 60 secs (result=FAIL)
Dec 26 22:40:12 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 1 seconds
Dec 26 22:40:12 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 1 seconds
Dec 26 22:40:12 server-101 dovecot[30462]: imap-login: Disconnected: Inactivity during authentication (auth failed, 2 attempts in 180 secs): user=<[email protected]>, method=LOGIN, rip=88.68.56.16, lip=88.99.77.35, TLS, session=<CebdiZ
Dec 26 22:40:12 server-101 dovecot[30462]: imap-login: Disconnected: Inactivity during authentication (auth failed, 2 attempts in 180 secs): user=<[email protected]>, method=LOGIN, rip=88.68.56.16, lip=88.99.77.35, TLS, session=<sFDeiZ
Dec 26 22:40:13 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 5 seconds
Dec 26 22:40:13 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 5 seconds
Dec 26 22:40:16 server-101 dovecot[30462]: imap-login: Aborted login (auth failed, 1 attempts in 119 secs): user=<[email protected]>, method=PLAIN, rip=188.238.82.115, lip=88.99.77.35, TLS: Disconnected, session=<x93EjZZEpi+87
Dec 26 22:40:18 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 25 second
Dec 26 22:40:18 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 25 second
Dec 26 22:40:22 server-101 CRON[2446]: pam_unix(cron:session): session closed for user root
Dec 26 22:40:35 server-101 systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysql.service has begun starting up.
Dec 26 22:40:35 server-101 mysql[2572]:  * Starting MariaDB database server mysqld
Dec 26 22:40:43 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 125 secon
Dec 26 22:40:43 server-101 dovecot[30462]: auth-worker(2530): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 125 secon
Dec 26 22:41:01 server-101 CRON[2999]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 26 22:41:01 server-101 CRON[2999]: pam_limits(cron:session): invalid line 'nofile soft 32000 ' - skipped
Dec 26 22:41:01 server-101 CRON[2999]: pam_limits(cron:session): invalid line 'nofile hard 32000' - skipped
Dec 26 22:41:01 server-101 CRON[2999]: pam_limits(cron:session): invalid line 'nproc soft 32000 ' - skipped
Dec 26 22:41:01 server-101 CRON[2999]: pam_limits(cron:session): invalid line 'nproc hard 32000' - skipped
Dec 26 22:41:01 server-101 CRON[3001]: (root) CMD (/usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Dec 26 22:41:01 server-101 CRON[3000]: pam_unix(cron:session): session opened for user root by (uid=0)
Dec 26 22:41:01 server-101 CRON[3000]: pam_limits(cron:session): invalid line 'nofile soft 32000 ' - skipped
Dec 26 22:41:01 server-101 CRON[3000]: pam_limits(cron:session): invalid line 'nofile hard 32000' - skipped
Dec 26 22:41:01 server-101 CRON[3000]: pam_limits(cron:session): invalid line 'nproc soft 32000 ' - skipped
Dec 26 22:41:01 server-101 CRON[3000]: pam_limits(cron:session): invalid line 'nproc hard 32000' - skipped
Dec 26 22:41:01 server-101 CRON[3002]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done)
Dec 26 22:41:01 server-101 CRON[2999]: pam_unix(cron:session): session closed for user root
Dec 26 22:41:04 server-101 dovecot[30462]: imap-login: Disconnected: Inactivity during authentication (auth failed, 2 attempts in 180 secs): user=<[email protected]>, method=LOGIN, rip=88.68.56.16, lip=88.99.77.35, TLS, session=<vE/1jJ
Dec 26 22:41:05 server-101 /etc/init.d/mysql[3093]: 1 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Dec 26 22:41:05 server-101 /etc/init.d/mysql[3093]: [61B blob data]
Dec 26 22:41:05 server-101 /etc/init.d/mysql[3093]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11 "Resource temporarily unavailable")'
Dec 26 22:41:05 server-101 /etc/init.d/mysql[3093]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Dec 26 22:41:05 server-101 /etc/init.d/mysql[3093]: 
Dec 26 22:41:05 server-101 mysql[2572]:    ...fail!
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Control process exited, code=exited status=1
Dec 26 22:41:05 server-101 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysql.service has failed.
-- 
-- The result is failed.
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Unit entered failed state.
Dec 26 22:41:05 server-101 systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 26 22:41:12 server-101 dovecot[30462]: auth: Error: auth worker: Aborted PASSV request for [email protected]: Lookup timed out
Dec 26 22:41:12 server-101 dovecot[30462]: auth: Error: Aborting auth request that was queued for 118 secs, 4 left in queue
Dec 26 22:41:12 server-101 dovecot[30462]: auth: Error: Aborting auth request that was queued for 118 secs, 3 left in queue
Dec 26 22:41:12 server-101 dovecot[30462]: auth-worker(2530): Error: sql([email protected],88.68.56.16): Password query failed: Not connected to database
Dec 26 22:41:12 server-101 dovecot[30462]: auth-worker(2530): Warning: Auth master disconnected us while handling request for [email protected] for 60 secs (result=FAIL)
Dec 26 22:41:12 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 1 seconds
Dec 26 22:41:12 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 1 seconds
Dec 26 22:41:13 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 5 seconds
Dec 26 22:41:13 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 5 seconds
Dec 26 22:41:18 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 25 second
Dec 26 22:41:18 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 25 second
Dec 26 22:41:22 server-101 CRON[3000]: pam_unix(cron:session): session closed for user root
Dec 26 22:41:38 server-101 dovecot[30462]: imap-login: Disconnected: Inactivity during authentication (auth failed, 2 attempts in 180 secs): user=<[email protected]>, method=LOGIN, rip=88.68.56.16, lip=88.99.77.35, TLS, session=<S9gC
Dec 26 22:41:43 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 125 secon
Dec 26 22:41:43 server-101 dovecot[30462]: auth-worker(3119): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11) - waiting for 125 secon

Am darauf folgenden Morgen startete bzw. lies sich der MySQL Server ohne Probleme sofort starten.

Irgendwie habe ich dafür momentan noch keine Erklärung... hat jemand eine Idee???

Vielen Dank Beste Grüße
 
Steht im Logfile bezüglich des möglichen Problems mit dem Socket.
Schau mal in /var/run/mysqld/ ob da das Socket drin ist.

Vielleicht auch /var/run voll?
Schau mal mit df /var/run.
 
Der Socket ist drin /var/run/mysqld/....

Im Logfile habe ich nichts gefunden.

Der /var/run ist auch nicht voll

Code: 
root@serverxxx /var/run # df /var/run
Filesystem     1K-blocks   Used Available Use% Mounted on
tmpfs            3277232 367028   2910204  12% /run
 
You must log in or register to reply here.
Back
Top