[
https://issues.apache.org/jira/browse/OLIO-45?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shanti Subramanyam closed OLIO-45.
----------------------------------
> Transaction deadlocks with high latency file storage
> ----------------------------------------------------
>
> Key: OLIO-45
> URL: https://issues.apache.org/jira/browse/OLIO-45
> Project: Olio
> Issue Type: Bug
> Components: php-app
> Reporter: Akara Sucharitakul
> Assignee: Akara Sucharitakul
>
> 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.
