yahoo-eng-team team mailing list archive

[Thomas Bechtold <tbechtold@xxxxxxxx>]

Public bug reported:

When using postgres, searching for volumes with "bootable=1" doesn't work.
The error is from the cinder-api log is:

 u'cd20675e9d0748c7a742827dc4d67840', 'bootable_1': 1, 'status_1': u'available'}
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters     context)
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: operator does not exist: boolean = integer
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters                                                              ^
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters 
2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters 
2015-05-20 17:23:56.162 12837 ERROR cinder.api.middleware.fault [req-2c01592d-7555-4766-9876-2c2f5b99ca85 2e0ec0a31b724dc2bcd6e2f9863ed252 cd20675e9d0748c7a742827dc4d67840 - - -] Caught error: (ProgrammingError) operator does not exist: boolean = integer
LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...


I think this should be fixed in the cinder code so the search parameters
are handled correctly, but as a workarround, search for 'true' does
work.

** Affects: horizon
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Dashboard (Horizon).
https://bugs.launchpad.net/bugs/1457153

Title:
  "Launch instance" dialog has "Error: Unable to retrieve list of
  volumes." with postgres db as backend

Status in OpenStack Dashboard (Horizon):
  New

Bug description:
  When using postgres, searching for volumes with "bootable=1" doesn't work.
  The error is from the cinder-api log is:

   u'cd20675e9d0748c7a742827dc4d67840', 'bootable_1': 1, 'status_1': u'available'}
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1063, in _execute_context
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters     context)
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: operator does not exist: boolean = integer
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters                                                              ^
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters 
  2015-05-20 17:23:56.159 12837 TRACE oslo_db.sqlalchemy.exc_filters 
  2015-05-20 17:23:56.162 12837 ERROR cinder.api.middleware.fault [req-2c01592d-7555-4766-9876-2c2f5b99ca85 2e0ec0a31b724dc2bcd6e2f9863ed252 cd20675e9d0748c7a742827dc4d67840 - - -] Caught error: (ProgrammingError) operator does not exist: boolean = integer
  LINE 3: ...volumes.status = 'available' AND volumes.bootable = 1 AND vo...


  
  I think this should be fixed in the cinder code so the search parameters are handled correctly, but as a workarround, search for 'true' does work.

To manage notifications about this bug go to:
https://bugs.launchpad.net/horizon/+bug/1457153/+subscriptions