Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of seba.wagner@gmail.com
 designates 209.85.216.46 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAOXaKAm8NTq8U5pvY3YBHrcBqVei-pQ4u0KwR3GDmotM737XbQ@mail.gmail.com>
References: 
 <CAOXaKA=G+1t=OoZ30UtiobsM15wTsTLn+fHe2tyHAyXFX+e7RQ@mail.gmail.com>
 <CAJmbs8giJm7g_b9kq6Ps6iL4nBk=Akxu8p7fEnKu36fUVjc0OQ@mail.gmail.com>
 <CACeMiA_uxJpnkogsjMDB3_-KvCcX3hX4V4nw+GYox6=LLd+3kA@mail.gmail.com>
 <CAOXaKAm8NTq8U5pvY3YBHrcBqVei-pQ4u0KwR3GDmotM737XbQ@mail.gmail.com>
From: "seba.wagner@gmail.com" <seba.wagner@gmail.com>
Date: Fri, 14 Dec 2012 14:45:01 +1000
Message-ID: 
 <CACeMiA8uvsJQ+ADOyOmBQoJndpzqJrVcSvYaZJ+VCrV0qrHpvQ@mail.gmail.com>
Subject: Re: MySQL timeouts?
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=005045015e46ffb33504d0c8b2fd

--005045015e46ffb33504d0c8b2fd
Content-Type: text/plain; charset=ISO-8859-1

Yes that is what I meant Mikael.

In the server on demo.openmeetings.de those config variables are exactly
the same:
mysql> SHOW GLOBAL VARIABLES LIKE "wait_timeout";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE "wait_timeout";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.01 sec)

mysql>


Another reason might be that the host in general is not available.

You could for example test this by doing a (nasty) small ping script that
runs "demon-like".

For example:
nohup ping -c 100000000000000 web.de &

it will write all ping results to a file called nohup.out.
And you can check the output in real-time using:
tail -f nohup.out

with some more "shell kung-fu" I guess you could also add the date part in
front of every ping result.

Then you let run the script overnight.

And tomorrow morning when you see in your openmeetings log file => there
was a db connection lost, you see in the openmeetings log what time exactly
the connection lost was

And then you check the output of your ping protocol in the nohup.out if
there was any host issue (especially around that date/time of course).

Sebastian


2012/12/13 Mikael Kurula <alcarola@gmail.com>

> 2880


-- 
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com

--005045015e46ffb33504d0c8b2fd--