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

[Frank Pertack]

Hello Brett,

yes I think that helped.
Yesterday I implemented those two lines into the my.ini and today morning
it started right away.
I hope that stays that way.

Thank you very much for your advise.

Best regards

Frank



|------------>
| Von:       |
|------------>
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Brett Sheeran <brett.sheeran at gmail.com>                                                                                                           |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An:        |
|------------>
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |opencms-dev at opencms.org                                                                                                                           |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum:     |
|------------>
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |26.04.2010 12:28                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff:   |
|------------>
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Re: [opencms-dev] server is not reacting after a time of inactivity                                                                               |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet   |
| von:       |
|------------>
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |opencms-dev-bounces at opencms.org                                                                                                                   |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|





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

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100427/1d79fbde/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: graycol.gif
Type: image/gif
Size: 105 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100427/1d79fbde/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ecblank.gif
Type: image/gif
Size: 45 bytes
Desc: not available
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100427/1d79fbde/attachment-0001.gif>