There is also another failure:
No handlers could be found for logger "neutron.common.legacy"
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
No handlers could be found for logger "neutron.common.legacy"
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade grizzly -> f489cf14a79c
Traceback (most recent call last):
File "/usr/bin/neutron-db-manage", line 10, in <module>
sys.exit(main())
File "/usr/lib/python2.6/site-packages/neutron/db/migration/cli.py", line 143, in main
CONF.command.func(config, CONF.command.name)
File "/usr/lib/python2.6/site-packages/neutron/db/migration/cli.py", line 80, in do_upgrade_downgrade
do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
File "/usr/lib/python2.6/site-packages/neutron/db/migration/cli.py", line 59, in do_alembic_command
getattr(alembic_command, cmd)(config, *args, **kwargs)
File "/usr/lib/python2.6/site-packages/alembic/command.py", line 124, in upgrade
script.run_env()
File "/usr/lib/python2.6/site-packages/alembic/script.py", line 191, in run_env
util.load_python_file(self.dir, 'env.py')
File "/usr/lib/python2.6/site-packages/alembic/util.py", line 186, in load_python_file
module = imp.load_source(module_id, path, open(path, 'rb'))
File "/usr/lib/python2.6/site-packages/neutron/db/migration/alembic_migrations/env.py", line 105, in <module>
run_migrations_online()
File "/usr/lib/python2.6/site-packages/neutron/db/migration/alembic_migrations/env.py", line 89, in run_migrations_online
options=build_options())
File "<string>", line 7, in run_migrations
File "/usr/lib/python2.6/site-packages/alembic/environment.py", line 494, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/lib/python2.6/site-packages/alembic/migration.py", line 211, in run_migrations
change(**kw)
File "/usr/lib/python2.6/site-packages/neutron/db/migration/alembic_migrations/versions/f489cf14a79c_lbaas_havana.py", line 61, in upgrade
sa.PrimaryKeyConstraint(u'id')
File "<string>", line 7, in create_table
File "/usr/lib/python2.6/site-packages/alembic/operations.py", line 570, in create_table
self._table(name, *columns, **kw)
File "/usr/lib/python2.6/site-packages/alembic/ddl/impl.py", line 148, in create_table
self._exec(schema.CreateTable(table))
File "/usr/lib/python2.6/site-packages/alembic/ddl/impl.py", line 75, in _exec
conn.execute(construct, *multiparams, **params)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1449, in execute
params)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1542, in _execute_ddl
compiled
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1698, in _execute_context
context)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
context)
File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table 'vips' already exists") "\nCREATE TABLE vips (\n\ttenant_id VARCHAR(255), \n\tid VARCHAR(36) NOT NULL, \n\tname VARCHAR(255), \n\tdescription VARCHAR(255), \n\tport_id VARCHAR(36), \n\tprotocol_port INTEGER NOT NULL, \n\tprotocol ENUM('HTTP','HTTPS','TCP') NOT NULL, \n\tpool_id VARCHAR(36) NOT NULL, \n\tstatus VARCHAR(16) NOT NULL, \n\tadmin_state_up BOOL NOT NULL, \n\tconnection_limit INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(port_id) REFERENCES ports (id), \n\tUNIQUE (pool_id), \n\tCHECK (admin_state_up IN (0, 1))\n)\n\n" ()
Happens when grizzly is running with LoadBalancer. vips table already exists but creating of this table is in migration chain grizzly->havana (specifically grizzly->f489cf14a79c).
There is also another failure: common. legacy" common. legacy" neutron- db-manage" , line 10, in <module> exit(main( )) python2. 6/site- packages/ neutron/ db/migration/ cli.py" , line 143, in main command. func(config, CONF.command.name) python2. 6/site- packages/ neutron/ db/migration/ cli.py" , line 80, in do_upgrade_ downgrade alembic_ command( config, cmd, revision, sql=CONF. command. sql) python2. 6/site- packages/ neutron/ db/migration/ cli.py" , line 59, in do_alembic_command alembic_ command, cmd)(config, *args, **kwargs) python2. 6/site- packages/ alembic/ command. py", line 124, in upgrade run_env( ) python2. 6/site- packages/ alembic/ script. py", line 191, in run_env load_python_ file(self. dir, 'env.py') python2. 6/site- packages/ alembic/ util.py" , line 186, in load_python_file source( module_ id, path, open(path, 'rb')) python2. 6/site- packages/ neutron/ db/migration/ alembic_ migrations/ env.py" , line 105, in <module> migrations_ online( ) python2. 6/site- packages/ neutron/ db/migration/ alembic_ migrations/ env.py" , line 89, in run_migrations_ online build_options( )) python2. 6/site- packages/ alembic/ environment. py", line 494, in run_migrations get_context( ).run_migration s(**kw) python2. 6/site- packages/ alembic/ migration. py", line 211, in run_migrations python2. 6/site- packages/ neutron/ db/migration/ alembic_ migrations/ versions/ f489cf14a79c_ lbaas_havana. py", line 61, in upgrade PrimaryKeyConst raint(u' id') python2. 6/site- packages/ alembic/ operations. py", line 570, in create_table _table( name, *columns, **kw) python2. 6/site- packages/ alembic/ ddl/impl. py", line 148, in create_table _exec(schema. CreateTable( table)) python2. 6/site- packages/ alembic/ ddl/impl. py", line 75, in _exec execute( construct, *multiparams, **params) python2. 6/site- packages/ SQLAlchemy- 0.7.8-py2. 6-linux- x86_64. egg/sqlalchemy/ engine/ base.py" , line 1449, in execute python2. 6/site- packages/ SQLAlchemy- 0.7.8-py2. 6-linux- x86_64. egg/sqlalchemy/ engine/ base.py" , line 1542, in _execute_ddl python2. 6/site- packages/ SQLAlchemy- 0.7.8-py2. 6-linux- x86_64. egg/sqlalchemy/ engine/ base.py" , line 1698, in _execute_context python2. 6/site- packages/ SQLAlchemy- 0.7.8-py2. 6-linux- x86_64. egg/sqlalchemy/ engine/ base.py" , line 1691, in _execute_context python2. 6/site- packages/ SQLAlchemy- 0.7.8-py2. 6-linux- x86_64. egg/sqlalchemy/ engine/ default. py", line 331, in do_execute execute( statement, parameters) python2. 6/site- packages/ MySQLdb/ cursors. py", line 173, in execute errorhandler( self, exc, value) python2. 6/site- packages/ MySQLdb/ connections. py", line 36, in defaulterrorhandler exc.Operational Error: (OperationalError) (1050, "Table 'vips' already exists") "\nCREATE TABLE vips (\n\ttenant_id VARCHAR(255), \n\tid VARCHAR(36) NOT NULL, \n\tname VARCHAR(255), \n\tdescription VARCHAR(255), \n\tport_id VARCHAR(36), \n\tprotocol_port INTEGER NOT NULL, \n\tprotocol ENUM('HTTP' ,'HTTPS' ,'TCP') NOT NULL, \n\tpool_id VARCHAR(36) NOT NULL, \n\tstatus VARCHAR(16) NOT NULL, \n\tadmin_state_up BOOL NOT NULL, \n\tconnection_ limit INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(port_id) REFERENCES ports (id), \n\tUNIQUE (pool_id), \n\tCHECK (admin_state_up IN (0, 1))\n)\n\n" ()
No handlers could be found for logger "neutron.
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
No handlers could be found for logger "neutron.
INFO [alembic.migration] Context impl MySQLImpl.
INFO [alembic.migration] Will assume non-transactional DDL.
INFO [alembic.migration] Running upgrade grizzly -> f489cf14a79c
Traceback (most recent call last):
File "/usr/bin/
sys.
File "/usr/lib/
CONF.
File "/usr/lib/
do_
File "/usr/lib/
getattr(
File "/usr/lib/
script.
File "/usr/lib/
util.
File "/usr/lib/
module = imp.load_
File "/usr/lib/
run_
File "/usr/lib/
options=
File "<string>", line 7, in run_migrations
File "/usr/lib/
self.
File "/usr/lib/
change(**kw)
File "/usr/lib/
sa.
File "<string>", line 7, in create_table
File "/usr/lib/
self.
File "/usr/lib/
self.
File "/usr/lib/
conn.
File "/usr/lib64/
params)
File "/usr/lib64/
compiled
File "/usr/lib64/
context)
File "/usr/lib64/
context)
File "/usr/lib64/
cursor.
File "/usr/lib64/
self.
File "/usr/lib64/
raise errorclass, errorvalue
sqlalchemy.
Happens when grizzly is running with LoadBalancer. vips table already exists but creating of this table is in migration chain grizzly->havana (specifically grizzly- >f489cf14a79c) .