Reader exits with "tca_write failed" in event_log. The read process goes idle after encountering full rollbacks in capture queue.
Event_log:
Error 2010-12-22 11:31:59.908852 19289 4140820160 Reader: Bad address 11057 - write failed (from {source sid}) [module ord]
Notice 2010-12-22 11:31:59.909866 19289 4140820160 Reader: tca_write failed. Exiting. (from {source sid}) [module ord]
Info 2010-12-22 11:31:59.924380 22247 4141033152 Reader exited with code=1, pid = 19289 (from {source sid})
Reading the capture queue, the following message is seen:
Sque -2, qseq 12384, NA, 1212/11360588, transid 0, ROLLBACK OOB Full Rollback, AAAAAAAAAAAAAAAAAA , SCN 5678988762526, forward = 0
Issue with read rollback logic inside the tcache.
WORKAROUND:
1. Read release full rollback in subqueue -2 (Contact SharePlex Technical Support)
2. Re-name tcache files in the $SP_SYS_VARDIR/state directory (*tcache.a* and *tcache.b*)
3. Start read
STATUS:
Fixed in 7.5.2.50 and above
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center