Hi Geoff,

If your DB is running MySQL, you can force it to terminate idle connections in a more timely manner. This is done on the MySQL server.

Lars

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Allen, Geoff
Sent: Wednesday, February 16, 2011 10:15 PM
To: User questions and discussions about OTRS.
Subject: [otrs] Loooonnnnnggggg database timeouts

I have some issues where occasionally a database query times out. I’m working to figure out why sometimes the connection to my DB machine has a problem. That’s not an OTRS issue.

The question I’m asking here, however, is: When these timeouts happen, they take 2 hours before they timeout. Fortunately, Postmaster.pl is smart enough to grab the error and tell sendmail to defer the message. The retry then works. My question is, is there some parameter that controls this timeout? 2 hours is an insanely long time in computer terms. Even long enough to be long in human terms. J

Thanks,

Geoff