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
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 |