Date: Mon, 14 May 2007 17:13:25 +0200
From: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Re: ERROR: invalid memory alloc request size
Message-ID: <20070514151325.GB30367@sun.ac.za>
Mail-Followup-To: Johann Spies <jspies@sun.ac.za>, pgsql-admin@postgresql.org
References: <20070514131318.GA26537@sun.ac.za>
 <11217.1179153258@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <11217.1179153258@sss.pgh.pa.us>
User-Agent: Mutt/1.5.13 (2006-08-11)


On Mon, May 14, 2007 at 10:34:18AM -0400, Tom Lane wrote:
> Johann Spies <jspies@sun.ac.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