Neutron database synchronization error Notimplementederror:no support for ALTER's constraints in SQLite dialect

Error message

[Email protected]:~# su-s/bin/sh-c "Neutron-db-manage--config-file/etc/neutron/neutron.conf \--config-file/etc/neutron/plugins/ml2/ml2_conf.ini upgrade Juno"Neutroninfo [alembic.migration] Context impl sqliteimpl.info [alembic.migration] would assume non-transactional DDL . INFO [alembic.migration] Running upgrade Havana, E197124D4B9, add unique constraint to Memberstraceback (most Recen T call last): File "/usr/bin/neutron-db-manage", line ten, in <module> Sys.exit (Main ()) File"/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 173, in main CONF.command.func (config, CONF.command.name) File"/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line, Do_upgrade_downgrade do_alembic_command (config, cmd, revision, sql=conf.command.sql) File"/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line, Do_alembic_command getattr (Alembic_command, cmd) (config, *args, **kwargs) File"/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 165, in Upgrade script.run_env () File"/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 390, in Run_env util.load_python_file (Self.dir, ' env.py ') file"/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 243, in load_python_file module = load_module_py (module_id, path) file"/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line +, in load_module_py mod = Imp.load_source (module_id, Path, FP) File"/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/env.py", line 108, in <module> run_migrations_online () File"/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/env.py", line +, in Run_migrations_online context.run_migrations () File"<string>", line 7, in Run_migrations File"/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line 738, in Run_migrations self.get_context (). Run_migrations (**kw) File"/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line 309, in Run_migrations step.migration_fn (**kw) File"/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/versions/e197124d4b9_add_unique_constrain.py", line A, in upgrade local_cols=[' pool_id ', ' address ', ' protocol_port '] File"<string>", line 7, in Create_unique_constraint File"/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line 805, in Create_unique_constraint Schema=schema, **kw) File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/sqlite.py", line, in Add_constraint"No Support forALTER of ConstraintsinchSQLite dialect") Notimplementederror:no support for ALTER's constraints in SQLite dialect

Cause of error

Today's database is MySQL, but when the software is installed, it will proactively generate a SQLite lightweight database. The reason for this error here is that SQLite is used here. and the above synchronization command does not conform to the syntax of SQLite, so error

Workaround

Disables SQLite. Stare at the SQLite connection in the [Database] section of the/etc/neutron/neutron.conf file, such as the following:

# vim /etc/neutron/neutron.conf[database]connection = mysql://neutron:[email protected]/neutron#connection = sqlite:////var/lib/neutron/neutron.sqlite

Run the synchronization statement again

[email protected]:~# su -s /bin/sh -c "neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade juno" neutronINFO  [alembic.migration] Context impl MySQLImpl.INFO  [alembic.migration] Will assume non-transactional DDL.

That's OK.

Neutron database synchronization error Notimplementederror:no support for ALTER's constraints in SQLite dialect