<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; "><div>Hi,</div><div>Anyone else encounter the following exception:</div><div><br></div><div><div>+ /usr/local/bin/neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head</div><div>No handlers could be found for logger "neutron.common.legacy"</div><div>INFO [alembic.migration] Context impl MySQLImpl.</div><div>INFO [alembic.migration] Will assume non-transactional DDL.</div><div>INFO [alembic.migration] Running upgrade None -> folsom, folsom initial database</div><div>INFO [alembic.migration] Running upgrade folsom -> 2c4af419145b, l3_support</div><div>INFO [alembic.migration] Running upgrade 2c4af419145b -> 5a875d0e5c, ryu</div><div>INFO [alembic.migration] Running upgrade 5a875d0e5c -> 48b6f43f7471, DB support for service types</div><div>INFO [alembic.migration] Running upgrade 48b6f43f7471 -> 3cb5d900c5de, security_groups</div><div>INFO [alembic.migration] Running upgrade 3cb5d900c5de -> 1d76643bcec4, nvp_netbinding</div><div>INFO [alembic.migration] Running upgrade 1d76643bcec4 -> 2a6d0b51f4bb, cisco plugin cleanup</div><div>INFO [alembic.migration] Running upgrade 2a6d0b51f4bb -> 1b693c095aa3, Quota ext support added in Grizzly</div><div>INFO [alembic.migration] Running upgrade 1b693c095aa3 -> 1149d7de0cfa, inital port security</div><div>INFO [alembic.migration] Running upgrade 1149d7de0cfa -> 49332180ca96, ryu plugin update</div><div>INFO [alembic.migration] Running upgrade 49332180ca96 -> 38335592a0dc, nvp_portmap</div><div>INFO [alembic.migration] Running upgrade 38335592a0dc -> 54c2c487e913, 'DB support for load balancing service</div><div>INFO [alembic.migration] Running upgrade 54c2c487e913 -> 45680af419f9, nvp_qos</div><div>INFO [alembic.migration] Running upgrade 45680af419f9 -> 1c33fa3cd1a1, Support routing table configuration on Router</div><div>INFO [alembic.migration] Running upgrade 1c33fa3cd1a1 -> 363468ac592c, nvp_network_gw</div><div>INFO [alembic.migration] Running upgrade 363468ac592c -> 511471cc46b, Add agent management extension model support</div><div>INFO [alembic.migration] Running upgrade 511471cc46b -> 3b54bf9e29f7, NEC plugin sharednet</div><div>INFO [alembic.migration] Running upgrade 3b54bf9e29f7 -> 4692d074d587, agent scheduler</div><div>INFO [alembic.migration] Running upgrade 4692d074d587 -> 1341ed32cc1e, nvp_net_binding</div><div>INFO [alembic.migration] Running upgrade 1341ed32cc1e -> grizzly, grizzly</div><div>INFO [alembic.migration] Running upgrade grizzly -> f489cf14a79c, DB support for load balancing service (havana)</div><div>INFO [alembic.migration] Running upgrade f489cf14a79c -> 176a85fc7d79, Add portbindings db</div><div>INFO [alembic.migration] Running upgrade 176a85fc7d79 -> 32b517556ec9, remove TunnelIP model</div><div>INFO [alembic.migration] Running upgrade 32b517556ec9 -> 128e042a2b68, ext_gw_mode</div><div>INFO [alembic.migration] Running upgrade 128e042a2b68 -> 5ac71e65402c, ml2_initial</div><div>INFO [alembic.migration] Running upgrade 5ac71e65402c -> 3cbf70257c28, nvp_mac_learning</div><div>INFO [alembic.migration] Running upgrade 3cbf70257c28 -> 5918cbddab04, add tables for router rules support</div><div>INFO [alembic.migration] Running upgrade 5918cbddab04 -> 3cabb850f4a5, Table to track port to host associations</div><div>INFO [alembic.migration] Running upgrade 3cabb850f4a5 -> b7a8863760e, Remove cisco_vlan_bindings table</div><div>INFO [alembic.migration] Running upgrade b7a8863760e -> 13de305df56e, nec_add_pf_name</div><div>INFO [alembic.migration] Running upgrade 13de305df56e -> 20ae61555e95, DB Migration for ML2 GRE Type Driver</div><div>INFO [alembic.migration] Running upgrade 20ae61555e95 -> 477a4488d3f4, DB Migration for ML2 VXLAN Type Driver</div><div>INFO [alembic.migration] Running upgrade 477a4488d3f4 -> 2032abe8edac, LBaaS add status description</div><div>INFO [alembic.migration] Running upgrade 2032abe8edac -> 52c5e4a18807, LBaaS Pool scheduler</div><div>INFO [alembic.migration] Running upgrade 52c5e4a18807 -> 557edfc53098, New service types framework (service providers)</div><div>INFO [alembic.migration] Running upgrade 557edfc53098 -> e6b16a30d97, Add cisco_provider_networks table</div><div>INFO [alembic.migration] Running upgrade e6b16a30d97 -> 39cf3f799352, FWaaS Havana-2 model</div><div>INFO [alembic.migration] Running upgrade 39cf3f799352 -> 52ff27f7567a, Support for VPNaaS</div><div>INFO [alembic.migration] Running upgrade 52ff27f7567a -> 11c6e18605c8, Pool Monitor status field</div><div>INFO [alembic.migration] Running upgrade 11c6e18605c8 -> 35c7c198ddea, remove status from HealthMonitor</div><div>INFO [alembic.migration] Running upgrade 35c7c198ddea -> 263772d65691, Cisco plugin db cleanup part II</div><div>INFO [alembic.migration] Running upgrade 263772d65691 -> c88b6b5fea3, Cisco N1KV tables</div><div>INFO [alembic.migration] Running upgrade c88b6b5fea3 -> f9263d6df56, remove_dhcp_lease</div><div>INFO [alembic.migration] Running upgrade f9263d6df56 -> 569e98a8132b, metering</div><div>INFO [alembic.migration] Running upgrade 569e98a8132b -> 86cf4d88bd3, remove bigswitch port tracking table</div><div>INFO [alembic.migration] Running upgrade 86cf4d88bd3 -> 3c6e57a23db4, add multiprovider</div><div>INFO [alembic.migration] Running upgrade 3c6e57a23db4 -> 63afba73813, Add unique constraint for id column of TunnelEndpoint</div><div>INFO [alembic.migration] Running upgrade 63afba73813 -> 40dffbf4b549, nvp_dist_router</div><div>INFO [alembic.migration] Running upgrade 40dffbf4b549 -> 53bbd27ec841, Extra dhcp opts support</div><div>INFO [alembic.migration] Running upgrade 53bbd27ec841 -> 46a0efbd8f0, cisco_n1kv_multisegment_trunk</div><div>INFO [alembic.migration] Running upgrade 46a0efbd8f0 -> 2a3bae1ceb8, NEC Port Binding</div><div>INFO [alembic.migration] Running upgrade 2a3bae1ceb8 -> 14f24494ca31, DB Migration for Arista ml2 mechanism driver</div><div>INFO [alembic.migration] Running upgrade 14f24494ca31 -> 32a65f71af51, ml2 portbinding</div><div>INFO [alembic.migration] Running upgrade 32a65f71af51 -> 66a59a7f516, NEC OpenFlow Router</div><div>INFO [alembic.migration] Running upgrade 66a59a7f516 -> 51b4de912379, Cisco Nexus ML2 mechanism driver</div><div>INFO [alembic.migration] Running upgrade 51b4de912379 -> 1efb85914233, allowedaddresspairs</div><div>INFO [alembic.migration] Running upgrade 1efb85914233 -> 38fc1f6789f8, Cisco N1KV overlay support</div><div>INFO [alembic.migration] Running upgrade 38fc1f6789f8 -> 4a666eb208c2, service router</div><div>INFO [alembic.migration] Running upgrade 4a666eb208c2 -> 338d7508968c, vpnaas peer_address size increase</div><div>INFO [alembic.migration] Running upgrade 338d7508968c -> 3ed8f075e38a, nvp fwaas plugin</div><div>INFO [alembic.migration] Running upgrade 3ed8f075e38a -> 3d6fae8b70b0, nvp lbaas plugin</div><div>INFO [alembic.migration] Running upgrade 3d6fae8b70b0 -> 1064e98b7917, nec-pf-port-del</div><div>INFO [alembic.migration] Running upgrade 1064e98b7917 -> 2528ceb28230, NEC PacketFilter network_id nullable fix</div><div>INFO [alembic.migration] Running upgrade 2528ceb28230 -> 3a520dd165d0, Cisco Nexus multi-switch</div><div>INFO [alembic.migration] Running upgrade 3a520dd165d0 -> 27ef74513d33, quota_in_plumgrid_plugin</div><div>INFO [alembic.migration] Running upgrade 27ef74513d33 -> havana, havana</div><div>INFO [alembic.migration] Running upgrade havana -> e197124d4b9, add unique constraint to members</div><div>INFO [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a unique constraint on (agent_type, host) columns to prevent a race</div><div>condition when an agent entry is 'upserted'.</div><div>Traceback (most recent call last):</div><div> File "/usr/local/bin/neutron-db-manage", line 10, in <module></div><div> sys.exit(main())</div><div> File "/opt/stack/neutron/neutron/db/migration/cli.py", line 143, in main</div><div> CONF.command.func(config, CONF.command.name)</div><div> File "/opt/stack/neutron/neutron/db/migration/cli.py", line 80, in do_upgrade_downgrade</div><div> do_alembic_command(config, cmd, revision, sql=CONF.command.sql)</div><div> File "/opt/stack/neutron/neutron/db/migration/cli.py", line 59, in do_alembic_command</div><div> getattr(alembic_command, cmd)(config, *args, **kwargs)</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124, in upgrade</div><div> script.run_env()</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 199, in run_env</div><div> util.load_python_file(self.dir, 'env.py')</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 198, in load_python_file</div><div> module = load_module(module_id, path)</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 55, in load_module</div><div> mod = imp.load_source(module_id, path, fp)</div><div> File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 105, in <module></div><div> run_migrations_online()</div><div> File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", line 89, in run_migrations_online</div><div> options=build_options())</div><div> File "<string>", line 7, in run_migrations</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 652, in run_migrations</div><div> self.get_context().run_migrations(**kw)</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 225, in run_migrations</div><div> change(**kw)</div><div> File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/1fcfc149aca4_agents_unique_by_type_and_host.py", line 50, in upgrade</div><div> local_cols=['agent_type', 'host']</div><div> File "<string>", line 7, in create_unique_constraint</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 544, in create_unique_constraint</div><div> schema=schema, **kw)</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 135, in add_constraint</div><div> self._exec(schema.AddConstraint(const))</div><div> File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76, in _exec</div><div> conn.execute(construct, *multiparams, **params)</div><div> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute</div><div> params)</div><div> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl</div><div> compiled</div><div> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context</div><div> context)</div><div> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context</div><div> context)</div><div> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute</div><div> cursor.execute(statement, parameters)</div><div> File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute</div><div> self.errorhandler(self, exc, value)</div><div> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler</div><div> raise errorclass, errorvalue</div><div>sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, "Table 'neutron_ml2.agents' doesn't exist") 'ALTER TABLE agents ADD CONSTRAINT uniq_agents0agent_type0host UNIQUE (agent_type, host)' ()</div></div><div><br></div><div>Thanks</div><div>Gary</div></body></html>