Tie::RDBM vs. MySQL ithread problems

[Autrijus Tang]

On Sun, Nov 24, 2002 at 08:20:44PM -0500, Lincoln Stein wrote:
> On Sunday 24 November 2002 06:18 pm, Autrijus Tang wrote:
> > Also I noticed that in Apache2 mod_perl1.99_07 Win2k Perl5.8
> > DBD::mysql2.1020 DBI1.30, Tie::RDBM constantly produces this
> > ithreads-related error:
> >
> >     "->prepare failed: handle %d is owned by thread %x not current thread
> > %x (%s)", "handles can't be shared between threads and your driver may need
> > a CLONE method added"
> >
> > The statement that causes this is in line 330, _prepare():
> >
> >     my $sth = $self->{'dbh'}->prepare($q);
> >
> > This is very strange since DBD::mysql does in fact have a CLONE
> > method, and other frameworks (like DBIx::SearchBuilder) does not
> > encouter such problems.
> >
> > Does it mean Tie::RDBM will need a CLONE method, or there is
> > something obvious that I am missing?
>
> I haven't played much with ithreads.  Would you be willing to look into this?
> Lincoln

Unfortunately I don't have much clues into ithreads DBI/DBD::mysql
programming, either -- I have applied a workaround that have the
Tie::RDBM object to do a new DBI->connect each time, which of course
solved this problem, at a prohibitive cost.

(Cc'ing [EMAIL PROTECTED], in the hope that somebody can give a
 hint on where to start debugging)

Thanks,
/Autrijus/

msg14320/pgp00000.pgp
Description: PGP signature