Bug 891420

Summary: Change default for compute node to poll for database connection indefinitely
Product: Red Hat OpenStack Reporter: Perry Myers <pmyers>
Component: openstack-novaAssignee: Pádraig Brady <pbrady>
Status: CLOSED ERRATA QA Contact: Ami Jeain <ajeain>
Severity: low Docs Contact:
Priority: medium    
Version: 2.0 (Folsom)CC: mmagr, yeylon
Target Milestone: snapshot3Keywords: Triaged
Target Release: 2.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-nova-2012.2.3-1.el6ost Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-03-21 14:14:42 EDT Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Description Perry Myers 2013-01-02 16:38:04 EST
Description of problem:
Default behavior is for compute node to poll for connection to database 10 times before the service fails and dies

However in a production environment it is probably more useful to poll indefinitely, since it is possible a network disruption could last longer than 10 poll tries and you'd want the compute node to reconnect as soon as it can

So this bug is to change our default nova.conf file to contain:
sql_max_retries -1
Comment 1 Martin Magr 2013-01-15 10:31:00 EST
This setting could be done in spec file during installation.
Comment 2 Pádraig Brady 2013-01-28 12:10:11 EST
I need to think/test about the implications of this
Comment 7 Ami Jeain 2013-03-07 11:34:53 EST
verified in build openstack-nova-api-2012.2.3-4.el6ost.noarch using:
1. #service mysqld stop
2. watched the errors in the log files
3. restarted the mysqld service and made sure the reconnect occured
Comment 9 errata-xmlrpc 2013-03-21 14:14:42 EDT
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHSA-2013-0657.html