Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: Ostia
« on: January 11, 2016, 04:22:48 AM »

We already discussed that here

TL,DR: The hoster installed crap and now the server is in a constant state of near breakdown. Erik is on it and plans on switching hosts.
Posted by: ardem
« on: January 10, 2016, 05:58:01 PM »

Lots of issues over the last two days for the forum for me. regardless where I am and what computers I use. I got a Server is out of resources message only 30 minutes ago. I had cannot post message forbidden. there was nothing in the text that I could see that was like 'case', but it would not allow me to post two sentences. I had very long delays in opening pages, sometimes not opening at all.

I think think the DB may need some maintenance.

Posted by: Mor
« on: January 09, 2016, 03:11:08 AM »

All of the words that have been triggers have been SQL keywords.

All I can tell is that if was something consistent that I can identify, then I could write couple of regex fixes for myself (like i did for 0.x). but to me it seem too random. Like MarcAFK post above which several minutes later you can no longer quote, or from today:

On Version_7.0 I can't add:
Code: [Select]
==Army Officer Promotions==
only
;=Army Officer Promotions==
while there are plenty of other headers above and bellow just like that, but only this one fires, even if I remove the content

Or on Version_6.40, there are several trigger words including wh_en that prevent me from updating it.

Edit:
Whatever it is, it interferes with forum\wiki basic function, affecting people ability to post content and wasting their time trying to hunt the heretic word of the day.
Posted by: Mor
« on: January 08, 2016, 03:13:16 AM »

On a side note, the host suggests that I optimize images and consolidate CSS files.
He is not completely wrong, it might alleviate some strain, every little bit helps, no? But here is catch 22, I tried to trim down the css on the wiki (I can reduce about a third without too much hassle) but I can't update it because 403 Forbidden!  At least images aren't an issue there, because of volume and the way mediawiki handles it.

.... I know the forum activity exploded but that still seems excessive considering this is still a fairly small forum.
Unfortunately, once you hit the ceiling, it usually tuns into a downward spiral. That is when people get an error they tend to obsessively refresh, generating extra calls for the already resource deprived sever..

The 7.1 patch thread was viewed 12000 times since December, assuming it's been downloaded that many times and the 5.54 as well, would be 1.2 Tb.....
Yeah, its most likely the single most offender as far as Eriks bandwidth stats goes. Probably more so for the portable version, but at least its not hosted here. Also it appears that most of the new users seem to have found a home on reddit.

Looks like Erik, changed the Aurora files hosting location, which should help. Btw, big thanks to Erik for working on all of this in the background!

Edited.
Posted by: Erik L
« on: January 08, 2016, 12:29:24 AM »

Yeah, they are certainly annoying me to no end.
Posted by: MarcAFK
« on: January 08, 2016, 12:04:12 AM »

That'd be great, but all of the built-in image compression in SMF relies on software the host has not loaded.

December's traffic was ~150g.
January is 3x that a week in.
Oh hi, please optimise your images using software we won't load onto the server, kthxbye.
Edit: perhaps my maths are off, but there's 340,000 page views. That's an Average of 1.2 mb per page views.
Oh I'm an idiot, the game is downloaded from the forum right?
The 7.1 patch thread was viewed 12000 times since December, assuming it's been downloaded that many times and the 5.54 as well, would be 1.2 Tb.....
Surely it's a little lower than that but still, I'm sure you can check many times the games been downloaded....
If it's significant then hosting the files elsewhere should help a little.
Posted by: Erik L
« on: January 07, 2016, 11:36:59 PM »

That'd be great, but all of the built-in image compression in SMF relies on software the host has not loaded.

December's traffic was ~150g.
January is 3x that a week in.
Posted by: MarcAFK
« on: January 07, 2016, 11:27:03 PM »

.... I know the forum activity exploded but that still seems excessive considering this is still a fairly small forum.
But images are a problem, even if spoilered they're always loaded. Perhaps SMF has a setting that might help somewhat, maybe storing and loading a small thumbnail unless clicked on ?
Posted by: Erik L
« on: January 07, 2016, 06:26:19 PM »

This is what I am looking for from a host.

Domain requirements
•   10+ gig storage
•   2tb+ bandwidth
•   MySQL
•   Php 5.5+
•   Subdomain support
•   Domain/subdomain forwarding
•   Unlimited email accounts
•   POP3 and webmail support
•   FTP/SFTP support
•   Shell access

This should cover everything I have at the moment.
Posted by: Erik L
« on: January 07, 2016, 06:22:36 PM »

Indeed it is, and I can now use google (and its cache) to find things on the forum without having to stumble into host of errors  ::) However, I am bufleld  by the fact that your change caused this to be no longer the case for the wiki.
You got lucky. I have had the pleasure quit often this week, ironically most recently it was while trying to quote your post...  Overall, it makes no sense, its like the host is playing a hat tick, pulling random words... how can he not notice the issue and fix it?! that or he is an evil genius  ;)

All of the words that have been triggers have been SQL keywords.

On a side note, the host suggests that I optimize images and consolidate CSS files. What. The. frakk.

On a second side note, I am now shopping for a domain host after 10+ years.

Bit of trivia... There has been ~450g of bandwidth HTTP transfer. Since Jan 1. If this keeps up, I'm looking at 2-2.5tb transfer/month.
Posted by: Mor
« on: January 07, 2016, 06:09:13 PM »

I've updated that, along with adding a sitemap. So in theory, things should appear on google, etc.
Indeed it is, and I can now use google (and its cache) to find things on the forum without having to stumble into host of errors  ::) However, I am bufleld  by the fact that your change caused this to be no longer the case for the wiki.

...
You got lucky. I have had the pleasure quit often this week, ironically most recently it was while trying to quote your post...  Overall, it makes no sense, its like the host is playing a hat tick, pulling random words... how can he not notice the issue and fix it?! that or he is an evil genius  ;)
Posted by: MarcAFK
« on: January 07, 2016, 04:54:32 PM »

The 403s seem to have been usurped by the out of memory and 500 errors.
Perhaps we need to download more ram?
Posted by: Erik L
« on: January 07, 2016, 11:50:02 AM »

The 403s seem to have been usurped by the out of memory and 500 errors.
Posted by: Vandermeer
« on: January 07, 2016, 10:12:59 AM »

A new occasionally forbidden word joins the club. "ha ving" (no space)
I was stumbled when I couldn't find any of the usual trigger words in one recent and short post. After some back and forth, the error vanished when deleting the word, though I am sure I have used it other place often enough without causing any 403.
Well, in this case not even the cursive method helped. I had to change it into "to have" to make the post work.

On other accounts, without this incident, I didn't see much 403s for a long time.
Posted by: Mor
« on: January 07, 2016, 05:19:30 AM »

^ this is due to peek hours usage. During the holidays Aurora got a lot more exposure than what the server can handle.

While the issue mentioned by the OP, is most likely an configuration issue or an evil plan by the host.