operator does not exist: boolean = integer
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
In Progress
|
Undecided
|
Marc Koderer |
Bug Description
i use Postgresql store trove's metadata, and get an error like 'operator does not exist: boolean = integer' when i click the [backups] database's submenu on dashboard. i found some useful log:
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi File "/root/
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi cursor.
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi ProgrammingError: (psycopg2.
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi LINE 4: ...cd45a9d947d8
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi ^
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi [SQL: 'SELECT count(*) AS count_1 \nFROM (SELECT backups.id AS backups_id, backups.name AS backups_name, backups.description AS backups_
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi
it suggests that the column "deleted" of table backups should be defined to integer in Postgresql not bool, because ZERO not equal to FALSE in Postgresql.
please clarify what you were doing and provide steps to possibly reproduce this problem. Thanks!