OpenStack Heat

db connection retrying doesn't work against db2

Bug #1244092 reported by David Jia
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Cinder
Invalid
Low
Flavio Percoco
Havana
Fix Released
Low
Flavio Percoco
Cinder 2013.2.3
OpenStack Compute (nova)
Fix Released
Low
David Geng
OpenStack Compute (nova) 2014.1 "icehouse"
Havana
Fix Released
Low
Flavio Percoco
OpenStack Compute (nova) 2013.2.3
OpenStack Heat
Fix Released
Low
Liang Chen
OpenStack Heat 2014.1 "icehouse"
oslo-incubator
Fix Released
Low
David Geng
oslo-incubator 2014.1 "icehouse"

Bug Description

When I start Openstack following below steps, Openstack services can't be started without db2 connection:
1, start openstack services;
2, start db2 service.

I checked codes in session.py under nova/openstack/common/db/sqlalchemy, the root cause is db2 connection error code "-30081" isn't in conn_err_codes in _is_db_connection_error function, connection retrying codes are skipped against db2, in order to enable connection retrying function against db2, we need add db2 support in _is_db_connection_error function

David Jia (jiataotj)
affects: nova → oslo
David Geng (genggjh)
Changed in oslo:
assignee: nobody → David Geng (genggjh)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to oslo-incubator (master)

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

Changed in oslo:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to oslo-incubator (master)

Reviewed: https://review.openstack.org/53816
Committed: http://github.com/openstack/oslo-incubator/commit/3acd57c2825a8bf6660c3124f12794414622eb26
Submitter: Jenkins
Branch: master

commit 3acd57c2825a8bf6660c3124f12794414622eb26
Author: gengjh <email address hidden>
Date: Fri Oct 25 17:29:01 2013 +0800

    Add db2 communication error code when check the db connection

    bug 1244092

    Change-Id: I17882e407afa00167e550a565081219f9e432a31

Changed in oslo:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to oslo-incubator (stable/havana)

Fix proposed to branch: stable/havana
Review: https://review.openstack.org/54021

Revision history for this message
Mark McLoughlin (markmc) wrote :

Nova fix: https://review.openstack.org/54024

Changed in nova:
importance: Undecided → Low
Changed in oslo:
importance: Undecided → Low
Changed in nova:
status: New → In Progress
assignee: nobody → David Geng (genggjh)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to oslo-incubator (stable/havana)

Reviewed: https://review.openstack.org/54021
Committed: http://github.com/openstack/oslo-incubator/commit/380f72fa32dbb8bd55d69eeb4a983b6afa54f564
Submitter: Jenkins
Branch: stable/havana

commit 380f72fa32dbb8bd55d69eeb4a983b6afa54f564
Author: gengjh <email address hidden>
Date: Fri Oct 25 17:29:01 2013 +0800

    Add db2 communication error code when check the db connection

    bug 1244092

    Change-Id: I17882e407afa00167e550a565081219f9e432a31
    (cherry picked from commit 3acd57c2825a8bf6660c3124f12794414622eb26)

tags: added: in-stable-havana
Revision history for this message
Matt Riedemann (mriedem) wrote :

Doesn't this also affect cinder, glance, heat - maybe others?

Liang Chen (cbjchen)
Changed in heat:
importance: Undecided → Low
assignee: nobody → Liang Chen (cbjchen)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to heat (master)

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

Changed in heat:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/54024
Committed: http://github.com/openstack/nova/commit/4d991cd5e3b150005de4b4b18384bb505e76ff76
Submitter: Jenkins
Branch: master

commit 4d991cd5e3b150005de4b4b18384bb505e76ff76
Author: gengjh <email address hidden>
Date: Sun Oct 27 19:25:13 2013 +0800

    Sync the DB2 communication error code change from olso

    Closes-Bug: #1244092

    oslo patch set: 3acd57c2825a8bf6660c3124f12794414622eb26

    Change-Id: I62e3a6d1137d53c4aa72b18db5bd9f7e41694436

Changed in nova:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to heat (master)

Reviewed: https://review.openstack.org/58202
Committed: http://github.com/openstack/heat/commit/cb0603a8aa07750375677fd5a8afcb197107a62f
Submitter: Jenkins
Branch: master

commit cb0603a8aa07750375677fd5a8afcb197107a62f
Author: <email address hidden> <email address hidden>
Date: Mon Nov 25 14:49:49 2013 +0800

    Sync DB2 error code handling from oslo

    Including DB2 error code -30081 in conn_err_codes, so that the
    connection retry code will not be skipped when DB2 connection
    error happens.

    SHA1 of Oslo commit - bdabd512943ebb84a1333b2b3ee31a33124af76e to
    which the db module code is syncd.

    Change-Id: Idec7a6d712f5ed08fc0daad0a64df203c624f194
    Closes-Bug: #1244092

Changed in heat:
status: In Progress → Fix Committed
Russell Bryant (russellb)
Changed in nova:
milestone: none → icehouse-1
Thierry Carrez (ttx)
Changed in heat:
milestone: none → icehouse-1
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in nova:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in oslo:
milestone: none → icehouse-1
status: Fix Committed → Fix Released
Alan Pevec (apevec)
tags: removed: in-stable-havana
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (stable/havana)

Fix proposed to branch: stable/havana
Review: https://review.openstack.org/72923

Jay Bryant (jsbryant)
Changed in cinder:
status: New → Confirmed
importance: Undecided → Low
assignee: nobody → Flavio Percoco (flaper87)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to cinder (stable/havana)

Reviewed: https://review.openstack.org/72664
Committed: https://git.openstack.org/cgit/openstack/cinder/commit/?id=41f043a6241890d04758dad7caa1c54fae92a964
Submitter: Jenkins
Branch: stable/havana

commit 41f043a6241890d04758dad7caa1c54fae92a964
Author: gengjh <email address hidden>
Date: Fri Oct 25 17:29:01 2013 +0800

    Add db2 communication error code when check the db connection

    bug 1244092

    Change-Id: I17882e407afa00167e550a565081219f9e432a31

tags: added: in-stable-havana
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (stable/havana)

Reviewed: https://review.openstack.org/72923
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=2bb8ce82791effea031ffa620d37574d307f7c4f
Submitter: Jenkins
Branch: stable/havana

commit 2bb8ce82791effea031ffa620d37574d307f7c4f
Author: Xavier Queralt <email address hidden>
Date: Wed Feb 12 12:47:58 2014 +0100

    Add db2 communication error code when check the db connection

    Closes-Bug: #1244092
    Change-Id: I17882e407afa00167e550a565081219f9e432a31

Thierry Carrez (ttx)
Changed in oslo:
milestone: icehouse-1 → 2014.1
Thierry Carrez (ttx)
Changed in nova:
milestone: icehouse-1 → 2014.1
Thierry Carrez (ttx)
Changed in heat:
milestone: icehouse-1 → 2014.1
Revision history for this message
Sean McGinnis (sean-mcginnis) wrote : Bug Cleanup

Closing stale bug. If this is still an issue please reopen.

Changed in cinder:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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