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

Thomas Goirand zigo at debian.org
Tue Apr 23 14:05:50 UTC 2013

On 04/18/2013 09:44 PM, Maciej Gałkiewicz wrote:
> /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 <http://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'}
> 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


Sorry for the delay in replying, but I was at the summit when you sent
this, and then got seriously sic. Let's try to fix it now.

It looks like your db schema isn't upgraded for nova. Could you try to:
nova-manage db sync

and see if this fixes it?


More information about the Openstack-devel mailing list