Hi Sonali,
At this stage, it looks like the Nova database is not in a very good shape :-/.
If you don't want to reinstall and start again from scratch, we could try the
following:
- Stop all Nova services
- Try to drop all the tables from the Nova database, and then re-run
"nova-manage db sync"
- If it works fine, run packstack again with the same answer file
Regards,
Javier
----- Original Message -----
> Hi Javier,
> Thanks for the response. I thought same before, since I had searched for that
> error. But I had executed “nova-manage db sync” before as well and rerun
> entire packstack, didn’t helped.
> My system is running on 98GB ram and 60G of SSD disks.
> I tried just now for this new installation again,
> I get this,
> [root@ostest ~]# nova-manage db sync
> An error has occurred:
> Traceback (most recent call last):
> File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 1797, in
> main
> ret = fn(*fn_args, **fn_kwargs)
> File "/usr/lib/python2.7/site-packages/nova/cmd/manage.py", line 711, in sync
> return migration.db_sync(version)
> File "/usr/lib/python2.7/site-packages/nova/db/migration.py", line 26, in
> db_sync
> return IMPL.db_sync(version=version, database=database, context=context)
> File "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migration.py", line
> 57, in db_sync
> repository, version)
> File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186,
> in upgrade
> return _migrate(url, repository, version, upgrade=True, err=err, **opts)
> File "<string>", line 2, in _migrate
> File "/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py",
> line 167, in with_engine
> return f(*a, **kw)
> File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366,
> in _migrate
> schema.runchange(ver, change, changeset.step)
> File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line
> 93, in runchange
> change.run(self.engine, step)
> File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line
> 148, in run
> script_func(engine)
> File
> "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py",
> line 1044, in upgrade
> instances.create()
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/schema.py", line 756,
> in create
> checkfirst=checkfirst)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1929, in _run_visitor
> conn._run_visitor(visitorcallable, element, **kwargs)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1538, in _run_visitor
> **kwargs).traverse_single(element)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/visitors.py", line
> 121, in traverse_single
> return meth(obj, **kw)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 767, in
> visit_table
> include_foreign_key_constraints=include_foreign_key_constraints
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 945, in execute
> return meth(self, multiparams, params)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in
> _execute_on_connection
> return connection._execute_ddl(self, multiparams, params)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1002, in _execute_ddl
> compiled
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1189, in _execute_context
> context)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1398, in _handle_dbapi_exception
> util.raise_from_cause(newraise, exc_info)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line
> 203, in raise_from_cause
> reraise(type(exception), exception, tb=exc_tb, cause=cause)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line
> 1182, in _execute_context
> context)
> File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> 470, in do_execute
> cursor.execute(statement, parameters)
> File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in
> execute
> result = self._query(query)
> File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in
> _query
> conn.query(q)
> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in
> query
> self._affected_rows = self._read_query_result(unbuffered=unbuffered)
> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in
> _read_query_result
> result.read()
> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in
> read
> first_packet = self.connection._read_packet()
> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in
> _read_packet
> packet.check_error()
> File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in
> check_error
> err.raise_mysql_exception(self._data)
> File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in
> raise_mysql_exception
> raise errorclass(errno, errval)
> DBError: (pymysql.err.InternalError) (1050, u"Table 'instances' already
> exists") [SQL: u"\nCREATE TABLE instances (\n\tcreated_at DATETIME,
> \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tid INTEGER NOT NULL
> AUTO_INCREMENT, \n\tinternal_id INTEGER, \n\tuser_id VARCHAR(255),
> \n\tproject_id VARCHAR(255), \n\timage_ref VARCHAR(255), \n\tkernel_id
> VARCHAR(255), \n\tramdisk_id VARCHAR(255), \n\tlaunch_index INTEGER,
> \n\tkey_name VARCHAR(255), \n\tkey_data MEDIUMTEXT, \n\tpower_state INTEGER,
> \n\tvm_state VARCHAR(255), \n\tmemory_mb INTEGER, \n\tvcpus INTEGER,
> \n\thostname VARCHAR(255), \n\thost VARCHAR(255), \n\tuser_data MEDIUMTEXT,
> \n\treservation_id VARCHAR(255), \n\tscheduled_at DATETIME, \n\tlaunched_at
> DATETIME, \n\tterminated_at DATETIME, \n\tdisplay_name VARCHAR(255),
> \n\tdisplay_description VARCHAR(255), \n\tavailability_zone VARCHAR(255),
> \n\tlocked BOOL, \n\tos_type VARCHAR(255), \n\tlaunched_on MEDIUMTEXT,
> \n\tinstance_type_id INTEGER, \n\tvm_mode VARCHAR(255), \n\tuuid
> VARCHAR(36), \n\tarchitecture VARCHAR(255), \n\troot_device_name
> VARCHAR(255), \n\taccess_ip_v4 VARCHAR(39), \n\taccess_ip_v6 VARCHAR(39),
> \n\tconfig_drive VARCHAR(255), \n\ttask_state VARCHAR(255),
> \n\tdefault_ephemeral_device VARCHAR(255), \n\tdefault_swap_device
> VARCHAR(255), \n\tprogress INTEGER, \n\tauto_disk_config BOOL,
> \n\tshutdown_terminate BOOL, \n\tdisable_terminate BOOL, \n\troot_gb
> INTEGER, \n\tephemeral_gb INTEGER, \n\tcell_name VARCHAR(255), \n\tnode
> VARCHAR(255), \n\tdeleted INTEGER, \n\tlocked_by ENUM('owner','admin'),
> \n\tcleaned INTEGER, \n\tPRIMARY KEY (id), \n\tCHECK (locked IN (0, 1)),
> \n\tCHECK (auto_disk_config IN (0, 1)), \n\tCHECK (shutdown_terminate IN (0,
> 1)), \n\tCHECK (disable_terminate IN (0, 1))\n)ENGINE=InnoDB
> CHARSET=utf8\n\n"]
> [root@ostest ~]#
> Thanks,
> /Sonali
> From: Javier Pena [mailto:javier.p...@redhat.com]
> Sent: 14 November 2017 05:49 PM
> To: Sonali Jadhav <son...@servercentralen.se>
> Cc: users@lists.rdoproject.org
> Subject: Re: [rdo-users] packstack allinone POC - unable to get openstack
> running ERROR oslo_service.service
> Hi Sonali,
> The source for the issues is here:
> Error: /Stage[main]/Nova:db::Sync/Exec[nova-db-sync]: Failed to call refresh:
> Command exceeded timeout
> That means that the "nova-manage db sync" command took too long to execute,
> and Puppet considered that as a failure. This usually happens when your disk
> is very slow or the machine you are using to run Packstack is low on RAM and
> constantly swapping.
> As a quick fix, I'd suggest to:
> - Run "nova-manage db sync" as root.
> - Re-run packstack using the same answer file.
> Regards,
> Javier
> ----- Original Message -----
> > Hi,
>
> > I am trying to implement all-in-one concept cloud with Packstack on Centos
> > 7.
> > But I am having problem.
>
> > My command “#packstack –allinone” end with following error,
>
> > Preparing Puppet manifests [ DONE ]
>
> > Copying Puppet modules and manifests [ DONE ]
>
> > Applying 172.16.5.184_controller.pp
>
> > 172.16.5.184_controller.pp: [ ERROR ]
>
> > Applying Puppet manifests [ ERROR ]
>
> > ERROR : Error appeared during Puppet run: 192.6.5.184_controller.pp
>
> > Error: /Stage[main]/Nova::Db::Sync/Exec[nova-db-sync]: Failed to call
> > refresh: Command exceeded timeout
>
> > You will find full trace in log
> > /var/tmp/packstack/20171113-141949-w6oJW4/manifests/172.16.5.184_controller.pp.log
>
> > Please check log file
> > /var/tmp/packstack/20171113-141949-w6oJW4/openstack-setup.log for more
> > information
>
> > Additional information:
>
> > * A new answerfile was created in:
> > /root/packstack-answers-20171113-141950.txt
>
> > * Time synchronization installation was skipped. Please note that
> > unsynchronized time on server instances might be problem for some OpenStack
> > components.
>
> > * File /root/keystonerc_admin has been created on OpenStack client host
> > 192.6.5.184. To use the command line tools you need to source the file.
>
> > * To access the OpenStack Dashboard browse to http://192.6.5.184/dashboard
> > .
>
> > Please, find your login credentials stored in the keystonerc_admin in your
> > home directory.
>
> > I am able to bowse dashboard but once I enter username and pwd , it’s not
> > loading further.
>
> > I checked nova logs,
>
> > I am getting these errors,
>
> > 2017-11-14 12:51:22.061 30815 INFO nova.service [-] Starting consoleauth
> > node
> > (version 16.0.2-1.el7)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > [req-6df91cfa-5d3e-4738-9d5e-06e0109a8175 - - - - -] DBAPIError exception
> > wrapped from (pymysql.err.InternalError) (1054, u"Unknown column
> > 'services.uuid' in 'field list'") [SQL: u'SELECT services.created_at AS
> > services_created_at, services.updated_at AS services_updated_at,
> > services.deleted_at AS services_deleted_at, services.deleted AS
> > services_deleted, services.id AS services_id, services.uuid AS
> > services_uuid, services.host AS services_host, services.`binary` AS
> > services_binary, services.topic AS services_topic, services.report_count AS
> > services_report_count, services.disabled AS services_disabled,
> > services.disabled_reason AS services_disabled_reason, services.last_seen_up
> > AS services_last_seen_up, services.forced_down AS services_forced_down,
> > services.version AS services_version \nFROM services \nWHERE
> > services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND
> > services.`binary` = %(binary_1)s \n LIMIT %(param_1)s'] [parameters:
> > {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1':
> > 'nova-consoleauth'}]: InternalError: (1054, u"Unknown column
> > 'services.uuid'
> > in 'field list'")
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > Traceback
> > (most recent call last):
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182,
> > in _execute_context
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters context)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> > 470,
> > in do_execute
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > cursor.execute(statement, parameters)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters result =
> > self._query(query)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > conn.query(q)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in
> > query
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > self._affected_rows = self._read_query_result(unbuffered=unbuffered)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in
> > _read_query_result
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > result.read()
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in
> > read
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > first_packet = self.connection._read_packet()
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in
> > _read_packet
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > packet.check_error()
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in
> > check_error
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > err.raise_mysql_exception(self._data)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in
> > raise_mysql_exception
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters raise
> > errorclass(errno, errval)
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
> > InternalError: (1054, u"Unknown column 'services.uuid' in 'field list'")
>
> > 2017-11-14 12:51:22.465 30815 ERROR oslo_db.sqlalchemy.exc_filters
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > [req-6df91cfa-5d3e-4738-9d5e-06e0109a8175 - - - - -] Error starting
> > thread.:
> > DBError: (pymysql.err.InternalError) (1054, u"Unknown column
> > 'services.uuid'
> > in 'field list'") [SQL: u'SELECT services.created_at AS
> > services_created_at,
> > services.updated_at AS services_updated_at, services.deleted_at AS
> > services_deleted_at, services.deleted AS services_deleted, services.id AS
> > services_id, services.uuid AS services_uuid, services.host AS
> > services_host,
> > services.`binary` AS services_binary, services.topic AS services_topic,
> > services.report_count AS services_report_count, services.disabled AS
> > services_disabled, services.disabled_reason AS services_disabled_reason,
> > services.last_seen_up AS services_last_seen_up, services.forced_down AS
> > services_forced_down, services.version AS services_version \nFROM services
> > \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND
> > services.`binary` = %(binary_1)s \n LIMIT %(param_1)s'] [parameters:
> > {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1':
> > 'nova-consoleauth'}]
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service Traceback (most
> > recent call last):
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/oslo_service/service.py", line 721, in
> > run_service
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service service.start()
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/nova/service.py", line 147, in start
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service ctxt, self.host,
> > self.binary)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/oslo_versionedobjects/base.py", line 184,
> > in wrapper
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result = fn(cls,
> > context, *args, **kwargs)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/nova/objects/service.py", line 296, in
> > get_by_host_and_binary
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service host, binary)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/nova/db/api.py", line 133, in
> > service_get_by_host_and_binary
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return
> > IMPL.service_get_by_host_and_binary(context, host, binary)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 265, in
> > wrapped
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return f(context,
> > *args, **kwargs)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/nova/db/sqlalchemy/api.py", line 554, in
> > service_get_by_host_and_binary
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > filter_by(binary=binary).\
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2755, in
> > first
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service ret =
> > list(self[0:1])
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2547, in
> > __getitem__
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return list(res)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2855, in
> > __iter__
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return
> > self._execute_and_instances(context)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in
> > _execute_and_instances
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result =
> > conn.execute(querycontext.statement, self._params)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 945,
> > in
> > execute
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return meth(self,
> > multiparams, params)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 263,
> > in _execute_on_connection
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service return
> > connection._execute_clauseelement(self, multiparams, params)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1053,
> > in _execute_clauseelement
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service compiled_sql,
> > distilled_params
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189,
> > in _execute_context
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service context)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1398,
> > in _handle_dbapi_exception
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > util.raise_from_cause(newraise, exc_info)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203,
> > in
> > raise_from_cause
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > reraise(type(exception), exception, tb=exc_tb, cause=cause)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182,
> > in _execute_context
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service context)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> > 470,
> > in do_execute
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > cursor.execute(statement, parameters)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result =
> > self._query(query)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service conn.query(q)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 856, in
> > query
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > self._affected_rows
> > = self._read_query_result(unbuffered=unbuffered)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in
> > _read_query_result
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service result.read()
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in
> > read
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service first_packet =
> > self.connection._read_packet()
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in
> > _read_packet
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > packet.check_error()
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in
> > check_error
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
> > err.raise_mysql_exception(self._data)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service File
> > "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in
> > raise_mysql_exception
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service raise
> > errorclass(errno, errval)
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service DBError:
> > (pymysql.err.InternalError) (1054, u"Unknown column 'services.uuid' in
> > 'field list'") [SQL: u'SELECT services.created_at AS services_created_at,
> > services.updated_at AS services_updated_at, services.deleted_at AS
> > services_deleted_at, services.deleted AS services_deleted, services.id AS
> > services_id, services.uuid AS services_uuid, services.host AS
> > services_host,
> > services.`binary` AS services_binary, services.topic AS services_topic,
> > services.report_count AS services_report_count, services.disabled AS
> > services_disabled, services.disabled_reason AS services_disabled_reason,
> > services.last_seen_up AS services_last_seen_up, services.forced_down AS
> > services_forced_down, services.version AS services_version \nFROM services
> > \nWHERE services.deleted = %(deleted_1)s AND services.host = %(host_1)s AND
> > services.`binary` = %(binary_1)s \n LIMIT %(param_1)s'] [parameters:
> > {u'host_1': 'ostest', u'param_1': 1, u'deleted_1': 0, u'binary_1':
> > 'nova-consoleauth'}]
>
> > 2017-11-14 12:51:22.469 30815 ERROR oslo_service.service
>
> > ^C
>
> > 2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters File
> > "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in
> > raise_mysql_exception
>
> > 2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters raise
> > errorclass(errno, errval)
>
> > 2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters
> > InternalError: (1054, u"Unknown column 'aggregates.uuid' in 'field list'")
>
> > 2017-11-13 15:17:13.194 2949 ERROR oslo_db.sqlalchemy.exc_filters
>
> > 2017-11-13 15:17:13.197 2949 CRITICAL nova
> > [req-2d6ddb32-c998-4123-a7ba-e1a0da9648e1 - - - - -] Unhandled error:
> > DBError: (pymysql.err.InternalError) (1054, u"Unknown column
> > 'aggregates.uuid' in 'field list'") [SQL: u'SELECT aggregates.created_at AS
> > aggregates_created_at, aggregates.updated_at AS aggregates_updated_at,
> > aggregates.deleted_at AS aggregates_deleted_at, aggregates.deleted AS
> > aggregates_deleted, aggregates.id AS aggregates_id, aggregates.uuid AS
> > aggregates_uuid, aggregates.name AS aggregates_name,
> > aggregate_hosts_1.created_at AS aggregate_hosts_1_created_at,
> > aggregate_hosts_1.updated_at AS aggregate_hosts_1_updated_at,
> > aggregate_hosts_1.deleted_at AS aggregate_hosts_1_deleted_at,
> > aggregate_hosts_1.deleted AS aggregate_hosts_1_deleted,
> > aggregate_hosts_1.id
> > AS aggregate_hosts_1_id, aggregate_hosts_1.host AS aggregate_hosts_1_host,
> > aggregate_hosts_1.aggregate_id AS aggregate_hosts_1_aggregate_id,
> > aggregate_metadata_1.created_at AS aggregate_metadata_1_created_at,
> > aggregate_metadata_1.updated_at AS aggregate_metadata_1_updated_at,
> > aggregate_metadata_1.deleted_at AS aggregate_metadata_1_deleted_at,
> > aggregate_metadata_1.deleted AS aggregate_metadata_1_deleted,
> > aggregate_metadata_1.id AS aggregate_metadata_1_id,
> > aggregate_metadata_1.`key` AS aggregate_metadata_1_key,
> > aggregate_metadata_1.value AS aggregate_metadata_1_value,
> > aggregate_metadata_1.aggregate_id AS aggregate_metadata_1_aggregate_id
> > \nFROM aggregates LEFT OUTER JOIN aggregate_hosts AS aggregate_hosts_1 ON
> > aggregates.id = aggregate_hosts_1.aggregate_id AND
> > aggregate_hosts_1.deleted
> > = %(deleted_1)s AND aggregates.deleted = %(deleted_2)s LEFT OUTER JOIN
> > aggregate_metadata AS aggregate_metadata_1 ON aggregates.id =
> > aggregate_metadata_1.aggregate_id AND aggregate_metadata_1.deleted =
> > %(deleted_3)s AND aggregates.deleted = %(deleted_4)s \nWHERE
> > aggregates.deleted = %(deleted_5)s'] [parameters: {u'deleted_5': 0,
> > u'deleted_4': 0, u'deleted_3': 0, u'deleted_2': 0, u'deleted_1': 0}]
>
> > 2017-11-13 15:17:13.197 2949 ERROR nova Traceback (most recent call last):
>
> > 2017-11-13 15:17:13.197 2949 ERROR nova File "/usr/bin/nova-scheduler",
> > line
> > 10, in <module>
>
> > 2017-11-13 15:17:13.197 2949 ERROR nova sys.exit(main())
>
> > I am unable to figure out the issue here. Can anyone help me figure it out?
>
> > Thanks,
>
> > /Sonali
>
> > _______________________________________________
>
> > users mailing list
>
> > users@lists.rdoproject.org
>
> > http://lists.rdoproject.org/mailman/listinfo/users
>
> > To unsubscribe: users-unsubscr...@lists.rdoproject.org
>
> _______________________________________________
> users mailing list
> users@lists.rdoproject.org
> http://lists.rdoproject.org/mailman/listinfo/users
> To unsubscribe: users-unsubscr...@lists.rdoproject.org
_______________________________________________
users mailing list
users@lists.rdoproject.org
http://lists.rdoproject.org/mailman/listinfo/users
To unsubscribe: users-unsubscr...@lists.rdoproject.org
