Re: Hang investigation - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Hang investigation
Date
Msg-id 20051230142346.GD15410@svana.org
Whole thread Raw
In response to Hang investigation  ("Ilja Golshtein" <ilejn@yandex.ru>)
List pgsql-general
On Fri, Dec 30, 2005 at 12:02:59PM +0300, Ilja Golshtein wrote:
> Hello!
>
> I'm developing application uses PG as backend.
> A recent stress test found out a serious trouble. Briefly,
> libpq does not return control after COMMIT, while
> commit actually happened Ok.

Hmm, sounds like a race condition. Most important would be strace of
postmaster and client at time of hang. If you have gdb and have
compiled with debug, attaching to them both will pinpoint the exact
line of code both a stuck on. From there we should be able to provide
more advice.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: a few questions
Next
From: John DeSoi
Date:
Subject: Re: Forum Software