MySQL indexer might die with a deadlock

Bug #1471169 reported by Julien Danjou
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Gnocchi
Fix Released
Medium
Julien Danjou

Bug Description

This is a MySQL issue, but we might try to fix it with various retries. oslo.db might have code to help.

http://logs.openstack.org/20/198020/1/check/gate-gnocchi-python34/91c5738/console.html

Julien Danjou (jdanjou)
Changed in gnocchi:
status: New → Triaged
importance: Undecided → Medium
Revision history for this message
Chris Dent (cdent) wrote :
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to gnocchi (master)

Fix proposed to branch: master
Review: https://review.openstack.org/234656

Changed in gnocchi:
assignee: nobody → Julien Danjou (jdanjou)
status: Triaged → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to gnocchi (master)

Reviewed: https://review.openstack.org/234656
Committed: https://git.openstack.org/cgit/openstack/gnocchi/commit/?id=2e3a8079c5b6524b23a49fe4033899297abacbe3
Submitter: Jenkins
Branch: master

commit 2e3a8079c5b6524b23a49fe4033899297abacbe3
Author: Julien Danjou <email address hidden>
Date: Wed Oct 14 11:13:49 2015 +0200

    sqlalchemy: use retry_on_deadlock in update_resource()

    MySQL is pretty bad at handling UPDATE conflicts and raises deadlock
    errors from time to time, even in our functional tests. Let's use the
    oslo_db.api.retry_on_deadlock decorator to retry if it happens.

    Change-Id: Idf366a3a3232046046075e0927d7c805b50ae1e0
    Closes-Bug: #1471169

Changed in gnocchi:
status: In Progress → Fix Committed
Julien Danjou (jdanjou)
Changed in gnocchi:
milestone: none → 1.3.0
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.