yahoo-eng-team team mailing list archive

[Ashish <ashish.jain14@xxxxxxxxx>]

Public bug reported:

Running the command glance-manage db_export_metadefs fails with
following error trace:


015-03-19 18:39:17.059 INFO glance.db.sqlalchemy.metadata [-] Namespace IOOpsperHost saved in /etc/glance/metadefs/IOOpsperHost.json
> /opt/stack/glance/glance/db/sqlalchemy/metadata.py(103)_get_namespace_resource_types()
-> get_metadef_namespace_resource_types_table(meta)
(Pdb) c
[(6L, 13L, None, None, datetime.datetime(2015, 3, 18, 2, 59, 30), None)]
2015-03-19 18:39:17.230 CRITICAL glance [-] NoSuchColumnError: "Could not locate column in row for column 'name'"

2015-03-19 18:39:17.230 TRACE glance Traceback (most recent call last):
2015-03-19 18:39:17.230 TRACE glance   File "/usr/local/bin/glance-manage", line 10, in <module>
2015-03-19 18:39:17.230 TRACE glance     sys.exit(main())
2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 303, in main
2015-03-19 18:39:17.230 TRACE glance     return CONF.command.action_fn()
2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 184, in export_metadefs
2015-03-19 18:39:17.230 TRACE glance     self.command_object.export_metadefs(CONF.command.path)
2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 148, in export_metadefs
2015-03-19 18:39:17.230 TRACE glance     path)
2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/db/sqlalchemy/metadata.py", line 481, in db_export_metadefs
2015-03-19 18:39:17.230 TRACE glance     _export_data_to_file(meta, metadata_path)
2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/db/sqlalchemy/metadata.py", line 404, in _export_data_to_file
2015-03-19 18:39:17.230 TRACE glance     'name': resource_type['name'],
2015-03-19 18:39:17.230 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 331, in _key_fallback
2015-03-19 18:39:17.230 TRACE glance     expression._string_or_unprintable(key))
2015-03-19 18:39:17.230 TRACE glance NoSuchColumnError: "Could not locate column in row for column 'name'"

** Affects: glance
     Importance: High
     Assignee: Ashish (ashish-jain14)
         Status: Triaged

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1434237

Title:
  glance-manage db_export_metadefs fails with NoSuchColumnError

Status in OpenStack Image Registry and Delivery Service (Glance):
  Triaged

Bug description:
  Running the command glance-manage db_export_metadefs fails with
  following error trace:

  
  015-03-19 18:39:17.059 INFO glance.db.sqlalchemy.metadata [-] Namespace IOOpsperHost saved in /etc/glance/metadefs/IOOpsperHost.json
  > /opt/stack/glance/glance/db/sqlalchemy/metadata.py(103)_get_namespace_resource_types()
  -> get_metadef_namespace_resource_types_table(meta)
  (Pdb) c
  [(6L, 13L, None, None, datetime.datetime(2015, 3, 18, 2, 59, 30), None)]
  2015-03-19 18:39:17.230 CRITICAL glance [-] NoSuchColumnError: "Could not locate column in row for column 'name'"

  2015-03-19 18:39:17.230 TRACE glance Traceback (most recent call last):
  2015-03-19 18:39:17.230 TRACE glance   File "/usr/local/bin/glance-manage", line 10, in <module>
  2015-03-19 18:39:17.230 TRACE glance     sys.exit(main())
  2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 303, in main
  2015-03-19 18:39:17.230 TRACE glance     return CONF.command.action_fn()
  2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 184, in export_metadefs
  2015-03-19 18:39:17.230 TRACE glance     self.command_object.export_metadefs(CONF.command.path)
  2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/cmd/manage.py", line 148, in export_metadefs
  2015-03-19 18:39:17.230 TRACE glance     path)
  2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/db/sqlalchemy/metadata.py", line 481, in db_export_metadefs
  2015-03-19 18:39:17.230 TRACE glance     _export_data_to_file(meta, metadata_path)
  2015-03-19 18:39:17.230 TRACE glance   File "/opt/stack/glance/glance/db/sqlalchemy/metadata.py", line 404, in _export_data_to_file
  2015-03-19 18:39:17.230 TRACE glance     'name': resource_type['name'],
  2015-03-19 18:39:17.230 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/result.py", line 331, in _key_fallback
  2015-03-19 18:39:17.230 TRACE glance     expression._string_or_unprintable(key))
  2015-03-19 18:39:17.230 TRACE glance NoSuchColumnError: "Could not locate column in row for column 'name'"

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1434237/+subscriptions