Resolved SQLSTATE[HY000] [2002] Resource temporarily unavailable

[Bayon]

Hello
I am experiencing a problem on my server indicating resource temporarily unavailable.
In the test we notice that msql does not start. I tried to reinstall plesk from the command line or repair: but it bug to finish, how to proceed?
To know that I already had this problem 2 months ago and I solved the problem with this: Resolved - Complete server Failure when auto-backuping database
But there impossible to correct.




root@ns331568:~# 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 mar. 2019-02-12 12:18:21 CET; 7min ago
Process: 30138 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

févr. 12 12:17:49 ns331568.ip-37-187-159.eu /etc/init.d/mysql[30165]: 190212 12:17:49 mysqld_safe A mysqld process already exists
févr. 12 12:18:21 ns331568.ip-37-187-159.eu mysql[30138]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . ...iled!
févr. 12 12:18:21 ns331568.ip-37-187-159.eu systemd[1]: mysql.service: control process exited, code=exited status=1
févr. 12 12:18:21 ns331568.ip-37-187-159.eu systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
févr. 12 12:18:21 ns331568.ip-37-187-159.eu systemd[1]: Unit mysql.service entered failed state.
févr. 12 12:19:13 ns331568.ip-37-187-159.eu mysqld[4584]: 190212 12:19:13 [ERROR] Error in accept: Too many open files
févr. 12 12:23:29 ns331568.ip-37-187-159.eu mysqld[4584]: 190212 12:23:29 [ERROR] Error in accept: Too many open files
Hint: Some lines were ellipsized, use -l to show in full.



root@ns331568:~# service mysqld status
● mysqld.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)

 

[IgorG]

The limit of open files has been reached on the MySQL server.
Use solution from this KB article Plesk or website does not work: Unable to connect to database MySQL server has gone away: Full server backup is created with warning: errno: 24 - Too many open files