Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A26DB9FB6B1 for ; Mon, 14 May 2007 11:34:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31484-06 for ; Mon, 14 May 2007 11:34:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3E6869FB960 for ; Mon, 14 May 2007 11:34:19 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4EEYIlf011218; Mon, 14 May 2007 10:34:18 -0400 (EDT) To: Johann Spies cc: pgsql-admin@postgresql.org Subject: Re: ERROR: invalid memory alloc request size In-reply-to: <20070514131318.GA26537@sun.ac.za> References: <20070514131318.GA26537@sun.ac.za> Comments: In-reply-to Johann Spies message dated "Mon, 14 May 2007 15:13:18 +0200" Date: Mon, 14 May 2007 10:34:18 -0400 Message-ID: <11217.1179153258@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/112 X-Sequence-Number: 25432 Johann Spies writes: > I am using postgresql 8.1 on Debian Stable. 8.1.what? > psql:laai_squid_logs:4: ERROR: invalid memory alloc request size 1350958157 > CONTEXT: COPY squidlogs, line 238780099 Is this repeatable? Is it always the same line and same bogus request size? 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 regards, tom lane