Reconcile hangs for want of data and there is no test table to force transactions on source datab (4330949)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Reconcile hangs for want of data and there is no test table to force transactions on source datab
Beschreibung

If running a reconcile, the process sp_oreconcile will wait for user activity on source to push a message in the queue that is from a redolog higher than the one up to which the queue is reconciled. Till it happens, the sp_ctrl may appear to be in a hung state. This may add to the maintenance time.
Ursache

Reconcile hung for want of data
Lösung

Normally one can wait for user activity on source database for reconcile to receive the desired message from next redolog and finish normally. However, at times this may involve long wait. If there are test tables in replication, one can always force a transaction on source database. If there are none, then as a workaround, one can issue a flush from source sp_ctrl as follows:

sp_ctrl>flush o.SID

The flush will generate a message in Shareplex queues (due to Shareplex writing in redolog) that will make reconcile exit so that other maintenance activities can be performed.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: SharePlex
5.3.2, 5.3.3, 5.3, 5.3.1, 5.1.7, 5.2, 5.1.6, 5.1.5, 5.1.4, 5.1.3, 5.1.2, 5.1, 5.1.1, 5.0, 4.5.14, 4.5.13, 5.0.1, 5.2.0, 4.5.12, 4.5.11, 4.5.10, 4.5.9, 4.5.8, 4.5.7, 4.0.17.1, 4.0.16.16, 4.5.6, 4.5.5, 4.0.16.15, 4.0.16.14, 4.6.0, 4.5.4, 4.5.3, 5.0.0, 4.0.16.12, 4.0.16.11, 4.5.2, 4.5.1, 4.0.16.8, 4.0.16.5, 3.2.12.21, 3.2.12.19, 4.0.16.3, 3.2.12.18, 4.0.16, 3.2.12.6, 3.2.12.5, 3.2.12.16, 3.2.12.13, 3.2.12.9, 3.2.12.4, 4.0.16.1, 3.2.12.15, 3.2.12.11, 3.2.12.8, 3.2.12.3, 3.2.12.14, 3.2.12.12, 3.2.12.10, 3.2.12.7, 3.2.12.2, 3.2.12.1, 3.2.12, 4.5, 4.0, 3.2

Titel