Tuple is too big: size 9104, max size 8128

Started by Noel Cornejoabout 22 years ago2 messagesbugs
Jump to latest
#1Noel Cornejo
ncornejo@elsendero.es

Hi, problems with the length of text type : "Tuple is too big: size 9104, max
size 8128"

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

type Exception report

message

description The server encountered an internal error () that prevented it from
fulfilling this request.

exception

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

at
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at
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
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPi....

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

..any idea and possible solutions ?? Thanks!

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noel Cornejo (#1)
Re: Tuple is too big: size 9104, max size 8128

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