in reply to mysql, locked databases, Apache::DBI and mod_perl
Well I found the source of my problem, and now I want to go bang my head against a wall. It seems PodMaster was closer than I thought in his private messages to me. On the assumption he doesn't mind, I'll quote him here:
PodMaster says reading your various troubles with DBI under mod_perl I can't help but get the screaming feeling that you really haven't learned scoping basics -- I hope i'm wrong, but it doesn't look that way (and them problems aren't generic enough to be resolve, much less properly diagnosed without proper disclosure)
perrin also mentioned the possibility here.
Both were pretty close, I had overlooked one thing. I had declared $state with my as could be seen in the code snippet I posted here. Until now, it hasn't made much of a difference where I declared it because each sub declared it's own $state, preventing $state from being cloned into it... I had recently added 2 new subs one of which did not need $state, and so it was not declared there... thus it was cloned in. In order to fix it, I modified the scope of $state, eliminating the chance that could happen again, and changed a few other variables while I was at it.
Thank you to those who offered advice and assistance.
My code doesn't have bugs, it just develops random features.
Flame ~ Lead Programmer: GMS (DOWN) | GMS (DOWN)