Back to bug 1324991

Who When What Removed Added
John Prause 2016-04-07 19:48:41 UTC Status NEW MODIFIED
CC jprause
Nick Carboni 2016-04-08 12:28:50 UTC Status MODIFIED ASSIGNED
Nick Carboni 2016-04-08 12:31:55 UTC Status ASSIGNED ON_DEV
Chris Pelland 2016-04-08 12:52:17 UTC Target Release 5.5.3 5.5.4
Gregg Tanzillo 2016-04-08 17:24:16 UTC CC gtanzill
Nick Carboni 2016-04-15 12:37:55 UTC Status ON_DEV POST
John Prause 2016-04-18 15:34:48 UTC Status POST MODIFIED
Marianne Feifer 2016-04-26 00:03:57 UTC Doc Text Cause: ems_events table was renamed to event_streams in 4.0. The migration that did the rename did not remove the old trigger for ems_events. Because of this the trigger stayed with the new event_streams table after the rename. In addition, the correct trigger was added for the new table name, as it should. This caused pending changes records to be created for both the old table and the new table names when a change occurred to event_streams.

The existence of the pending change entries for the removed ems_events table caused the replication run to raise an internal error while trying to get table information. The error was not properly handled and that prevented a timeout from being reset. This caused the timeout error seen in the output and prevented the process from replicating any changes.


Consequence: Replication works after upgrade for a few dozen transactions and then stops and is unable to continue.

Fix: Add a script to remove out of date rubyrep triggers

Result:
errata-xmlrpc 2016-04-27 01:27:40 UTC Status MODIFIED ON_QA
John Prause 2016-04-27 01:28:46 UTC Fixed In Version 5.5.4.0
Suyog Sainkar 2016-05-03 02:32:43 UTC CC ssainkar
Doc Text Cause: ems_events table was renamed to event_streams in 4.0. The migration that did the rename did not remove the old trigger for ems_events. Because of this the trigger stayed with the new event_streams table after the rename. In addition, the correct trigger was added for the new table name, as it should. This caused pending changes records to be created for both the old table and the new table names when a change occurred to event_streams.

The existence of the pending change entries for the removed ems_events table caused the replication run to raise an internal error while trying to get table information. The error was not properly handled and that prevented a timeout from being reset. This caused the timeout error seen in the output and prevented the process from replicating any changes.


Consequence: Replication works after upgrade for a few dozen transactions and then stops and is unable to continue.

Fix: Add a script to remove out of date rubyrep triggers

Result:
Previously, after upgrading CloudForms Management Engine from 5.4.x to 5.5.3.2, replication worked only for a few transactions but then stopped and was unable to continue.

This was caused because ems_events table was renamed to event_streams in 4.0. The migration that did the rename did not remove the old trigger for ems_events. Due to this, the trigger stayed with the new event_streams table after the rename. In addition, the correct trigger was added for the new table name, as it should. This caused pending changes records to be created for both the old table and the new table names when a change occurred to event_streams.

The existence of the pending change entries for the removed ems_events table caused the replication run to raise an internal error while trying to get table information. The error was not properly handled and that prevented a timeout from being reset. This caused the timeout error seen in the output and prevented the process from replicating any changes.

With this release, a script to remove out of date rubyrep triggers was added and the issue is now resolved.
luke couzens 2016-05-06 17:46:23 UTC Status ON_QA ON_DEV
CC lcouzens
QA Contact jkrocil lcouzens
Gregg Tanzillo 2016-05-09 19:35:18 UTC Flags needinfo?(lcouzens)
luke couzens 2016-05-10 07:44:25 UTC Flags needinfo?(lcouzens)
Nick Carboni 2016-05-11 16:46:01 UTC Flags needinfo?(gtanzill)
Gregg Tanzillo 2016-05-11 18:32:20 UTC Flags needinfo?(gtanzill)
Nick Carboni 2016-05-12 12:49:49 UTC Flags needinfo?(mfeifer)
Marianne Feifer 2016-05-13 14:55:57 UTC Flags needinfo?(mfeifer)
Gregg Tanzillo 2016-05-13 16:31:24 UTC Blocks 1335968
John Prause 2016-05-13 17:11:28 UTC Status ON_DEV ON_QA
Gregg Tanzillo 2016-05-17 21:13:29 UTC Flags needinfo?(lcouzens)
luke couzens 2016-05-19 16:26:20 UTC Status ON_QA VERIFIED
Flags needinfo?(lcouzens)
errata-xmlrpc 2016-05-31 03:01:06 UTC Status VERIFIED RELEASE_PENDING
errata-xmlrpc 2016-05-31 13:42:16 UTC Status RELEASE_PENDING CLOSED
Resolution --- ERRATA
Last Closed 2016-05-31 09:42:16 UTC

Back to bug 1324991