[Catalyst] Cat + DBIC + DBD-Pg + mpm_worker -- Solution

[Matt S Trout]

On Wed, Aug 13, 2008 at 11:59:11AM +1000, Toby Corkindale wrote:
> On Tue, Aug 12, 2008 at 02:03:56PM +1000, Toby Corkindale wrote:
> > Hi,
> > I know the Cat cookbook suggests one should use mod_perl only with the
> > preforking MPM.. but I wanted to try with the worker (ie. threaded) MPM anyway.
> > 
> > DBD-Pg had some thread-safety work done years ago, and I meant to be fine..
> > However I'm seeing errors like this one:
> >   Couldn't render template "undef error - DBD::Pg::db STORE failed:
> >   handle 2 is owned by thread 84e5bf0 not current thread 8fe48f8 (handles can't
> >   be shared between threads and your driver may need a CLONE method added) at
> >   /usr/lib/perl5/vendor_perl/5.8.8/DBIx/Class/Storage/DBI.pm line 723.
> > 
> > I've checked, and I am running a recent version of DBD-Pg, that does indeed
> > have the required CLONE function. (Ver 2.8.6)
> > 
> > Are there any known issues with Cat+DBIC+DBD-Pg here? Or maybe I just have
> > screwed something else up..
> 
> Following up on this after some more investigation last night..
> I was previously using DBIx::Class::Schema::Loader. I swapped to a static
> DBIx::Class::Schema setup, and the problem vanished..
> 
> I had a google around for anyone else with this issue, and found a japanese
> site I can't understand which looks to be mentioning it too, including a fix.
> http://d.hatena.ne.jp/holidays-l/20070126/p1

COuld you try the last DBIC dev release?

Also, please can you keep DBIC questions on the DBIC list :)

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/