Description of problem: Migration fails on remote region after running yum update from 5.6 to 5.9 Version-Release number of selected component (if applicable):5.9.0.18 How reproducible:100% Steps to Reproduce: 1.Provision 5.6 appliances 2.configure them in pglogical configuration 3.add latest 5.9 repos 4.stop evm on remote 5.run yum update 6.run rake db:migrate Actual results: rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::DependentObjectsStillExist: ERROR: cannot drop desired object(s) because other objects depend on them DETAIL: table public.miq_cim_associations in replication set miq HINT: Use DROP ... CASCADE to drop the dependent objects too. : DROP TABLE "miq_cim_associations" full traceback at http://pastebin.test.redhat.com/551537 Expected results: Migration to complete successfully Additional info:
https://github.com/ManageIQ/pg-pglogical/pull/19
New commit detected on ManageIQ/pg-pglogical/master: https://github.com/ManageIQ/pg-pglogical/commit/61f8a11174c2bc1c8b0bd64e987d107231f603eb commit 61f8a11174c2bc1c8b0bd64e987d107231f603eb Author: Nick Carboni <ncarboni> AuthorDate: Wed Jan 31 14:12:41 2018 -0500 Commit: Nick Carboni <ncarboni> CommitDate: Wed Jan 31 14:12:41 2018 -0500 Account for symbol table names in drop_table patch The array of tables names coming from the database contains only strings. When comparing the given name to the list we were getting a false negative result and not removing the table from the replication set before trying to drop it. Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1540528 lib/pg/pglogical/active_record_extension.rb | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-)
This isn't actually in post. We still need to release a new gem version. I used the "Fixes" notation by mistake.
https://github.com/ManageIQ/manageiq/pull/16967
New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/32584e92367709eb4c45f0be5dac26c2aed85e87 commit 32584e92367709eb4c45f0be5dac26c2aed85e87 Author: Nick Carboni <ncarboni> AuthorDate: Wed Feb 7 16:18:42 2018 -0500 Commit: Nick Carboni <ncarboni> CommitDate: Wed Feb 7 16:18:42 2018 -0500 Update pg-pglogical gem to 2.1.2 Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1540528 Fixes https://bugzilla.redhat.com/show_bug.cgi?id=1540688 Gemfile | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
Verified in 5.10