Bug 1361218
| Summary: | RubyRep fails to start after 5.5 -> 5.6 migration | |||
|---|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | luke couzens <lcouzens> | |
| Component: | Appliance | Assignee: | Nick Carboni <ncarboni> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | luke couzens <lcouzens> | |
| Severity: | high | Docs Contact: | ||
| Priority: | high | |||
| Version: | 5.6.0 | CC: | abellott, cpelland, jhardy, jkrocil, ncarboni, obarenbo, simaishi | |
| Target Milestone: | GA | Keywords: | TestOnly, ZStream | |
| Target Release: | 5.7.0 | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | black:upgrade:migration:replication | |||
| Fixed In Version: | 5.7.0.0 | Doc Type: | If docs needed, set a value | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1361610 (view as bug list) | Environment: | ||
| Last Closed: | 2017-01-11 20:12:36 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 1361610 | |||
|
Description
luke couzens
2016-07-28 14:11:04 UTC
The issue is a unique constraint error on the cloud_subnets_network_ports table. This was caused by a region agnostic migration which created join table rows containing data from a remote region with global ids when a global region was migrated. This was introduced in https://github.com/ManageIQ/manageiq/pull/7237 Unfortunately this issue seems to also be in 5.6.0. We can doc a fix which will be, after the migration, to: On the global region: - DELETE from cloud_subnets_network_ports; On each remote region: - Stop the replication worker - bin/rake evm:dbsync:local_uninstall cloud_subnets_network_ports - Start the replication worker I'm also currently working on a fix for the migration itself. New commit detected on ManageIQ/manageiq/master: https://github.com/ManageIQ/manageiq/commit/6c0ab8b32f8f621474588bfe94b62fc25692bc0d commit 6c0ab8b32f8f621474588bfe94b62fc25692bc0d Author: Nick Carboni <ncarboni> AuthorDate: Thu Jul 28 12:39:15 2016 -0400 Commit: Nick Carboni <ncarboni> CommitDate: Thu Jul 28 12:41:57 2016 -0400 Only migrate rows in the current region This was causing an issue with replication when rows which actually belonged to a region were migrated. The new rows in the join table got an id in the global region. This caused replication to fail with a unique constraint error when trying to replicate the new rows in the regional database. https://bugzilla.redhat.com/show_bug.cgi?id=1361218 ...oud_subnet_id_to_network_ports_cloud_subnets.rb | 6 +- ...ubnet_id_to_network_ports_cloud_subnets_spec.rb | 71 ++++++++++++++++++++++ 2 files changed, 74 insertions(+), 3 deletions(-) If we should be doing 5.5 - 5.7 inplace upgrade then we are currently blocked by https://bugzilla.redhat.com/show_bug.cgi?id=1376888 Verified in 5.7.0.7 |