Ok i have done it
root@pl ~ # 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 Fri 2017-02-24 17:27:41 CET; 10min ago
Process: 23096 ExecStop=/etc/init.d/mysql stop...
Here is the backup protocol
Error:
Runtime error: The dump has wrong format! backup_info_1702241439.xml: Line 685 error: Element 'rotation': Missing child element(s). Expected is one of ( disabled, by-time, by-entires ). Line 706 error: Element 'file-sharing-settings': Missing child...
Hello,
i want to start a new backup and get after a while this error when i refresh the tab
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_4316_0.MAI' (Errcode: 24 "Too many open files"), query was: DESCRIBE...
Ok i have done it like you said
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...
i have dont this, but there are also running the same
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...
I have tested it
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...
after a repair try
**** 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...
Hey,
Plesk has upgraded this mornig. After that my sql server is no more running.
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...