-
Title
Compare fails with Error while waiting for lock file for second rc point -
Description
The following error messages are observed in target compare log (declt log) when a repair fails:
declt 2014-12-09 22:24:37.938099 55509122 1 Current status: ready to fetch batch,of rows; including the order by sorting.
declt 2014-12-09 22:24:49.360061 55509122 1 Current status: got batch of rows
declt 2014-12-09 22:31:27.765692 55509122 1 NOTE: total number of rows fetched = 9623450 (../src/deqtr/de_select.cpp,L1709)
declt 2014-12-09 22:31:27.780346 55509122 1 Notice: starting the second phase in the repair process
declt 2014-12-09 22:31:28.031046 55509122 1 Leaving de_msg_clt_preCompareMessaging1_5,L1152
declt 2014-12-09 22:31:58.037217 55509122 1 send alive, timeout=1860, remain=1830 (sp_declt_wait_for_lockfile,L1078)
declt 2014-12-09 23:03:04.187626 55509122 1 Error: broken pipe (sp_declt_wait_for_lockfile,L1083)
declt 2014-12-09 23:03:05.068798 55509122 1 Error while waiting for lock file for second rc point (after 1860 seconds): (main,L2197)
declt 2014-12-09 23:03:05.068818 55509122 1 Status : Error
declt 2014-12-09 23:03:05.068829 55509122 1 Exiting....
-
Cause
The compare client process on target is not able to lock the target table in pass 2. -
Resolution
As a workaround, use the following option in repair command to make it a one pass process and avoid locking issues:
For versions 7.6.3 and lower (use repair1 option):
compare table owner.source_table to owner.target_table target <target_server_name>@o.targetSID repair1
For versions 8.0 and higher (use onepass option):
repair owner.source_table to owner.target_table at <target_server_name>@o.targetSID onepass
Note that in older versions the option is termed repair1 and in the newer versions (8.0 and up) it is termed onepass.
The commands shown above are examples and your command may include multiple targets and other command options.
Normally the repair is a two pass process. In the first pass the source and target tables are compared, the SQL needed to be applied to fix the out of sync are formulated, and in the second pass the repair phase is done. The target table is locked during the repair phase. In a one pass compare, the target rows are repaired as and when compare finds them.