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.

 

[Sebahat.hadzhi]

Hello, @gary_za . Could you please run the following command and provide us with the output:

grep innodb_force_recovery /etc/mysql/my.cnf

 

[miguelcarmona]

I have same problem:

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` < 1746715193) (Mysql.php:79)

root@plesk:~# grep -R innodb_force_recovery /etc/mysql/
root@plesk:~# plesk version
Product version: Plesk Obsidian 18.0.69.3
OS version: Ubuntu 24.04 x86_64
Build date: 2025/05/02 08:00
Revision: abe86fc4c9a229e8eeb2ba0e8629c6eb896322d5
root@plesk:~# mariadb --version
mariadb Ver 15.1 Distrib 10.11.11-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
root@plesk:~# uname -a
Linux server 6.8.12-9-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-9 (2025-03-16T19:18Z) x86_64 x86_64 x86_64 GNU/Linux

 

[Sebahat.hadzhi]

Thank you for your update. Our team is currently reviewing the issue. I will follow up with more details.

 

[Teknashop]

A solution is urgently needed.
It is impossible to work.

 

[Teknashop]

A solution is urgently needed.
It is impossible to work.

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` < 1746783869) (Mysql.php:79)

 

[vinzzd]

same problem on several servers:

# cat /etc/os-release
NAME="CloudLinux"
VERSION="8.10 (Vladimir Aksyonov)"

# plesk version
Product version: Plesk Obsidian 18.0.69.3
OS version: CloudLinux 8.10 x86_64
Build date: 2025/05/02 08:00
Revision: abe86fc4c9a229e8eeb2ba0e8629c6eb896322d5

# mysql -V
mysql Ver 15.1 Distrib 10.3.39-MariaDB, for Linux (x86_64) using readline 5.1

[2025-05-09 14:15:54.917] 3068726:681de3eadfea2 ERR [panel] 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` < 1746789354):
0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
    Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `sessions` WHERE (`modified` + `lifetime` < 1746789354)')
1: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Adapter/Abstract.php:664
    Zend_Db_Adapter_Abstract->delete(string 'sessions', string '(`modified` + `lifetime` < 1746789354)')
2: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:1203
    Zend_Db_Table_Abstract->delete(string '`modified` + `lifetime` < 1746789354')
3: /usr/local/psa/admin/plib/Session/Storage/DbTable.php:168
    Plesk\Session\Storage_DbTable->_removeSessions(boolean true)
4: /usr/local/psa/admin/plib/Session/Storage/DbTable.php:146
    Plesk\Session\Storage_DbTable->removeExpiredSessions()
5: /usr/local/psa/admin/plib/Application/Web.php:181
    Plesk\Application_Web->loadSession()
6: /usr/local/psa/admin/plib/auth.php:298
    AutoPrepend->initUserSession()
7: /usr/local/psa/admin/plib/auth.php:178
    AutoPrepend->run()
8: /usr/local/psa/admin/plib/auth.php:581

 

[Teknashop]

A solution is urgently needed.
It is impossible to work.

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` < 1746783869) (Mysql.php:79)

 

[Sebahat.hadzhi]

At this point, the reason for the issue is still unclear. I will follow up with more details.

 

[gary_za]

At this point, the reason for the issue is still unclear. I will follow up with more details.

Sadly I could not wait for a solution, as the issue triggered our internal disaster recovery protocols. So rolled back to a back-up done before, as this was affecting all six of our servers. Then setup 6 new servers, and Migrated all subscriptions, as the issue, however, I live with the fear this may occur again.