Re: Enterprise Replication error when attempting to delete a replicate

Bugs, bugs and more bugs, IMHO. Did you recently try to use the alter facilities that ER now provides? If so according to tech support it is riddled with bugs prior to 10.00.FC5. I was told to destroy my ER environment and rebuild it from scratch when the shadow tables would not clear themselves up. I assume you'll have to do the same. ----- Original Message ---- From: Bogdan Botez <bmbogdan@gmail.com> To: informix-list@iiug.org; Madison Pruet <mpruet@comcast.net> Sent: Tuesday, August 1, 2006 5:41:03 AM Subject: Enterprise Replication error when attempting to delete a replicate Hello, When attempting to delete a replicate, the following error is raised: $ cdr del repl r_bln_db_b0400_db_sk57command failed -- Attempt to perform invalid operation including shadow replicates (122) Additional info: ----- onstat - IBM Informix Dynamic Server Version 10.00.FC4 ----- The server is an AIX 5.3 ML04. ----- No error message in online.log. No error message from "cdr error ". There are no locks on the replicated table (source table/destination table). ----- $ cdr list repl r_bln_db_b0400_db_sk57 DEFINED REPLICATES ATTRIBUTES ------------------------------ REPLICATE: r_bln_db_b0400_db_sk57 STATE: Inactive ON:g_sk57 CONFLICT: Ignore FREQUENCY: immediate QUEUE SIZE: 0 PARTICIPANT: b0400_db:ibanks.bln_db OPTIONS: transaction,ris,ats REPLID: 33227027 / 0x1fb0113 REPLMODE: PRIMARY ON:g_sk57 APPLY-AS: INFORMIX ON:g_sk57 REPLTYPE: Master cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_sk57 507 Active Local 0 g_sk67 607 Active Connected 1728 Aug 1 13:19:10 Repeating the cdr list server after attempting to delete the replicate again: cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_sk57 507 Active Local 0 g_sk67 607 Active Connected 1860 Aug 1 13:19:10 Checking the network threads on both servers (onstat -g ntt | grep -i cdr): 70000005135aa70 CDRNsT607 4884 13:19:10 13:35:10 13:35:11 700000052342d20 cdraccept 1101 13:19:11 13:35:11 13:35:11 cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_sk57 507 Active Local 0 g_sk67 607 Active Connected 2256 Aug 1 13:19:10 Again we can see the increased queue size for g_sk67, even if it reports communication on the cdr network threads. Any ideas? Regards, Bogdan BOTEZ. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list