Yeah, that's what we have to resort to now, but that's not a solution. Until we kill the client, the entire database is locked (or, at least the tables that other clients need to write to, which is effectively the same thing). This is annoying enough during the week but it's especially a problem on weekends when none of the developers are in the office. A single client should not be able to bring the entire database down. The DB should recognize that the client went down and roll back the transaction. That would be the ideal solution. Anything else we can do to remedy the situation? thanks, Eugene --- Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote: > On Tue, Jul 26, 2005 at 07:40:30AM -0700, Dr NoName > wrote: > > > So, is transaction timeout option planned at all? > > > What's the alternative solution to a client that's > hung in > > transaction? > > Forcibly end it? > > -- > Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) > "I dream about dreams about dreams", sang the > nightingale > under the pale moon (Sandman) > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
