Обсуждение: timeout for a transaction
I have a connection opened, and begin a transaction. If tomcat or web server dies for no reasons, I found that in the backend, there is a postgresql server process waiting for the transaction to complete. It blocks all my database calls because of this waiting process. I have to manually kill that waiting process to unlock the database. Is there any way of setting a timeout for the transaction? How come the postgresql server doesn't detect the client dies, rollback and release the resources? I want the system be able to do it automatically. Any suggestions? Thanks, Percy
HYip <hualinyip@earthlink.net> writes: > I have a connection opened, and begin a transaction. If tomcat or web > server dies for no reasons, I found that in the backend, there is a > postgresql server process waiting for the transaction to complete. It > blocks all my database calls because of this waiting process. The backend will abort its transaction and exit when it observes closure of the client connection. If your webserver is holding open the TCP connection even after it's stopped processing your script, then you'd best fix the webserver. regards, tom lane