Issue Serialization failure: 1213 Deadlock found when trying to get lock

[ivanes82]

Server operating system version

AlmaLinux 8.10 (Cerulean Leopard)

Plesk version and microupdate number

Plesk Obsidian 18.0.69 # 2

Very good, community, since the last update I am getting this error every hour.

[2025-05-06 23:00:02.133] 3744287:681a785220143 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` < 1746565202):

0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79

Db_Adapter_Pdo_Mysql->query(string 'DELETE FROM `sessions` WHERE (`modified` + `lifetime` < 1746565202)')

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` < 1746565202)')

2: /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Table/Abstract.php:1203

Zend_Db_Table_Abstract->delete(string '`modified` + `lifetime` < 1746565202')

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/sdk.php:16

 

[ChristophRo]

I've seen this error once on a server of ours as well... (but so far did not investigate it any further)

 

[Sebahat.hadzhi]

Hello, @ivanes82 . Could you please try closing the sessions in Tools Settings > Active Plesk sessions. Also, please also try resetting the Session idle time in Tools & Settings > Session Idle Time to default.