it definitely seems to be a leak, and i've been able to reproduce it outside of mod_perl

it seems that there are a few potential sources / behaviors

a_ the statement handle created by a prepare never seems to expire in the lifetime of a db connection
                i could trace this as far back as
                        DBI::_new_handle

b_ if i connect, run 100 'update x where y=z' , then disconnect, no SV are released

c_ if i then undef my db handle, a lot of SV are freed - but i seem to have a 138 SV which are not released

d_ if i reconnect , i seem to use only 15 more SV than the original connect- whereas the original connect used 231 SV over my test platforms 'weight'

e_ if i undef the reconnect, I seem to have leaked 1 SV since the first disconnect

unfortunately, thats as far as my DBI knowledge can take me


Reply via email to