Solution: mysql, locked databases, Apache::DBI and mod_perl

[Flame]

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)