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

[Thomas Goirand]

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

Hi,

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?

Thomas