IDS Forum

Re: ER:cdr sync stops whith 528: Maximum output ro

Posted By: Richard Snoke
Date: Monday, 10 October 2011, at 10:13 a.m.

In Response To: ER:cdr sync stops whith 528: Maximum output rowsiz (GERARDO PADIERNA)

Hi,

This has nothing to do with ulimit. The row size is the sum of the sizes
of the columns in the row in the table in the database. It may also be
the sum of the sizes of the columns in what a query returns if the query
draws data from more than one table. Based on your message, it sounds
like you have a table defined with rows that may be too large. One
possible cause is variable length character columns when enough of them
get larger than usual. If a row is too large, Informix refuses to build
the table, and that is what the error message is telling you. You'll have
to either change the table definition or the query used in defining the
replicate. Can you share the replicate definition and associated table
definitions?

Cheers,
Dick Snoke
Executive IT Specialist
IBM - Channel Works
(404) 487-1595
dsnoke@us.ibm.com

From: "GERARDO PADIERNA" <g.padierna@gmail.com>
To: ids@iiug.org
Date: 10/10/11 08:59 AM
Subject: ER:cdr sync stops whith 528: Maximum output rowsiz [25156]
Sent by: ids-bounces@iiug.org

Hi,
I'm trying to do an initial sync of 2 datatabases whith ER, but I'm
getting
this error after a while when I launch (on the 'primary' server):
cdr check replset -c <secondary> -m <primary> -s templ_oc_pks <secondary>

and I get this error:

Error Details:

528: Maximum output rowsize (32767) exceeded.

Current Connection:conn5, Database:orion_clinic@g_prim
command failed -- SQL failure (195)

Previously I issued a 'cdr sync template' and I got the same error. And
for
some reason 'cdr realize template ...' didn't synchronize the 2 databases
well, but without an error.

I've tried several things like setting ulimit higher (by pure chance, I
had
the ulimit for nofiles set to 32727), and changing CDR_QUEUEUMEM higher,
but
that doesn't work.
I've googled around and found that the 32767 is a hard limit in IDS, and
that
in those cases it's advised to change the logic of your query, but in this

case, how can I avoid this limit? (honestly, I don't really understand
what
that limit means).

Some additional infor:
IDS verions: 11.70FC2
OS: linux (Ubuntu 11.04)

If you need some more info, please ask.

Thanks.

Cheers.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• ER:cdr sync stops whith 528: Maximum output rowsiz
  GERARDO PADIERNA -- Monday, 10 October 2011, at 8:58 a.m.
  • Re: ER:cdr sync stops whith 528: Maximum output ro
    Richard Snoke -- Monday, 10 October 2011, at 10:13 a.m.
    • Re: ER:cdr sync stops whith 528: Maximum output ro
      GERARDO PADIERNA -- Monday, 10 October 2011, at 10:51 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.