<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>Mark has a good point. That is, it break compatibility for 'trunk chasers'. Question is, is there anyway that we can get this resolved that addresses his concern.</div><div>Thanks</div><div>Gary</div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> Yongsheng Gong <<a href="mailto:gongysh@unitedstack.com">gongysh@unitedstack.com</a>><br><span style="font-weight:bold">Reply-To: </span> "OpenStack Development Mailing List (not for usage questions)" <<a href="mailto:openstack-dev@lists.openstack.org">openstack-dev@lists.openstack.org</a>><br><span style="font-weight:bold">Date: </span> Monday, December 23, 2013 5:43 AM<br><span style="font-weight:bold">To: </span> "OpenStack Development Mailing List (not for usage questions)" <<a href="mailto:openstack-dev@lists.openstack.org">openstack-dev@lists.openstack.org</a>><br><span style="font-weight:bold">Subject: </span> Re: [openstack-dev] [Neutron] Alembic migrations<br></div><div><br></div><div><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><div><div dir="ltr">but <a class="" href="https://urldefense.proofpoint.com/v1/url?u=https://review.openstack.org/%23/dashboard/2592&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=eH0pxTUZo8NPZyF6hgoMQu%2BfDtysg45MkPhCZFxPEq8%3D%0A&m=5K8MatoRoqaZFIRyem%2F4QffE%2FRuzaNXGWcSrXSTEWjg%3D%0A&s=f5e086c678211632a32ff58d9391e0cd06223bb496da8fb18f12879f451b4b06" title="mark mcclain &lt;mark.mcclain@dreamhost.com&gt;" style="text-decoration:none;color:rgb(0,0,170);white-space:nowrap;font-family:&#39;Arial Unicode MS&#39;,Arial,sans-serif;background-image:none!important">mark
 mcclain</a> seems not to agree it. so it is blocked for a long time.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Dec 22, 2013 at 10:38 PM, Roman Podoliaka <span dir="ltr">
<<a href="mailto:rpodolyaka@mirantis.com" target="_blank">rpodolyaka@mirantis.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Gary,<br><br>
It's a known bug (the migration script creating 'agents' table is<br>
mistakenly not applied when running schema migrations with ML2 core<br>
plugin selected). There is a patch on review<br><a href="https://urldefense.proofpoint.com/v1/url?u=https://review.openstack.org/%23/c/61677&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=eH0pxTUZo8NPZyF6hgoMQu%2BfDtysg45MkPhCZFxPEq8%3D%0A&m=5K8MatoRoqaZFIRyem%2F4QffE%2FRuzaNXGWcSrXSTEWjg%3D%0A&s=117edb0d7e6ff16ef0ecaf8e45c4072c59ea01323eeecf77c28db39be6cc7a49" target="_blank">https://review.openstack.org/#/c/61677</a>
 fixing this error.<br><br>
Thanks,<br>
Roman<br><div><div class="h5"><br>
On Sun, Dec 22, 2013 at 4:02 PM, Gary Kotton <<a href="mailto:gkotton@vmware.com">gkotton@vmware.com</a>> wrote:<br>
> Hi,<br>
> Anyone else encounter the following exception:<br>
><br>
> + /usr/local/bin/neutron-db-manage --config-file /etc/neutron/neutron.conf<br>
> --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head<br>
> No handlers could be found for logger "neutron.common.legacy"<br>
> INFO  [alembic.migration] Context impl MySQLImpl.<br>
> INFO  [alembic.migration] Will assume non-transactional DDL.<br>
> INFO  [alembic.migration] Running upgrade None -> folsom, folsom initial<br>
> database<br>
> INFO  [alembic.migration] Running upgrade folsom -> 2c4af419145b, l3_support<br>
> INFO  [alembic.migration] Running upgrade 2c4af419145b -> 5a875d0e5c, ryu<br>
> INFO  [alembic.migration] Running upgrade 5a875d0e5c -> 48b6f43f7471, DB<br>
> support for service types<br>
> INFO  [alembic.migration] Running upgrade 48b6f43f7471 -> 3cb5d900c5de,<br>
> security_groups<br>
> INFO  [alembic.migration] Running upgrade 3cb5d900c5de -> 1d76643bcec4,<br>
> nvp_netbinding<br>
> INFO  [alembic.migration] Running upgrade 1d76643bcec4 -> 2a6d0b51f4bb,<br>
> cisco plugin cleanup<br>
> INFO  [alembic.migration] Running upgrade 2a6d0b51f4bb -> 1b693c095aa3,<br>
> Quota ext support added in Grizzly<br>
> INFO  [alembic.migration] Running upgrade 1b693c095aa3 -> 1149d7de0cfa,<br>
> inital port security<br>
> INFO  [alembic.migration] Running upgrade 1149d7de0cfa -> 49332180ca96, ryu<br>
> plugin update<br>
> INFO  [alembic.migration] Running upgrade 49332180ca96 -> 38335592a0dc,<br>
> nvp_portmap<br>
> INFO  [alembic.migration] Running upgrade 38335592a0dc -> 54c2c487e913, 'DB<br>
> support for load balancing service<br>
> INFO  [alembic.migration] Running upgrade 54c2c487e913 -> 45680af419f9,<br>
> nvp_qos<br>
> INFO  [alembic.migration] Running upgrade 45680af419f9 -> 1c33fa3cd1a1,<br>
> Support routing table configuration on Router<br>
> INFO  [alembic.migration] Running upgrade 1c33fa3cd1a1 -> 363468ac592c,<br>
> nvp_network_gw<br>
> INFO  [alembic.migration] Running upgrade 363468ac592c -> 511471cc46b, Add<br>
> agent management extension model support<br>
> INFO  [alembic.migration] Running upgrade 511471cc46b -> 3b54bf9e29f7, NEC<br>
> plugin sharednet<br>
> INFO  [alembic.migration] Running upgrade 3b54bf9e29f7 -> 4692d074d587,<br>
> agent scheduler<br>
> INFO  [alembic.migration] Running upgrade 4692d074d587 -> 1341ed32cc1e,<br>
> nvp_net_binding<br>
> INFO  [alembic.migration] Running upgrade 1341ed32cc1e -> grizzly, grizzly<br>
> INFO  [alembic.migration] Running upgrade grizzly -> f489cf14a79c, DB<br>
> support for load balancing service (havana)<br>
> INFO  [alembic.migration] Running upgrade f489cf14a79c -> 176a85fc7d79, Add<br>
> portbindings db<br>
> INFO  [alembic.migration] Running upgrade 176a85fc7d79 -> 32b517556ec9,<br>
> remove TunnelIP model<br>
> INFO  [alembic.migration] Running upgrade 32b517556ec9 -> 128e042a2b68,<br>
> ext_gw_mode<br>
> INFO  [alembic.migration] Running upgrade 128e042a2b68 -> 5ac71e65402c,<br>
> ml2_initial<br>
> INFO  [alembic.migration] Running upgrade 5ac71e65402c -> 3cbf70257c28,<br>
> nvp_mac_learning<br>
> INFO  [alembic.migration] Running upgrade 3cbf70257c28 -> 5918cbddab04, add<br>
> tables for router rules support<br>
> INFO  [alembic.migration] Running upgrade 5918cbddab04 -> 3cabb850f4a5,<br>
> Table to track port to host associations<br>
> INFO  [alembic.migration] Running upgrade 3cabb850f4a5 -> b7a8863760e,<br>
> Remove cisco_vlan_bindings table<br>
> INFO  [alembic.migration] Running upgrade b7a8863760e -> 13de305df56e,<br>
> nec_add_pf_name<br>
> INFO  [alembic.migration] Running upgrade 13de305df56e -> 20ae61555e95, DB<br>
> Migration for ML2 GRE Type Driver<br>
> INFO  [alembic.migration] Running upgrade 20ae61555e95 -> 477a4488d3f4, DB<br>
> Migration for ML2 VXLAN Type Driver<br>
> INFO  [alembic.migration] Running upgrade 477a4488d3f4 -> 2032abe8edac,<br>
> LBaaS add status description<br>
> INFO  [alembic.migration] Running upgrade 2032abe8edac -> 52c5e4a18807,<br>
> LBaaS Pool scheduler<br>
> INFO  [alembic.migration] Running upgrade 52c5e4a18807 -> 557edfc53098, New<br>
> service types framework (service providers)<br>
> INFO  [alembic.migration] Running upgrade 557edfc53098 -> e6b16a30d97, Add<br>
> cisco_provider_networks table<br>
> INFO  [alembic.migration] Running upgrade e6b16a30d97 -> 39cf3f799352, FWaaS<br>
> Havana-2 model<br>
> INFO  [alembic.migration] Running upgrade 39cf3f799352 -> 52ff27f7567a,<br>
> Support for VPNaaS<br>
> INFO  [alembic.migration] Running upgrade 52ff27f7567a -> 11c6e18605c8, Pool<br>
> Monitor status field<br>
> INFO  [alembic.migration] Running upgrade 11c6e18605c8 -> 35c7c198ddea,<br>
> remove status from HealthMonitor<br>
> INFO  [alembic.migration] Running upgrade 35c7c198ddea -> 263772d65691,<br>
> Cisco plugin db cleanup part II<br>
> INFO  [alembic.migration] Running upgrade 263772d65691 -> c88b6b5fea3, Cisco<br>
> N1KV tables<br>
> INFO  [alembic.migration] Running upgrade c88b6b5fea3 -> f9263d6df56,<br>
> remove_dhcp_lease<br>
> INFO  [alembic.migration] Running upgrade f9263d6df56 -> 569e98a8132b,<br>
> metering<br>
> INFO  [alembic.migration] Running upgrade 569e98a8132b -> 86cf4d88bd3,<br>
> remove bigswitch port tracking table<br>
> INFO  [alembic.migration] Running upgrade 86cf4d88bd3 -> 3c6e57a23db4, add<br>
> multiprovider<br>
> INFO  [alembic.migration] Running upgrade 3c6e57a23db4 -> 63afba73813, Add<br>
> unique constraint for id column of TunnelEndpoint<br>
> INFO  [alembic.migration] Running upgrade 63afba73813 -> 40dffbf4b549,<br>
> nvp_dist_router<br>
> INFO  [alembic.migration] Running upgrade 40dffbf4b549 -> 53bbd27ec841,<br>
> Extra dhcp opts support<br>
> INFO  [alembic.migration] Running upgrade 53bbd27ec841 -> 46a0efbd8f0,<br>
> cisco_n1kv_multisegment_trunk<br>
> INFO  [alembic.migration] Running upgrade 46a0efbd8f0 -> 2a3bae1ceb8, NEC<br>
> Port Binding<br>
> INFO  [alembic.migration] Running upgrade 2a3bae1ceb8 -> 14f24494ca31, DB<br>
> Migration for Arista ml2 mechanism driver<br>
> INFO  [alembic.migration] Running upgrade 14f24494ca31 -> 32a65f71af51, ml2<br>
> portbinding<br>
> INFO  [alembic.migration] Running upgrade 32a65f71af51 -> 66a59a7f516, NEC<br>
> OpenFlow Router<br>
> INFO  [alembic.migration] Running upgrade 66a59a7f516 -> 51b4de912379, Cisco<br>
> Nexus ML2 mechanism driver<br>
> INFO  [alembic.migration] Running upgrade 51b4de912379 -> 1efb85914233,<br>
> allowedaddresspairs<br>
> INFO  [alembic.migration] Running upgrade 1efb85914233 -> 38fc1f6789f8,<br>
> Cisco N1KV overlay support<br>
> INFO  [alembic.migration] Running upgrade 38fc1f6789f8 -> 4a666eb208c2,<br>
> service router<br>
> INFO  [alembic.migration] Running upgrade 4a666eb208c2 -> 338d7508968c,<br>
> vpnaas peer_address size increase<br>
> INFO  [alembic.migration] Running upgrade 338d7508968c -> 3ed8f075e38a, nvp<br>
> fwaas plugin<br>
> INFO  [alembic.migration] Running upgrade 3ed8f075e38a -> 3d6fae8b70b0, nvp<br>
> lbaas plugin<br>
> INFO  [alembic.migration] Running upgrade 3d6fae8b70b0 -> 1064e98b7917,<br>
> nec-pf-port-del<br>
> INFO  [alembic.migration] Running upgrade 1064e98b7917 -> 2528ceb28230, NEC<br>
> PacketFilter network_id nullable fix<br>
> INFO  [alembic.migration] Running upgrade 2528ceb28230 -> 3a520dd165d0,<br>
> Cisco Nexus multi-switch<br>
> INFO  [alembic.migration] Running upgrade 3a520dd165d0 -> 27ef74513d33,<br>
> quota_in_plumgrid_plugin<br>
> INFO  [alembic.migration] Running upgrade 27ef74513d33 -> havana, havana<br>
> INFO  [alembic.migration] Running upgrade havana -> e197124d4b9, add unique<br>
> constraint to members<br>
> INFO  [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a<br>
> unique constraint on (agent_type, host) columns to prevent a race<br>
> condition when an agent entry is 'upserted'.<br>
> Traceback (most recent call last):<br>
>   File "/usr/local/bin/neutron-db-manage", line 10, in <module><br>
>     sys.exit(main())<br>
>   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 143, in main<br>
>     CONF.command.func(config, <a href="https://urldefense.proofpoint.com/v1/url?u=http://CONF.command.name&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=eH0pxTUZo8NPZyF6hgoMQu%2BfDtysg45MkPhCZFxPEq8%3D%0A&m=5K8MatoRoqaZFIRyem%2F4QffE%2FRuzaNXGWcSrXSTEWjg%3D%0A&s=0d5f2c9e76dfa707e8c0ab10bc614197dbf34ea2021ff6a7a7b0fc5928c77c84" target="_blank">
CONF.command.name</a>)<br>
>   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 80, in<br>
> do_upgrade_downgrade<br>
>     do_alembic_command(config, cmd, revision, sql=CONF.command.sql)<br>
>   File "/opt/stack/neutron/neutron/db/migration/cli.py", line 59, in<br>
> do_alembic_command<br>
>     getattr(alembic_command, cmd)(config, *args, **kwargs)<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line<br>
> 124, in upgrade<br>
>     script.run_env()<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 199,<br>
> in run_env<br>
>     util.load_python_file(self.dir, 'env.py')<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 198,<br>
> in load_python_file<br>
>     module = load_module(module_id, path)<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 55,<br>
> in load_module<br>
>     mod = imp.load_source(module_id, path, fp)<br>
>   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",<br>
> line 105, in <module><br>
>     run_migrations_online()<br>
>   File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",<br>
> line 89, in run_migrations_online<br>
>     options=build_options())<br>
>   File "<string>", line 7, in run_migrations<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line<br>
> 652, in run_migrations<br>
>     self.get_context().run_migrations(**kw)<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line<br>
> 225, in run_migrations<br>
>     change(**kw)<br>
>   File<br>
> "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/1fcfc149aca4_agents_unique_by_type_and_host.py",<br>
> line 50, in upgrade<br>
>     local_cols=['agent_type', 'host']<br>
>   File "<string>", line 7, in create_unique_constraint<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line<br>
> 544, in create_unique_constraint<br>
>     schema=schema, **kw)<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line<br>
> 135, in add_constraint<br>
>     self._exec(schema.AddConstraint(const))<br>
>   File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line<br>
> 76, in _exec<br>
>     conn.execute(construct, *multiparams, **params)<br>
>   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
> line 1449, in execute<br>
>     params)<br>
>   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
> line 1542, in _execute_ddl<br>
>     compiled<br>
>   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
> line 1698, in _execute_context<br>
>     context)<br>
>   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
> line 1691, in _execute_context<br>
>     context)<br>
>   File<br>
> "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line<br>
> 331, in do_execute<br>
>     cursor.execute(statement, parameters)<br>
>   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in<br>
> execute<br>
>     self.errorhandler(self, exc, value)<br>
>   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36,<br>
> in defaulterrorhandler<br>
>     raise errorclass, errorvalue<br>
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, "Table<br>
> 'neutron_ml2.agents' doesn't exist") 'ALTER TABLE agents ADD CONSTRAINT<br>
> uniq_agents0agent_type0host UNIQUE (agent_type, host)' ()<br>
><br>
> Thanks<br>
> Gary<br>
><br></div></div>
> _______________________________________________<br>
> OpenStack-dev mailing list<br>
> <a href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a><br>
> <a href="https://urldefense.proofpoint.com/v1/url?u=http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=eH0pxTUZo8NPZyF6hgoMQu%2BfDtysg45MkPhCZFxPEq8%3D%0A&m=5K8MatoRoqaZFIRyem%2F4QffE%2FRuzaNXGWcSrXSTEWjg%3D%0A&s=c5e3d3667e4267b2a251183ecc5ad2f4f0ff18afc4e991666c0c90bf84de8c6d" target="_blank">
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
><br><br>
_______________________________________________<br>
OpenStack-dev mailing list<br><a href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a><br><a href="https://urldefense.proofpoint.com/v1/url?u=http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=eH0pxTUZo8NPZyF6hgoMQu%2BfDtysg45MkPhCZFxPEq8%3D%0A&m=5K8MatoRoqaZFIRyem%2F4QffE%2FRuzaNXGWcSrXSTEWjg%3D%0A&s=c5e3d3667e4267b2a251183ecc5ad2f4f0ff18afc4e991666c0c90bf84de8c6d" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br></blockquote></div><br></div></div></div></span></body></html>