Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of alcarola@gmail.com designates
 209.85.217.174 as permitted sender)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1085)
Subject: Re: MySQL timeouts?
From: Mikael Kurula <alcarola@gmail.com>
In-Reply-To: 
 <CACeMiA8uvsJQ+ADOyOmBQoJndpzqJrVcSvYaZJ+VCrV0qrHpvQ@mail.gmail.com>
Date: Fri, 14 Dec 2012 09:52:22 +0200
Content-Transfer-Encoding: quoted-printable
Message-Id: <E2DB6A43-5367-4D71-A8EA-1CFE15AB7291@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>
 <CACeMiA8uvsJQ+ADOyOmBQoJndpzqJrVcSvYaZJ+VCrV0qrHpvQ@mail.gmail.com>
To: users@openjpa.apache.org

Hi!

Thanks for the suggestion. I didn't manage to get the time stamps in =
(I'm a mathematician, not a sysadmin) and I find it unlikely the server =
has gone down. MySQL is on the same server as OpenMeetings and AFAIK we =
have nagios watchdogging it, probably also with ping.

Friendly greetings,
Mikael


On 2012.14.12, at 06:45, seba.wagner@gmail.com wrote:

> Yes that is what I meant Mikael.
>=20
> 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)
>=20
> mysql> SHOW VARIABLES LIKE "wait_timeout";
> +---------------+-------+
> | Variable_name | Value |
> +---------------+-------+
> | wait_timeout  | 28800 |
> +---------------+-------+
> 1 row in set (0.01 sec)
>=20
> mysql>
>=20
>=20
> Another reason might be that the host in general is not available.
>=20
> You could for example test this by doing a (nasty) small ping script =
that
> runs "demon-like".
>=20
> For example:
> nohup ping -c 100000000000000 web.de &
>=20
> 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
>=20
> with some more "shell kung-fu" I guess you could also add the date =
part in
> front of every ping result.
>=20
> Then you let run the script overnight.
>=20
> And tomorrow morning when you see in your openmeetings log file =3D> =
there
> was a db connection lost, you see in the openmeetings log what time =
exactly
> the connection lost was
>=20
> 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).
>=20
> Sebastian
>=20
>=20
> 2012/12/13 Mikael Kurula <alcarola@gmail.com>
>=20
>> 2880
>=20
>=20
>=20
>=20
> --=20
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com