Re: 9.1.11 - many backends in "semtimedop" syscall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.1.11 - many backends in "semtimedop" syscall
Date: 2014-03-06 16:56:06
Message-ID: 27155.1394124966@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> Thread 1 (LWP 21422):
> #0 0x00007ffa60da2dc7 in semop () from /lib/x86_64-linux-gnu/libc.so.6
> No symbol table info available.
> #1 0x00000000005f65e8 in PGSemaphoreLock ()
> No symbol table info available.
> #2 0x0000000000636125 in LWLockAcquire ()
> No symbol table info available.
> #3 0x0000000000630f91 in LockAcquireExtended ()
> No symbol table info available.
> #4 0x000000000062f88c in LockRelationOid ()
> No symbol table info available.
> #5 0x0000000000470f6d in relation_open ()
> No symbol table info available.

Huh. Looks like it's blocked trying to acquire one of the lock-partition
LWLocks, which is odd because those ought never be held very long.
Somebody else has failed to release that LWLock, looks like.

Did you by any chance capture stack traces from all of the backends?
The interesting one would be the one that *doesn't* look like this.
Or possibly there's more than one such.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2014-03-06 16:57:53 Re: 9.1.11 - many backends in "semtimedop" syscall
Previous Message Catherine Devlin 2014-03-06 16:54:24 extract psql meta-commands into library?