pg_dumpall segmentation fault

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dumpall segmentation fault
Date: 2003-05-08 05:36:03
Message-ID: Pine.LNX.4.44.0305081058550.2178-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I use pgsql 7.3.2.

The pg_dumpall fails while dumping the user-defined functions. But, the
pg_dump does fine. I have checked the archives and found two things.

1. To enable statement log and analyze. I did it.
2. To apply patch provided by Mr.Tom in the below link:

http://archives.postgresql.org/pgsql-bugs/2003-05/msg00011.php

I did it, but the problem still exists.

FYI, i have attached the sql log and the actual error thrown by pg_dumpall
(with -v). If you require further information, i can provide.

TIA.

regards,
bhuvaneswaran

<log>
LOG: query: SELECT proretset, prosrc, probin, provolatile, proisstrict, prosecdef, (SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) as lanname
FROM pg_catalog.pg_proc WHERE oid = '20570'::pg_catalog.oid
LOG: query: SELECT pg_catalog.format_type('2279'::pg_catalog.oid, NULL)
LOG: query: SELECT description FROM pg_catalog.pg_description WHERE objoid = '20570'::pg_catalog.oid and classoid = 'pg_catalog.pg_proc'::pg_catalog.regclass and objsubid = 0
LOG: query: SELECT proretset, prosrc, probin, provolatile, proisstrict, prosecdef, (SELECT lanname FROM pg_catalog.pg_language WHERE oid = prolang) as lanname
FROM pg_catalog.pg_proc WHERE oid = '20571'::pg_catalog.oid
LOG: pq_recvbuf: unexpected EOF on client connection
</log>

<pg_dump-v>
pg_dump: dumping out indexes
pg_dump: dumping out user-defined procedural languages
pg_dump: dumping out user-defined functions
Segmentation fault (core dumped)
</pg_dump-v>

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-08 11:20:20 Re: An unresolved performance problem.
Previous Message Sean Chittenden 2003-05-08 04:57:49 Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem.