I've just tried to reproduce your condition by dropping all the tables on
the ovs_quantum db and then relaunching quantum-server, quantum-agent, and
quantum-dhcp.
The tables were successfully recreated.
The only advice I can give is to 1) verify no table actually appears when
you do "show tables" for ovs_quantum, and 2) drop the current ovs_quantum
schema and create a new one (with no tables).
Even if the service starts fine, I guess it then fails when you try to
perform any operations. It would be nice to see that traceback.
Salvatore
On 25 July 2012 16:30, Nicolas de Bonfils <openst...@nicolas2bonfils.com>wrote:
> It seems you are already in a situation where you have an empty db
>> ("show databases" returns ovs_quantum, but "show tables" returns an
>> empty list).
>>
> That's it.
>
>
> Quantum-server should recreate the tables for you. If this is not
>> happening, you should have an error during Quantum startup. Can you
>> post the traceback?
>>
> I got no error :/
> I recheck the sql connection url, it's ok (other services connects without
> error)
> You can read the startup log below :
> 2012-07-25 16:22:03 DEBUG [quantum.service]
> ****************************************************************
> ********************
> 2012-07-25 16:22:03 DEBUG [quantum.service] Configuration options
> gathered from config file:
> 2012-07-25 16:22:03 DEBUG [quantum.service]
> ==============================**==================
> 2012-07-25 16:22:03 DEBUG [quantum.service] api_extensions_path
> 2012-07-25 16:22:03 DEBUG [quantum.service] api_paste_config
> api-paste.ini
> 2012-07-25 16:22:03 DEBUG [quantum.service] base_mac
> fa:16:3e:00:00:00
> 2012-07-25 16:22:03 DEBUG [quantum.service] bind_host
> 192.168.23.5
> 2012-07-25 16:22:03 DEBUG [quantum.service] bind_port
> 12060
> 2012-07-25 16:22:03 DEBUG [quantum.service] config_dir
> None
> 2012-07-25 16:22:03 DEBUG [quantum.service] config_file
> ['/etc/quantum/quantum.conf']
> 2012-07-25 16:22:03 DEBUG [quantum.service] core_plugin
> quantum.plugins.openvswitch.**ovs_quantum_plugin.**OVSQuantumPluginV2
> 2012-07-25 16:22:03 DEBUG [quantum.service] debug
> True
> 2012-07-25 16:22:03 DEBUG [quantum.service] log_config
> None
> 2012-07-25 16:22:03 DEBUG [quantum.service] log_date_format
> %Y-%m-%d %H:%M:%S
> 2012-07-25 16:22:03 DEBUG [quantum.service] log_dir
> None
> 2012-07-25 16:22:03 DEBUG [quantum.service] log_file
> None
> 2012-07-25 16:22:03 DEBUG [quantum.service] log_format
> %(asctime)s %(levelname)8s [%(name)s] %(message)s
> 2012-07-25 16:22:03 DEBUG [quantum.service] mac_generation_retries
> 16
> 2012-07-25 16:22:03 DEBUG [quantum.service] policy_file
> policy.json
> 2012-07-25 16:22:03 DEBUG [quantum.service] syslog_log_facility
> LOG_USER
> 2012-07-25 16:22:03 DEBUG [quantum.service] use_syslog
> False
> 2012-07-25 16:22:03 DEBUG [quantum.service] verbose
> True
> 2012-07-25 16:22:03 DEBUG [quantum.service]
> ****************************************************************
> ********************
> 2012-07-25 16:22:03 INFO [quantum.common.config] Config paste file:
> /etc/quantum/api-paste.ini
> 2012-07-25 16:22:03 DEBUG [quantum.manager] Plugin
> location:quantum.plugins.**openvswitch.ovs_quantum_**
> plugin.OVSQuantumPluginV2
> 2012-07-25 16:22:03 INFO [quantum.manager] Loading Plugin:
> quantum.plugins.openvswitch.**ovs_quantum_plugin.**OVSQuantumPluginV2
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Initializing
> extension manager.
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: credential.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: extensions.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: providernet.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: multiport.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _qos_view.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: portstats.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: portprofile.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Cisco Port
> Profile
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: Cisco
> Port Profile
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description:
> Portprofile include QoS information
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.ciscocloud.com/**api/ext/portprofile/v1.0<http://docs.ciscocloud.com/api/ext/portprofile/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2011-07-23T13:25:27-06:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension Cisco Port
> Profile not supported by plugin <quantum.plugins.openvswitch.**
> ovs_quantum_plugin.**OVSQuantumPluginV2 object at 0x2975ed0>
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _portstats_view.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _novatenant_view.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: providernet.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Provider
> Network
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: provider
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description:
> Expose mapping of virtual networks to VLANs and flat networks
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.openstack.org/ext/**provider/api/v1.0<http://docs.openstack.org/ext/provider/api/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2012-07-23T10:00:00-00:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] Loaded extension:
> provider
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: extensions.py
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] Did not find
> expected name "Extensions" in /xxxxx/openstack/quantum/**
> quantum/extensions/extensions.**py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: novatenant.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Cisco Nova
> Tenant
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: Cisco
> Nova Tenant
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description:
> novatenant resource is used by nova side to invoke quantum api
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.ciscocloud.com/**api/ext/novatenant/v1.0<http://docs.ciscocloud.com/api/ext/novatenant/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2011-08-09T13:25:27-06:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension Cisco Nova
> Tenant not supported by plugin <quantum.plugins.openvswitch.**
> ovs_quantum_plugin.**OVSQuantumPluginV2 object at 0x2975ed0>
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: portstats.py
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension file
> portstats.py wasnt loaded due to cannot import name extensions
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _credential_view.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _pprofiles.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: novatenant.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: portprofile.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: __init__.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: __init__.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _pprofiles.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: credential.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Cisco
> Credential
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: Cisco
> Credential
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description:
> Credential include username and password
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.ciscocloud.com/**api/ext/credential/v1.0<http://docs.ciscocloud.com/api/ext/credential/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2011-07-25T13:25:27-06:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension Cisco
> Credential not supported by plugin <quantum.plugins.openvswitch.**
> ovs_quantum_plugin.**OVSQuantumPluginV2 object at 0x2975ed0>
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _novatenant_view.pyc
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: multiport.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Cisco
> Multiport
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: Cisco
> Multiport
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description:
> handle multiple ports in one call
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.ciscocloud.com/**api/ext/multiport/v1.0<http://docs.ciscocloud.com/api/ext/multiport/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2011-08-25T13:25:27-06:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension Cisco
> Multiport not supported by plugin <quantum.plugins.openvswitch.**
> ovs_quantum_plugin.**OVSQuantumPluginV2 object at 0x2975ed0>
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: qos.py
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext name: Cisco qos
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext alias: Cisco qos
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext description: qos
> includes qos_name and qos_desc
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext namespace:
> http://docs.ciscocloud.com/**api/ext/qos/v1.0<http://docs.ciscocloud.com/api/ext/qos/v1.0>
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Ext updated:
> 2011-07-25T13:25:27-06:00
> 2012-07-25 16:22:03 WARNING [quantum.api.extensions] extension Cisco qos
> not supported by plugin <quantum.plugins.openvswitch.**ovs_quantum_plugin.
> **OVSQuantumPluginV2 object at 0x2975ed0>
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _qos_view.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: _credential_view.py
> 2012-07-25 16:22:03 INFO [quantum.api.extensions] Loading extension
> file: qos.pyc
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Extended resource:
> extensions
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Extended resource:
> extensions
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [quantum.api.extensions] Extended resource:
> extensions
> 2012-07-25 16:22:03 DEBUG [routes.middleware] Initialized with method
> overriding = True, and path info altering = True
> 2012-07-25 16:22:03 DEBUG [eventlet.wsgi.server] (22190) wsgi starting
> up on http://192.168.23.5:12060/
>
--
Mailing list: https://launchpad.net/~netstack
Post to : netstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~netstack
More help : https://help.launchpad.net/ListHelp
