Hi allI 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 FC14Is 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 lightsEric
Error returned from scanReplNWayMatchMerge: Execute statement: select count(*) from "owner".tabname
SQLCODE -252 ISAM -154
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
Crashing is maybe too hard terminology ��
The background issue is that, due to that, it is impossible to sync a replicate if there is 1 lock in the source table ... This would imply a production stop ( even for one minute or less ) so that the select count(*) can be executed.
Are there any addition queries on the source table after that select count(*) or does it go ALL thru logical logs processing ?
Customer is not happy ...
Ashok and Andreas:
Target tables have been truncated previously ...
It seems that it is necessary to obtain a lock at the beginning of the operation, so starting it with no current transactions on the source table seems to be a must, at least for a few seconds
And thanks for your input ��
Have a great week end
Eric VercellettoData Management Architect and Owner / Begooden IT ConsultingKandooERP Founder and CTOIBM Champion 2013,2014,2015,2016,2017,2018,2019,2020
Tel: +33(0) 298 51 3210Mob : +33(0)626 52 50 68skype: begooden-itGoogle Hangout: email@example.comEmail: firstname.lastname@example.org : http://www.vercelletto.comwww https://kandooerp.org