Issue Plesk problem, website crash every 60 mins

[stevemartin]

iam facing some issue after migrated my website to new server every 60 mints site hangs and get 504 errors gateway timeout

when try to access plesk panel i get this errro

but after i run service psa stopall and restart server works great and again after 60mints same issues

 

[Hex]

System Requirements for Plesk Obsidian

Contents Supported Operating Systems ...

docs.plesk.com

 

[stevemartin]

i have better and bigger server
General

CPU Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz (40 core(s)) Version Plesk Obsidian v18.0.25_build1800200325.19 os_CentOS 7 OS CentOS Linux 7.7.1908 (Core) Key number PLSK.06360157.0000

Memory Usage

Total Used Free Shared Buffer Cached Usage 251.63 GB 42.63 GB 209.00 GB 63.44 MB 226.38 MB 37.01 GB 2.15%

Swap Usage

Total Used Free Usage 4.00 GB 0 B 4.00 GB 0%

 

[Hex]

I've just guessed since no Plesk information provided and no environment info ether but here some things you can do in general:

A. Analyze the log file to see more detail about this error.
B. Change PHP version to the right number that was working before migration (with correct settings).
C. Remove or modify unnecessary Scheduled Tasks (Cron jobs) if any.
D. Change PHP handler to Apache with fast CGI enabled.
E. Install PHP 5 vendor version (Unlikely the case).
F. plesk repair web -all
G. Website is inaccessible: 504 Gateway Timeout
H. Cannot open website: 504 Gateway Timeout


I. Free migration to Plesk

 

[stevemartin]

iam getting error like this

(23) Out of resources when opening file '/var/tmp/#sql_ae2_105.MAD' (Errcode: 24) SELECT SQL_NO_CACHE (t.name LIKE '%the affair%') AS Score,t.*,

 

[Hex]

Try to edit
/usr/lib/systemd/system/mysqld.service
and add

LimitNOFILE=infinity
LimitMEMLOCK=infinity

Then execute

systemctl daemon-reload
systemctl restart  mysql.service

Resolved - (Errcode: 24 - Too many open files) [23] - Plesk Onyx 17.5.3 and Ubuntu 16.04.2 LTS‬

Good morning I have a problem with the configuration of my.cnf. I am shown the error: SQL ERROR [mysql4] Out of resources when opening file `./bbdd_name/table_name.MYD´ (Errcode: 24 - Too many open files) [23] SQL I have read the Plesk help articles, but the information they provide does...

talk.plesk.com

 

[stevemartin]

iam using

OS	CentOS Linux 7.7.1908 (Core)

i dont see that mysqld.service file i can see folder- mariadb.service.d under it -respawn.conf file nothing else

 

[Hex]

It's not recommended anyway, any updates will override your changes.
instead.. create a file under mariadb.service.d and call it mynightmare.conf and add:

LimitNOFILE=infinity
LimitMEMLOCK=infinity

then

systemctl daemon-reload
systemctl restart mysql.service
or
systemctl restart mariadb.service

 

[stevemartin]

yes i checked and found one cron is creating problem when cron runs every hours sites goes down for 5 mints and its comeback again after cron is completed how to fix this