Page 1 of 2

SQL error

Posted: Sun Dec 13, 2015 3:28 pm
by mrieder79
When I try to access my private messages, I get an SQL error. It says:


Incorrect key file for table '/tmp/#sql_6a84_0.MYI'; try to repair it [126]

Thanks for any help that can be provided.

Re: SQL error

Posted: Sun Dec 13, 2015 3:34 pm
by Aspect of Sorrow
This issue resides on the web server, the problem appears global.

1. Table corruption, needs the the repair syntax fired on the table having the issue (possibly phpbb_privmsgs).
2. Disk is nearing being out of available space and cannot expand the defined file

Re: SQL error

Posted: Sun Dec 13, 2015 3:36 pm
by mrieder79
Ah. So you are experiencing it too?

Re: SQL error

Posted: Sun Dec 13, 2015 3:37 pm
by Aspect of Sorrow
Image

Re: SQL error

Posted: Sun Dec 13, 2015 3:48 pm
by DM Narshe
It seems like a physical disk issue. They've run out of space (which happens more often than I'd like) and our usual fix seems to be pruning the forums.

I tried deleting a few obsolete threads but it didn't really resolve anything for us. I -could- try pruning the 55-pages of Auction House.... I know a lot of people source those old threads for pricing and item stats though.

And it's just a temporary measure that might not even fix it for us. The partition in question might be PM-specific rather than generalized forum stuff.

Re: SQL error

Posted: Tue Dec 15, 2015 9:01 am
by Duster47
Whatever it is also blocks the FTP site, hence the AutoDownLoader problems. No PM folder either.

The forums themselves are dropping in/out for me.

I vote for deleting some older forum content. I know design-side we have dozens of tabs of ancient threads that could probably be deleted. Even if it does not help, we can at least clean house.

Re: SQL error

Posted: Tue Dec 15, 2015 10:24 am
by Ivan38Rus
We can safely purge Community and General discussions, b/c topics there tend to lose relevance very quickly.

Re: SQL error

Posted: Tue Dec 15, 2015 10:48 am
by Steve
Quick! Someone get Ivan a drink...his sarcasm is overtaking his wit. :roll:

Re: SQL error

Posted: Tue Dec 15, 2015 9:12 pm
by DM Narshe
Cropped out 52 pages of Auction House stuff...

Hopefully we'll keep forums up for a while now. I'll do more pruning later.

Re: SQL error

Posted: Tue Dec 15, 2015 10:34 pm
by Tsidkenu
I am a little curious: would culling excessive and old pms help with forum server capacity?

Re: SQL error

Posted: Tue Dec 15, 2015 10:36 pm
by DM Narshe
Probably wouldn't hurt.

I believe the Inbox counts as a Folder and should eventually fill up. I'm not sure what the capacity is though.

Re: SQL error

Posted: Wed Dec 16, 2015 2:19 am
by Ivan38Rus
Steve wrote:Quick! Someone get Ivan a drink...his sarcasm is overtaking his wit. :roll:
What? I was being serious :(

Re: SQL error

Posted: Wed Dec 16, 2015 2:32 am
by Charraj
Ivan38Rus wrote:We can safely purge Community and General discussions, b/c topics there tend to lose relevance very quickly.
I understand Ivan to mean "delete old posts," not "totally purge those forums." :lol:

Re: SQL error

Posted: Wed Dec 16, 2015 2:54 am
by Ivan38Rus
Oh, now I see where confusion comes from :lol:

Yeah let's just censor forums completely :!:

Re: SQL error

Posted: Wed Dec 16, 2015 4:22 am
by Blackman D
last time luna had to do a forum clean up i know guild moderators were also asked if they could clear out old posts that werent needed, if any