Staredit Network > Forums > Staredit Network > Topic: Dear all users
Dear all users
Nov 22 2011, 3:29 am
By: Aristocrat  

Nov 22 2011, 3:29 am Aristocrat Post #1



Want SEN to stop having downtime? Then please stop using the "Search" functionality on the site. Yes, I know, it's convenient, but from the looks of it, using search generally results in the following sequence of events happening:

1. Search ties up SEN's server for several minutes due to how much data it must dig through (also blame search implementation for being inefficient).
2. During this time, SEN is inaccessible. Frustrated users mash F5 as hard as they can to get their SEN fix.
3. Once the search query is complete, all the web requests sent during the freeze begin to be processed by the server. This flood of a ridiculously large number of backed-up requests causes errors like the following to occur:
Warning: mysql_connect() [function.mysql-connect]: User starlite_starglo already has more than 'max_user_connections' active connections in /home/starlite/public_html/core/mysql.php on line 21
A Staredit Network error has occured:
MySQL Error: No connection to the server.
Please contact administration with all the details.

4. Users keep mashing F5 because either no one reads the error, or every person on SEN is an impatient fool. The number of requests sent to SEN's server increases dramatically and stays high because people keep mashing F5 in hopes that the situation will improve, when in reality the refreshes make everything worse. This results in the following error being displayed during attempts to view SEN, even for hours to come until people finally give up. The load on the server lightens and everything returns to normal...
A Staredit Network error has occured:
MySQL Error '2006': MySQL server has gone away
Query failed: SELECT * FROM sessions WHERE s_ip='xxx.xxx.xxx.xxx' AND s_id='asdfghjklasdfghjklasdfghjklasdfghjkl' LIMIT 1
Waited: 0.0371932983398 ms
Please contact administration with all the details.

5. Someone uses Search again, instead of just using Google and appending site:staredit.net to the query. Repeat steps 1-4.



None.

Nov 22 2011, 3:39 am The Starport Post #2



k.



None.

Nov 22 2011, 3:43 am BiOAtK Post #3



Why doesn't the search just use google?



None.

Nov 22 2011, 3:59 am Aristocrat Post #4



Quote from BiOAtK
Why doesn't the search just use google?

Google search cannot discriminate between subforums, search by author, time, date, or use any of the more advanced features available in SEN search. Unfortunately, with SEN search as inefficient and SEN-breaking as it is right now, it would be nice if people could refrain from using it.



None.

Nov 22 2011, 5:09 am poison_us Post #5

Back* from the grave

Gonna go do a search now.
EDIT: Done with about 10 searches, and not a single member bitching about SEN crashing.





Nov 22 2011, 6:07 am TomWaits Post #6



What about going to a profile and viewing all posts? Any idea if that would cause similar problems?



None.

Nov 22 2011, 6:22 am Fire_Kame Post #7

wth is starcraft

They both do crash the forums. You guys are a few months late to the party.




Nov 23 2011, 4:36 am Dem0n Post #8

ᕕ( ᐛ )ᕗ

Why can't we just disable it? The search from the drop-down menu works perfectly fine. It'd be easier than actually trying to fix it...




Nov 23 2011, 4:52 am DevliN Post #9

OVERWATCH STATUS GO

The Search from the dropdown menu is the one everyone here is talking about. Yes, it works some times, but it also causes mysql errors other times.



\:devlin\: Currently Working On: \:devlin\:
My Overwatch addiction.

Nov 23 2011, 6:41 am IskatuMesk Post #10

Lord of the Locker Room



I would bet that, like most other forums I see these weird numbers on, many of those guests are bots. While unrelated to the search (afaik anyways), on their own they can cause problems.



Show them your butt, and when you do, slap it so it creates a sound akin to a chorus of screaming spider monkeys flogging a chime with cacti. Only then can you find your destiny at the tip of the shaft.

Nov 23 2011, 7:36 am DavidJCobb Post #11



Quote from IskatuMesk


I would bet that, like most other forums I see these weird numbers on, many of those guests are bots. While unrelated to the search (afaik anyways), on their own they can cause problems.
Interesting... Might you know offhand any ways to pick the bots from the legit guests?



None.

Nov 23 2011, 9:18 pm IskatuMesk Post #12

Lord of the Locker Room

Well, if you can view the ips/actions of the guests that might make it a lot easier. I don't know what SEN's forum software would offer in that regard.

Depending on the bots, they could be crawling the forum like crazy or attempting to register to later spam it. Since (as least from what I see) SEN isn't getting spammed all the time like a lot of forums do, it either may not be those kinds of bots or they may not be able to register. :3 (An easy way to check is to look at the memberlist, like CC, and find the ridiculously large number of 0 post registrees with unusual names fitting a certain pattern).

As I don't have admin access on CC and haven't been on a forum with admin access for quite some time, I can't remember if it was as simple as looking at their IP's and seeing a very large range of guests on the same IP or not. But 72 guests to 6 users is veeery strange. This is something I see very consistently on SEN.



Show them your butt, and when you do, slap it so it creates a sound akin to a chorus of screaming spider monkeys flogging a chime with cacti. Only then can you find your destiny at the tip of the shaft.

Nov 23 2011, 9:27 pm TiKels Post #13



Quote from DevliN
The Search from the dropdown menu is the one everyone here is talking about. Yes, it works some times, but it also causes mysql errors other times.
I have taken down SEN plenty of times trying to search a user's topics/posts from their profile, bro.

Also, SEN is finally back up.

@Iskatu, There have been some spambots that have registered and mass PM'd users.



"If a topic that clearly interest noone needs to be closed to underline the "we don't want this here" message, is up to debate."

-NudeRaider

Nov 23 2011, 11:51 pm ClansAreForGays Post #14



I think the "Find all posts by" is what's really doing




Nov 23 2011, 11:59 pm TiKels Post #15



Quote from TiKels
Quote from DevliN
The Search from the dropdown menu is the one everyone here is talking about. Yes, it works some times, but it also causes mysql errors other times.
I have taken down SEN plenty of times trying to search a user's topics/posts from their profile, bro.
Quote from ClansAreForGays
I think the "Find all posts by" is what's really doing
:rolleyes:



"If a topic that clearly interest noone needs to be closed to underline the "we don't want this here" message, is up to debate."

-NudeRaider

Nov 24 2011, 12:43 am ClansAreForGays Post #16



Quote from TiKels
Quote from TiKels
Quote from DevliN
The Search from the dropdown menu is the one everyone here is talking about. Yes, it works some times, but it also causes mysql errors other times.
I have taken down SEN plenty of times trying to search a user's topics/posts from their profile, bro.
Quote from ClansAreForGays
I think the "Find all posts by" is what's really doing
:rolleyes:
Why would I bother reading your posts?




Nov 24 2011, 1:03 am NicholasBeige Post #17



Why bother reading any posts? They just get moderated anyways.

Bring it Devlin :P

Anyways, I think what someone was getting at earlier was that, why doesn't the SEN search just re-direct the user to trusty old google, with their search term and site:staredit.net appended already? Or can't we do this? Isn't CecilSunkure meant to be re-writing SEN in its entirety anyways?



None.

Nov 24 2011, 1:18 am DevliN Post #18

OVERWATCH STATUS GO

Quote from TiKels
Quote from DevliN
The Search from the dropdown menu is the one everyone here is talking about. Yes, it works some times, but it also causes mysql errors other times.
I have taken down SEN plenty of times trying to search a user's topics/posts from their profile, bro.
Did I make it seem like I was suggesting that only using Search from the Search page was causing the issue, bro? :rolleyes:



\:devlin\: Currently Working On: \:devlin\:
My Overwatch addiction.

Nov 24 2011, 1:23 am IskatuMesk Post #19

Lord of the Locker Room

Google search is terrible on forums. Just awful. Indie devs left and right rely on this and you can never find shit.



Show them your butt, and when you do, slap it so it creates a sound akin to a chorus of screaming spider monkeys flogging a chime with cacti. Only then can you find your destiny at the tip of the shaft.

Nov 24 2011, 1:31 am Lanthanide Post #20



That's because Google actually sells these 'google search' hardware boxes for use by companies. So they deliberately make their free offering gimped.



None.

Options
  Back to forum
Please log in to reply to this topic or to report it.
Members in this topic: None.
[04:29 am]
m.0.n.3.y -- Can anyone help me get SCMDraft 2 running? Getting "Fatal Error: Failed loading primary MPQ (stardat.mpq)"
[06:25 pm]
Roy -- I think it used to say "I'm feeling lucky" and it would pull up a random file when clicked, but it broke at some point, so I changed the text and made it display a message instead.
[2024-3-03. : 7:37 pm]
NudeRaider -- oh funny, hadn't noticed that before :w00t:
[2024-3-03. : 7:28 pm]
UndeadStar -- NudeRaider
NudeRaider shouted: UndeadStar what are these? Never heard of both of them.
In "Starcraft I Files", there's a "I'm feeling lazy" link. And in Starcraft 2, when playing coop missions with Alarak, there's a jewel that can be turned on/off (eventually annoying Alarak).
[2024-3-03. : 6:29 pm]
NudeRaider -- UndeadStar
UndeadStar shouted: I just discovered the "I'm feeling lazy" button. Just as addicting as the Alarak interface thing in SC2.
what are these? Never heard of both of them.
[2024-3-03. : 4:22 pm]
UndeadStar -- I just discovered the "I'm feeling lazy" button. Just as addicting as the Alarak interface thing in SC2.
[2024-3-02. : 7:31 pm]
Dem0n -- Oh_Man
Oh_Man shouted: i wonder how they did grand moff tarkins voice in star wars
Got someone to do a decent impersonation and then used professional audio engineers to make it sound like the original actor
[2024-3-01. : 8:11 pm]
IlyaSnopchenko -- Sure doesn't sound perfect... nothing is. I know it's better than my own attempts at voiceacting (but I'll have to resort to that, too; I've just been putting that off for ages).
[2024-3-01. : 2:58 pm]
Oh_Man -- i wonder how they did grand moff tarkins voice in star wars
[2024-3-01. : 2:58 pm]
Oh_Man -- oh right, yeh if ur trying to do additional dialogue for dead or unavailable actors then its ur only option. it still doesnt sound perfect though
Please log in to shout.


Members Online: Roy