← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1689023] [NEW] PostgreSQL fails with Ocata Nova-API on CentOS 7.2

 

Public bug reported:

Hi all:
I'm now trying to install an Openstack Ocata on a CentOS 7.2 Host,with PostgreSQL 9.2.18 el7 as the backend database.Following the offical installation Guide of Ocata.

1、Keystone is successfully deployed on the controller node.
2、Glance is successfully deployed on the controller node.
3、Nova is successfuly deployed on the controller node.

After Check all NOVA-Service is active and running, before continuing
deploy nova on compute node,i typed the “openstack compute service list”
command, i got an error return as following:

[root@controller ~(keystone_admin)]# openstack compute service list
Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.OperationalError'> (HTTP 500) (Request-ID: req-41ec69a5-28cf-4b00-8ec9-d4aad3d83481)

When i check the nova-api.log,i found although the nova-api service is
active and running,there is always an database connection fail error
from the very beginning after i started the nova-api service.The error
log is in the attachment:

2017-05-07 05:47:07.789 2311 ERROR oslo_service.service
OperationalError: (psycopg2.OperationalError) asynchronous connection
failed


Is there any solution now?

** Affects: nova
     Importance: Undecided
         Status: New

** Attachment added: "The nova-api.log"
   https://bugs.launchpad.net/bugs/1689023/+attachment/4873017/+files/nova-api.log

** Description changed:

  Hi all:
  I'm now trying to install an Openstack Ocata on a CentOS 7.2 Host,with PostgreSQL 9.2.18 el7 as the backend database.Following the offical installation Guide of Ocata.
  
  1、Keystone is successfully deployed on the controller node.
  2、Glance is successfully deployed on the controller node.
  3、Nova is successfuly deployed on the controller node.
  
  After Check all NOVA-Service is active and running, before continuing
  deploy nova on compute node,i typed the “openstack compute service list”
  command, i got an error return as following:
  
  [root@controller ~(keystone_admin)]# openstack compute service list
  Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.OperationalError'> (HTTP 500) (Request-ID: req-41ec69a5-28cf-4b00-8ec9-d4aad3d83481)
  
  When i check the nova-api.log,i found although the nova-api service is
  active and running,there is always an database connection fail error
  from the very beginning after i started the nova-api service.The error
- log is in the attachment.
+ log is in the attachment:
+ 
+ 2017-05-07 05:47:07.789 2311 ERROR oslo_service.service
+ OperationalError: (psycopg2.OperationalError) asynchronous connection
+ failed
+ 
  
  Is there any solution now?

-- 
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/1689023

Title:
  PostgreSQL fails with Ocata Nova-API on CentOS 7.2

Status in OpenStack Compute (nova):
  New

Bug description:
  Hi all:
  I'm now trying to install an Openstack Ocata on a CentOS 7.2 Host,with PostgreSQL 9.2.18 el7 as the backend database.Following the offical installation Guide of Ocata.

  1、Keystone is successfully deployed on the controller node.
  2、Glance is successfully deployed on the controller node.
  3、Nova is successfuly deployed on the controller node.

  After Check all NOVA-Service is active and running, before continuing
  deploy nova on compute node,i typed the “openstack compute service
  list” command, i got an error return as following:

  [root@controller ~(keystone_admin)]# openstack compute service list
  Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
  <class 'sqlalchemy.exc.OperationalError'> (HTTP 500) (Request-ID: req-41ec69a5-28cf-4b00-8ec9-d4aad3d83481)

  When i check the nova-api.log,i found although the nova-api service is
  active and running,there is always an database connection fail error
  from the very beginning after i started the nova-api service.The error
  log is in the attachment:

  2017-05-07 05:47:07.789 2311 ERROR oslo_service.service
  OperationalError: (psycopg2.OperationalError) asynchronous connection
  failed

  
  Is there any solution now?

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


Follow ups