APAR status
Closed as program error.
Error description
The cdc api demo program errors with the following errors: Got Record type CDC_REC_ERROR. Size = 0 bytesread is -1 loreaderr is -9810 SQLCODE -9810 cdcapi: loreaderr -9810 SQLCODE -9810 cdcapi: ifx_lo_read loreaderr -9810 SQLCODE -9810 CDC_ENDCAPTURE of 'cdc_test:informix.t1' on session 21495847 CDC API 'cdc_endcapture' Failed at cdcapi.ec:1294. CDCAPI_RETVAL = -83792, CDC_ERRORCODE = CDC_E_MUSTCLOSE CDC Error Description is The CDC capture session cannot continue and must be closed. The table t1 was created using a varchar column and then the table was compressed. In the onlog data for the rowid that cdc is having a problem with you would see the following log record sequence: addr len type xid id link b5f4 92 HUPBEF 20 0 b564 1001e1 139 25 5c000000 00002a00 12010000 00000000 \.....*. ........ 00000000 00000000 14000000 64b50000 ........ ....d... 88200600 e1011000 e1011000 39010000 . ...... ....9... 19400000 00000000 00000000 36746173 .@...... ....6tas 02120040 0c701400 e0010110 0c00e003 ...@.p.. ........ b0b33745 80ed0c01 02000000 ..7E.... .... b650 68 HUPAFT 20 0 b5f4 1001e1 139 4 139 44000000 00002b00 10010000 00000000 D.....+. ........ 00000000 00000000 14000000 f4b50000 ........ ........ 88200600 e1011000 e1011000 39010000 . ...... ....9... 04c00000 00000000 00000000 36746173 ........ ....6tas 00000139 ...9 b694 72 HUPBEF 20 0 b650 1001e1 139 4 48000000 00002a00 10014800 00000000 H.....*. ..H..... 00000000 00000000 14000000 50b60000 ........ ....P... 88200600 e1011000 e1011000 39010000 . ...... ....9... 04000000 00000000 09000000 50b60000 ........ ....P... 00000139 00000000 ...9.... b6dc 68 HUPAFT 20 0 b694 1001e1 139 4 44000000 00002b00 10010800 00000000 D.....+. ........ 00000000 00000000 14000000 94b60000 ........ ........ 88200600 e1011000 e1011000 39010000 . ...... ....9... 04000000 00000000 00000000 50b60000 ........ ....P... 00000139 ...9 b720 68 CKPOINT 1 9 0 1 begin xid id addr user 9 20 9 b6dc informix d018 144 RINSERT 20 0 b6dc 1001e1 812 79 90000000 00002c00 12010000 00000000 ......,. ........ 00000000 00000000 14000000 dcb60000 ........ ........ 97200600 e1011000 e1011000 12080000 . ...... ........ 4f000004 39010000 00000000 50b60000 O...9... ....P... 02120040 0c701400 e0010110 0c00e003 ...@.p.. ........ b0b33745 80ed0c00 3c107062 06206206 ..7E.... <.pb. b. 20621070 62062062 06206210 70620620 b.pb. b . b.pb. 62062062 10706206 20620620 62107062 b. b.pb. b. b.pb 06206206 20621070 62062062 06206204 . b. b.p b. b. b. When a home row (of a row containing varchar) has to be moved to a new page because the varchar column expanded and there isn't enough room on the current page to contain the new row, we store the rowid of the new page at the current row location. That part would normally be the HUPBEF/HUPAFT with the length of the HUPAFT being 4 (the size of a rowid). However, if a checkpoint happens during that process, as in the above onlog output, you see the 2nd set of HUPBEF/HUPAFT, the 2nd pair has a length of 4 for both the before and after. Then after that, you see the RINSERT which occurs after the checkpoint record. If this sequence happens on a table using compression, cdc can't handle it and it errors out as described.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IDS-11.70.xC9 * ****************************************************************
Problem conclusion
Problem Fixed In IDS-11.70.xC9
Temporary fix
Comments
APAR Information
APAR number
IC98843
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-01-20
Closed date
2017-06-09
Last modified date
2017-06-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
RA10 PSN
UP
RA10 PSY
UP
RB10 PSN
UP
RB10 PSY
UP
RB50 PSN
UP
RB50 PSY
UP
RB70 PSN
UP
RB70 PSY
UP
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 June 2017