Chat box

[Michu]

Originally Posted by fick

Don't know Joel, not sure I was online last time we had a major issue...

Edit:

I think I know what error is, its searching a table of contents too large to process.

[Sweey]

Originally Posted by Joel

Was the same message coming up when we had a problem the last time?

Yes.

EDIT: For the chat box at least.

[Hunter]

As Joel has said, even the Admin CP is problematic right now for the most part. Frustration?

[Michu]

This may help

MySQL > java.sql.SQLException: Error writing file '/tmp/MY1kynpA' (Errcode: 28)
by Sarath Chandra Pandurangi at 16:26 | 1 Comment | OpenShare Share

Recently, a heavy burst of traffic into our production webservice caused this error. As with all Mysql errors, this shows little information. Like any sane person would think, we checked if the filesystem was full. We found the /tmp has 98% free space. Permissions are all fine. No locks on table. Increasing /tmp partition - NoGo. Just crazy error message.

However, the issue was beating us time and again. It took us a couple of days and we realized the cause was a select query. The query was fetching from a table of about 2 million records. Although it was fetching a limited subset, the column in the order by had no index. This was causing mysql to load records into pagefile in tmp for sorting, apparently.

Created the index on the sort column seemed to have solved the problem. We also augmented it with the following options in my.cfg

sort_buffer_size=2M
table_cache=1800
thread_cache_size=384
tmp_table_size=64M

[Joel]

It's not that you don't have the power to get in, it's because the database is full and not functioning properly.

Only person who can increase our power right now is Matt Holme.

I think I found a solution, but none of the current admins have the power to do it. I've emailed Matt Holme, so all we can do is wait.

I just wish I saw this issue earlier.

[Jonno394]

Was the 250k thread deleted because of this?

[Joel]

Yes.

[Michu]

Originally Posted by Joel

Yes.

A soft or hard delete from the database just out of curiosity?

[Joel]

Hard.

[Michu]

Originally Posted by Joel

Hard.

So it really is adios to essentially the heart of Spammers paradise. In terms of the rest of Spammers paradise, there is little that is active or perhaps little even worth keeping. Maybe it might be worth hard deleting a lot of the old closed threads to free up space. A bit of late spring cleaning.

[fick]

Not that the thread was a hive of activity any more. The chatbox has pretty much seen to that

[Sweey]

Originally Posted by Sminky

Maybe it might be worth hard deleting a lot of the old closed threads to free up space. A bit of late spring cleaning.

That's not necessary.

[Michu]

Originally Posted by :>

That's not necessary.

Fair enough, although the closed threads could do with archiving in my humble pensionable opinion.

[Jonno394]

Another database issue on the chatbox (and can't access some clearly delightful PM's off a certain cretin).