Skip Menu |

This queue is for tickets about the Catalyst-Plugin-Session-Store-DBI CPAN distribution.

Report information
The Basics
Id: 27205
Status: resolved
Priority: 0/
Queue: Catalyst-Plugin-Session-Store-DBI
People
Owner: Nobody in particular
Requestors: DROLSKY [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Sun May 20 10:43:59 2007 DROLSKY [...] cpan.org - Ticket created
Subject: Does not deal with handle timeout gracefully
I noticed this problem when I leave my dev server running overnight and try to use it the next morning. The database handle is disconnected because it timed out (I assume), and I get this error - "DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/share/perl/5.8.8/Catalyst/Plugin/Session/Store/DBI.pm line 30." The problem is that the code is creating a bunch of statement handles once and then using them forever, but it doesn't try to ensure that the underlying database handle is still active. It might make sense to add a ping() call in _session_sth() and delete all the statement handles if that fails.
  Sun May 20 10:54:09 2007 AGRUNDMA [...] cpan.org - Correspondence added
From: AGRUNDMA [...] cpan.org
Since 0.11 the _session_sth method has done a check for this sort of thing. Is it not working properly?
  Sun May 20 10:54:19 2007 The RT System itself - Status changed from 'new' to 'open'
  Sun May 20 11:04:06 2007 autarch [...] urth.org - Correspondence added
Subject: Re: [rt.cpan.org #27205] Does not deal with handle timeout gracefully
Date: Sun, 20 May 2007 10:02:16 -0500 (CDT)
To: via RT <bug-Catalyst-Plugin-Session-Store-DBI [...] rt.cpan.org>
From: Dave Rolsky <autarch [...] urth.org>
On Sun, 20 May 2007, via RT wrote: Show quoted text
> > <URL: http://rt.cpan.org/Ticket/Display.html?id=27205 > > > Since 0.11 the _session_sth method has done a check for this sort of > thing. Is it not working properly?
Doh, I didn't have the latest version installed. You can probably close this bug. -dave /*=================================================== VegGuide.Org www.BookIRead.com Your guide to all that's veg. My book blog ===================================================*/
  Sun May 20 11:06:07 2007 AGRUNDMA [...] cpan.org - Correspondence added
Great, let me know if you still see any problems.
  Sun May 20 11:07:02 2007 AGRUNDMA [...] cpan.org - Status changed from 'open' to 'resolved'