From: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Re: ERROR: invalid memory alloc request size
Date: Mon, 14 May 2007 17:13:25 +0200
Message-ID: <20070514151325.GB30367@sun.ac.za> (raw)
In-Reply-To: <11217.1179153258@sss.pgh.pa.us>
References: <20070514131318.GA26537@sun.ac.za>
<11217.1179153258@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jspies@sun.ac.za
Subject: Re: ERROR: invalid memory alloc request size
In-Reply-To: <20070514151325.GB30367@sun.ac.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox