• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Resolved After Automatic Backup no SQL Server

pbpromotion

New Pleskian
Hey,




Plesk has upgraded this mornig. After that my sql server is no more running.




Code:
root@pl ~ # ps aux |grep mysql

root      1159  0.0  0.0  21808  1696 ?        S    Feb14   0:00 /bin/bash /usr/bin/mysqld_safe

mysql     1335  0.2  1.3 766028 210412 ?       Sl   Feb14  24:29 /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

root      1336  0.0  0.0  23684  1880 ?        S    Feb14   0:00 logger -t mysqld -p daemon.error

root     30005  0.0  0.0  12668  1760 pts/0    S+   14:26   0:00 grep mysql

root@pl ~ # /etc/init.d/mysql start

[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

 failed!




Code:
root@pl ~ # 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 Tue 2017-02-21 14:27:47 CET; 48s ago

  Process: 11524 ExecStop=/etc/init.d/mysql stop (code=killed, signal=TERM)

  Process: 30022 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)




Feb 21 14:27:17 pl.xxyxx24.de /etc/init.d/mysql[30049]: 170221 14:27:17 mysqld_safe A mysqld process already exists

Feb 21 14:27:47 pl.xxyxx24.de mysql[30022]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!

Feb 21 14:27:47 pl.xxyxx24.de systemd[1]: mysql.service: control process exited, code=exited status=1

Feb 21 14:27:47 pl.xxyxx24.de systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.

Feb 21 14:27:47 pl.xxyxx24.de systemd[1]: Unit mysql.service entered failed state.





Code:
root@pl ~ # journalctl -xn




-- Logs begin at Sun 2017-02-19 21:21:10 CET, end at Tue 2017-02-21 14:28:01 CET. --




Feb 21 14:27:47 pl.xxyxx24.de /etc/init.d/mysql[30516]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!




Feb 21 14:27:47 pl.xxyxx24.de /etc/init.d/mysql[30516]:




Feb 21 14:27:47 pl.xxyxx24.de mysql[30022]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!




Feb 21 14:27:47 pl.xxyxx24.de systemd[1]: mysql.service: control process exited, code=exited status=1




Feb 21 14:27:47 pl.xxyxx24.de 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.




Feb 21 14:27:47 pl.xxyxx24.de systemd[1]: Unit mysql.service entered failed state.




Feb 21 14:27:54 pl.xxyxx24.de plesk_saslauthd[30250]: select timeout, exiting




Feb 21 14:28:01 pl.xxyxx24.de CRON[30543]: pam_unix(cron:session): session opened for user xxy by (uid=0)




Feb 21 14:28:01 pl.xxyxx24.de CRON[30544]: (xxy) CMD (/var/www/vhosts/pl.xxyxx24.de/frame.xxyxx24.de/artisan schedule:run >> /dev/null 2>&1)




Feb 21 14:28:01 pl.xxyxx24.de CRON[30543]: pam_unix(cron:session): session closed for user xxy




und hier der plesk install log




Code:
**** Product prep-install started.




===> Checking for previous installation ... found.

Create user 'psaadm' and group 'psaadm'

 Checking for the group 'psaadm'...

 Group 'psaadm' already exists




 Checking for the user 'psaadm'...

 User 'psaadm' already exists




Create group swkey-data

 Checking for the group 'swkey-data'...

 Group 'swkey-data' already exists




 Checking for the group 'swkey-data'...

 Trying to add supplementary group 'swkey-data' for user 'psaadm'...  already there

Create Mail accounts

 Checking for the group 'popuser'...

 Group 'popuser' already exists




 Checking for the user 'popuser'...

 User 'popuser' already exists




 Checking for the user 'mhandlers-user'...

 User 'mhandlers-user' already exists




 Trying to got legacy variables... done

config updated

===> Updated /etc/psa/psa.conf

 Trying to save legacy variables... done

 Trying to resolve hostname 'pl.xxyxx24.de' and validate its IP address... done







===> Checking for the necessary system accounts

 Checking for the system groups and users necessary for admin server...

 Checking for the group 'psaadm'...

 Group 'psaadm' already exists




 Checking for the user 'psaadm'...

 User 'psaadm' already exists




 Checking for the group 'psaserv'...

 Group 'psaserv' already exists




 Checking for the group 'psaserv'...

 Trying to add supplementary group 'psaserv' for user 'psaadm'...  already there

 Checking for the group 'psacln'...

 Group 'psacln' already exists




 Checking that /opt/psa/bin/chrootsh registered as login shell...







===> Performing safe prep-install database actions







===> Upgrading database




 Trying to start service mysql... /usr/sbin/mysqld (pid 1335) is running...

done

 Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")

failed




ERROR while trying to establish test connection

Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_installation.log), fix and try again







 Trying to start psa...

Stopping sw_engine service... already stopped




**** Product prep-install for BASE failed.




*****  problem report *****

ERROR while trying to establish test connection

Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_installation.log), fix and try again

STOP Bootstrapper 17.0.17 prep-install for BASE AT Tue Feb 21 13:30:40 CET 2017

Who can help?
 
after a repair try

Code:
**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

 Trying to start service mysql... /usr/sbin/mysqld (pid 1335) is running...
done
 Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_repair.log), fix and try again


**** Product repair failed.

*****  problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_repair.log), fix and try again
STOP Bootstrapper 17.0.17 repair AT Tue Feb 21 18:36:12 CET 2017
 
Code:
root@pl ~ # ps aux |grep mysql
root 1159 0.0 0.0 21808 1696 ? S Feb14 0:00 /bin/bash /usr/bin/mysqld_safe
mysql 1335 0.2 1.3 766028 210412 ? Sl Feb14 24:29 /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
root 1336 0.0 0.0 23684 1880 ? S Feb14 0:00 logger -t mysqld -p daemon.error
root 30005 0.0 0.0 12668 1760 pts/0 S+ 14:26 0:00 grep mysql

root@pl ~ # /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
failed!

As I see MySQL is working as a process. So, you try to start second MySQL process and it is failed. If MySQL really does not work, try to stop current MySQL service and start MySQL again.
 
I have tested it

Code:
root@pl ~ # /etc/init.d/mysql stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@pl ~ # /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
 failed!

Code:
root@pl ~ # 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 Wed 2017-02-22 09:53:04 CET; 35s ago
  Process: 27992 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Feb 22 09:52:34 pl.pricelook24.de /etc/init.d/mysql[28019]: 170222 09:52:34 mysqld_safe A mysqld process alre...sts
Feb 22 09:53:04 pl.pricelook24.de mysql[27992]: Starting MariaDB database server: mysqld . . . . . . . . . ....led!
Feb 22 09:53:04 pl.pricelook24.de systemd[1]: mysql.service: control process exited, code=exited status=1
Feb 22 09:53:04 pl.pricelook24.de systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Feb 22 09:53:04 pl.pricelook24.de systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
root@pl ~ # ^C
root@pl ~ # journalctl -xn
-- Logs begin at Sun 2017-02-19 21:21:10 CET, end at Wed 2017-02-22 09:53:04 CET. --
Feb 22 09:53:02 pl.pricelook24.de CRON[28447]: pam_unix(cron:session): session closed for user pbpromotion
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]: 1 processes alive and '/usr/bin/mysqladmin --defaults-f
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]: [61B blob data]
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]: error: 'Can't connect to local MySQL server through soc
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]: Check that mysqld is running and that the socket: '/var
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]:
Feb 22 09:53:04 pl.pricelook24.de mysql[27992]: Starting MariaDB database server: mysqld . . . . . . . . . . . . .
Feb 22 09:53:04 pl.pricelook24.de systemd[1]: mysql.service: control process exited, code=exited status=1
Feb 22 09:53:04 pl.pricelook24.de 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.
Feb 22 09:53:04 pl.pricelook24.de systemd[1]: Unit mysql.service entered failed state.
 
I again see working MySQL process:
Feb 22 09:53:04 pl.pricelook24.de /etc/init.d/mysql[28493]: 1 processes alive and '/usr/bin/mysqladmin --defaults-f

Try next steps:
1) Stop mysqld service.
2) Check `ps axu | grep mysqld` for working service. You should see nothing.
3) Restart mysqld if no other process started.
4) Check `systemctl -l status mysql.service`.
 
How can i stop all of this?

Code:
root@pl ~ # /etc/init.d/mysql stop
[ ok ] Stopping mysql (via systemctl): mysql.service.
root@pl ~ # ps axu | grep mysqld
root       456  0.0  0.0  12664  1712 pts/0    S+   10:23   0:00 grep mysqld
root      1159  0.0  0.0  21808  1696 ?        S    Feb14   0:00 /bin/bash /usr/bin/mysqld_safe
mysql     1335  0.2  1.2 766028 196308 ?       Sl   Feb14  25:04 /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
root      1336  0.0  0.0  23684  1880 ?        S    Feb14   0:00 logger -t mysqld -p daemon.error
 
i have dont this, but there are also running the same

Code:
root@pl /opt/psa/admin/sbin # mysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
root@pl /opt/psa/admin/sbin # kill -SIGTERM pid-of-mysqld-process
-bash: kill: pid-of-mysqld-process: arguments must be process or job IDs
root@pl /opt/psa/admin/sbin # kill -SIGTERM 1159 1335
root@pl /opt/psa/admin/sbin # ps axu | grep mysqld
mysql      808  2.3  0.4 611928 66864 ?        Sl   10:45   0:00 /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
root       809  0.0  0.0  23684  2472 ?        S    10:45   0:00 logger -t mysqld -p daemon.error
root       838  0.0  0.0  12664  1764 pts/0    S+   10:45   0:00 grep mysqld
root      1159  0.0  0.0  21816  2920 ?        S    Feb14   0:00 /bin/bash /usr/bin/mysqld_safe
root@pl /opt/psa/admin/sbin #
 
Ok, let's try one more attempt:
1) kill -SIGKILL 1159
2) kill -SIGTERM 808
3) ps aux | grep mysql
4) systemctl -l status mysql.service
5) systemctl stop mysql.service
6) systemctl start mysql.service
7) systemctl -l status mysql.service
 
Ok i have done it like you said

Code:
root@pl /opt/psa/admin/sbin # kill -SIGKILL 1159
root@pl /opt/psa/admin/sbin # kill -SIGTERM 808
root@pl /opt/psa/admin/sbin # ps aux | grep mysql
root     16993  0.0  0.0  12664  1732 pts/0    S+   11:15   0:00 grep mysql
root@pl /opt/psa/admin/sbin # systemctl -l 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 Wed 2017-02-22 10:13:59 CET; 1h 2min ago
  Process: 31984 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Feb 22 10:45:26 pl.pricelook24.de mysqld[809]: Version: '10.0.29-MariaDB-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Feb 22 11:15:51 pl.pricelook24.de mysqld[809]: 170222 11:15:51 [Note] /usr/sbin/mysqld: Normal shutdown
Feb 22 11:15:51 pl.pricelook24.de mysqld[809]:
Feb 22 11:15:51 pl.pricelook24.de mysqld[809]: 170222 11:15:51 [Note] Event Scheduler: Purging the queue. 0 events
Feb 22 11:15:51 pl.pricelook24.de mysqld[809]: 170222 11:15:51 [Note] InnoDB: FTS optimize thread exiting.
Feb 22 11:15:51 pl.pricelook24.de mysqld[809]: 170222 11:15:51 [Note] InnoDB: Starting shutdown...
Feb 22 11:15:52 pl.pricelook24.de mysqld[809]: 170222 11:15:52 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
Feb 22 11:15:53 pl.pricelook24.de mysqld[809]: 170222 11:15:53 [Note] InnoDB: Shutdown completed; log sequence number 211513636
Feb 22 11:15:53 pl.pricelook24.de mysqld[809]: 170222 11:15:53 [Note] /usr/sbin/mysqld: Shutdown complete
Feb 22 11:15:53 pl.pricelook24.de mysqld[809]:
root@pl /opt/psa/admin/sbin # systemctl stop mysql.service
root@pl /opt/psa/admin/sbin # systemctl start mysql.service
root@pl /opt/psa/admin/sbin # systemctl -l status mysql.service
● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (running) since Wed 2017-02-22 11:16:24 CET; 6s ago
  Process: 17009 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysql.service
           ├─17033 /bin/bash /usr/bin/mysqld_safe
           ├─17174 /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
           └─17175 logger -t mysqld -p daemon.error

Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] InnoDB: Highest supported file format is Barracuda.
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] InnoDB: 128 rollback segment(s) are active.
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] InnoDB: Waiting for purge to start
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 211513636
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] Plugin 'FEEDBACK' is disabled.
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] Server socket created on IP: '127.0.0.1'.
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: 170222 11:16:23 [Note] /usr/sbin/mysqld: ready for connections.
Feb 22 11:16:23 pl.pricelook24.de mysqld[17175]: Version: '10.0.29-MariaDB-0+deb8u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Feb 22 11:16:24 pl.pricelook24.de mysql[17009]: Starting MariaDB database server: mysqld.
Feb 22 11:16:24 pl.pricelook24.de systemd[1]: Started LSB: Start and stop the mysql database server daemon.

Now it works. Thanks for help.
 
Back
Top