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/.pyenv/versions/trovenv/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi cursor.execute(statement, parameters)
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi ProgrammingError: (psycopg2.ProgrammingError) operator does not exist: boolean = integer
2015-11-18 10:38:30.220 13666 ERROR trove.common.wsgi LINE 4: ...cd45a9d947d8848af53e928cec41' AND backups.deleted = 0 ORDER ...
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_description, backups.location AS backups_location, backups.backup_type AS backups_backup_type, backups.size AS backups_size, backups.tenant_id AS backups_tenant_id, backups.state AS backups_state, backups.instance_id AS backups_instance_id, backups.checksum AS backups_checksum, backups.backup_timestamp AS backups_backup_timestamp, backups.deleted AS backups_deleted, backups.created AS backups_created, backups.updated AS backups_updated, backups.deleted_at AS backups_deleted_at, backups.parent_id AS backups_parent_id, backups.datastore_version_id AS backups_datastore_version_id \nFROM backups \nWHERE backups.tenant_id = %(tenant_id_1)s AND backups.deleted = %(deleted_1)s ORDER BY backups.updated DESC \n LIMIT %(param_1)s OFFSET %(param_2)s) AS anon_1'] [parameters: {'param_2': 0, 'param_1': 20, 'deleted_1': 0, 'tenant_id_1': u'bd4ccd45a9d947d8848af53e928cec41'}]
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!