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 : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
