Poxy fule

Message Bookmarked
Bookmark Removed
Not all messages are displayed: show all messages (379 of them)
STARSBUCK COFFEE

Ruud Haarvest (KenL), Wednesday, 30 August 2006 15:24 (seventeen years ago) link

and now every bugger trying to find old threads to bump has killed it dead agane.

stet (stet), Wednesday, 30 August 2006 17:05 (seventeen years ago) link

Any idea what's happened - I didn't get a chance to have a read through the relevant threads before it buggered off again.

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 17:36 (seventeen years ago) link

I think with the recently publicity we've received it's just chock-a-block with users.

Ruud Haarvest (KenL), Wednesday, 30 August 2006 17:39 (seventeen years ago) link

The new answers cache was deleted, I guess an attempt to unpoxy the fule by reducing server load?

I Am Curious (George) (Slight Return) (Rock Hardy), Wednesday, 30 August 2006 17:39 (seventeen years ago) link

How was the fap in Edinburgh? I wish I could have been at some of those Scottish ken faps.

Ruud Haarvest (KenL), Wednesday, 30 August 2006 17:41 (seventeen years ago) link

Ken, I know about that*, I meant recently, like in the last couple of hours with all the new answers gone.

(xpost)

*though I still struggle to believe that one article in the Observer Music Monthly has crashed this for weeks on end.

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 17:43 (seventeen years ago) link

You should come over for a double ken-fap! It was small but perfectly formed and very pleasant indeed. Drinks, football-watching, Thai food and Belle and Sebastian. Pretty much a perfect day out, really.

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 17:45 (seventeen years ago) link

xpost:
Sorry, Ailsa, I just wanted to say that because once we were in Edinburgh in August and we managed to find a hotel for one night and the guy told us possibly maybe he could let us have a room the next night if the Great Northern Railway rep didn't need it. Well, that didn't work out so he said he would try to help us find another room, but when we came down to breakfast he said: "I've called round, but Edinburgh's just chock-a-block with the Festival!"

Ruud Haarvest (KenL), Wednesday, 30 August 2006 17:50 (seventeen years ago) link

The search function can kill the whole thing with just one user. When the cache got corrupted, loads of people started searching to try and bump old threads.

For some reason there's no timeout set on searches, so the server will continue with the very, very slow search until it's done. While it's searching, nothing else can access it. Hmph.

stet (stet), Wednesday, 30 August 2006 17:56 (seventeen years ago) link

People should've revived threads via New Questions.

jaymc, Wednesday, 30 August 2006 18:48 (seventeen years ago) link

Yeh, it was the ancient threads that did it, I think.

stet (stet), Wednesday, 30 August 2006 18:57 (seventeen years ago) link

Point the search link to Google.

nu_onimo (nu_onimo), Wednesday, 30 August 2006 19:27 (seventeen years ago) link

Until nu_ILX code is sorted, that is. One less overhead to worry about.

nu_onimo (nu_onimo), Wednesday, 30 August 2006 19:28 (seventeen years ago) link

The quickest fix could well be to put a timeout on SQL queries. But I don't know how many people have server access these days to do that.

stet (stet), Wednesday, 30 August 2006 19:49 (seventeen years ago) link

Well. that was good for about five minutes. Is it just the search function that knackers it, or does random, viewing expanded categories etc do it as well?

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 21:34 (seventeen years ago) link

Opening the categories page is another big hit, but by far the worst culprit is doing a search.

stet (stet), Wednesday, 30 August 2006 21:44 (seventeen years ago) link

Can we stick something on the new answers pages of ILX telling people to cool it with the search function?

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 21:46 (seventeen years ago) link

(when I say "we" I mean "someone that isn't me", obviously. Sorry.)

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 21:47 (seventeen years ago) link

i can't understand why anyone bothers with the ILX search anyway. it's a heap of spectacular shit. ever since i realised google can search the thing, that's the method i've used.

the real ILX has just popped back up while i type. new answers has even less on it than it did last time i looked.

the whole thing is fucked, and is obviously going to remain so until someone posts something sensible on every new answers page saying: YO ILX0RS, DON'T USE THE FUCKING SEARCH, or similar.

at the moment it's something of a clusterfuck and i haven't really got time to worry about it.

grimly fiendish (simon), Wednesday, 30 August 2006 21:58 (seventeen years ago) link

OK, now there are no new answers at all again on the new answers page. Give it two minutes before everyone starts searching for stuff and it all goes tits up again...

ailsa_xx (ailsa_xx), Wednesday, 30 August 2006 22:20 (seventeen years ago) link

Results 1 - 10 of about 87 from ilx.wh3rd.net for "tits up". (0.11 seconds)

Google pwns poxy search.

nu_onimo (nu_onimo), Wednesday, 30 August 2006 22:58 (seventeen years ago) link

Um, aren't a lot of threads deindexed?

Ruud Haarvest (KenL), Wednesday, 30 August 2006 23:46 (seventeen years ago) link

Hm, I thought I had posted something about using Thread Titles and Login Names in searches.

Ruud Haarvest (KenL), Thursday, 31 August 2006 00:35 (seventeen years ago) link

http://www.geocities.com/alcus2/rickynelson4.jpg
Poor little fule, oh yeah

Ruud Haarvest (KenL), Thursday, 31 August 2006 00:36 (seventeen years ago) link

Didn't I see a "ILX is down for maintenance" about two hours ago? Now it's all fuled poxily again.

StanM (StanM), Thursday, 31 August 2006 05:02 (seventeen years ago) link

is here working then other than the lack of the historical posts then? or is it still a gentle fledgling?

secondhandnews, Thursday, 31 August 2006 10:29 (seventeen years ago) link

Here works just about as well as real ILX, fwiw

stet (stet), Thursday, 31 August 2006 10:37 (seventeen years ago) link

here works substantially better :)

grimly fiendish (simon), Thursday, 31 August 2006 11:14 (seventeen years ago) link

How much can the database deal with though? We can't all migrate here can we?

beanz-ii (beanz), Thursday, 31 August 2006 11:18 (seventeen years ago) link

Not as permanent move, absolutely not. It'll work fine in the short-term though while the real database is repaired.

stet (stet), Thursday, 31 August 2006 11:22 (seventeen years ago) link

Um, aren't a lot of threads deindexed?

Searching 90% of ilx is better than killing it.

One thing I noticed is that wh3rd.net give more google results than p3r.net - I was concerned that maybe deindexing threads wasn't working properly for both domains and asked a question about it on the Mod request forum. No-one answered.

compare:
Results 1 - 10 of about 187 from ilx.wh3rd.net for "tits up". (0.24 seconds)

Results 1 - 10 of about 42 from ilx.p3r.net for "tits up". (0.26 seconds)

nu_onimo (nu_onimo), Thursday, 31 August 2006 11:38 (seventeen years ago) link

Searching 90% of ilx is better than killing has killed it. :(

grimly fiendish (simon), Thursday, 31 August 2006 12:52 (seventeen years ago) link

I meant searching 90% using google and only using the ilx search if you have a desperate crushing need to find a deindexed thread and think the search engine will actually work. I find clicking "random" for a week is more efficient.

nu_onimo (nu_onimo), Thursday, 31 August 2006 13:02 (seventeen years ago) link

Stet, has *anyone* answered to Andrew's message on the Google Code group yet?

Ned Raggett (Ned), Thursday, 31 August 2006 13:02 (seventeen years ago) link

Unless someone's replied to him privately, it doesn't look like it.

Norman Phay (Pashmina), Thursday, 31 August 2006 13:09 (seventeen years ago) link

I wish could've replied but my coding skills are not mighty enough to save ilX

Ms Misery (MsMisery), Thursday, 31 August 2006 13:17 (seventeen years ago) link

Stet, Pash, check your mail. (I am not offering a solution to the current problem, but this is a related issue.)

Ned Raggett (Ned), Thursday, 31 August 2006 13:22 (seventeen years ago) link

Not that I'm aware of. I've been asking around to see if there's anyone with the appropriate skills. I think a lot of us could and would volunteer to have a pop, but I fear we really need a proper DBA with experience of large (4gb+) databases. Does anyone know of any ilxors who sound like that?

stet (stet), Thursday, 31 August 2006 13:24 (seventeen years ago) link

Hmm. I don't know what the question is, but I've worked with 70GB+ databases before (on SQL Server 2000). I'm not really a DBA though, more application development, so I dunno if I could help.

What's the problem?

Colonel Poo (Colonel Poo), Thursday, 31 August 2006 13:26 (seventeen years ago) link

Me too.

M Grout (Mark Grout), Thursday, 31 August 2006 13:27 (seventeen years ago) link

I don't know the specific problem, only that the DB isn't behaving itself. There are problems with the code's scaling, but they're long term and not likely to be the source of this outage.

Currently the DB (MySQL on Linux) is in itself apparently broken -- from the outside it appears it is not responding correctly to updates, inserts or selects.

stet (stet), Thursday, 31 August 2006 13:30 (seventeen years ago) link

It does suddenly occur to me that MySQL ships with a 4gb limit. I'm sure that must have been raised at some point in the past, however, but the DB is about 4gb as it stands.

stet (stet), Thursday, 31 August 2006 13:31 (seventeen years ago) link

There's a 4gb limit on table size in MySQL, but not on the db itself.

jaq (jaq), Thursday, 31 August 2006 13:36 (seventeen years ago) link

I know absolutely fuck all about MySQL, sorry.

Colonel Poo (Colonel Poo), Thursday, 31 August 2006 13:38 (seventeen years ago) link

MySQL hasn't had that limit since v3.22. Might be a problem with Linux file size limit?

http://dev.mysql.com/doc/refman/5.0/en/table-size.html

nu_onimo (nu_onimo), Thursday, 31 August 2006 13:41 (seventeen years ago) link

http://www.cinematical.com/images/2005/11/johnnyrotten.jpg
Ever get the feeling you've been poxy fuled?

Ruud Haarvest (KenL), Thursday, 31 August 2006 13:58 (seventeen years ago) link

This is no fun.

nu_onimo (nu_onimo), Thursday, 31 August 2006 14:08 (seventeen years ago) link

The worst part is that I still can't be bothered to get any work done.

I Am Curious (George) (Slight Return) (Rock Hardy), Thursday, 31 August 2006 14:10 (seventeen years ago) link


You must be logged in to post. Please either login here, or if you are not registered, you may register here.