Hi Eric,
whole 'cdr sync' runs with a (hardcoded) "set lock mode to wait 30" after which e.g. said "select count(*) from <table_to_sync>" would fail with
Error returned from scanReplNWayMatchMerge: Execute statement: select count(*) from "owner".tabname
SQLCODE -252 ISAM -154
Error Details:
252: Cannot open file 'csql.iem'.
154: Cannot open file 'cisam.iem'.
Current Connection:conn4, Database:db@er_node
command failed -- SQL failure (195)
... for which "crashing", imho, would sound a tad too ugly ;-)
HTH,
Andreas
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Thu July 01, 2021 11:26 AM
From: Eric Vercelletto
Subject: ER CDR SYNC: cdr sync does not start due to some locks in the to be replicated table: any way to set some dirty read sync ?
Hi all
I am despererately trying to cdr sync a few tables from one instance to another.
Most of replicates work fine, but a few of them have some locks in the table, that prevent the initial "select count(*) from table" statement fired by cdr sync to run successfully, therefore crashing the cdr sync command .
this select count(*) is execute in the scanRepl1NWayMatchMerge function ...
this is 12.10 FC14
Is there any undocumented option of cdr sync that can pass this select count(*) in dirty read, on any tricky way ?
Or just way for locks to be gone (maybe some day ? )
Thanks for your lights
Eric
------------------------------
[eric] [Vercelletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
------------------------------
#Informix