Comment 12 for bug 1907525

I have deleted all tables of the tacker database and run the command for created schema. It's updating till "8a7ca803e0d0 -> c47a733f425a" and after that giving following error :

 File "/usr/local/lib/python3.6/site-packages/tacker/db/migration/alembic_migrations/versions/c47a733f425a_add_vnflcm_subscription.py", line 60, in upgrade
    sa.Computed(noti_str)),
AttributeError: module 'sqlalchemy' has no attribute 'Computed'

== Complete output ==

[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 -> 1c6b0d82afcd, add tables for tacker framework
INFO [alembic.runtime.migration] Running upgrade 1c6b0d82afcd -> 81ffa86020d, rpc_proxy
INFO [alembic.runtime.migration] Running upgrade 81ffa86020d -> 4c31092895b8, empty message
INFO [alembic.runtime.migration] Running upgrade 4c31092895b8 -> 13c0e0661015, add description to vnf
INFO [alembic.runtime.migration] Running upgrade 13c0e0661015 -> 5958429bcb3c, modify datatype of value
INFO [alembic.runtime.migration] Running upgrade 5958429bcb3c -> 12a57080b277, Add Service related dbs
INFO [alembic.runtime.migration] Running upgrade 12a57080b277 -> 12a57080b278, Alter devices
INFO [alembic.runtime.migration] Running upgrade 12a57080b278 -> 2774a42c7163, remove service related
INFO [alembic.runtime.migration] Running upgrade 2774a42c7163 -> 24bec5f211c7, Alter value in deviceattributes
INFO [alembic.runtime.migration] Running upgrade 24bec5f211c7 -> 5246a6bd410f, multisite_vim
INFO [alembic.runtime.migration] Running upgrade 5246a6bd410f -> acf941e54075, Add error_reason to device
INFO [alembic.runtime.migration] Running upgrade acf941e54075 -> f958f58e5daa, uuid consistency
INFO [alembic.runtime.migration] Running upgrade f958f58e5daa -> 6e56d4474b2a, blob-to-json-text
INFO [alembic.runtime.migration] Running upgrade 6e56d4474b2a -> c7cde2f45f82, set-description-to-text
INFO [alembic.runtime.migration] Running upgrade c7cde2f45f82 -> b07673bb8654, set-status-type-tenant-id-length
INFO [alembic.runtime.migration] Running upgrade b07673bb8654 -> 354de64ba129, set-mandatory-columns-not-null
INFO [alembic.runtime.migration] Running upgrade 354de64ba129 -> 5f88e86b35c7, make VNFD/VNF/VIM name mandatory
INFO [alembic.runtime.migration] Running upgrade 5f88e86b35c7 -> 22f5385a3d3f, Add status to vims
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d3f -> d4f265e8eb9d, add default to vim
INFO [alembic.runtime.migration] Running upgrade d4f265e8eb9d -> 22f5385a3d4f, remove proxydb related
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d4f -> 22f5385a3d50, rename device db tables
INFO [alembic.runtime.migration] Running upgrade 22f5385a3d50 -> 2ff0a0e360f1, audit support
INFO [alembic.runtime.migration] Running upgrade 2ff0a0e360f1 -> 941b5a6fff9e, enable soft delete
INFO [alembic.runtime.migration] Running upgrade 941b5a6fff9e -> 4ee19c8a6d0a, audit_support_events
INFO [alembic.runtime.migration] Running upgrade 4ee19c8a6d0a -> 507122918800, adds_VNFFG
INFO [alembic.runtime.migration] Running upgrade 507122918800 -> 0ae5b1ce3024, unique_constraint_name
INFO [alembic.runtime.migration] Running upgrade 0ae5b1ce3024 -> 8f7145914cb0, remove infra_driver column
INFO [alembic.runtime.migration] Running upgrade 8f7145914cb0 -> 0ad3bbce1c18, create of Network service tables
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c18 -> 0ad3bbce1c19, increase_vim_password_size
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c19 -> 000632983ada, add template_source column
INFO [alembic.runtime.migration] Running upgrade 000632983ada -> e8918cda6433, add_attributes_to_vnffg
INFO [alembic.runtime.migration] Running upgrade e8918cda6433 -> ef14f8026327, add default onboarded template source
INFO [alembic.runtime.migration] Running upgrade ef14f8026327 -> c256228ed37c, unique constraint on name and id
INFO [alembic.runtime.migration] Running upgrade c256228ed37c -> e7993093baf1, add unique constraint on deleted_at
INFO [alembic.runtime.migration] Running upgrade e7993093baf1 -> 31acbaeb8299, change_vim_shared_property_to_false
INFO [alembic.runtime.migration] Running upgrade 31acbaeb8299 -> f5c1c3b0f6b4, set default value for deleted_at
INFO [alembic.runtime.migration] Running upgrade f5c1c3b0f6b4 -> e9a1e47fb0b5, add onboarded status for vnffgd and nsd
INFO [alembic.runtime.migration] Running upgrade e9a1e47fb0b5 -> 5d490546290c, add_name_to_classifiers
INFO [alembic.runtime.migration] Running upgrade 5d490546290c -> 4747cc26b9c6, add support vnffg to ns database
INFO [alembic.runtime.migration] Running upgrade 4747cc26b9c6 -> 13ecc2dd6f7f, Change nullable value of path_id
INFO [alembic.runtime.migration] Running upgrade 13ecc2dd6f7f -> cd04a8335c18, mgmt_url to mgmt_ip_address
INFO [alembic.runtime.migration] Running upgrade cd04a8335c18 -> 9d425296f2c3, add db tables for vnf packages
INFO [alembic.runtime.migration] Running upgrade 9d425296f2c3 -> abbef484b34c, modify_unique_constraint_on_vnf_packages_user_data
INFO [alembic.runtime.migration] Running upgrade abbef484b34c -> 975e28392888, Add unique constraints on vnfd_id,deleted in vnf_package_vnfd
INFO [alembic.runtime.migration] Running upgrade 975e28392888 -> 985e28392890, VNF instance management changes
INFO [alembic.runtime.migration] Running upgrade 985e28392890 -> d2e39e01d540, add size column to vnf_packages table
INFO [alembic.runtime.migration] Running upgrade d2e39e01d540 -> e06fbdc90a32, add db tables for add artifacts
INFO [alembic.runtime.migration] Running upgrade e06fbdc90a32 -> f9bc96967462, add_vnf_pkg_id_to_vnf_instances
INFO [alembic.runtime.migration] Running upgrade f9bc96967462 -> 745e3e9fe5e2, add_vnf_metadata_to_vnflcm_db
INFO [alembic.runtime.migration] Running upgrade 745e3e9fe5e2 -> aaf461c8844c, change type for vnf_resources and vnf_instantiated_info table
INFO [alembic.runtime.migration] Running upgrade aaf461c8844c -> 8a7ca803e0d0, add_vnfc_info_to_instantiated_vnf_info
INFO [alembic.runtime.migration] Running upgrade 8a7ca803e0d0 -> c47a733f425a, add_vnflcm_subscription
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 60, in upgrade
    sa.Computed(noti_str)),
AttributeError: module 'sqlalchemy' has no attribute 'Computed'