By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

transaction timeout

P: n/a
Hi everybody,
Our aplpication uses PostgreSQL for data store. We
have a problem with the way
long-running transactions are handled.
Our application had a bug (from what I understand it
went into an infinite
loop). As a result, the transaction it was processing
was neither committed
nor rolled back. Because of that, the misbehaving
process was left holding
the locks and none of the other processes were able to
do transactions.
My question is, how do I get PostgreSQL to
automatically abort transactions
that take longer than a certain timeout?
thanks in advance,
Eugene
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.