[OLIO-45] Transaction deadlocks with high latency file storage

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: php-app
• Assignee: Akara Sucharitakul
• Reporter: Akara Sucharitakul
• Created: 27/Jan/09 00:19
• Updated: 28/Jan/09 20:44
• Resolved: 27/Jan/09 00:37

Description

The Apache logs show that the AddEventResult.php is incurring deadlocks:

[Wed Jan 14 11:45:34 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2

{main}
[Wed Jan 14 11:45:34 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2 {main}

[Wed Jan 14 11:45:41 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2

{main}
[Wed Jan 14 11:45:41 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2 {main}

[Wed Jan 14 11:45:52 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2

{main}
[Wed Jan 14 11:45:52 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2 {main}

[Wed Jan 14 11:45:52 2009] [error] [client 192.168.100.8] exception 'PDOException' with message 'SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction' in /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php:77\nStack trace:\n#0 /var/apache2/2.2/htdocs/web20php2.011309/classes/PDOConnection.php(77): PDO->exec('update SOCIALEV...')\n#1 /var/apache2/2.2/htdocs/web20php2.011309/public_html/addEventResult.php(97): PDOConnection->exec('update SOCIALEV...')\n#2

{main}

This happens for high-latency storage such as a slow NFS server.