ER /checksum failures
Posted in 2006
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)