SQL error

mrieder79 · Unread post by **mrieder79** » Sun Dec 13, 2015 3:28 pm

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.

Sun Dec 13, 2015 3:34 pm

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

mrieder79 · Unread post by **mrieder79** » Sun Dec 13, 2015 3:36 pm

Ah. So you are experiencing it too?

Sun Dec 13, 2015 3:37 pm

DM Narshe · Unread post by **DM Narshe** » Sun Dec 13, 2015 3:48 pm

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.

Duster47 · Unread post by **Duster47** » Tue Dec 15, 2015 9:01 am

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.

Ivan38Rus · Unread post by **Ivan38Rus** » Tue Dec 15, 2015 10:24 am

We can safely purge Community and General discussions, b/c topics there tend to lose relevance very quickly.

Steve · Unread post by **Steve** » Tue Dec 15, 2015 10:48 am

Quick! Someone get Ivan a drink...his sarcasm is overtaking his wit.

DM Narshe · Unread post by **DM Narshe** » Tue Dec 15, 2015 9:12 pm

Cropped out 52 pages of Auction House stuff...

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

Tsidkenu · Unread post by **Tsidkenu** » Tue Dec 15, 2015 10:34 pm

I am a little curious: would culling excessive and old pms help with forum server capacity?

DM Narshe · Unread post by **DM Narshe** » Tue Dec 15, 2015 10:36 pm

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.

Ivan38Rus · Unread post by **Ivan38Rus** » Wed Dec 16, 2015 2:19 am

Steve wrote:Quick! Someone get Ivan a drink...his sarcasm is overtaking his wit.

What? I was being serious

Charraj · Unread post by **Charraj** » Wed Dec 16, 2015 2:32 am

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

Ivan38Rus · Unread post by **Ivan38Rus** » Wed Dec 16, 2015 2:54 am

Oh, now I see where confusion comes from

Yeah let's just censor forums completely

Blackman D · Unread post by **Blackman D** » Wed Dec 16, 2015 4:22 am

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

SQL error

SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error

Re: SQL error