Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Nova services on controller are not working due to SQL error

Hello.

I'm trying to set up Liberty on VMs with CentOS 7. Following the Install Guide, with only exception is Postgres instead of MySQL. Now, I'm stuck with setting up Nova on Controller node. Some services (nova-cert, nova-consoleauth and nova-scheduler) are reporting they can't connect to SQL (actual message in logs is like WARNING oslo_db.sqlalchemy.engines [req-uuiduuid-uuid-uuid-uuid-uuiduuiduuid - - - - -] SQL connection failed. -nn attempts left.).

Obviously, database is working good and accessible, because other services are working, and connection string is correct, because nova-manage db sync works without errors.

So, tell me, please, where to look for causes?

Nova services on controller are not working due to SQL error

Hello.

I'm trying to set up Liberty on VMs with CentOS 7. Following the Install Guide, with only exception is Postgres instead of MySQL. Now, I'm stuck with setting up Nova on Controller node. Some services (nova-cert, nova-consoleauth and nova-scheduler) are reporting they can't connect to SQL (actual message in logs is like WARNING oslo_db.sqlalchemy.engines [req-uuiduuid-uuid-uuid-uuid-uuiduuiduuid - - - - -] SQL connection failed. -nn attempts left.).

Obviously, database is working good and accessible, because other services are working, and connection string is correct, because nova-manage db sync works without errors.

During my later research, I found that running, i.e., su -s /bin/sh -c "nova-scheduler" nova in console works fine. According to logs, it can communicate with database. The error reproduced only when it's started as a daemon.

So, tell me, please, where to look for causes?