Re: Random hang during commit

Bill - please cc: the bugs list too.

Lin, B (Bill) wrote:
> Some more information please.
> 1. What operating-system?
> XP SP2
> 2. Installed from a package (which) or source?
>>From package
> 3. What hangs - the client or the backend (or both)?
> Both. The client is waiting for the backend's commit() to be completed.
> 4. What do the logs show?
> Usually, the last log shows commit is executed.

Hmm - if the log shows the commit happening that suggests the backend is
doing its bit. It's not hanging, it's just idle waiting for the next
query from the client. That would mean that the problem is either in the
client library, jdbc driver or the communication channel itself.

In your original message, you say: "I have installed same database, jdbc
driver, jre and test case on some other computers. However, this problem
will be never happened on others."

Does that mean 8.1.3 works fine on other PCs you have, but not this one?

If so, that suggests to me that there must be either:
1. A different library on the problem machine.
2. Some process (firewall/antivirus) that is occasionally interfering
with communication.

Three things suggest themselves to me:
1. Make sure there aren't any known issues with the jdbc driver version
you have http://jdbc.postgresql.org/
2. Check if there is anything unusual about the problem machine
3. Try running the client on the problem machine and the database on
another, then the other way around. Does this change anything?

--
Richard Huxton
Archonet Ltd