Public bug reported:
Description
===========
nova-manage db archive_deleted_rows crash during processing of nova.tags table
because table do not have `id` column.
Steps to reproduce
==================
Execute: nova-manage db archive_deleted_rows
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
=============
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
Environment
===========
Openstack Queens release:
openstack-nova-conductor-17.0.5-1.el7.noarch
openstack-nova-scheduler-17.0.5-1.el7.noarch
openstack-nova-api-17.0.5-1.el7.noarch
openstack-nova-placement-api-17.0.5-1.el7.noarch
openstack-nova-novncproxy-17.0.5-1.el7.noarch
openstack-nova-console-17.0.5-1.el7.noarch
openstack-nova-common-17.0.5-1.el7.noarch
** Affects: nova
Importance: Undecided
Status: New
** Description changed:
Description
===========
- nova-manage db archive_deleted_rows crash during processing of `nova.tags`
table because table do not have `id` column.
+ nova-manage db archive_deleted_rows crash during processing of nova.tags
table because table do not have `id` column.
Steps to reproduce
==================
Execute: nova-manage db archive_deleted_rows
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
=============
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)
+ 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
Environment
===========
Openstack Queens release:
openstack-nova-conductor-17.0.5-1.el7.noarch
openstack-nova-scheduler-17.0.5-1.el7.noarch
openstack-nova-api-17.0.5-1.el7.noarch
openstack-nova-placement-api-17.0.5-1.el7.noarch
openstack-nova-novncproxy-17.0.5-1.el7.noarch
openstack-nova-console-17.0.5-1.el7.noarch
openstack-nova-common-17.0.5-1.el7.noarch
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1782328
Title:
nova-manage db archive_deleted_rows crash on tags table
Status in OpenStack Compute (nova):
New
Bug description:
Description
===========
nova-manage db archive_deleted_rows crash during processing of nova.tags
table because table do not have `id` column.
Steps to reproduce
==================
Execute: nova-manage db archive_deleted_rows
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
=============
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
Environment
===========
Openstack Queens release:
openstack-nova-conductor-17.0.5-1.el7.noarch
openstack-nova-scheduler-17.0.5-1.el7.noarch
openstack-nova-api-17.0.5-1.el7.noarch
openstack-nova-placement-api-17.0.5-1.el7.noarch
openstack-nova-novncproxy-17.0.5-1.el7.noarch
openstack-nova-console-17.0.5-1.el7.noarch
openstack-nova-common-17.0.5-1.el7.noarch
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1782328/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
