Memory Errors - Mailing list pgsql-general

From Sam Nelson
Subject Memory Errors
Date
Msg-id AANLkTi=9c9V5Qg09PXBZ-vz9=kGrzs2noUfCt==pYG8H@mail.gmail.com
Whole thread Raw
Responses Re: Memory Errors  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Memory Errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hey, a client of ours has been having some data corruption in their database.  We got the data corruption fixed and we believe we've discovered the cause (they had a script killing any waiting queries if the locks on their database hit 1000), but they're still getting errors from one table:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  invalid memory alloc request size 18446744073709551613
pg_dump: The command was: COPY public.foo (<columns>) TO stdout;

That seems like an incredibly large memory allocation request - it shouldn't be possible for the table to really be that large, should it?  Any idea what may be wrong if it's actually trying to allocate that much memory for a copy command?

pgsql-general by date:

Previous
From: "Donald Catanzaro, PhD"
Date:
Subject: Re: Copy From csv file with double quotes as null
Next
From: Scott Marlowe
Date:
Subject: Re: Memory Errors