On Wed, Dec 27, 2006 at 10:34:25AM -0600, Brandon Black wrote: > On 12/27/06, Chisel Wright <[EMAIL PROTECTED]> wrote: > >On Wed, Dec 27, 2006 at 10:35:27AM -0500, Jesse Sheidlower wrote: > >> Any suggestions what might be causing this, or where I should > >> start to try to figure it out? Keep in mind that I cannot seem > >> to force this to happen, so when it's OK, as it is now, I can't > >> get it started. > > > >This sounds a bit like the old "tell mysql not to be so annoying" flag - > >try setting the "mysql_auto_reconnect" option: > > > > http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm#mysql_auto_reconnect > > > >I think you can pass/set it in the DSN string. > > > > Also, if you just used DBIx::Class instead of straight DBI, automatic > reconnect would be transparently handled for you on all databases. > mysql_auto_reconnect is MySQL-specific, doesn't work if AutoCommit is > off, and doesn't re-establish locks (whereas using your locks within a > txn_do via DBIx::Class should always Do The Right Thing).
I _am_ just using DBIx::Class for this app. If this is supposed to be being handled for me, it's not doing a very good job.... Jesse Sheidlower _______________________________________________ List: [email protected] Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
