[Openstack-devel] Problem with upgrading keystone from folsom to grizzly

Maciej Gałkiewicz maciejgalkiewicz at ragnarson.com
Thu Apr 18 13:44:59 UTC 2013


Hello

I am experiencing the problem with upgrading keystone package from folsom
to grizzly:

# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up keystone (2013.1-1) ...
dpkg: error processing keystone (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 keystone
E: Sub-process /usr/bin/dpkg returned an error code (1)

I managed to get some more info:
# ( strace -f dpkg --configure keystone 2>&1 ) | grep execve | grep post
[pid  8190] execve("/var/lib/dpkg/info/keystone.postinst",
["/var/lib/dpkg/info/keystone.post"..., "configure", "2012.2.3-2"], [/* 36
vars */] <unfinished ...>
[pid  8190] execve("/usr/share/debconf/frontend",
["/usr/share/debconf/frontend", "/var/lib/dpkg/info/keystone.post"...,
"configure", "2012.2.3-2"], [/* 37 vars */]) = 0
[pid  8239] execve("/var/lib/dpkg/info/keystone.postinst",
["/var/lib/dpkg/info/keystone.post"..., "configure", "2012.2.3-2"], [/* 38
vars */] <unfinished ...>
# cat /var/log/keystone_upgrade.log (output logged from
/var/lib/dpkg/info/keystone.postinst script)
GET keystone/auth-token
GET keystone/configure_db
GET keystone/configure_db

I think it might be related to the problem with nova-scheduler which cannot
start after upgrade because of:
2013-04-18 15:38:27.315 9140 DEBUG nova.service [-] instance_usage_audit :
False wait /usr/lib/python2.7/dist-packages/nova/service.py:205
2013-04-18 15:38:27.315 9140 DEBUG nova.service [-] cells :
<oslo.config.cfg.GroupAttr object at 0x3427250> wait
/usr/lib/python2.7/dist-packages/nova/service.py:205
2013-04-18 15:38:27.315 9140 DEBUG nova.service [-] trusted_computing :
<oslo.config.cfg.GroupAttr object at 0x3427210> wait
/usr/lib/python2.7/dist-packages/nova/servi
ce.py:205
2013-04-18 15:38:27.315 9140 DEBUG nova.service [-] conductor :
<oslo.config.cfg.GroupAttr object at 0x341ac50> wait
/usr/lib/python2.7/dist-packages/nova/service.py:20
5
2013-04-18 15:38:27.315 9140 DEBUG nova.service [-] spice :
<oslo.config.cfg.GroupAttr object at 0x34272d0> wait
/usr/lib/python2.7/dist-packages/nova/service.py:205
2013-04-18 15:38:27.315 9140 AUDIT nova.service [-] Starting scheduler node
(version 2013.1)
2013-04-18 15:38:27.316 DEBUG nova.openstack.common.lockutils
[req-b6c59467-cba7-4f2d-9062-c96db4cf9d49 None None] Got semaphore
"dbapi_backend" for method "__get_backe
nd"... inner
/usr/lib/python2.7/dist-packages/nova/openstack/common/lockutils.py:186
2013-04-18 15:38:27.475 9140 CRITICAL nova [-] (ProgrammingError) operator
does not exist: boolean = integer
LINE 3: WHERE services.deleted = 0 AND services.host = 'cc' AND serv...
                               ^
HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.
 '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 service
s_deleted, services.id AS services_id, 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 \nFROM
services \nWHERE services.deleted = %(deleted_1)s AND services.host =
%(host_1)s AND services."bina
ry" = %(binary_1)s \n LIMIT %(param_1)s' {'host_1': 'cc', 'param_1': 1,
'deleted_1': 0, 'binary_1': 'nova-scheduler'}
2013-04-18 15:38:27.475 9140 TRACE nova Traceback (most recent call last):
2013-04-18 15:38:27.475 9140 TRACE nova   File "/usr/bin/nova-scheduler",
line 56, in <module>
2013-04-18 15:38:27.475 9140 TRACE nova     service.wait()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 689, in wait
2013-04-18 15:38:27.475 9140 TRACE nova     _launcher.wait()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 209, in wait
2013-04-18 15:38:27.475 9140 TRACE nova     super(ServiceLauncher,
self).wait()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 179, in wait
2013-04-18 15:38:27.475 9140 TRACE nova     service.wait()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 168, in
wait
2013-04-18 15:38:27.475 9140 TRACE nova     return self._exit_event.wait()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/event.py", line 116, in wait
2013-04-18 15:38:27.475 9140 TRACE nova     return hubs.get_hub().switch()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/hubs/hub.py", line 187, in switch
2013-04-18 15:38:27.475 9140 TRACE nova     return self.greenlet.switch()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/eventlet/greenthread.py", line 194, in
main
2013-04-18 15:38:27.475 9140 TRACE nova     result = function(*args,
**kwargs)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 147, in run_server
2013-04-18 15:38:27.475 9140 TRACE nova     server.start()
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/service.py", line 434, in start
2013-04-18 15:38:27.475 9140 TRACE nova     self.host, self.binary)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/conductor/api.py", line 258, in
service_get_by_args
2013-04-18 15:38:27.475 9140 TRACE nova     binary=binary)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/utils.py", line 1348, in wrapper
2013-04-18 15:38:27.475 9140 TRACE nova     return func(*args, **kwargs)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/common.py",
line 424, in inner
2013-04-18 15:38:27.475 9140 TRACE nova     return
catch_client_exception(exceptions, func, *args, **kwargs)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/openstack/common/rpc/common.py",
line 407, in catch_client_exception
2013-04-18 15:38:27.475 9140 TRACE nova     return func(*args, **kwargs)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/conductor/manager.py", line 322, in
service_get_all_by
2013-04-18 15:38:27.475 9140 TRACE nova     result =
self.db.service_get_by_args(context, host, binary)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/api.py", line 155, in
service_get_by_args
2013-04-18 15:38:27.475 9140 TRACE nova     return
IMPL.service_get_by_args(context, host, binary)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 96, in
wrapper
2013-04-18 15:38:27.475 9140 TRACE nova     return f(*args, **kwargs)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 411, in
service_get_by_args
2013-04-18 15:38:27.475 9140 TRACE nova     filter_by(binary=binary).\
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2156, in
first
2013-04-18 15:38:27.475 9140 TRACE nova     ret = list(self[0:1])
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2023, in
__getitem__
2013-04-18 15:38:27.475 9140 TRACE nova     return list(res)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in
__iter__
2013-04-18 15:38:27.475 9140 TRACE nova     return
self._execute_and_instances(context)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in
_execute_and_instances
2013-04-18 15:38:27.475 9140 TRACE nova     result =
conn.execute(querycontext.statement, self._params)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in
execute
2013-04-18 15:38:27.475 9140 TRACE nova     params)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in
_execute_clauseelement
2013-04-18 15:38:27.475 9140 TRACE nova     compiled_sql, distilled_params
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in
_execute_context
2013-04-18 15:38:27.475 9140 TRACE nova     context)
2013-04-18 15:38:27.475 9140 TRACE nova   File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1851, in
_handle_dbapi_exception
2013-04-18 15:38:27.475 9140 TRACE nova     None, sys.exc_info()[2]
2013-04-18 15:38:27.475 9140 TRACE nova ProgrammingError:
(ProgrammingError) operator does not exist: boolean = integer
2013-04-18 15:38:27.475 9140 TRACE nova LINE 3: WHERE services.deleted = 0
AND services.host = 'cc' AND serv...
2013-04-18 15:38:27.475 9140 TRACE nova                                ^
2013-04-18 15:38:27.475 9140 TRACE nova HINT:  No operator matches the
given name and argument type(s). You might need to add explicit type casts.
2013-04-18 15:38:27.475 9140 TRACE nova  '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.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 \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' {'host_1': 'cc',
'param_1': 1, 'deleted_1': 0, 'binary_1': 'nova-scheduler'}
2013-04-18 15:38:27.475 9140 TRACE nova

All packages are from debian experimental and:
deb http://ftp.gplhost.com/debian/ openstack main
deb http://archive.gplhost.com/debian grizzly main

Postgresql is used for all services which require database.

regards
Maciej Gałkiewicz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/openstack-devel/attachments/20130418/7fef05d7/attachment-0001.html>


More information about the Openstack-devel mailing list