Re: ERROR: invalid memory alloc request size

[Johann Spies <jspies(at)sun(dot)ac(dot)za>]

On Mon, May 14, 2007 at 10:34:18AM -0400, Tom Lane wrote:
> Johann Spies <jspies(at)sun(dot)ac(dot)za> writes:
> > I am using postgresql 8.1 on Debian Stable.
> 
> 8.1.what?

Sorry.  The version is 8.1.8-1
> 
> > psql:laai_squid_logs:4: ERROR:  invalid memory alloc request size 1350958157
> > CONTEXT:  COPY squidlogs, line 238780099
> 
> Is this repeatable? 

Yes.

> Is it always the same line and same bogus request size?
> 

Yes - the same line.  I am not 100% certain that it is the same bogus
request size.  I will test it overnight again. It takes a long time.

> If Postgres was built with debug symbols it would be useful to get a
> stack trace to try to figure out more about what's happening.  If you
> want to try that, attach to the backend with gdb while the COPY is
> running, then do
> 
> 	$ gdb /path/to/postgres PID-of-backend
> 	gdb> b errfinish
> 	gdb> cont
> 	... wait for breakpoint to be hit ...
> 	gdb> bt
> 	gdb> q
> 	answer 'y' to ok-to-detach prompt
> 

Unfortunately gdb reports "no debugging symbols found".  I will try and
recompile postgresql with debugging symbols and try again.

Thanks.

Johann
-- 
Johann Spies          Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch

     "Yea, though I walk through the valley of the shadow of
      death, I will fear no evil, for thou art with me; 
      thy rod and thy staff they comfort me."  Psalms 23:4