Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 49BF69FB313 for ; Tue, 6 Feb 2007 06:05:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 90298-07 for ; Tue, 6 Feb 2007 06:05:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.236]) by postgresql.org (Postfix) with ESMTP id 3EE4C9FB316 for ; Tue, 6 Feb 2007 06:05:38 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so2037394wxd for ; Tue, 06 Feb 2007 02:05:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=uXE8E7Xj/bXIoBljnnV1+SiD2peSBYJeU9+vTu6p6zTlOZGWhRDZPSrUFEf18LVWQImkOK9Kg4uN/0DWQ+qbhMWsrW+MbCH8KPdLA0ru1i59HRf/6/ga1VtWBi1GKXs/SfmSE/1nqiQAjInso/R4H9jx3NzeDmfqgYOzwzCpPvI= Received: by 10.70.39.5 with SMTP id m5mr14382789wxm.1170756337389; Tue, 06 Feb 2007 02:05:37 -0800 (PST) Received: by 10.70.10.17 with HTTP; Tue, 6 Feb 2007 02:05:37 -0800 (PST) Message-ID: <4c5a5abe0702060205w5d29a3f0x1048804db8d901ab@mail.gmail.com> Date: Tue, 6 Feb 2007 10:05:37 +0000 From: "David Cotter" Reply-To: davidcotter@gmail.com To: "Shoaib Mir" Subject: Re: Unable to pg_dump 8.1.2 - memory alloc error Cc: airbulb , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2613_141595.1170756337348" References: <896477840701311014t21d07275kd2bd5c01b9a92b67@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/79 X-Sequence-Number: 24544 ------=_Part_2613_141595.1170756337348 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks - I tracked down the offending row and deleted it. Just in case anyone wishes to know how select * from site where id < 5000 (no error) select * from site where id < 10000 (no error) select * from site where id < 15000 (error) ... select * from site where id = 12344 (no error) select * from site where id = 12345 (error) delete from site where id = 12345 (error) On 2/6/07, Shoaib Mir wrote: > > Hmmm that looks like to me a HW problem causing data corruption. Try doing > a REINDEX for the database, if possible restart the database server machine > and then try taking the dump again to see if that works. > > But I will recommend doing memory tests for the hardware... > > -- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 1/31/07, airbulb < airbulb@gmail.com> wrote: > > > > Hello > > > > I get the following error when dumping a pg database with WIN_1252 > > encoding: > > > > pg_dump --clean --no-owner dumpfile | gzip > > >/home/postgres/globalen.dump.gz 2>>./err.out > > > > pg_dump: ERROR: invalid memory alloc request size 4294967293 > > pg_dump: SQL command to dump the contents of table "site" failed: > > PQendcopy() failed. > > pg_dump: Error message from server: ERROR: invalid memory alloc request > > size 4294967293 > > pg_dump: The command was: COPY public.site (site_id, url, status, > > created, "domain", title) TO stdout; > > > > Possibly related is a particular query with pgAdmin on same site table > > with above error yields > > ERROR: invalid multibyte character for locale > > > > I have upgraded from 8.1.2 to 8.1.6 but get the same error. > > > > Any help appreciated. > > > > Regards, > > David. > > > > -- ----------------------------- David Cotter CTO Alatto Technologies Ltd ----------------------------- david.cotter@alatto.com m. +353 87 6293698 t. +353 1 2090700 (main) t. +353 1 2090779 (direct) f. +353 1 2090707 www.alatto.com ----------------------------- The new way to mobile browse: http://tribes.cc/demo ------=_Part_2613_141595.1170756337348 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks - I tracked down the offending row and deleted it. Just in case anyone wishes to know how

select * from site where id < 5000 (no error)
select * from site where id < 10000 (no error)
select * from site where id < 15000 (error)
...
select * from site where id = 12344 (no error)
select * from site where id = 12345 (error)
delete from site where id = 12345 (error)




On 2/6/07, Shoaib Mir <shoaibmir@gmail.com> wrote:
Hmmm that looks like to me a HW problem causing data corruption. Try doing a REINDEX for the database, if possible restart the database server machine and then try taking the dump again to see if that works.

But I will recommend doing memory tests for the hardware...

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/31/07, airbulb < airbulb@gmail.com> wrote:
Hello

I get the following error when dumping a pg database with WIN_1252 encoding:

pg_dump --clean --no-owner dumpfile | gzip >/home/postgres/globalen.dump.gz 2>>./err.out

pg_dump: ERROR:  invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "site" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR:  invalid memory alloc request size 4294967293
pg_dump: The command was: COPY public.site (site_id, url, status, created, "domain", title) TO stdout;

Possibly related is a particular query with pgAdmin on same site table with above error yields
ERROR:  invalid multibyte character for locale

I have upgraded from 8.1.2 to 8.1.6 but get the same error.

Any help appreciated.

Regards,
David.




--
-----------------------------
David Cotter CTO
Alatto Technologies Ltd
-----------------------------
david.cotter@alatto.com
m. +353 87 6293698
t. +353  1 2090700 (main)
t. +353  1 2090779 (direct)
f. +353  1 2090707
www.alatto.com
-----------------------------
The new way to mobile browse: http://tribes.cc/demo ------=_Part_2613_141595.1170756337348--