Re: Problem with locks

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
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 15:41:33
Message-ID: 162867790708120841y7b6233f4m20bf7f0e56ebb824@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2007/8/12, Gregory Stark <stark(at)enterprisedb(dot)com>:
> > "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.
>
> $ gcc -Wall ipctest.c -lrt
> $ ./a.out 40 3600
>
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
Hello
[pavel(at)localhost ~]$ cat /proc/sys/kernel/osrelease
2.6.22.1-41.fc7

[pavel(at)localhost tmp]$ ./a.out 40 3600
running with 40 processes for 3600s
[pavel(at)localhost tmp]$

without any problem

Regards
Pavel Stehule

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-08-12 16:03:47 Re: Problem with locks
Previous Message Peter Eisentraut 2007-08-12 15:09:47 Re: proper way to fix information_schema.key_column_usage view