Issue DB query failed - Deadlock

[gary_za]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

18.0.69

Hi All (new here, though been using plesk for last 10 years),

I am experiencing this issue on all 6 of our Plesk servers, that I have never seen before.

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `sessions` WHERE (`modified` + `lifetime` < 1745309391) (Mysql.php:79)

I have scoured the forums however have not seen anyone with the same issue.

This issue had occured once upgrading to Plesk Obsidian 18.0.69, I have rolled back to a backup/snapshot of the server and it still occurs.

I also have: "Response not successful: Received status code 500" across various pages of the Plesk web Panel

Server is 16 vCPU, with 24 GB RAM and 1TB SSD, running MySQL 10.11.11, plenty of RAM and Resources available.

All websites and subscriptions, mail,etc on the server is workign without issue with no performance issues.

Any assistance is greatly appreciated.

===============================

More log info (repeated every few seconds in the Plesk log):

DB query failed: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: DELETE FROM `sessions` WHERE (`modified` + `lifetime` < 1745309813): 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79 Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `sessions` WHERE (`modified` + `lifetime` < 1745309813)') 1: /opt/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Adapter/Abstract.php:664 Zend_Db_Adapter_Abstract->delete(string 'sessions', string '(`modified` + `lifetime` < 1745309813)') 2: /opt/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:1203 Zend_Db_Table_Abstract->delete(string '`modified` + `lifetime` < 1745309813') 3: /opt/psa/admin/plib/Session/Storage/DbTable.php:168 Plesk\Session\Storage_DbTable->_removeSessions(boolean true) 4: /opt/psa/admin/plib/Session/Storage/DbTable.php:146 Plesk\Session\Storage_DbTable->removeExpiredSessions() 5: /opt/psa/admin/plib/Application/Web.php:181 Plesk\Application_Web->loadSession() 6: /opt/psa/admin/plib/auth.php:298 AutoPrepend->initUserSession() 7: /opt/psa/admin/plib/auth.php:178 AutoPrepend->run() 8: /opt/psa/admin/plib/auth.php:581

Servers are connected to a WHMCS server, however do not see any issue reported by WHMCS.

 

[gary_za]

Forgot to mention,

I have done a "Plesk repair all -y" and "Plesk db -v", along with a few other things, nothing seems to have resolved the issue. And I am unable to determine why the lock is occuring.