Hi, A better place to ask this question would be ask.openstack.org .
Cheers, Ajaya On Tue, May 5, 2015 at 4:56 PM, Abhishek Talwar <[email protected]> wrote: > Hi Folks, > > 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. > > The logs are following : > > 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') > 2015-05-05 14:35:13.158 18551 TRACE nova.openstack.common.periodic_task > 2015-05-05 14:37:47.972 18551 INFO oslo.messaging._drivers.impl_rabbit [-] > Connecting to AMQP server on controller:5672 > 2015-05-05 14:37:47.991 18551 INFO oslo.messaging._drivers.impl_rabbit [-] > Connected to AMQP server on controller:5672 > 2015-05-05 15:10:59.535 18551 INFO nova.openstack.common.service [-] > Caught SIGTERM, exiting > 2015-05-05 15:11:01.506 19260 AUDIT nova.service [-] Starting scheduler > node (version 2014.2.2) > 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 > 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 > 2015-05-05 15:21:55.601 19260 INFO nova.openstack.common.service [-] > Caught SIGTERM, exiting > 2015-05-05 15:21:56.568 19542 AUDIT nova.service [-] Starting scheduler > node (version 2014.2.2) > 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 > 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 > 2015-05-05 15:32:39.316 19542 INFO oslo.messaging._drivers.impl_rabbit [-] > Connecting to AMQP server on controller:5672 > 2015-05-05 15:32:39.343 19542 INFO oslo.messaging._drivers.impl_rabbit [-] > Connected to AMQP server on controller:5672 > 2015-05-05 15:38:21.280 19542 INFO nova.openstack.common.service [-] > Caught SIGTERM, exiting > 2015-05-05 15:38:22.434 19954 AUDIT nova.service [-] Starting scheduler > node (version 2014.2.2) > 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 > 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 > 2015-05-05 15:39:46.468 19954 INFO oslo.messaging._drivers.impl_rabbit [-] > Connecting to AMQP server on controller:5672 > 2015-05-05 15:39:46.484 19954 INFO oslo.messaging._drivers.impl_rabbit [-] > Connected to AMQP server on controller:5672 > > > > > > > > The configuration for nova.conf is : > > [DEFAULT] > dhcpbridge_flagfile=/etc/nova/nova.conf > dhcpbridge=/usr/bin/nova-dhcpbridge > logdir=/var/log/nova > state_path=/var/lib/nova > lock_path=/var/lock/nova > force_dhcp_release=True > libvirt_use_virtio_for_bridges=True > verbose=True > ec2_private_dns_show_ip=True > api_paste_config=/etc/nova/api-paste.ini > enabled_apis=ec2,osapi_compute,metadata > scheduler_default_filters=AllHostsFilter > verbose = True > connection = mysql://nova:NOVA_DBPASS@controller/nova > rpc_backend = rabbit > rabbit_host = controller > rabbit_password = RABBIT_PASS > > auth_strategy = keystone > > my_ip = 10.10.10.10 > > vncserver_listen = 10.10.10.10 > vncserver_proxyclient_address = 10.10.10.10 > > network_api_class = nova.network.neutronv2.api.API > security_group_api = neutron > linuxnet_interface_driver = nova.network.linux_net.LinuxOVSInterfaceDriver > firewall_driver = nova.virt.firewall.NoopFirewallDriver > > [keystone_authtoken] > auth_uri = http://controller:5000/v2.0 > identity_uri = http://controller:35357 > admin_tenant_name = service > admin_user = nova > admin_password = NOVA_PASS > > [glance] > host = controller > > [neutron] > url = http://controller:9696 > auth_strategy = keystone > admin_auth_url = http://controller:35357/v2.0 > admin_tenant_name = service > admin_username = neutron > admin_password = NEUTRON_PASS > > > The configuration for neutron is: > > [DEFAULT] > verbose = True > lock_path = $state_path/lock > core_plugin = ml2 > service_plugins = router > allow_overlapping_ips = True > > auth_strategy = keystone > > > > # Driver to use for scheduling a loadbalancer pool to an lbaas agent > # loadbalancer_pool_scheduler_driver = > neutron.services.loadbalancer.agent_scheduler.ChanceScheduler > notify_nova_on_port_status_changes = True > notify_nova_on_port_data_changes = True > nova_url = http://controller:8774/v2 > nova_admin_auth_url = http://controller:35357/v2.0 > nova_region_name = regionOne > nova_admin_username = nova > nova_admin_tenant_id = 21e4ba2d07ac4c7e9b220be98175cd8f > nova_admin_password = NOVA_PASS > rabbit_host=controller > # The RabbitMQ password. (string value) > rabbit_password=RABBIT_PASS > rpc_backend=rabbit > [matchmaker_redis] > [matchmaker_ring] > [agent] > # Use "sudo neutron-rootwrap /etc/neutron/rootwrap.conf" to use the real > # root filter facility. > # Change to "sudo" to skip the filtering and just run the comand directly > root_helper = sudo /usr/bin/neutron-rootwrap /etc/neutron/rootwrap.conf > [keystone_authtoken] > auth_uri = http://controller:5000/v2.0 > identity_uri = http://controller:35357 > admin_tenant_name = service > admin_user = neutron > admin_password = NEUTRON_PASS > [database] > [service_providers] > > service_provider=LOADBALANCER:Haproxy:neutron.services.loadbalancer.drivers.haproxy.plugin_driver.HaproxyOnHostPluginDriver:default > > service_provider=VPN:openswan:neutron.services.vpn.service_drivers.ipsec.IPsecVPNDriver:default > > service_provider=LOADBALANCER:Embrane:neutron.services.loadbalancer.drivers.embrane.driver.EmbraneLbaas:default > > > > Kindly update me with the steps where I am going wrong or what should be > the next steps. > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: [email protected]?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > >
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
