pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Litao Wu <litaowu@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: reindex and copy - deadlock?
Date: Wed, 30 Jun 2004 11:43:38 -0400
Message-ID: <9419.1088610218@sss.pgh.pa.us> (raw)
In-Reply-To: <20040630150816.96381.qmail@web13121.mail.yahoo.com>
References: <20040630150816.96381.qmail@web13121.mail.yahoo.com>

Litao Wu <litaowu@yahoo.com> writes:
> It happened again. 
> This time it hangs when we drop/create index.
> Here is gdb info with --enable-debug postgres.

Well, that pretty much removes all doubt: something has left the buffer
context lock (cntx_lock) set on a buffer that certainly ought to be free.

The problem here is that REINDEX (or CREATE INDEX in this case) is the
victim, not the perpetrator, so we still don't know exactly what's
causing the error.  We need to go backwards in time, so to speak, to
identify the code that's leaving the buffer locked when it shouldn't.
I don't offhand have a good idea about how to do that.  Is there another
process that is also getting stuck when REINDEX does (if so please get
a backtrace from it too)?

BTW, what Postgres version are you using again?  The line numbers in
your trace don't square with any current version of bufmgr.c ...

			regards, tom lane



view thread (16+ messages)  latest in thread

Message-ID: <9419.1088610218@sss.pgh.pa.us>
Permalink:  ../9419.1088610218@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/9419.1088610218@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, litaowu@yahoo.com
  Subject: Re: reindex and copy - deadlock?
  In-Reply-To: <9419.1088610218@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox