Ask Your Question
1

[IMP] Ocata Ubuntu 16.04 Openstack installation: No valid host was found. There are not enough hosts available

asked 2017-07-28 13:23:39 -0500

Ruchir Nerurkar gravatar image 
    Hello All,

    I am trying to launch a VM instance on Ocata Ubuntu 16.04 openstack environment but I am getting this error on dashboard.`enter code here`

    ****Error:-****Failed to perform requested operation on instance "VM 1", the instance has an error status: Please try again later [Error: No valid host was found. There are not enough hosts available.]

    After checking in nova-conductor.log, it gives the following error:-

    2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     return connection._execute_clauseelement(self, multiparams, params)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     compiled_sql, distilled_params
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     context)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     util.raise_from_cause(newraise, exc_info)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     reraise(type(exception), exception, tb=exc_tb)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     context)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db     cursor.execute(statement, parameters)
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db OperationalError: (sqlite3.OperationalError) database is locked [SQL: u'UPDATE services SET updated_at=?, report_count=?, last_seen_up=? WHERE services.id = ?'] [parameters: ('2017-07-28 16:17:02.395709', 10, '2017-07-28 16:17:02.395151', 3)]
2017-07-28 09:17:02.396 22067 ERROR nova.servicegroup.drivers.db
2017-07-28 09:17:12.579 22067 INFO nova.servicegroup.drivers.db [-] Recovered from being unable to report status.
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db [-] Unexpected error while reporting service status
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db Traceback (most recent call last):
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/nova/servicegroup/drivers/db.py", line 87, in _report_state
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db     service.service_ref.save()
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db   File "/usr/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 226, in wrapper
2017-07-28 09:17:32.409 22065 ERROR nova.servicegroup.drivers.db     return ...
(more)
edit retag flag offensive close merge delete

Comments

@Praveen Nagegowda

Kindly help me for this issue..I have been facing the same issue since last 2 weeks and have been stuck here..Request your co-operation and support sir, please help

Ruchir Nerurkar gravatar imageRuchir Nerurkar ( 2017-07-28 13:35:44 -0500 )edit

@Bernd Bausch

Sir, need your assistance. I have been facing the same issue since last 2 weeks and have been stuck here..Request your co-operation and support sir, please help or guide me to resolve the issue..

Ruchir Nerurkar gravatar imageRuchir Nerurkar ( 2017-07-28 13:36:55 -0500 )edit
1

How can I resist such a request:)

I am surprised at the sqlite reference in the stack trace. Can you check your conf file and replace any occurrence of sqlite with the corresponding mysql?

Bernd Bausch gravatar imageBernd Bausch ( 2017-07-28 20:33:23 -0500 )edit

@Ruchir, First Ensure about the configurations are correct [mysql for db]. Check nova-compute logs and neutron logs. Is it single node deployment or multi-node?

Praveen N gravatar imagePraveen N ( 2017-08-01 00:24:23 -0500 )edit

Hello all, it was the configuration error. I was doing the installation through automation script and in bridge_mappings parameter in neutron_openvswitch_agent.ini file was missing. After adding, VM starts to respond

Ruchir Nerurkar gravatar imageRuchir Nerurkar ( 2017-08-01 15:12:31 -0500 )edit
add a comment

1 answer

Sort by ยป oldest newest most voted
0

answered 2017-07-31 16:23:17 -0500

Radhakrishnan Rk gravatar image

Hello,

It might due to any configuration error. If you like to evaluate openstack ocata release in sible node and mulinode environment, Clone the git repo https://github.com/thrinethratechhara... and run the bash script.

Could you please post your nova config file. Have you checked the db connectivity from nova service db user and database connection conf in config file.

Best Regards,

Radhakrishnan Rk

edit flag offensive delete link more

Comments

Hello Rk, it was the configuration error. I was doing the installation through automation script and in bridge_mappings parameter in neutron_openvswitch_agent.ini file was missing. After adding, VM starts to respond

Ruchir Nerurkar gravatar imageRuchir Nerurkar ( 2017-08-01 15:12:41 -0500 )edit
add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

subscribe to rss feed

Stats

Asked: 2017-07-28 13:23:39 -0500

Seen: 352 times

Last updated: Jul 31 '17

Related questions

second compute added, command "nova-status upgrade check" warning for Check: Resource Providers

Ocata installation - unable to launch instance (default default] Unexpected exception in API method)

[IMP] Ocata Ubuntu 16.04 Openstack installation: Getting manager creation issue in neutron while launching an instance

Ocata creates 2 IPs of same subnet in each instance

Ocata - "nova-manage db sync" fails [closed]

Error: Unable to retrieve the flavors. (IE only)

ocata to pike upgrade

Install OpenStack OpenSuseLEAP42.2 Ocata RabbitMQ service fails to start

No valid host was found. There are not enough hosts available.

VCPU over commit issue