tacker-db-manage purge_deleted command error

[Ukesh]

purge command fails for 'all' parameter

tacker-db-manage --config-file /etc/tacker/tacker.conf purge_deleted all

traceback:

Traceback (most recent call last):
  File "/usr/local/bin/tacker-db-manage", line 10, in <module>
    sys.exit(main())
  File "/opt/stack/tacker/tacker/db/migration/cli.py", line 179, in main
    CONF.command.func(config, CONF.command.name)
  File "/opt/stack/tacker/tacker/db/migration/cli.py", line 113, in purge_deleted
    CONF.command.granularity)
  File "/opt/stack/tacker/tacker/db/migration/purge_tables.py", line 116, in purge_deleted
    return _purge_resource_tables(t, meta, engine, time_line, assoc_map)
  File "/opt/stack/tacker/tacker/db/migration/purge_tables.py", line 53, in _purge_resource_tables
    table_load.c.deleted_at <= time_line)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/_collections.py", line 212, in __getattr__
    raise AttributeError(key)
AttributeError: deleted_at

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/408584

[Sridhar Ramaswamy (srics-r)]

Thanks for the reporting and fixing the problem, Ukesh !

[Sridhar Ramaswamy (srics-r)]

Traceback due to the issue:

$ tacker-db-manage --config-file /etc/tacker/tacker.conf purge_deleted all
Traceback (most recent call last):
  File "/usr/local/bin/tacker-db-manage", line 10, in <module>
    sys.exit(main())
  File "/opt/stack/tacker/tacker/db/migration/cli.py", line 179, in main
    CONF.command.func(config, CONF.command.name)
  File "/opt/stack/tacker/tacker/db/migration/cli.py", line 113, in purge_deleted
    CONF.command.granularity)
  File "/opt/stack/tacker/tacker/db/migration/purge_tables.py", line 113, in purge_deleted
    _purge_resource_tables(t, meta, engine, time_line, assoc_map)
  File "/opt/stack/tacker/tacker/db/migration/purge_tables.py", line 53, in _purge_resource_tables
    table_load.c.deleted_at <= time_line)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/_collections.py", line 212, in __getattr__
    raise AttributeError(key)
AttributeError: deleted_at

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/408584
Committed: https://git.openstack.org/cgit/openstack/tacker/commit/?id=dfcacd9ca5c76c90d441b746ca5e50cb8cf93af4
Submitter: Jenkins
Branch: master

commit dfcacd9ca5c76c90d441b746ca5e50cb8cf93af4
Author: Ukesh Kumar Vasudevan <email address hidden>
Date: Thu Dec 8 17:50:57 2016 +0530

    tacker-db-manage purge_deleted command error

    purge command fails for 'all' parameter
    tacker-db-manage --config-file /etc/tacker/tacker.conf purge_deleted all

    Why trace: current code tries to delete from many tables which are not expected
    Solution: only delete the expected tables(events, vnf, vnfd, vims)

    Change-Id: Ic86ab8ca1d2619d55b5244fec488060c87ede0c3
    closes-bug: #1647278

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tacker 0.6.0 release.