cleared whilst still active?

Hi,

I have a perl daemon fork subprocesses that uses DBI. They create their
own handle to connect to the database through and do not use the
daemon's handle. I have InactiveDestroy set to 1 in the daemon. I
noticed, though, that I was getting errors in my error log (see below).
I looked to make sure that I was calling $sth->finish on all of my
handles in the subprocess and I was.

Can anyone point me in the right direction for what I need to debug? I
turned on trace level 2 and ran the daemon first without forking and
second with forking to see if I could see the difference in the two and
what the problem might be (there were no errors when I did not have
forking on in the daemon). But, I can not really see what the issue
might be. I pasted both of those trace & errors below.

Thanks in advance for any help or direction anyone might be able to
provide.
~dave


ORIGINAL ERROR:
------------------------------------
DBI handle cleared whilst still active.
dbih_clearcom (drh 0xf373e0 0x0, com 0x11c5750, imp
DBD::mysql::dr):
FLAGS 0x215: COMSET Active Warn AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef

TRACE LOG WITH FORKING FUNCTION DISABLED:
-----------------------------------
DBI::db=HASH(0x11f7710) trace level set to 2 in DBI 1.40-ithread (pid
10616)
-> prepare for DBD::mysql::db (DBI::db=HASH(0x11ba6d0)~0x11f7710
'SELECT * FROM urls where frequency='5' and status='active' limit 1')
thr#504010
Setting mysql_use_result to 0
<- prepare= ( DBI::st=HASH(0x11f7900) ) [1 items] at daemonlwp.cgi
line 47
-> execute for DBD::mysql::st (DBI::st=HASH(0x11f7900)~0x11f79c0)
thr#504010
-> dbd_st_execute for 011f7a00
<- dbd_st_execute 1 rows
<- execute= 1 at daemonlwp.cgi line 48
-> fetchrow for DBD::mysql::st (DBI::st=HASH(0x11f7900)~0x11f79c0)
thr#504010
-> dbd_st_fetch for 011f7a00, chopblanks 0
<- dbd_st_fetch, 33 cols
<- fetchrow= ( '2536' 'cyberkid81' 'Advanced' '5' '89.95'
'2006-03-30 13:05:01' '1' '5' 'EDT' 'http://www.uvhosting.com/' '' ''
'' 'http://www.uvhosting.com/monitor/asgcookie.txt' '' ''
'http://www.joe.com' 'Computers' '' 'no' '' ''
'no|no|no|no|no|no|no|no|6' 'no|no|no|no|no|no|no|no|4' '' '' ''
'0000-00-00 00:00:00' '2005-10-11 04:55:46' 'active' '0' '' '1' ) [33
items] row1 at daemonlwp.cgi line 49
-> fetchrow for DBD::mysql::st (DBI::st=HASH(0x11f7900)~0x11f79c0)
thr#504010
-> dbd_st_fetch for 011f7a00, chopblanks 0
<- fetchrow= ( ) [0 items] row1 at daemonlwp.cgi line 79
-> finish for DBD::mysql::st (DBI::st=HASH(0x11f7900)~0x11f79c0)
thr#504010
<- finish= 1 at daemonlwp.cgi line 81
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x11f79c0)~INNER)
thr#504010
<- DESTROY= undef at daemonlwp.cgi line 92


TRACE WITH FORKING FUNCTION TURNED ON:
------------------------------------------------
DBI::db=HASH(0x11f7ec0) trace level set to 2 in DBI 1.40-ithread
(pid 11693)
-> prepare for DBD::mysql::db (DBI::db=HASH(0x11bae50)~0x11f7ec0
'SELECT * FROM urls where frequency='5' and status='active' limit 1')
thr#504010
Setting mysql_use_result to 0
<- prepare= ( DBI::st=HASH(0x11f80b0) ) [1 items] at daemonlwp.cgi
line 47
-> execute for DBD::mysql::st (DBI::st=HASH(0x11f80b0)~0x11f8170)
thr#504010
-> dbd_st_execute for 011f81b0
<- dbd_st_execute 1 rows
<- execute= 1 at daemonlwp.cgi line 48
-> fetchrow for DBD::mysql::st (DBI::st=HASH(0x11f80b0)~0x11f8170)
thr#504010
-> dbd_st_fetch for 011f81b0, chopblanks 0
<- dbd_st_fetch, 33 cols
<- fetchrow= ( '2536' 'cyberkid81' 'Advanced' '5' '89.95'
'2006-03-30 13:05:01' '1' '5' 'EDT' 'http://www.uvhosting.com/' '' ''
'' 'http://www.uvhosting.com/monitor/asgcookie.txt' '' ''
'http://www.joe.com' 'Computers' '' 'no' '' ''
'no|no|no|no|no|no|no|no|6' 'no|no|no|no|no|no|no|no|4' '' '' ''
'0000-00-00 00:00:00' '2005-10-11 04:55:46' 'active' '0' '' '1' ) [33
items] row1 at daemonlwp.cgi line 49
-> fetchrow for DBD::mysql::st (DBI::st=HASH(0x11f80b0)~0x11f8170)
thr#504010
-> dbd_st_fetch for 011f81b0, chopblanks 0
<- fetchrow= ( ) [0 items] row1 at daemonlwp.cgi line 79
-> finish for DBD::mysql::st (DBI::st=HASH(0x11f80b0)~0x11f8170)
thr#504010
<- finish= 1 at daemonlwp.cgi line 81
DBI::db=HASH(0x13da840) trace level set to 2 in DBI 1.40-ithread
(pid 11697)
-> do for DBD::mysql::db (DBI::db=HASH(0x13d2220)~0x13da840 'insert
into data values('','2536',NOW(),'1','265','1','0','206','','','','')')
thr#504010
<- do= 1 at browserbuilder.cgi line 294
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x11f8170)~INNER)
thr#504010
<- DESTROY= undef
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x11f7ec0)~INNER)
thr#504010
<- DESTROY= undef
DBI handle cleared whilst still active.
dbih_clearcom (drh 0xf373e0 0x0, com 0x11c5750, imp
DBD::mysql::dr):
FLAGS 0x215: COMSET Active Warn AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef
! -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x13da840)~INNER)
thr#504010
&imp_dbh->mysql: 13dadb8
! <- DESTROY= undef during global destruction

.

Relevant Pages