No subject
Sun Nov 20 20:48:46 GMT 2022
```
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.
```
--
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/dbix-class-schema-loader/issues/45
You are receiving this because you are subscribed to this thread.
Message ID: <dbsrgits/dbix-class-schema-loader/issues/45 at github.com>
----==_mimepart_637a93362dc92_71f2c6701899635
Content-Type: text/html;
charset=UTF-8
Content-Transfer-Encoding: 7bit
<p></p>
<p dir="auto">Migrated from <a href="https://rt.cpan.org/Ticket/Display.html?id=38600" rel="nofollow">rt.cpan.org#38600</a> (status was 'open')</p>
<p dir="auto">Requestors:</p>
<ul dir="auto">
<li><a href="mailto:TJC at cpan.org">TJC at cpan.org</a></li>
</ul>
<p dir="auto">Attachments:</p>
<ul dir="auto">
<li><a href="https://rt.cpan.org/Ticket/Attachment/499208/247330/loader_bug_demo_1.tar.gz" rel="nofollow">loader_bug_demo_1.tar.gz</a></li>
</ul>
<p dir="auto">From <a href="mailto:tjc at cpan.org">tjc at cpan.org</a> on 2008-08-20 06:35:50<br>
:</p>
<pre class="notranslate"><code class="notranslate">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.
</code></pre>
<p dir="auto">From <a href="mailto:tjc at cpan.org">tjc at cpan.org</a> on 2008-08-20 06:43:37<br>
:</p>
<pre class="notranslate"><code class="notranslate">Note that I've just tested against the current latest dev release, and
the problem remains.
</code></pre>
<p dir="auto">From <a href="mailto:ribasushi at leporine.io">ribasushi at leporine.io</a> on 2010-12-02 12:38:28<br>
:</p>
<pre class="notranslate"><code class="notranslate">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?
</code></pre>
<p dir="auto">From <a href="mailto:tjc at cpan.org">tjc at cpan.org</a> on 2010-12-03 02:34:43<br>
:</p>
<pre class="notranslate"><code class="notranslate">On Thu Dec 02 07:38:28 2010, RIBASUSHI wrote:
> 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."
</code></pre>
<p dir="auto">From <a href="mailto:tjc at cpan.org">tjc at cpan.org</a> on 2010-12-03 02:39:20<br>
:</p>
<pre class="notranslate"><code class="notranslate">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.
</code></pre>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/dbsrgits/dbix-class-schema-loader/issues/45">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AACJ4AVV7U6VCZUBINBNQRTWJKFLNANCNFSM6AAAAAASGAVX2U">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AACJ4AQ2K2J6O6PA5O5H7HLWJKFLNA5CNFSM6AAAAAASGAVX2WWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHFNWFRQA.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><dbsrgits/dbix-class-schema-loader/issues/45</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/dbix-class-schema-loader/issues/45",
"url": "https://github.com/dbsrgits/dbix-class-schema-loader/issues/45",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>
----==_mimepart_637a93362dc92_71f2c6701899635--
More information about the DBIx-Class-Devel
mailing list