Re: invalid memory alloc request size - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid memory alloc request size
Date
Msg-id 5863.1138032323@sss.pgh.pa.us
Whole thread Raw
In response to invalid memory alloc request size  (Janning Vygen <vygen@gmx.de>)
Responses Re: invalid memory alloc request size  (Janning Vygen <vygen@gmx.de>)
List pgsql-general
Janning Vygen <vygen@gmx.de> writes:
> pg_dump: ERROR:  invalid memory alloc request size 18446744073709551614
> pg_dump: SQL command to dump the contents of table "spieletipps" failed:
> PQendcopy() failed.

This looks more like a corrupt-data problem than anything else.  Have
you tried the usual memory and disk testing programs?

> recent thread on HACKERS but sorry guys: i dont know how to produce a
> backtrace.

Time to learn ;-)

    gdb /path/to/postgres_executable /path/to/core_file
    gdb> bt
    gdb> q

The core file will be somewhere under $PGDATA, named either "core" or
"core.nnnnn" depending on your kernel settings.  If you don't see one
then it's probable that the postmaster was started under "ulimit -c 0".
Put "ulimit -c unlimited" in your postgres startup script, restart,
trigger the crash again.

It's also a good idea to look in the postmaster log to see if any
unusual messages appeared before the crash.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: RAID 5 and postgresql
Next
From: John DeSoi
Date:
Subject: Re: What is made a mistake with SP?