Re: stuck spin lock with many concurrent users

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: stuck spin lock with many concurrent users
Date: 2001-06-22 03:24:22
Message-ID: 20010622122422E.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> >>> How can I check it?
> >>
> >> The 'stuck' message should at least give you a code location...
>
> > FATAL: s_lock(0x2ac2d016) at spin.c:158, stuck spinlock. Aborting.
>
> Hmm, that's SpinAcquire, so it's one of the predefined spinlocks
> (and not, say, a buffer spinlock). You could try adding some
> debug logging here, although the output would be voluminous.
> But what would really be useful is a stack trace for the stuck
> process. Consider changing the s_lock code to abort() when it
> gets a stuck spinlock --- then you could gdb the coredump.

Nice idea. I will try that.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message AV 2001-06-22 03:52:50 Re: JDBC Connection State Management with SQL Exceptions (esp Postgresql)
Previous Message Alex Pilosov 2001-06-22 03:16:14 [ANNOUNCE] DBD::PgSPI