-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Major
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Environment:All nodes run the following:
- Ubuntu 8.04TLS
All nodes have a separate database server
- Ubuntu 8.04 TLS
- Mysql 5.0
New deadlock issues in 1.6.3-pre.
Here is a short part of log displaying these deadlog messages.
Quote:
12605: 20090318 :161500 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='12445615' where itemid=100100000021090 and function='last' and parameter='0';
12605: 20090318 :163546 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='50.000722' where itemid=100100000020458 and function='last' and parameter='0';
12605: 20090318 :164632 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='0' where itemid=100100000021405 and function='min' and parameter='1800';
12605: 20090318 :170522 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='12451732' where itemid=100100000021117 and function='last' and parameter='0';
12605: 20090318 :170726 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='0.77' where itemid=100100000020099 and function='min' and parameter='600';
12605: 20090318 :171539 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='6379402' where itemid=100100000021132 and function='last' and parameter='0';
12605: 20090318 :171744 [Z3005] Query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update functions set lastvalue='0.1328' where itemid=100100000020780 and function='min' and parameter='600';