On Thu, 2004-05-06 at 12:42, Hans Poo R. wrote: > I removed the manual rollback and let the job to Apache::DBI, the problem is > that after the change, the message about the handle destroyed still appears in > the log. I activated the $Apache::DBI::DEBUG variable, but the message persist > (now with the DEBUG information).
Does the debug info show that Apache::DBI is holding onto the connection or making a new connection every time? The error you're getting is one that DBI gives when a database handle goes out of scope (or gets explicitly undef'ed) without being disconnected. A handle that Apache::DBI is keeping persistent should not get DESTROY'd when it goes out of scope. You might want to run this in the debugger and see where this is happening. > It looks like it's a postgreSQL specific problem. I don't see anything PostgreSQL-specific in the errors you showed us. - Perrin -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html