postgres 7.0.3 hangs

From: Sheer El-Showk <sheer(at)saraf(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: postgres 7.0.3 hangs
Date: 2002-01-04 17:31:02
Message-ID: Pine.LNX.4.33.0201041226110.605-100000@laudanum.saraf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there any known problem with postgres 7.0.3 on a linux box (2.4 kernel)
hanging? I noticed it from time to time in the past, but it was
infrequent enough that I didn't do anything about it, but its become a
much more pervasive problem. I have multiple threads runing and one of
them hangs on an INSERT (visible in the process listing). When I check
the process status, it is sleeping. Other threads, presumably trying to
access a locked resource also hang (though they are otherwise response,
you can do other things so long as you don't access whatever resource is
locked). Even if a I kill the sleeping process, the next one that comes
in place after it (presumably waiting on that lock) blocks in the same
way. I have to restart the whole database to get things to work again.
I know this is not a very detailed analysis, but has anyone seen anything
like it before? Is upgrading postgres likeley to solve the problem?

Thanks,
Sheer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2002-01-04 17:31:16 Re: PostgreSQL GUI
Previous Message Thomas Lockhart 2002-01-04 17:08:45 Re: More on CURRENT_TIME and changes