You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "Akara Sucharitakul (JIRA)" <ji...@apache.org> on 2009/01/27 00:38:59 UTC
[jira] Resolved: (OLIO-45) Transaction deadlocks with high latency
file storage
[ https://issues.apache.org/jira/browse/OLIO-45?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Akara Sucharitakul resolved OLIO-45.
------------------------------------
Resolution: Fixed
Fixed as commented.
> 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.