DB sync failed when enable_service=postgresql in devstack
Bug #1687585 reported by
Rui Chen
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
In Progress
|
Low
|
Unassigned |
Bug Description
I enable trove and postgresql in devstack local.conf, as following, executing stack.sh fail when trove do db sync, please see more details in stack.log [1], and it's no problem with mysql.
===local.conf===
enable_service postgresql
enable_plugin trove https:/
Changed in trove: | |
assignee: | nobody → Thomas Bechtold (toabctl) |
status: | Confirmed → In Progress |
Changed in trove: | |
importance: | Undecided → Low |
Changed in trove: | |
assignee: | Thomas Bechtold (toabctl) → nobody |
To post a comment you must log in.
Thanks for pasting the traceback, this looks like its a database type issue.
This works for mysql because 0 is equivalent to false but postgres this is not the case and we need to cast it to work in this case.