opendev
/
elastic-recheck
Code Issues Proposed changes

Add query for neutron DBDeadlock bug 1426543 

80 hits in 24 hours, check and gate, not all
failures since there is probably a retry on deadlock
in play here. Trends toward 76% failure when this
shows up though.

There is a related query in n-cpu for a connection
read timeout failure with neutronclient that has
a better failure rate (94%) but given the source of
the neutronclient read timeout is probably the
deadlock in the neutron DB, it's better to fingerprint
on the cause rather than the symptom.

Change-Id: I7e0a2199d1a9c561e2948ab95b508311a3b7ec9a
Related-Bug: #1426543
This commit is contained in:
Matt Riedemann 2015-02-27 12:41:42 -08:00
parent a0b10135dd
commit f62e0d4bb0
1 changed files with 3 additions and 0 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

3
queries/1426543.yaml Normal file
View File

@ -0,0 +1,3 @@
query: >-
message:"DBDeadlock: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'UPDATE floatingips SET status" AND
tags:"screen-q-svc.txt"