-
Title
Post slow due to frequent logging of “No conflict resolution available” -
Description
Post is slow and the following entries are logged very frequently in event_log:
Warning 2016-08-18 01:13:31.333416 4006 893086016 s:6 Poster: que/seq = 6/ 395247600 seqno/offset = 3743/68745936 Table "owner.tablename" is out-of-sync. No conflict resolution available (posting from source_SID, queue queue_name, to target_SID) [module opo]
Warning 2016-08-18 01:13:31.348457 4006 893086016 s:6 Poster: que/seq = 6/ 395248038 seqno/offset = 3743/68746484 Table "owner.tablename" is out-of-sync. No conflict resolution available (posting from source_SID, queue queue_name, to target_SID) [module opo]
The “trace post” is run on the Post queue which indicates that the execution rate of the SQL in the database is healthy and there are no other issues with Post such as time spent in queues or time spent in COMMIT.
-
Cause
The frequent logging of lack of conflict resolution is causing slowness. -
Resolution
Correct the anomaly in conflict resolution on target by:
1. sp_ctrl>stop post [queue queue_name]
2. Go to the /vardir/data directory (where vardir refers to SharePlex variable directory) and either remove references to the problem object from the conflict.SID file (where SID stands for target database’s SID) or correct the conflict resolution procedure associated with the problem object.
3. sp_ctrl>start post
-
Additional Information
For details on the trace command please refer to SharePlex Reference Guide. For details on conflict resolution, please refer to SharePlex Administrator Guide.