CDC: Log Seq: Page out of seq error

Posted in 2016

RONALD OLAVIDEZ — Fri, 12 Feb 2016 03:26:44 — source: IIUG Forums & Mailing Lists

Hi Informix DBAs, Is there any way i can I fix the problem below? i'm running cdc aka change data capture on IDS11.7 and AIX 7.2. error: 02/12/16 12:38:04 CDC: Log Seq: Page out-of-seq error [got page 572048:c7fd, cur page 572048:c5] 02/12/16 12:38:04 CDC: Log Seq: Page out-of-seq error [got page 572048:c7fe, cur page 572048:c5] 02/12/16 12:38:04 CDC: Log Seq: Page out-of-seq error [got page 572048:c7fe, cur page 572048:c5] 02/12/16 12:38:04 CDC: Log Seq: Page out-of-seq error [got page 572048:c7ff, cur page 572048:c5] 02/12/16 12:38:04 CDC: Log Seq: Page out-of-seq error [got page 572048:c7ff, cur page 572048:c5] 02/12/16 12:38:33 CDC: Log Reader ended. CDC session id 1661992999. SQL session id 35938. 02/12/16 12:38:37 CDC: A capture session ended abnormally. See also /dump/cdcras_1455246517.1661992999_0x700002797794028 this is the content of the file /dump/cdcras_1455246517.1661992999_0x700002797794028. CDC session id: 1661992999 Global flags:DATALOST Total events registered: 6 Total events spilled: 0 Individual events (newest first): Event at 700002797795400 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10000 (SURVIVED) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_LPGSRC_OL Registered at snoop/snoopxformsubclass.c:1378 Event at 700002797795148 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10001 (DATALOST) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_LHT_EXTRACTOR Registered at snoop/snoopxformsubclass.c:2141 Event at 700002797794e90 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10000 (SURVIVED) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_LHT_ASSEMBLER Registered at snoop/snoopxformsubclass.c:3142 Event at 700002797794bd8 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10001 (DATALOST) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_IUD_PRESENTER Registered at snoop/snoopxformsubclass.c:3971 Event at 700002797794920 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10000 (SURVIVED) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_DM_PACKETIZER Registered at snoop/snoopxformsubclass.c:4328 Event at 700002797794668 ErrorEvent_t Error type: -19 (SNOEShutDown) Error UTC time: 1455246513 (Fri Feb 12 12:38:33 2016) Data sequence number: 0x0 Error flags:0x10000 (SURVIVED) Error message: none Registered by SNOOPCOMP_SBT_SUBCLASS_RINGBUF Registered at snoop/snoopxformsubclass.c:690