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>
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. |