[darkpuppet]

S2,Oct 13 2006, 04:18 PM Wrote:http://www.focuscanada.net/forum/index.php...ounce&f=12&id=9
[right][snapback]211511[/snapback][/right]

I wish that were the case... this is the best I can make of the situation from what I'm allowed to poke around with...

Occasionally there are circumstances that cause some of the database connections (or threads holding them) to hang. It could be anything from a memory leak to a connectivity issue.. whatever...

Anyways, what happens usually is that the threads don't wait long enough before timing out and retrying. When the eventual bottlenecks open up, you get a bunch of duplicated queries being submitted which can collide and even crash a table in the database.

So I run a 'fix' on the database and reset db connections and everything comes up dandy again. I'm not sure why it's happened twice in a 4 month period, but I'll keep an eye on it and see about opening a ticket with the support folks at the hosting company (would actually be a first)