[rt-users] Problems with RT3 losing MySQL connection

[Jesse Vincent]

On Sat, Jul 12, 2003 at 08:13:43AM -0700, Derek Suzuki wrote:
>  I am running RT 3.0.3 under FastCGI with Apache 1.3.27 and MySQL 4.0.13 on
> Red Hat 7.3.  I basically have everything working okay, but if I leave the
> system alone overnight and try to access it again in the morning, I get the
> following error:
> 
> RT Couldn't write to session directory '/usr/local/rt/var/session_data':
> DBD::mysql::st execute failed: MySQL server has gone away at
> /usr/lib/perl5/site_perl/5.6.1/Apache/Session/Lock/MySQL.pm line 54.

What version of DBIx::SearchBuilder are you running?

>  Is there a robust workaround for this problem?  Either a keepalive, or
> (preferably) a reliable way to re-establish a dropped connection on the fly?

I seem to recall dealing with this in the RT 3.0.3 / searchbuilder 0.88
timeframe. if that's not the case, I'd like to know.

	-j


> Thanks,
> Derek
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.