← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1338841] Re: asynchronous connection failed in postgresql jobs

 

Reviewed:  https://review.openstack.org/105854
Committed: https://git.openstack.org/cgit/openstack-dev/devstack/commit/?id=94c654ef37f6a0247a307578f3240f97201a3cba
Submitter: Jenkins
Branch:    master

commit 94c654ef37f6a0247a307578f3240f97201a3cba
Author: Matt Riedemann <mriedem@xxxxxxxxxx>
Date:   Wed Jul 9 12:38:36 2014 -0700

    Set postgresql max_connections=200
    
    Now that we have multiple workers running by default
    in various projects (nova/cinder/glance/trove), the
    postgresql job is failing intermittently with connection
    failures to the database.
    
    The default max_connections for postgresql is 100 so here
    we double that.
    
    Note that the default max_connections for mysql used to
    be 100 but is now 151, so this change brings the postgresql
    configuration more in line with mysql.
    
    Change-Id: I2fcae8184a82e303103795a7bf57c723e27190c9
    Closes-Bug: #1338841


** Changed in: devstack
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1338841

Title:
  asynchronous connection failed in postgresql jobs

Status in Cinder:
  Invalid
Status in devstack - openstack dev environments:
  Fix Released
Status in OpenStack Compute (Nova):
  Invalid

Bug description:
  The trace for the failure is here:

  http://logs.openstack.org/57/105257/4/check/check-tempest-dsvm-
  postgres-
  full/f72b818/logs/tempest.txt.gz?level=TRACE#_2014-07-07_23_43_37_250

  This is the console error:

  2014-07-07 23:44:59.590 | tearDownClass (tempest.thirdparty.boto.test_ec2_keys.EC2KeysTest)
  2014-07-07 23:44:59.590 | -----------------------------------------------------------------
  2014-07-07 23:44:59.590 | 
  2014-07-07 23:44:59.590 | Captured traceback:
  2014-07-07 23:44:59.590 | ~~~~~~~~~~~~~~~~~~~
  2014-07-07 23:44:59.590 |     Traceback (most recent call last):
  2014-07-07 23:44:59.590 |       File "tempest/thirdparty/boto/test.py", line 272, in tearDownClass
  2014-07-07 23:44:59.590 |         raise exceptions.TearDownException(num=fail_count)
  2014-07-07 23:44:59.590 |     TearDownException: 1 cleanUp operation failed

  There isn't much in the n-api logs, just the 400 response.

To manage notifications about this bug go to:
https://bugs.launchpad.net/cinder/+bug/1338841/+subscriptions


References