Skip site navigation (1) Skip section navigation (2)

Re: pg_dump dumping... core

From: ohp(at)pyrenet(dot)fr
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump dumping... core
Date: 2003-04-24 18:00:07
Message-ID: Pine.UW2.4.53.0304241957170.1908@server.pyrenet.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all,
I've been doing some more research on this:
pg_dump -s works as expected
pg_dump -a works as expected
pg_dump -v shows that pg_dump crashes when dumping user defined functions.

There's a lot (~30) plpsql functions how could it be a problem.

I'm also surprised that pg_dump -s dumps those function without crashing.

Regards
On Thu, 24 Apr 2003, Tom Lane wrote:

> Date: Thu, 24 Apr 2003 10:57:25 -0400
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: ohp(at)pyrenet(dot)fr
> Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] pg_dump dumping... core
>
> ohp(at)pyrenet(dot)fr writes:
> > pg_dump is crashing on 1 database here.
>
> Judging from the backtrace, malloc's data structures have gotten
> corrupted, probably as a result of somebody scribbling on a few more
> bytes than their buffer would hold.
>
> Since we haven't seen other reports of similar problems, I'm leaning
> to the theory that it's a platform-specific problem.  In particular
> I wonder whether you might have a buggy version of vsnprintf().  I have
> seen Solaris 7's vsnprintf() overrun its output buffer --- could
> Unixware's have the same bug?
>
> It'd be worth trying the workaround outlined in FAQ_Solaris (add
> snprintf.o to LIBOBJS and rebuild libpq.so), just to see if it makes
> any difference.  If not, you're in for some tedious debugging to try
> to figure out exactly where the culprit is :-(
>
> 			regards, tom lane
>

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


In response to

pgsql-hackers by date

Next:From: Kurt RoeckxDate: 2003-04-24 18:07:44
Subject: Re: query optimization scenarios 17,701 times faster!!!
Previous:From: ohpDate: 2003-04-24 17:31:23
Subject: Re: pg_dump dumping... core

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group