[opencms-dev] server is not reacting after a time of inactivity

[Brett Sheeran]

Frank Pertack wrote:
> After a certain time of inactivity the server does not respond:
> Server Error 500
> After a Browser-Refresh (F5) the page appears normally.
> I don't understand this opencms-error, what causes this error?
> Did anybody else experience this behaviour of OpenCms, what can I do to

Hi Frank,

I suggest editing your MySQL config file to increase the following two
values from their defaults (of 8 hours) to 24 hours (as shown below):
wait_timeout=86400
interactive_timeout=86400

As I understand it, the default value for wait_timeout is 28800
(seconds) or 8 hours. After 8 hours of inactivity, MySQL closes the
connection. The next time OpenCMS calls that connection, you get an
error.

I have had similar problem on systems that did not receive page
requests outside working hours. The first request of the day would
generate an error, but things would be fine after that. Since
increasing those wait_timeout and interactive_timeout values, I have
had no further problems.

HTH.

Regards

Brett