Bug #38600 for DBIx-Class-Schema-Loader: DBIC-Schema-Loader incompatible with Apache threads.

Wed Aug 20 02:35:50 2008 TJC [...] cpan.org - Ticket created

Subject:

DBIC-Schema-Loader incompatible with Apache threads.

DBIx::Class::Loader 0.21 is not compatible with Apache running in worker(threaded) mode on Linux, at least not on my tested environment, which was: DBIx::Class::Schema::Loader 0.04005 DBIx::Class 0.08010 and 0.08099_04 DBI 1.601 (and a slightly earlier) DBD::Pg 2.8.6, 2.9.0 and another fairly older one. Note that DBIx::Class::Schema works in the same configuration when used without -Loader. I attach a fairly complete demonstration app. See README for setup/installation instructions. Also, I note that this website seems to mention the problem and a potential couple of fixes: http://d.hatena.ne.jp/holidays-l/20070126/p1 Unfortunately I can't read Japanese, but the code itself looks OK.

Subject:

loader_bug_demo_1.tar.gz

Download loader_bug_demo_1.tar.gz
application/x-gzip 5.3k

Message body not shown because it is not plain text.

Wed Aug 20 02:42:47 2008 TJC [...] cpan.org - Broken in 0.04999_05 added

Wed Aug 20 02:43:37 2008 TJC [...] cpan.org - Correspondence added 10 min

Note that I've just tested against the current latest dev release, and the problem remains.

Thu Dec 02 07:38:28 2010 ribasushi [...] leporine.io - Correspondence added

On Wed Aug 20 02:35:50 2008, TJC wrote: Show quoted text

> DBIx::Class::Loader 0.21 is not compatible with Apache running in > worker(threaded) mode on Linux, at least not on my tested environment, > which was: > DBIx::Class::Schema::Loader 0.04005 > DBIx::Class 0.08010 and 0.08099_04 > DBI 1.601 (and a slightly earlier) > DBD::Pg 2.8.6, 2.9.0 and another fairly older one. > > Note that DBIx::Class::Schema works in the same configuration when used > without -Loader. > > I attach a fairly complete demonstration app. See README for > setup/installation instructions. > > > Also, I note that this website seems to mention the problem and a > potential couple of fixes: http://d.hatena.ne.jp/holidays-l/20070126/p1 > Unfortunately I can't read Japanese, but the code itself looks OK.

Is this still a problem?

Thu Dec 02 07:38:29 2010 The RT System itself - Status changed from 'new' to 'open'

Thu Dec 02 21:34:43 2010 TJC [...] cpan.org - Correspondence added

On Thu Dec 02 07:38:28 2010, RIBASUSHI wrote: Show quoted text

> On Wed Aug 20 02:35:50 2008, TJC wrote:

> > DBIx::Class::Loader 0.21 is not compatible with Apache running in > > worker(threaded) mode on Linux, at least not on my tested environment, > > which was: > > DBIx::Class::Schema::Loader 0.04005 > > DBIx::Class 0.08010 and 0.08099_04 > > DBI 1.601 (and a slightly earlier) > > DBD::Pg 2.8.6, 2.9.0 and another fairly older one. > > > > Note that DBIx::Class::Schema works in the same configuration when used > > without -Loader. > > > > I attach a fairly complete demonstration app. See README for > > setup/installation instructions. > > > > > > Also, I note that this website seems to mention the problem and a > > potential couple of fixes: http://d.hatena.ne.jp/holidays-l/20070126/p1 > > Unfortunately I can't read Japanese, but the code itself looks OK.

> > Is this still a problem?

Took me a while to build a new VM and set it up with everything, since I don't run Apache any more, especially not the threaded version. However - yes, I can confirm the problem still occurs on Ubuntu Maverick, with its versions of Apache (2.2), Perl (5.10.1), mod_perl, mpm_worker, and all the latest version of Perl modules installed from CPAN. http://192.168.1.204/testdbic/loader Caught exception in MyApp::Controller::Root->loader "DBD::Pg::db STORE failed: handle 2 is owned by thread 7f0ffc427bf0 not current thread 7f1002cd92c0 (handles can't be shared between threads and your driver may need a CLONE method added) at /usr/local/share/perl/5.10.1/DBIx/Class/Storage/DBI.pm line 217."

Thu Dec 02 21:34:55 2010 TJC [...] cpan.org - Broken in 0.07002 added

Thu Dec 02 21:37:47 2010 TJC [...] cpan.org - Reference to ticket #63558 added

Thu Dec 02 21:39:20 2010 TJC [...] cpan.org - Correspondence added

BTW I opened another ticket (63558) about some warnings in the unit tests from DBIC about DCSL holding cached references when it shouldn't be.. I just wondered if maybe that's related to this bug, since if DCSL was closing the handles properly then the new threads would all re-open their own handles just fine. Or maybe it's unrelated.