a) i fixed the 'message xxxx' errors - they were indeed from an accidentally preforked handle. i'll try to make a note or something for apache docs this evening.

b)

I did a bunch of tracing this morning it seems that apache::dbi isn't always issuing the rollback at cleanup

I set a trace level on my dbi arg, and have a handler print a marker for the cleanup phase

 the bulk of time I get something like this:

==============CLEANUP DBI::db=HASH(0x1a2c918) trace level set to 0x0/1 (DBI @ 0x0/0) in DBI 1.50-ithread (pid 24285) <> FETCH('TraceLevel')= 1 ('TraceLevel' from cache) at DBI.pm line 667
    <- STORE('Username' 'XXXXX')= 1 at DBI.pm line 667
<> FETCH('Username')= 'XXXXX' ('Username' from cache) at DBI.pm line 667 <- STORE('dbi_connect_closure' CODE(0x1a2be3c))= 1 at DBI.pm line 683


if there's an invalid sql command executed in my transaction though,
==============CLEANUP

is all i get. no cleanup is issued (rollback/closure/etc) on the dbi, and i'm still using a bad cached handle on subsequent page views , necessitating a page start.

the above arguments were with a TraceLevel1 - i also did a TraceLevel 15, and saw no additional commands executed.

anyone have a suggestion on where I can look next?



Reply via email to