Enterprise replication can not sync data
Answered: amber (hollow confidence) — The asker found a deleted ATS directory, recreated it and redefined the replication, which fixed it, but Andreas Legner doubts the missing directory explains the replmap error.
Advisory only.
Posted in 2022
Topics: High Availability & Replication, Error Codes & Troubleshooting
when I create an replication,the data can sync;but wait one or two days,the replication will stop。 SERVER and replication status is oK. online.log: can not get replmap for replicate 2687022 CDR CDRDS:transaction abort(Error in retrieving the replicate's attributes) with SQL error 0 isam error 0. failed to perform quality of data operation,failed to count row for abort transaction ------------------------------ ZhiWei Cui GBASE ------------------------------ #Informix
cdr list server is OK cdr list repl is OK I find Someone deleted atsdir mkdir $atsdir cdr del repl ... cdr del server ... cdr define server ... cdr define rep ... all is OK ------------------------------ ZhiWei Cui GBASE ------------------------------
In my view, a missing ats/ris directory should not cause "can not get replmap" errors. I'd rather assume some replicate definition lost on one side, so data arriving from a remote server for a replicate that isn't present (or isn't intact) any more on the local server. ------------------------------ Andreas Legner ------------------------------