Issue Slow + 504 Gateway Time-out

[cposol]

Hello,
We have the same problem since approx. 1 week. (Plesk Onyx 17.5.3)
Login is slow, each Plesk page loading is slow (in minutes...) and nginx 504 Gateway Time-out occurs...

 

[Bitpalast]

Check if you have many web server and PHP processes running that consume a lot of cpu power. E.g.

# ps aux | grep php-fpm
or
# ps aux | grep httpd
or
# ps aux | grep apache2

Also check what the database is doing. Login with
# plesk db
then run
> show processlist;

Do you see many processes with a lot of load?

 

[cposol]

Hello Peter,

Sometimes, just after a PLESK server restart
service sw-engine restart && service sw-cp-server restart

I get:

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1613469075)))

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key &#039;translate&#039; (Mysql.php:53)

Search for related Knowledge Base articles

Thanks you for your reply

 

[cposol]

ps aux | grep php-fpm

root 21936 0.0 0.0 7792 852 pts/0 S+ 10:58 0:00 grep php-fpm

mysql> show processlist;
+-------+-------+-----------+------+---------+------+-----------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------+-----------+------+---------+------+-----------+------------------------------------------------------------------------------------------------------+
| 38747 | admin | localhost | psa | Query | 614 | query end | INSERT INTO `sessions` (`sess_id`, `type`, `login`, `ip_address`, `login_time`, `modified`, `lifetim |
| 38748 | admin | localhost | psa | Query | 444 | query end | INSERT INTO `sessions` (`sess_id`, `type`, `login`, `ip_address`, `login_time`, `modified`, `lifetim |
| 38756 | admin | localhost | psa | Query | 434 | query end | INSERT INTO `sessions` (`sess_id`, `type`, `login`, `ip_address`, `login_time`, `modified`, `lifetim |
| 38763 | admin | localhost | psa | Query | 0 | NULL | show processlist |
+-------+-------+-----------+------+---------+------+-----------+------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

It seems related with sessions (?)

 

[cposol]

Additionally
plesk repair mysql -n

says all is OK...

 

[Bitpalast]

Maybe this can help:

Access, create, remove, copy operations with databases in Plesk hang in UI or PHPMyAdmin: 504 Gateway Timeout error

Applicable to: Plesk for Linux Symptoms Any operation on a database loads for a long time in Plesk at Domains > example.com > Databases and then fails with: PLESK_INFO: 504 Gateway Timeo...

support.plesk.com