Hello guys,When configuring loopback replication, the following error appears:command failed -- remote/cyclic synchronization not allowed (64)Verification of test@informix1410_grp:informix.t1 started
Verification of test@informix1410_grp:informix.t1 is successful
Verification of test@g_loopback:informix.t1 started
Verification of test@g_loopback:informix.t1 is successful
command failed -- undefined server (37)participant test@g_loopback:informix.t1 'select t.c1, t.c2 from t1 t '
These are the comands I execute:cdr define server -I g_loopback
cdr define repl --connect=informix1410_grp rep1 -C always -S row -A -R --master=informix1410_grp --splname=logger4repl2spl "P test@informix1410_grp:informix.t1" "select * from t1" "R test@g_loopback:informix.t1" "select * from t1"
Don't know if defining pseudo ER group is correct !!$INFORMIXSQLHOSTS:ol_informix1210 onsoctcp informix.aldextra.com ol_informix1210
informix1410_grp group - - i=139
ol_informix1410 onsoctcp informix14.aldextra.com ol_informix1410 g=informix1410_grp
dr_informix1410 drsoctcp informix14.aldextra.com dr_informix1410 g=informix1410_grp
lo_informix1410 onsoctcp 127.0.0.1 lo_informix1410 g=informix1410_grp
g_loopback group - - i=150loopback onsoctcp informix14.aldextra.com 17002 g=g_loopbackencrypt onsoctcp informix14.aldextra.com 9043
demo_on_grp group - - i=140
demo_on onsoctcp informixva 9088 g=demo_on_grp
migrado_grp group - - i=141
migrado onsoctcp informix14.aldextra.com 9042 g=migrado_grp
SPL definition:create database test with log;
create table t1 (c1 int , c2 int);
create table t1log (optype int, srcdir int, committime int, txnid bigint, c1bef int, c2bef int, c1 int, c2 int);
create procedure logger4repl2spl (opType char(1), srcid integer, committime integer, txnid bigint, c1bef integer, c2bef int, c1 integer, c2 int)
insert into t1log values (opType, srcid, committime, txnid, c1bef, c2bef, c1, c2);
end procedure;
Any help/comments would be very much appreciate.
------------------------------
juan luis roca
------------------------------
#Informix