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

Re: NEED HELP !

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Sergej Galkin <sergej(dot)galkin(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: NEED HELP !
Date: 2010-01-13 19:21:32
Message-ID: 603c8f071001131121o4f827b2cn174bc1f4e14e20a9@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, Jan 13, 2010 at 1:42 PM, Sergej Galkin <sergej(dot)galkin(at)gmail(dot)com> wrote:
> I can not understand why DB is restarting ? It is restarting when SQL begins
> use index :(((
> Can anybody help me , I would by appretiate every people who downloads my
> sources, try to deploy index and maybe solve where is the problem.

Your code is probably crashing.  Before trying to use the index, run
"select pg_backend_pid()" in the backend that you're going to try to
use it from.  Then use "gdb -p <pid>" to attach gdb to the backend.
Type "c" for continue.  Now run the query that crashes it.  gdb will
trap the signal and you can use "bt" to get a backtrace.

I don't think it would be appropriate for us to help you debug your
class project, but learning to use gdb should help you a lot.

Also see:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

...Robert

In response to

  • NEED HELP ! at 2010-01-13 18:42:22 from Sergej Galkin

pgsql-hackers by date

Next:From: Stephen FrostDate: 2010-01-13 19:27:11
Subject: Re: [PATCH] remove redundant ownership checks
Previous:From: Simon RiggsDate: 2010-01-13 19:20:29
Subject: Re: Hot Standby and query cancel

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