<div dir="ltr"><div>Hi,</div><div><br></div><div>recently I faced this issue.</div><div><br></div>upgrade amqp lib on all nodes and it should work.<div><br></div><div>Regards,</div><div>Yatin</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, May 5, 2015 at 5:37 PM, Ajaya Agrawal <span dir="ltr"><<a href="mailto:ajku.agr@gmail.com" target="_blank">ajku.agr@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi,<div><br></div><div>A better place to ask this question would be <a href="http://ask.openstack.org" target="_blank">ask.openstack.org</a> .</div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div>Cheers,<br></div>Ajaya<br></div></div></div>
<br><div class="gmail_quote"><div><div class="h5">On Tue, May 5, 2015 at 4:56 PM, Abhishek Talwar <span dir="ltr"><<a href="mailto:abhishek.talwar@tcs.com" target="_blank">abhishek.talwar@tcs.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">Hi Folks,<br><br>I am trying to setup a multinode OpenStack. When I boot an instance it is successfully created but it is going in ERROR state. I have checked the logs in /var/log/nova/nova-scheduler.log and it gives an Operational error “database is locked”. Moreover when I check the database there are no tables getting created in the Nova database, while Neutron and others have there tables.<br><br>The logs are following :<br><br>2015-05-05 14:35:13.158 18551 TRACE nova.openstack.common.periodic_task OperationalError: (OperationalError) database is locked u'UPDATE reservations SET deleted_at=?, deleted=id, updated_at=updated_at WHERE reservations.deleted = ? AND reservations.expire < ?' ('2015-05-05 09:05:13.150105', 0, '2015-05-05 09:05:13.138314')
<br>2015-05-05 14:35:13.158 18551 TRACE nova.openstack.common.periodic_task 
<br>2015-05-05 14:37:47.972 18551 INFO oslo.messaging._drivers.impl_rabbit [-] Connecting to AMQP server on controller:5672
<br>2015-05-05 14:37:47.991 18551 INFO oslo.messaging._drivers.impl_rabbit [-] Connected to AMQP server on controller:5672
<br>2015-05-05 15:10:59.535 18551 INFO nova.openstack.common.service [-] Caught SIGTERM, exiting
<br>2015-05-05 15:11:01.506 19260 AUDIT nova.service [-] Starting scheduler node (version 2014.2.2)
<br>2015-05-05 15:11:03.691 19260 INFO oslo.messaging._drivers.impl_rabbit [req-7b53c22a-2161-4f9f-9942-c39ad5b35ca0 ] Connecting to AMQP server on controller:5672
<br>2015-05-05 15:11:03.747 19260 INFO oslo.messaging._drivers.impl_rabbit [req-7b53c22a-2161-4f9f-9942-c39ad5b35ca0 ] Connected to AMQP server on controller:5672
<br>2015-05-05 15:21:55.601 19260 INFO nova.openstack.common.service [-] Caught SIGTERM, exiting
<br>2015-05-05 15:21:56.568 19542 AUDIT nova.service [-] Starting scheduler node (version 2014.2.2)
<br>2015-05-05 15:21:57.504 19542 INFO oslo.messaging._drivers.impl_rabbit [req-ee9a2d39-678d-48c2-b490-2894cb6370b5 ] Connecting to AMQP server on controller:5672
<br>2015-05-05 15:21:57.514 19542 INFO oslo.messaging._drivers.impl_rabbit [req-ee9a2d39-678d-48c2-b490-2894cb6370b5 ] Connected to AMQP server on controller:5672
<br>2015-05-05 15:32:39.316 19542 INFO oslo.messaging._drivers.impl_rabbit [-] Connecting to AMQP server on controller:5672
<br>2015-05-05 15:32:39.343 19542 INFO oslo.messaging._drivers.impl_rabbit [-] Connected to AMQP server on controller:5672
<br>2015-05-05 15:38:21.280 19542 INFO nova.openstack.common.service [-] Caught SIGTERM, exiting
<br>2015-05-05 15:38:22.434 19954 AUDIT nova.service [-] Starting scheduler node (version 2014.2.2)
<br>2015-05-05 15:38:23.173 19954 INFO oslo.messaging._drivers.impl_rabbit [req-b65ec7c6-6bbd-4e13-9694-da927c9cf337 ] Connecting to AMQP server on controller:5672
<br>2015-05-05 15:38:23.248 19954 INFO oslo.messaging._drivers.impl_rabbit [req-b65ec7c6-6bbd-4e13-9694-da927c9cf337 ] Connected to AMQP server on controller:5672
<br>2015-05-05 15:39:46.468 19954 INFO oslo.messaging._drivers.impl_rabbit [-] Connecting to AMQP server on controller:5672
<br>2015-05-05 15:39:46.484 19954 INFO oslo.messaging._drivers.impl_rabbit [-] Connected to AMQP server on controller:5672<br><br><br><br><br><br><br><br>The configuration for nova.conf is :<br><br>[DEFAULT]
<br>dhcpbridge_flagfile=/etc/nova/nova.conf
<br>dhcpbridge=/usr/bin/nova-dhcpbridge
<br>logdir=/var/log/nova
<br>state_path=/var/lib/nova
<br>lock_path=/var/lock/nova
<br>force_dhcp_release=True
<br>libvirt_use_virtio_for_bridges=True
<br>verbose=True
<br>ec2_private_dns_show_ip=True
<br>api_paste_config=/etc/nova/api-paste.ini
<br>enabled_apis=ec2,osapi_compute,metadata
<br>scheduler_default_filters=AllHostsFilter
<br>verbose = True
<br>connection = mysql://nova:NOVA_DBPASS@controller/nova
<br>rpc_backend = rabbit
<br>rabbit_host = controller
<br>rabbit_password = RABBIT_PASS
<br> <br>auth_strategy = keystone
<br> <br>my_ip = 10.10.10.10
<br> <br>vncserver_listen = 10.10.10.10
<br>vncserver_proxyclient_address = 10.10.10.10
<br> <br>network_api_class = nova.network.neutronv2.api.API
<br>security_group_api = neutron
<br>linuxnet_interface_driver = nova.network.linux_net.LinuxOVSInterfaceDriver
<br>firewall_driver = nova.virt.firewall.NoopFirewallDriver
<br> <br>[keystone_authtoken]
<br>auth_uri = <a href="http://controller:5000/v2.0" target="_blank">http://controller:5000/v2.0</a>
<br>identity_uri = <a href="http://controller:35357" target="_blank">http://controller:35357</a>
<br>admin_tenant_name = service
<br>admin_user = nova
<br>admin_password = NOVA_PASS
<br> <br>[glance]
<br>host = controller
<br> <br>[neutron]
<br>url = <a href="http://controller:9696" target="_blank">http://controller:9696</a>
<br>auth_strategy = keystone
<br>admin_auth_url = <a href="http://controller:35357/v2.0" target="_blank">http://controller:35357/v2.0</a>
<br>admin_tenant_name = service
<br>admin_username = neutron
<br>admin_password = NEUTRON_PASS<br><br><br>The configuration for neutron is:<br><br>[DEFAULT]<br>verbose = True<br>lock_path = $state_path/lock<br>core_plugin = ml2<br>service_plugins = router<br>allow_overlapping_ips = True<br><br>auth_strategy = keystone<br><br><br><br># Driver to use for scheduling a loadbalancer pool to an lbaas agent<br># loadbalancer_pool_scheduler_driver = neutron.services.loadbalancer.agent_scheduler.ChanceScheduler<br>notify_nova_on_port_status_changes = True<br>notify_nova_on_port_data_changes = True<br>nova_url = <a href="http://controller:8774/v2" target="_blank">http://controller:8774/v2</a><br>nova_admin_auth_url = <a href="http://controller:35357/v2.0" target="_blank">http://controller:35357/v2.0</a><br>nova_region_name = regionOne<br>nova_admin_username = nova<br>nova_admin_tenant_id = 21e4ba2d07ac4c7e9b220be98175cd8f<br>nova_admin_password = NOVA_PASS<br>rabbit_host=controller<br># The RabbitMQ password. (string value)<br>rabbit_password=RABBIT_PASS<br>rpc_backend=rabbit<br>[matchmaker_redis]<br>[matchmaker_ring]<br>[agent]<br># Use "sudo neutron-rootwrap /etc/neutron/rootwrap.conf" to use the real<br># root filter facility.<br># Change to "sudo" to skip the filtering and just run the comand directly<br>root_helper = sudo /usr/bin/neutron-rootwrap /etc/neutron/rootwrap.conf<br>[keystone_authtoken]<br>auth_uri = <a href="http://controller:5000/v2.0" target="_blank">http://controller:5000/v2.0</a><br>identity_uri = <a href="http://controller:35357" target="_blank">http://controller:35357</a><br>admin_tenant_name = service<br>admin_user = neutron<br>admin_password = NEUTRON_PASS<br>[database]<br>[service_providers]<br>service_provider=LOADBALANCER:Haproxy:neutron.services.loadbalancer.drivers.haproxy.plugin_driver.HaproxyOnHostPluginDriver:default<br>service_provider=VPN:openswan:neutron.services.vpn.service_drivers.ipsec.IPsecVPNDriver:default<br>service_provider=LOADBALANCER:Embrane:neutron.services.loadbalancer.drivers.embrane.driver.EmbraneLbaas:default<br><br><br><br>Kindly update me with the steps where I am going wrong or what should be the next steps.<br><div></div></font>
<p>=====-----=====-----=====<br>
Notice: The information contained in this e-mail<br>
message and/or attachments to it may contain <br>
confidential or privileged information. If you are <br>
not the intended recipient, any dissemination, use, <br>
review, distribution, printing or copying of the <br>
information contained in this e-mail message <br>
and/or attachments to it are strictly prohibited. If <br>
you have received this communication in error, <br>
please notify us by reply e-mail or telephone and <br>
immediately and permanently delete the message <br>
and any attachments. Thank you</p>

<p></p>

<br></div></div>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br></div>
<br>__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br></blockquote></div><br></div>