Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Checksum is producing the FOLLOWING errors below, does anyone have any idea
why it is happening?
Of the 92 replicates 7 fail to work with checksum.
3 fail with "ISAM error: deadlock detected" when running in repair mode
(-R).
These same 3 work just fine when run in check only mode.
4 fail with "Memory fault(coredump)"
============
Informix Version
============
IBM Informix Dynamic Server Version 10.00.UC4
============
Server
============
AIX 5.2 32 bit
============
For the 3 that fail with "deadlock error"
here is an example of running check sum in check only mode
============
$ time cdr check repl --all -m g_toltp -r chb_legacy_rel
------ Statistics for chb_legacy_rel ------
Node Rows Extra Missing Mismatch Processed
---------------- --------- --------- --------- --------- ---------
g_toltp 1542937 0 0 0 0
g_trptg 1542958 25 4 89 0
WARNING: replicate is not in sync
real 15m35.95s
user 0m17.90s
sys 0m1.37s
============
For the 3 that fail with "deadlock error"
here is an example of running check sum in repair mode
Notice how long before failure. Almost at the end.
============
$ time cdr check repl -R --all -m g_toltp -r chb_legacy_rel
------ Statistics for chb_legacy_rel ------
ERROR Code -243 Isam -143 File replcheck.ec Line 4429
fetch of cur_2632
Could not position within a table (%s).
ISAM error: deadlock detected
real 15m14.39s
user 0m17.15s
sys 0m1.83s
============
for the 4 that core dump
here is an example of running check sum in check only mode
============
$ time cdr check repl --all -m g_toltp -r quote_cvg
Error at line:4273 - Select index parts for sysadm.quote_cvg
***ABORTING***
repl-check.ksh[3]: 175450 Memory fault(coredump)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.