Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
Received-SPF: pass (nike.apache.org: domain of pharkins@gmail.com designates
 209.85.212.179 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <20141113182144.b8b7d91b26390b945dce2492@wanadoo.fr>
References: <D0898361.7CFBC%xzheng@christianbook.com>
	<CAEK7ryiHo4Qu0qREQCC+6EonvbW3N-Cbqv-aFLpXRyNKEGdezQ@mail.gmail.com>
	<D08A2BBE.7D092%xzheng@christianbook.com>
	<CAC0_be0tHT3W3-UZdOCw58q_uKVrLFRy9M1-euNkohUy38ya-g@mail.gmail.com>
	<CAC5eUStphFGBZnMGgaSgqbjjwpyOAmHdOXyfYXD2t8n2RQMxgg@mail.gmail.com>
	<D08A366F.7D0A7%xzheng@christianbook.com>
	<CAC0_be2ofBNnztnqdds4B=LEYNeDCWjB0yrU_k+Yo6UnHjqccA@mail.gmail.com>
	<20141113182144.b8b7d91b26390b945dce2492@wanadoo.fr>
Date: Thu, 13 Nov 2014 12:45:09 -0500
Message-ID: 
 <CAC0_be2O52d63tor9Jt51EVnw1FQPoF6wEEyOH57VMNUZMjSqw@mail.gmail.com>
Subject: Re: Disconnect database connection after idle timeout
From: Perrin Harkins <pharkins@gmail.com>
To: Vincent Veyron <vv.lists@wanadoo.fr>
Cc: modperl <modperl@perl.apache.org>
Content-Type: multipart/alternative; boundary=047d7b5d9c63d5b11b0507c11284

--047d7b5d9c63d5b11b0507c11284
Content-Type: text/plain; charset=UTF-8

On Thu, Nov 13, 2014 at 12:21 PM, Vincent Veyron <vv.lists@wanadoo.fr>
wrote:

> Nobody suggested using connect_cached, where the documentations says :
>
> The cached database handle is replaced with a new
>        connection if it has been disconnected or if the "ping" method fails
>
> Would that not solve OP's problem?


Well, Apache::DBI should already be doing a ping and a successful
re-connect if needed. If that isn't working with Apache::DBI, there's no
reason to think it will work better with connect_cached. Also, Apache::DBI
has some additional things in it (avoiding caching connections during
startup, protection from dangling transactions at the end of a request)
that might be needed.

- Perrin

--047d7b5d9c63d5b11b0507c11284
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On T=
hu, Nov 13, 2014 at 12:21 PM, Vincent Veyron <span dir=3D"ltr">&lt;<a href=
=3D"mailto:vv.lists@wanadoo.fr" target=3D"_blank">vv.lists@wanadoo.fr</a>&g=
t;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=3D"im HOEnZb=
">Nobody suggested using connect_cached, where the documentations says :<br=
>
<br>
The cached database handle is replaced with a new<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0connection if it has been disconnected or if the=
 &quot;ping&quot; method fails<br>
<br>
Would that not solve OP&#39;s problem?</span></blockquote></div><br>Well, A=
pache::DBI should already be doing a ping and a successful re-connect if ne=
eded. If that isn&#39;t working with Apache::DBI, there&#39;s no reason to =
think it will work better with connect_cached. Also, Apache::DBI has some a=
dditional things in it (avoiding caching connections during startup, protec=
tion from dangling transactions at the end of a request) that might be need=
ed.</div><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">- =
Perrin</div></div>

--047d7b5d9c63d5b11b0507c11284--