|
Problem IT13819
|
Status: Closed |
CDR CHECK CAN FAIL WITH ERRNO -528 IF TABLE HAS BLOB OR SBLOB COLUMNS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The 'cdr check replicate/replset' command would fail with -528
(Maximum output rowsize (32767) exceeded.) if the replicated
table has too many blob (BYTE or TEXT) or sblob (BLOB or CLOB)
columns and other wide columns like LVARCHAR(32000).
This is what you would see:
Error returned from createStatement: prepare verbose_2 from
select from db@er_node:"owner".tabname t where
= ?
SQLCODE -528 ISAM 0
Error Details:
528: Maximum output rowsize (32767) exceeded.
Current Connection:conn4, Database:stores7@al12s
command failed -- SQL failure (195)
With listing all non-LOB columns and an
ifx_checksum(t.colname, NULL)::lvarchar construct for each LOB
column. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.02.2016
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
