Re: [GENERAL] pg_upgrade problem

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: depesz(at)depesz(dot)com
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] pg_upgrade problem
Date: 2011-09-05 18:51:12
Message-ID: 201109051851.p85IpCS05627@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

hubert depesz lubaczewski wrote:
> On Mon, Sep 05, 2011 at 02:18:18PM -0400, Bruce Momjian wrote:
> > hubert depesz lubaczewski wrote:
> > > I'm not sure if it's upgrade thing, or is it because of error in
> > > ltree/compilation, but it looks bad.
> > >
> > > Is there any more info I could show/gather to help debug the issue?
> >
> > I am confused by the error --- is it not loading, or can you get a
> > backtrace of the crash?
>
> The one in logs is not sufficient?
> If not - could you tell me how to make the backtrace? I'm by far not a c
> programmer, so for this I'd need some tutoring.

I think you want this:

http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

While strace is useful, it doesn't show us where the C code is failing.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-09-05 19:03:00 Re: alter column appears to work, but doesn't?
Previous Message hubert depesz lubaczewski 2011-09-05 18:44:11 Re: [GENERAL] pg_upgrade problem

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-09-05 18:55:13 Re: B-tree parent pointer and checkpoints
Previous Message Pavel Stehule 2011-09-05 18:47:31 Re: remove useless ccache searching