When running compare, the following errors are observed in target event_log:
07/30/07 04:00 Internal error: Error: Unable to remove lock file, /ngrodb/splexdata/state/sp_de_lock-default (sp_declt_cleanup_befor
e_exit, 844) [sp_declt(deq)/10089]
07/30/07 04:00 Internal error: Error 2: No such file or directory [sp_declt(deq)/10089]
07/30/07 04:00 Process exited sp_declt (for o.SID1-o.SID2-10615501446) [pid = 10089] - exit(0)
The compare hangs or errors out.
Exclusive lock during repair phase is causing issues.
The repair option in compare needs exclusive lock on the target table and at times this is not easy to acquire. Consequently the compare simply hangs or errors out. As a workaround, the compare can be re-run by either killing the hung compare, or in case the prior compare errored out, simply re-run it, preferably during quiet times.