OGG-01232 Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint:-优快云博客

本文记录了使用 GoldenGate 进行数据同步时遇到的 TCP/IP 错误 104 (连接被对方重置)，并提供了通过前滚文件和产生新文件点来解决该问题的步骤。同时，文章还提供了详细的错误日志解析和解决过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

源端:

2015-02-05 17:45:49 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/home/ggt/goldengate/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

2015-02-05 17:45:59 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).

Source Context :
SourceModule : [er.extrout]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/extrout.c]
SourceFunction : [complete_tcp_msg]
SourceLine : [1420]
ThreadBacktrace : [9] elements
: [/home/ggt/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b15d939c8be]]
: [/home/ggt/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x2b15d939585c]]
: [/home/ggt/goldengate/libgglog.so(_MSG_ERR_TCP_RECEIVE_PARAMS_ERROR(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2b15d937da2b]]
: [/home/ggt/goldengate/extract(complete_tcp_msg(extract_def*)+0x72c) [0x51b5f0]]
: [/home/ggt/goldengate/extract(flush_tcp(extract_def*, int)+0x22b) [0x51bbd7]]
: [/home/ggt/goldengate/extract(RECOVERY_initialize()+0x371) [0x52d121]]
: [/home/ggt/goldengate/extract(main+0x4a5) [0x575d95]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x37cdc1d994]]
: [/home/ggt/goldengate/extract(__gxx_personality_v0+0x39a) [0x4efa8a]]

2015-02-05 17:46:03 ERROR OGG-01232 Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: 10.128.133.220:7800.

2015-02-05 17:46:03 ERROR OGG-01668 PROCESS ABENDING.

目标端:

2015-02-05 17:40:00 ERROR OGG-01028 Incompatible record (104) in .\dirdat\yl01\re030734, rba 14136614 (getting header).

解决方法:

把源端投递进程前滚一个文件,产生一个新的文件点

info PUPYL01

alter extract PUPYL01, etrollover