Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tuple is too big: size 9104, max size 8128

Tuple is too big: size 9104, max size 8128

From
Noel Cornejo
Date:
Hi, problems with the length of text type : "Tuple is too big: size 9104, m=
ax=20
size 8128"


***************************************************************************=
***********************************************************

type Exception report

message

description The server encountered an internal error () that prevented it f=
rom=20
fulfilling this request.

exception

javax.servlet.ServletException: java.lang.Exception: java.sql.SQLException:=
=20
ERROR:  Tuple is too big: size 9104, max size 8128

        at=20
org.apache.struts.action.RequestProcessor.processException(RequestProcessor=
.java:545)
        at=20
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProce=
ssor.java:486)
        at=20
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at=20
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at=20
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at=20
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio=
nFilterChain.java:247)
        at=20
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC=
hain.java:193)
        at=20
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j=
ava:256)
        at=20
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
keNext(StandardPipeline.java:643)
        at=20
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at=20
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at=20
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j=
ava:191)
        at=20
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
keNext(StandardPipeline.java:643)
        at=20
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at=20
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at=20
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
        at=20
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:18=
0)
        at=20
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
keNext(StandardPipeline.java:643)
        at=20
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve=
.java:171)
        at=20
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invo=
keNext(StandardPi....



***************************************************************************=
***************************************************************************=
******************


..any idea and possible solutions ?? Thanks!=20

Re: Tuple is too big: size 9104, max size 8128

From
Tom Lane
Date:
Noel Cornejo <ncornejo@elsendero.es> writes:
> Hi, problems with the length of text type : "Tuple is too big: size 9104, max
> size 8128"

Uh ... what Postgres version are you using?  This sounds like you must
have a pre-7.1 server.

> ..any idea and possible solutions ?? Thanks!

Update to something current (7.3.5 or 7.4.1 would be my recommendation).

            regards, tom lane