On Sunday 17 July 2011 18:18:25 Mr. Puneet Kishor wrote:
I think I may have found a reason and a (temporary) solution. Actually, I didn't find it, but a helpful person at Stackoverflow suggested that I may be creating a $dbh that might be getting shared by different Starman preforked children (see link below). I think that was the case. I am still testing it by moving the $dbh creation in the subs.
Ah, yes, that certainly sounds a plausible explanation. I'm biased of course, but might I recommend letting Dancer::Plugin::Database handle the creation & re-use of database handles for you? It's exactly what it's designed for, and it goes to lengths to ensure that handles are not shared between processes/threads, to avoid issues just like this one. -- David Precious ("bigpresh") http://www.preshweb.co.uk/ "Programming is like sex. One mistake and you have to support it for the rest of your life". (Michael Sinz)