Not a DB expert but looks like a valid bug. Do you mind file a bug on this?
On Mon, Jun 1, 2015 at 5:43 PM, Vasco Rodrigues <[email protected]> wrote: > Running Cinder on postgresql, i get the following error: > > 2015-06-02 01:21:27.471 32698 DEBUG cinder.api.v2.volumes > [req-a0a15e07-2a86-4f98-a371-2f7203706b9f > e8bd9bfef65c4def9d3977993c56b9b0 9dbebc529a0a469cb4574c3f9c0d86f7 - - -] > Could not evaluate value 1, assuming string _get_volumes > /usr/lib/python2.7/dist-packages/cinder/api/v2/volumes.py:238 > 2015-06-02 01:21:27.471 32698 DEBUG cinder.volume.api > [req-a0a15e07-2a86-4f98-a371-2f7203706b9f > e8bd9bfef65c4def9d3977993c56b9b0 9dbebc529a0a469cb4574c3f9c0d86f7 - - -] > Searching by: MultiDict([(u'status', u'available'), (u'bootable', 1)]). > get_all /usr/lib/python2.7/dist-packages/cinder/volume/api.py:421 > 2015-06-02 01:21:27.486 32698 ERROR oslo_db.sqlalchemy.exc_filters > [req-a0a15e07-2a86-4f98-a371-2f7203706b9f > e8bd9bfef65c4def9d3977993c56b9b0 9dbebc529a0a469cb4574c3f9c0d86f7 - - -] > DBAPIError exception wrapped from (psycopg2.ProgrammingError) operator > does not exist: boolean = integer > LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo... > ^ > HINT: No operator matches the given name and argument type(s). You > might need to add explicit type casts. > > > I think it's because postgresql doesn't allow comparing integer to boolean. > > Which I fixed by adding: > > if 'bootable' in filters: > filters['bootable'] = bool(filters['bootable']) > > > to VolumeController._get_volumes > > > Regards, > Vasco Rodrigues > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: [email protected]?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > -- Regards Huang Zhiteng
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: [email protected]?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
