[Catalyst] Shared database handles under mod_perl 2.0 / Catalyst 5.33?

Jules Bean jules at jellybean.co.uk
Fri Nov 11 08:30:51 CET 2005


Perrin Harkins wrote:
> On Thu, 2005-11-10 at 13:34 -0600, Brandon Black wrote:
>   
>> The most compelling evidences that it's a shared database handle
>> problem I'm facing are:
>> 1) Problem dissappears under the built-in testing server
>> (scripts/myapp_server.pl)
>> 2) Problem will not occur as long as all my requests land on a single
>> apache child.  If I tie that child up (telnet host 80) and issue
>> another request, which goes off to the 2nd child in line, the problem
>> immediately appears.
>> 3) The PostgreSQL database server only shows a single connection from
>> anybody, even when I have multiple concurrent children up that have
>> answered database-backed requests (or at least, tried to).
>>     
>
> Sounds like you need this:
> http://cdbi.dcmanaged.com/wiki/Using_with_mod_perl
>   

IMO that should be a standard part of Catalyst::Model:{CDBI,DBIC}, if it 
is indeed needed?

Jules



More information about the Catalyst mailing list