Actual result
=============
An error has occurred:
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 1644, in main
ret = fn(*fn_args, **fn_kwargs)
File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 532, in archive_deleted_rows
run, deleted_instance_uuids = db.archive_deleted_rows(max_rows)
File "/usr/lib/python2.7/site-packages/nova/db/api.py", line 2018, in archive_deleted_rows
return IMPL.archive_deleted_rows(max_rows=max_rows)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 6233, in archive_deleted_rows
tablename, max_rows=max_rows - total_rows_archived)
File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 6116, in _archive_deleted_rows_for_table
column = table.c.id
File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/_collections.py", line 212, in __getattr__
raise AttributeError(key)
AttributeError: id
Description deleted_ rows crash during processing of `nova.tags` table because table do not have `id` column.
===========
nova-manage db archive_
Steps to reproduce deleted_ rows
==================
Execute: nova-manage db archive_
Expected result
===============
Successful execution with summary:
+------ ------- ----+-- ------- ------- ------- --+ ------- ----+-- ------- ------- ------- --+ ------- ----+-- ------- ------- ------- --+
| Table | Number of Rows Archived |
+------
| agent_builds | 12 |
| floating_ips | 12 |
| instance_groups | 7 |
| instance_types | 6 |
| key_pairs | 44242 |
+------
Actual result python2. 7/site- packages/ nova/cmd/ manage. py", line 1644, in main python2. 7/site- packages/ nova/cmd/ manage. py", line 532, in archive_ deleted_ rows instance_ uuids = db.archive_ deleted_ rows(max_ rows) python2. 7/site- packages/ nova/db/ api.py" , line 2018, in archive_ deleted_ rows deleted_ rows(max_ rows=max_ rows) python2. 7/site- packages/ nova/db/ sqlalchemy/ api.py" , line 6233, in archive_ deleted_ rows archived) python2. 7/site- packages/ nova/db/ sqlalchemy/ api.py" , line 6116, in _archive_ deleted_ rows_for_ table python2. 7/site- packages/ sqlalchemy/ util/_collectio ns.py", line 212, in __getattr__
=============
An error has occurred:
Traceback (most recent call last):
File "/usr/lib/
ret = fn(*fn_args, **fn_kwargs)
File "/usr/lib/
run, deleted_
File "/usr/lib/
return IMPL.archive_
File "/usr/lib/
tablename, max_rows=max_rows - total_rows_
File "/usr/lib/
column = table.c.id
File "/usr/lib64/
raise AttributeError(key)
AttributeError: id
Environment nova-conductor- 17.0.5- 1.el7.noarch nova-scheduler- 17.0.5- 1.el7.noarch nova-api- 17.0.5- 1.el7.noarch nova-placement- api-17. 0.5-1.el7. noarch nova-novncproxy -17.0.5- 1.el7.noarch nova-console- 17.0.5- 1.el7.noarch nova-common- 17.0.5- 1.el7.noarch
===========
Openstack Queens release:
openstack-
openstack-
openstack-
openstack-
openstack-
openstack-
openstack-