Transaction deadlocks with high latency file storage
----------------------------------------------------
Key: OLIO-45
URL: https://issues.apache.org/jira/browse/OLIO-45
Project: Olio
Issue Type: Bug
Reporter: Akara Sucharitakul
Assignee: Shanti Subramanyam
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
