pg_dump Crashes and core dumps
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Shibashish
Your email address : shib@postmark.net
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II
Operating System (example: Linux 2.0.26 ELF) : SCO_SV (SCO Open Server
5.0.4)
PostgreSQL version (example: PostgreSQL-7.3): PostgreSQL-7.3.1
Compiler used (example: gcc 2.95.2) : gcc 2.7.2.1
Please enter a FULL description of your problem:
-----------------------------------------------
I have 2 databases. "test" and "working"
There r 39 tables in "test", very less data in them.
There r 40 tables in "working" and there is some data, not too much. And
there are referential integrety ocnstraints between the data.
When i do a "pg_dump test" it works fine.
But When i do a "pg_dump working" I get "Segmentation fault (core dumped)"
If anybody wants, i can send the core file. Any help will be highly
appreciated.
Shibashish <shiba@it.iitb.ac.in> writes:
When i do a "pg_dump test" it works fine.
But When i do a "pg_dump working" I get "Segmentation fault (core dumped)"
If anybody wants, i can send the core file. Any help will be highly
appreciated.
The core file will be useless away from your own system.
Could we see a stack backtrace from it, instead? (Please compile with
debug symbols if you didn't already.) Also, please run pg_dump with
query logging enabled (see log_statement in postgresql.conf) so that you
can show us the last few queries it issues before crashing.
regards, tom lane
Shibashish <shiba@it.iitb.ac.in> writes:
When i do a "pg_dump test" it works fine.
But When i do a "pg_dump working" I get "Segmentation fault (core dumped)"
Olivier Prenant just found a problem that could lead to pg_dump trouble
with any database using PL languages. Try the attached patch and see if
it fixes your problem.
regards, tom lane
*** src/bin/pg_dump/pg_dump.c.orig Thu Apr 24 22:28:22 2003
--- src/bin/pg_dump/pg_dump.c Sat May 3 18:09:51 2003
***************
*** 3591,3597 ****
resetPQExpBuffer(delqry); /* Make a dependency to ensure function is dumped first */
! deps = malloc(sizeof(char *) * (2 + (strcmp(lanvalidator, "0") != 0) ? 1 : 0));
depIdx = 0;
(*deps)[depIdx++] = strdup(lanplcallfoid);
--- 3591,3597 ----
resetPQExpBuffer(delqry); /* Make a dependency to ensure function is dumped first */
! deps = malloc(sizeof(char *) * 10);
depIdx = 0;
(*deps)[depIdx++] = strdup(lanplcallfoid);