GEFL Database locked up

[Yoda]

I am working with the webhost atm trying to get this resolved, but until then the database (which contains the forum) is locked up.

If anyone has some insight to help, this what is causing the error-

Time: 99% (18834 sec) Amount: 50% (3 queries) Rows Examined/Sent: 5.70282e+09 / 537 Avg. Query Exec/Lock Time: 6278 / 0 sec.
Used databases: [mastery_jimmyforum]
Query example: use mastery_jimmyforum; SELECT m.position AS position, h.id AS playerid, h.position AS posid, firstname, lastname, nickname, draftround, draftpick, yeardraft, yearretired, sum(passcompletions) AS cmp, sum(passattempts) AS att, sum(passyards) AS passyds, sum(tdpasses) AS tdpasses, sum(intthrown) AS picks, sum(passplays) AS passplays, sum(pat) AS xp, sum(patattempted) AS xpa, sum(puntin20) as in20, sum(rushattempts) AS rushatt, sum(rushingyards) AS rushyds, sum(rushtd) AS rushtd, sum(catches) AS catches, sum(receivingyards) AS recyds, sum(receivingtds) AS rectds, sum(passtargets) AS tgts, sum(keyrunblock) AS krb, sum(keyrunblockopport ... [too long]
|id rows Extra
|1 10248 Using where; Using temporary; Using filesort
|1 1 Using where
|1 302694

[jdavidbakr]

Originally Posted by Yoda

I am working with the webhost atm trying to get this resolved, but until then the database (which contains the forum) is locked up.

If anyone has some insight to help, this what is causing the error-

Time: 99% (18834 sec) Amount: 50% (3 queries) Rows Examined/Sent: 5.70282e+09 / 537 Avg. Query Exec/Lock Time: 6278 / 0 sec.
Used databases: [mastery_jimmyforum]
Query example: use mastery_jimmyforum; SELECT m.position AS position, h.id AS playerid, h.position AS posid, firstname, lastname, nickname, draftround, draftpick, yeardraft, yearretired, sum(passcompletions) AS cmp, sum(passattempts) AS att, sum(passyards) AS passyds, sum(tdpasses) AS tdpasses, sum(intthrown) AS picks, sum(passplays) AS passplays, sum(pat) AS xp, sum(patattempted) AS xpa, sum(puntin20) as in20, sum(rushattempts) AS rushatt, sum(rushingyards) AS rushyds, sum(rushtd) AS rushtd, sum(catches) AS catches, sum(receivingyards) AS recyds, sum(receivingtds) AS rectds, sum(passtargets) AS tgts, sum(keyrunblock) AS krb, sum(keyrunblockopport ... [too long]
|id rows Extra
|1 10248 Using where; Using temporary; Using filesort
|1 1 Using where
|1 302694

you could try running optimize and repair on your DB tables

[Yoda]

I'll pass that along to the webhost. At the moment, they have the DB locked away and I cannot access it.

[marc_rdfl]

Isn't this just that there's a query that's running that has buggered things up? Can't they kill any queries running on the d/b currently?

Once they do, then check with Ben as to what query this runs off (my guess would be draft history which doesn't work properly on the GEFL site)

[Yoda]

Yes, that is what it appears to be.

I am sure they can, and they have. Like I said, I have no access to the database atm.

Honestly, right now I am more worried about just getting the database restored because they are refusing to restore it until the situation is resolved.

[Subby]

Probably makes sense to reach out to Ben to see if he can help.

[gstelmack]

Take that particular page down then.

[Ben E Lou]

Originally Posted by Subby

Probably made sense to reach out to Ben to see if he can help.

Fixed. It sounds like there's no access to the database at this point, so there's nothing I can do. The information above doesn't tell me for certain what page caused the error, even. This query...

SELECT m.position AS position, h.id AS playerid, h.position AS posid, firstname, lastname, nickname, draftround, draftpick, yeardraft, yearretired, sum(passcompletions) AS cmp, sum(passattempts) AS att, sum(passyards) AS passyds, sum(tdpasses) AS tdpasses, sum(intthrown) AS picks, sum(passplays) AS passplays, sum(pat) AS xp, sum(patattempted) AS xpa, sum(puntin20) as in20, sum(rushattempts) AS rushatt, sum(rushingyards) AS rushyds, sum(rushtd) AS rushtd, sum(catches) AS catches, sum(receivingyards) AS recyds, sum(receivingtds) AS rectds, sum(passtargets) AS tgts, sum(keyrunblock) AS krb, sum(keyrunblockopport

...is a pretty generic one to grab some stats. I have no idea from this which page might have caused it, and why whatever page this is has worked in several other leagues but is evidently causing problems in this one.

[Yoda]

Which is why I am waiting for more information before directly contacting Ben. Honestly, I feel it's better to ask general questions to the community at large instead of sending messages to Ben eachtime something creeps up. If I am mistaken in that, I apologize.

I didn't know if someone else had a similar issue.

Right now, that is all the information I have gotten from the webhost. I just got off the phone with them and they are supposed to be getting me the particular file that is causing the issue.

[Subby]

Any luck? Jonesing for GEFL results.

[Yoda]

Nothing yet. :/

I'm on the phone with them atm.

[Alf]

Site is back up for those inquiring.