Re: Problem with locks

From: Stefan Kaltenbrunner <mm-mailinglist(at)madness(dot)at>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Problem with locks
Date: 2007-08-12 14:12:16
Message-ID: 46BF1540.9010009@madness.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark wrote:
> "Gregory Stark" <stark(at)enterprisedb(dot)com> writes:
>
>> "Gregory Stark" <stark(at)enterprisedb(dot)com> writes:
>>
>>> "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>>>
>>>> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>>>>> We're seeing a problem where occasionally a process appears to be granted a
>>>>> lock but miss its semaphore signal.
>>>> Kernel bug maybe? What's the platform?
>
> I've written a synthetic test program to check for lost semaphore wakeups. I
> can't seem to produce any on my machine but haven't had a chance to run it yet
> on the benchmark machine that's been showing the problem.
>
> If I can't produce any lost wakeups with a program like this it looks more
> like it might be a Postgres or GCC bug than a Linux bug.
>
> It would be helpful if people could run this on various architectures and
> various versions of Linux (or other OSes). I've been running it with 40
> processes for an hour, but even shorter runs would be useful. It will drive
> the load on your machine through the roof but doesn't cause any i/o.

doesn't work on OpenBSD:

$ gcc -o ipctest ipctest.c -lpthread
$ ./ipctest 40 3600
running with 40 processes for 3600s
sem_init: Operation not permitted

"This implementation does not support shared semaphores, and reports
this fact by setting errno to EPERM. This is perhaps a stretch of the
intention of POSIX, but is compliant, with the caveat that sem_init()
always reports a permissions error when an attempt to create a shared
semaphore is made."

Stefan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2007-08-12 15:09:47 Re: proper way to fix information_schema.key_column_usage view
Previous Message Gregory Stark 2007-08-12 13:47:43 Re: Problem with locks