Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 2B6119FB36C
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 May 2007 11:47:01 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 58508-09 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 28 May 2007 11:46:49 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from lists.commandprompt.com (host-254.commandprompt.net
	[207.173.203.254])
	by postgresql.org (Postfix) with ESMTP id 086219FB2DE
	for <pgsql-admin@postgresql.org>; Mon, 28 May 2007 11:46:54 -0300 (ADT)
Received: from perhan.alvh.no-ip.org (201-221-217-243.bk12-dsl.surnet.cl
	[201.221.217.243]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l4SEksqe017544;
	Mon, 28 May 2007 07:46:54 -0700
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 5971932A15; Mon, 28 May 2007 10:46:51 -0400 (CLT)
Date: Mon, 28 May 2007 10:46:51 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Johann Spies <jspies@sun.ac.za>, pgsql-admin@postgresql.org
Subject: Re: ERROR: invalid memory alloc request size
Message-ID: <20070528144651.GA7795@alvh.no-ip.org>
References: <11217.1179153258@sss.pgh.pa.us>
	<20070515105042.GA8121@burger.sun.ac.za>
	<5221.1179337804@sss.pgh.pa.us> <20070517132033.GA9482@sun.ac.za>
	<25608.1179412804@sss.pgh.pa.us> <20070518122942.GA28931@sun.ac.za>
	<27574.1179501021@sss.pgh.pa.us> <20070521140718.GC10742@sun.ac.za>
	<10687.1179758440@sss.pgh.pa.us> <20070528134559.GC5615@sun.ac.za>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20070528134559.GC5615@sun.ac.za>
User-Agent: Mutt/1.5.13 (2006-08-11)
X-Virus-Scanned: ClamAV version 0.88.5,
	clamav-milter version 0.88.5 on projects.commandprompt.com
X-Virus-Status: Clean
X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by
	milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]);
	Mon, 28 May 2007 07:46:55 -0700 (PDT)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/291
X-Sequence-Number: 25611

Johann Spies wrote:
> On Mon, May 21, 2007 at 10:40:40AM -0400, Tom Lane wrote:
> > Well, if you aren't having any luck debugging it yourself, maybe you
> > could put together a self-contained test case for someone else to
> > reproduce the problem with?
> 
> Hallo Tom,
> 
> Sorry for the long delay.
> 
> Maybe the following was what you were looking for:
> 
> 
> gdb) bt
> #0  errfinish (dummy=0) at elog.c:313
> #1  0x00000000005f40c1 in elog_finish (elevel=<value optimized out>, fmt=<value optimized out>) at elog.c:939
> #2  0x0000000000609585 in MemoryContextAlloc (context=0x941210, size=1350958157) at mcxt.c:504
> #3  0x00000000005ff1c8 in perform_default_encoding_conversion (
>     src=0x2b881e87f040 "\"2007-04-20\" \"18:07:06\" \"192.168.0.100\" \"73\" \"http://www.kerkbode.co.za/kerkbode/images/blank.gif\\\"\"\n\"2007-04-20\" \"18:07:06\" \"192.168.0.100\" \"69\" \"http://develop.christians.co.za/phpAdsNew/adx.js\"\n\"20"..., len=337739539, is_client_to_server=5 '\005') at mbutils.c:461

Interesting.  You are passing a single 300 MB string here, not
90-something char lines.  The problem is probably in newlines.  Why are
they not getting used as line separators escapes me.

-- 
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"There is evil in the world. There are dark, awful things. Occasionally, we get
a glimpse of them. But there are dark corners; horrors almost impossible to
imagine... even in our worst nightmares." (Van Helsing, Dracula A.D. 1972)