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
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.

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.

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."

Re: SQL error
Posted: Wed Dec 16, 2015 2:54 am
by Ivan38Rus
Oh, now I see where confusion comes from
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