Version of Tacker DB is not matching with the head "329cd1619d41". I run the upgrade command, but getting some errors, and in the end DB is not updated. 


[root@localhost orion-vnfd(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/tacker.conf current
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
8a7ca803e0d0
[root@localhost orion-vnfd(keystone_admin)]# cd
[root@localhost ~(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/tacker.conf current
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
8a7ca803e0d0
[root@localhost ~(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/tacker.conf upgrade head
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 8a7ca803e0d0 -> c47a733f425a, add_vnflcm_subscription
Traceback (most recent call last):
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 732, in _read_query_result
    result.read()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1077, in read
    first_packet = self.connection._read_packet()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/usr/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.InternalError: (1050, "Table 'vnf_lcm_subscriptions' already exists")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/bin/tacker-db-manage", line 10, in <module>
    sys.exit(main())
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 178, in main
    CONF.command.func(config, CONF.command.name)
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 68, in do_upgrade
    do_alembic_command(config, cmd, revision, sql=CONF.command.sql)
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/cli.py", line 47, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  File "/usr/lib/python3.6/site-packages/alembic/command.py", line 298, in upgrade
    script.run_env()
  File "/usr/lib/python3.6/site-packages/alembic/script/base.py", line 489, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/usr/lib/python3.6/site-packages/alembic/util/pyfiles.py", line 98, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python3.6/site-packages/alembic/util/compat.py", line 173, in load_module_py
    spec.loader.exec_module(module)
  File "<frozen importlib._bootstrap_external>", line 678, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/env.py", line 84, in <module>
    run_migrations_online()
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/env.py", line 76, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/usr/lib/python3.6/site-packages/alembic/runtime/environment.py", line 846, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/lib/python3.6/site-packages/alembic/runtime/migration.py", line 518, in run_migrations
    step.migration_fn(**kw)
  File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/versions/c47a733f425a_add_vnflcm_subscription.py", line 48, in upgrade
    mysql_engine='InnoDB'
  File "<string>", line 8, in create_table
  File "<string>", line 3, in create_table
  File "/usr/lib/python3.6/site-packages/alembic/operations/ops.py", line 1250, in create_table
    return operations.invoke(op)
  File "/usr/lib/python3.6/site-packages/alembic/operations/base.py", line 345, in invoke
    return fn(self, operation)
  File "/usr/lib/python3.6/site-packages/alembic/operations/toimpl.py", line 101, in create_table
    operations.impl.create_table(table)
  File "/usr/lib/python3.6/site-packages/alembic/ddl/impl.py", line 252, in create_table
    self._exec(schema.CreateTable(table))
  File "/usr/lib/python3.6/site-packages/alembic/ddl/impl.py", line 134, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1050, in _execute_ddl
    compiled,
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 128, in reraise
    raise value.with_traceback(tb)
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
    cursor, statement, parameters, context
  File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
    result = self._query(query)
  File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
    conn.query(q)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 517, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 732, in _read_query_result
    result.read()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1077, in read
    first_packet = self.connection._read_packet()
  File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 684, in _read_packet
    packet.check_error()
  File "/usr/lib/python3.6/site-packages/pymysql/protocol.py", line 220, in check_error
    err.raise_mysql_exception(self._data)
  File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
    raise errorclass(errno, errval)
sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1050, "Table 'vnf_lcm_subscriptions' already exists")
[SQL: 
CREATE TABLE vnf_lcm_subscriptions (
	id VARCHAR(36) NOT NULL, 
	callback_uri VARCHAR(255) NOT NULL, 
	subscription_authentication JSON, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME, 
	deleted_at DATETIME, 
	deleted BOOL, 
	PRIMARY KEY (id), 
	CHECK (deleted IN (0, 1))
)ENGINE=InnoDB

]
(Background on this error at: http://sqlalche.me/e/2j85)
[root@localhost ~(keystone_admin)]# tacker-db-manage --config-file /etc/tacker/tacker.conf current
INFO  [alembic.runtime.migration] Context impl MySQLImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
8a7ca803e0d0
[root@localhost ~(keystone_admin)]#


Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 9436989
Server version: 10.3.17-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use tacker
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [tacker]> show tables
    -> ;
+-----------------------------+
| Tables_in_tacker            |
+-----------------------------+
| aclmatchcriterias           |
| alembic_version             |
| events                      |
| ns                          |
| nsd                         |
| nsd_attribute               |
| servicetypes                |
| vimauths                    |
| vims                        |
| vnf                         |
| vnf_artifacts               |
| vnf_attribute               |
| vnf_deployment_flavours     |
| vnf_instances               |
| vnf_instantiated_info       |
| vnf_lcm_subscriptions       |
| vnf_package_vnfd            |
| vnf_packages                |
| vnf_packages_user_data      |
| vnf_resources               |
| vnf_software_image_metadata |
| vnf_software_images         |
| vnfd                        |
| vnfd_attribute              |
| vnffgchains                 |
| vnffgclassifiers            |
| vnffgnfps                   |
| vnffgs                      |
| vnffgtemplates              |
+-----------------------------+
29 rows in set (0.001 sec)

MariaDB [tacker]> desc vnf_instantiated_info;
+--------------------------------+--------------+------+-----+---------+----------------+
| Field                          | Type         | Null | Key | Default | Extra          |
+--------------------------------+--------------+------+-----+---------+----------------+
| id                             | int(11)      | NO   | PRI | NULL    | auto_increment |
| vnf_instance_id                | varchar(36)  | NO   | MUL | NULL    |                |
| flavour_id                     | varchar(255) | NO   |     | NULL    |                |
| ext_cp_info                    | longtext     | YES  |     | NULL    |                |
| ext_virtual_link_info          | longtext     | YES  |     | NULL    |                |
| ext_managed_virtual_link_info  | longtext     | YES  |     | NULL    |                |
| vnfc_resource_info             | longtext     | YES  |     | NULL    |                |
| vnf_virtual_link_resource_info | longtext     | YES  |     | NULL    |                |
| virtual_storage_resource_info  | longtext     | YES  |     | NULL    |                |
| vnf_state                      | varchar(255) | NO   |     | NULL    |                |
| instance_id                    | text         | YES  |     | NULL    |                |
| instantiation_level_id         | varchar(255) | YES  |     | NULL    |                |
| additional_params              | longtext     | YES  |     | NULL    |                |
| created_at                     | datetime     | NO   |     | NULL    |                |
| updated_at                     | datetime     | YES  |     | NULL    |                |
| deleted_at                     | datetime     | YES  |     | NULL    |                |
| deleted                        | tinyint(1)   | YES  |     | NULL    |                |
| vnfc_info                      | longtext     | YES  |     | NULL    |                |
+--------------------------------+--------------+------+-----+---------+----------------+
18 rows in set (0.001 sec)

MariaDB [tacker]>