o.O

• prepare your statement to get a handle
• execute to fetch results
• call whatever fetch routines to retrieve all the results
• WHEN YOU ARE DONE FETCHING RESULTS call finish on the handle

*plonk*

Edit: Obviously from the errors in the OP he's not fetching all the results from the queries and he's not scoping his handles such that they're destroyed before the DB handle is cleaned up, so he either needs to explicitly finish when he's not going to fetch anything more or properly scope the handles so they're cleaned up automagically as documented. Given the historical behavior of the source that's unlikely.