[Yahoo-eng-team] [Bug 1747665] [NEW] Unknown column 'cn.mapped' in 'field list' after upgrade from Ocata to Pike

jiri Tue, 06 Feb 2018 04:56:33 -0800

Public bug reported:

Hello I upgraded from Ocata to Pike and now I see the following in scheduler:
I did nova-manage db sync, api_db sync and online migrations.
Am I missing something?


2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters 
[req-6065c009-2056-498e-9b71-5a27daca7092 - - - - -] DBAPIError exception 
wrapped from (pymysql.err.InternalError) (1054, u"Unknown column 'cn.mapped' in 
'field list'") [SQL: u'SELECT cn.created_at, cn.updated_at, cn.deleted_at, 
cn.deleted, cn.id, cn.service_id, cn.host, cn.uuid, cn.vcpus, cn.memory_mb, 
cn.local_gb, cn.vcpus_used, cn.memory_mb_used, cn.local_gb_used, 
cn.hypervisor_type, cn.hypervisor_version, cn.hypervisor_hostname, 
cn.free_ram_mb, cn.free_disk_gb, cn.current_workload, cn.running_vms, 
cn.cpu_info, cn.disk_available_least, cn.host_ip, cn.supported_instances, 
cn.metrics, cn.pci_stats, cn.extra_resources, cn.stats, cn.numa_topology, 
cn.ram_allocation_ratio, cn.cpu_allocation_ratio, cn.disk_allocation_ratio, 
cn.mapped \nFROM compute_nodes AS cn \nWHERE cn.deleted = %(deleted_1)s ORDER 
BY cn.id ASC'] [parameters: {u'deleted_1': 0}]: InternalError: (1054, u"Unknown 
column 'cn.mapped' in 'field list'")
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters Traceback 
(most recent call last):
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in 
_execute_context
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     context)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in 
do_execute
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
cursor.execute(statement, parameters)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 167, in execute
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     result = 
self._query(query)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 323, in _query
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
conn.query(q)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 836, in query
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1020, in 
_read_query_result
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
result.read()
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1303, in read
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
first_packet = self.connection._read_packet()
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 982, in 
_read_packet
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
packet.check_error()
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in 
check_error
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
err.raise_mysql_exception(self._data)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in 
raise_mysql_exception
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
_check_mysql_exception(errinfo)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in 
_check_mysql_exception
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     raise 
InternalError(errno, errorvalue)
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters 
InternalError: (1054, u"Unknown column 'cn.mapped' in 'field list'")
2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters

** Affects: nova
     Importance: Undecided
         Status: New

-- 
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/1747665

Title:
  Unknown column 'cn.mapped' in 'field list' after upgrade from Ocata to
  Pike

Status in OpenStack Compute (nova):
  New

Bug description:
  Hello I upgraded from Ocata to Pike and now I see the following in scheduler:
  I did nova-manage db sync, api_db sync and online migrations.
  Am I missing something?

  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters 
[req-6065c009-2056-498e-9b71-5a27daca7092 - - - - -] DBAPIError exception 
wrapped from (pymysql.err.InternalError) (1054, u"Unknown column 'cn.mapped' in 
'field list'") [SQL: u'SELECT cn.created_at, cn.updated_at, cn.deleted_at, 
cn.deleted, cn.id, cn.service_id, cn.host, cn.uuid, cn.vcpus, cn.memory_mb, 
cn.local_gb, cn.vcpus_used, cn.memory_mb_used, cn.local_gb_used, 
cn.hypervisor_type, cn.hypervisor_version, cn.hypervisor_hostname, 
cn.free_ram_mb, cn.free_disk_gb, cn.current_workload, cn.running_vms, 
cn.cpu_info, cn.disk_available_least, cn.host_ip, cn.supported_instances, 
cn.metrics, cn.pci_stats, cn.extra_resources, cn.stats, cn.numa_topology, 
cn.ram_allocation_ratio, cn.cpu_allocation_ratio, cn.disk_allocation_ratio, 
cn.mapped \nFROM compute_nodes AS cn \nWHERE cn.deleted = %(deleted_1)s ORDER 
BY cn.id ASC'] [parameters: {u'deleted_1': 0}]: InternalError: (1054, u"Unknown 
column 'cn.mapped' in 'field list'")
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters Traceback 
(most recent call last):
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in 
_execute_context
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
context)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in 
do_execute
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
cursor.execute(statement, parameters)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 167, in execute
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     result 
= self._query(query)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 323, in _query
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
conn.query(q)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 836, in query
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1020, in 
_read_query_result
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
result.read()
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1303, in read
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
first_packet = self.connection._read_packet()
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 982, in 
_read_packet
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
packet.check_error()
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in 
check_error
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
err.raise_mysql_exception(self._data)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in 
raise_mysql_exception
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     
_check_mysql_exception(errinfo)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters   File 
"/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in 
_check_mysql_exception
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters     raise 
InternalError(errno, errorvalue)
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters 
InternalError: (1054, u"Unknown column 'cn.mapped' in 'field list'")
  2018-02-06 12:39:51.654 32708 ERROR oslo_db.sqlalchemy.exc_filters

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

[Yahoo-eng-team] [Bug 1747665] [NEW] Unknown column 'cn.mapped' in 'field list' after upgrade from Ocata to Pike

Reply via email to