Hi, im new to this list, but have joined since I have come across
something im not quite sure what to make of.
Basically, we are using ithreads in perl 5.8.0-RC3 and using DBI-1.29 to
access a mysql database. Everything seems to work ok, except when we
try to create a new thread AFTER a database connection has been created
in the main process, in which case it seems that perl is trying to clone
the DBI connection (which is understandable as that is what ithreads
does) but then failing. My guess is that it is either DBI is not fully
compatable with it (contrary to what I have read) or I am doing
something stupid (far more likely).
If anyone has experience of anything like this, do you have any
pointers? This is the error I am getting:
thread failed to start: DBD::mysql::dr connect failed: handle 1 is owned
by thread 8123da8 not current thread 8495d20 (handles can't be shared
between threads and your driver may need a CLONE method added) at
/usr/lib/perl5/site_perl/5.8.0/i686-linux-thread-multi/DBI.pm line 503.
CONE DBI for new thread (dbis 81ba870 -> 886b500)
DESTROY ignored because DBI handle (type=3) is owned thread 84782f8
not current thread 8642378
DESTROY ignored because DBI handle (type=2) is owned thread 8473510
not current thread 8618de0
DESTROY ignored because DBI handle (type=2) is owned thread 8473510
not current thread 8618de0
DESTROY ignored because DBI handle (type=1) is owned thread 8471848
not current thread 85ad8d0
DESTROY ignored because DBI handle (type=3) is owned thread 84782f8
not current thread 8642378
Scalars leaked: 1
-> fetchrow_array for DBD::mysql::st
(DBI::st=HASH(0x84879d8)~0x8487b94) thr#8123da8
-> dbd_st_fetch for 08487a50, chopblanks 0
<- dbd_st_fetch, 3 cols
<- fetchrow_array= ( '6' 'data' 'data) [3 items] row2 at Search.pm
line 55
CONE DBI for new thread (dbis 81ba870 -> 888dbb0)
in distributed query, tid is 4
-> DBI->connect(DBI:mysql:info_search:devdb.info-plc.com, cacheuser,
****)
-> DBI->install_driver(mysql) for linux perl=5.008 pid=5280 ruid=500
euid=500
install_driver: DBD::mysql version 2.1017 loaded from
/usr/lib/perl5/site_perl/5.8.0/i686-linux-thread-multi/DBD/mysql.pm
<- install_driver= DBI::dr=HASH(0x87e4620)
Any help would be appreciated.
Ray
