Facebook
Twitter
-
If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
CentOS2Alma discussion -
Inviting everyone to the UX test of a new security feature in the WP Toolkit
For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.
Issue Slow + 504 Gateway Time-out
- Thread starter cposol
- Start date
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?
# 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?
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 'translate' (Mysql.php:53)
Search for related Knowledge Base articles
Thanks you for your reply
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 'translate' (Mysql.php:53)
Search for related Knowledge Base articles
Thanks you for your reply
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 (?)
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 (?)
Maybe this can help:
support.plesk.com
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...
