Re: Urgent!

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Nirav Parikh <nirav(dot)p(at)workskillsprofessionals(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent!
Date: 2005-10-13 16:12:50
Message-ID: 20051013161250.GC8138@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Nirav Parikh wrote:
> Hi,
>
> I got this error message when I tried to do pg_dump on the database.
>
> pg_dump: ERROR: invalid memory alloc request size 4294967293
> pg_dump: SQL command to dump the contents of table "wordlist" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR: invalid memory alloc request
> size 4294967293
> pg_dump: The command was: COPY public.wordlist (word_id, word,
> count_word) TO stdout;
>
> I went to phppgadmin and try to access the worldlist table and it also
> gives me following error message:
>
> ERROR: could not access status of transaction 6849340
> DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
> file or directory

What version is this? Also, is the system running with fsync=off or on
disks with write cache enabled?

--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

In response to

  • Urgent! at 2005-10-13 01:18:21 from Nirav Parikh

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-10-13 16:21:24 Re: Urgent!
Previous Message Tom Lane 2005-10-13 16:12:08 Re: DB Cluster hanging