Discussion:
cdr check -R says replicate is not active, when it is
(too old to reply)
Laurie Gustin
2013-09-19 18:44:58 UTC
Permalink
Im trying to sync data using cdr check -R. The command fails indicating
the replicate is not active. The output from cdr list repl says it IS
active. (see outputs below).

Any clues?

IDS11.7
Linux

Thanks
Laurie

*$ cdr check repl -R -m g_ct -r prod_protective_orders_kase g_pscourts
g_pscourtsrf*
SYNC:Replicate prod_protective_orders_kase is not active
prod_protective_orders_kase at node g_pscourtsrfThe specified replicate is
not in an active state on the master node.
Perform the following actions and then run the above repair command again:
1. Use the \"cdr list repl\" command to check the current state
of the replicate.
2. Make the replicate active:
- If the replicate is stopped, then use the \"cdr start
repl\"
command to start it.
- If the replicate is suspended, then use the \"cdr resume
repl\"
command to resume it.
command failed -- Sync attempted on replicate which is not active (176)



$* cdr list repl -c g_pscourts prod_protective_orders_kase*

DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_pscourts
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_orders:informix.kase
OPTIONS: row,ris,ats,fullrow
REPLID: 5964060 / 0x5b011c
REPLMODE: READ-ONLY ON:g_pscourts
APPLY-AS: INFORMIX ON:g_pscourts
REPLTYPE: Master

*$ cdr list repl -c g_pscourtsrf prod_protective_orders_kase*

DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_pscourtsrf
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_orders:informix.kase
OPTIONS: row,ris,ats,fullrow
REPLID: 5964060 / 0x5b011c
REPLMODE: READ-ONLY ON:g_pscourtsrf
APPLY-AS: INFORMIX ON:g_pscourtsrf
REPLTYPE: Master

*$ cdr list repl -c g_ct prod_protective_orders_kase*

DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_ct
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_order_er:informix.kase
OPTIONS: transaction,ris,ats,fullrow
REPLID: 1179735 / 0x120057
REPLMODE: PRIMARY ON:g_ct
APPLY-AS: INFORMIX ON:g_ct
REPLTYPE: Master
Laurie Gustin
2013-09-19 20:41:49 UTC
Permalink
Ah - so it turns out that there were some rogue 'sync'/shadow replicates on
one of the servers. I cleared them out... stop start, several times,
delete define... anyway - it is working now.

Laurie
Post by Laurie Gustin
Im trying to sync data using cdr check -R. The command fails indicating
the replicate is not active. The output from cdr list repl says it IS
active. (see outputs below).
Any clues?
IDS11.7
Linux
Thanks
Laurie
*$ cdr check repl -R -m g_ct -r prod_protective_orders_kase g_pscourts
g_pscourtsrf*
SYNC:Replicate prod_protective_orders_kase is not active
prod_protective_orders_kase at node g_pscourtsrfThe specified replicate is
not in an active state on the master node.
1. Use the \"cdr list repl\" command to check the current state
of the replicate.
- If the replicate is stopped, then use the \"cdr start
repl\"
command to start it.
- If the replicate is suspended, then use the \"cdr resume
repl\"
command to resume it.
command failed -- Sync attempted on replicate which is not active (176)
$* cdr list repl -c g_pscourts prod_protective_orders_kase*
DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_pscourts
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_orders:informix.kase
OPTIONS: row,ris,ats,fullrow
REPLID: 5964060 / 0x5b011c
REPLMODE: READ-ONLY ON:g_pscourts
APPLY-AS: INFORMIX ON:g_pscourts
REPLTYPE: Master
*$ cdr list repl -c g_pscourtsrf prod_protective_orders_kase*
DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_pscourtsrf
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_orders:informix.kase
OPTIONS: row,ris,ats,fullrow
REPLID: 5964060 / 0x5b011c
REPLMODE: READ-ONLY ON:g_pscourtsrf
APPLY-AS: INFORMIX ON:g_pscourtsrf
REPLTYPE: Master
*$ cdr list repl -c g_ct prod_protective_orders_kase*
DEFINED REPLICATES ATTRIBUTES
------------------------------
REPLICATE: prod_protective_orders_kase
STATE: Active ON:g_ct
CONFLICT: Ignore
FREQUENCY: immediate
QUEUE SIZE: 0
PARTICIPANT: protective_order_er:informix.kase
OPTIONS: transaction,ris,ats,fullrow
REPLID: 1179735 / 0x120057
REPLMODE: PRIMARY ON:g_ct
APPLY-AS: INFORMIX ON:g_ct
REPLTYPE: Master
Loading...