Page 1 of 1
Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 15, 2018 3:13 pm
by RF1
I have been getting error messages throughout today indicating that the board has exceeded its maximum number of users. That alone is testament and proof that Rhody nation is presently very excited about the program.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 15, 2018 3:54 pm
by Rhody74
Yeah, I have noticed the max connections exceeded message. I just refresh my connection and it usually pops back up. After we win the Final Four you may need to ask your provider for extra bandwidth.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 15, 2018 5:34 pm
by EGram
Yep, it's odd as i'm pretty sure Admins have said we were nowhere near BAndwith limit in terms of users before....
May be a bug of ZenForo?
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 15, 2018 10:26 pm
by ATPTourFan
Thanks for letting me know you are seeing it. I’ve been trying to track down the cause assuming it’s a configuration issue. It may be a hosting issue but we aren’t close to hitting limits on bandwidth or processing/memory even during peak traffic.
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 16, 2018 4:20 pm
by ATPTourFan
Did anyone get the message today? If possible pls post the time you saw the message so I can align it with hourly traffic.
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 16, 2018 7:28 pm
by twisted3829
I have gotten in the last in prior day but nothing today
Re: Keaney Blue Forum Traffic crashing system
Posted: Wed Jan 17, 2018 10:02 am
by sf2010
Error message when I tried to open the Attendance Prediction thread at 10:00am
Site working fine beyond that one brief blip
Re: Keaney Blue Forum Traffic crashing system
Posted: Wed Jan 17, 2018 1:31 pm
by ATPTourFan
Ok thanks
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 20, 2018 11:43 am
by RF1
Got this error today 01/20/18 at 11:41am while I had the "Who has been the most pleasant surprise of the season so far?" thread open.
General Error
SQL ERROR [ mysqli ]
User keaneybl_admin already has more than 'max_user_connections' active connections [1203]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 20, 2018 12:08 pm
by ATPTourFan
Yeah. That’s weird because traffic is very low.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 20, 2018 12:52 pm
by Rhody74
RF1 wrote:Got this error today 01/20/18 at 11:41am while I had the "Who has been the most pleasant surprise of the season so far?" thread open.
General Error
SQL ERROR [ mysqli ]
User keaneybl_admin already has more than 'max_user_connections' active connections [1203]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
According to:
https://dba.stackexchange.com/questions ... ions-error
this limit is not on total user connections, but on the total connections by the individual user (in your case keaneybl_admin).
Seems like a user setting of some sort. Hope this helps.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 20, 2018 2:03 pm
by SGreenwell
If y'all could screen shot these issues, that would probably be helpful for ATP as well! Hit "printscreen" on your keyboard, and then copy-paste into an empty Paint or Photoshop or IrfanView file. (Or whatever the kids use to create JPGs nowadays.)
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 20, 2018 4:53 pm
by ATPTourFan
Rhody74 wrote:RF1 wrote:Got this error today 01/20/18 at 11:41am while I had the "Who has been the most pleasant surprise of the season so far?" thread open.
General Error
SQL ERROR [ mysqli ]
User keaneybl_admin already has more than 'max_user_connections' active connections [1203]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
According to:
https://dba.stackexchange.com/questions ... ions-error
this limit is not on total user connections, but on the total connections by the individual user (in your case keaneybl_admin).
Seems like a user setting of some sort. Hope this helps.
Exactly. It's connections to the database. I'm going to turn off some of the extra features to see if that resolves the issue.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 10:18 am
by Rhody09
10:16 AM, attempting to visit the main URL.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 10:21 am
by ATPTourFan
Yep. Thx. I'm on with the hosting provider and about to upgrade the site performance, thanks to generosity from members this past week.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 10:32 am
by URI_05
You also might want to check if the forum software has any caching settings you can mess with. If so, you might be able to cut down on the DB connections going that route.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 10:37 am
by ATPTourFan
Yeah, for phpBB, caching provides no advantage. I just doubled the # of CPUs we have at our disposal. We were pushing 90-100% utilization around 9am.
I am told that the doubled processing capacity should commence sometime within next 4 hours.
It's very strange that the same exact system stayed up (as far as I remember) during the NCAA games vs Creighton and Oregon.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 10:44 am
by steviep123
I just got an error for the first time. Next time I'll take an image for you.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 12:44 pm
by ATPTourFan
OK. That should be behind us. We now have double performance overhead on the server side and just to be safe, I did some clean-up on the database side to relieve stress on the server and to prevent sluggishness under heavy usage. I'm interested in anyone's feedback on the speed of page loads now that I've done some clean-up.
Very sorry about the interruption of service, but we're back and Rhody is #24 in the country!!
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:35 pm
by rhodysurf
I wonder if the higher CPU usage comes as a side effect of the meltdown patches. It can have a 50% speed penalty when it comes to database IO
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:35 pm
by urirx
I am getting some major lag on trying any of the links. hopefully just temporary, or an overload of users celebrating our new top 25 ranking
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:36 pm
by Seawrightspostgame
I noticed a lag trying to get KB to upload. Tried to come onto this thread to note that and it took me over 5 minutes to sign in and now im hitting Submit. IDK how long it will take to post.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:42 pm
by urirx
I am getting some major lag on trying any of the links. hopefully just temporary, or an overload of users celebrating our new top 25 ranking
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:45 pm
by ATPTourFan
Yes, definitely strange. I'm working with hosting provider to see what's different.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 1:46 pm
by ATPTourFan
FINALLY an update from the hosting provider:
There's currently an issue with all our severs. The issue is known and is being worked on as we speak. This doesn't look to be specific to your account, our admins are already looking into what is causing this. As soon as the issue is fixed, you should be able to access the website.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 2:59 pm
by Rhody74
Seems to be working fine now. Of course, I'vE a couple 603 Amber Ales and the glow of national ranking to keep me happy.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 3:10 pm
by rhodyrudder
Does the new net neutrality law have anything to do with it?
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 6:08 pm
by theblueram
Is anyone else not getting the color on topics with new posts?
edit: as I posted this the colors came back.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 6:10 pm
by adam914
ATPTourFan wrote:OK. That should be behind us. We now have double performance overhead on the server side and just to be safe, I did some clean-up on the database side to relieve stress on the server and to prevent sluggishness under heavy usage. I'm interested in anyone's feedback on the speed of page loads now that I've done some clean-up.
Very sorry about the interruption of service, but we're back and Rhody is #24 in the country!!
Page loads definitely seem faster to me. Especially those pages you get to that end up with a ton of embedded tweets that need to load are coming through faster then they were before.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 7:28 pm
by ATPTourFan
theblueram wrote:Is anyone else not getting the color on topics with new posts?
edit: as I posted this the colors came back.
I did temporarily disable post tracking only for guests who are NOT logged in. Normal orange posts still work as always for those who log into the site.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 7:34 pm
by bigappleram
Kim Kardashian on the cover of Paper Magazine breaks the internet
Rhody ranked in late January breaks Keaney Blue
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 8:45 pm
by Blue Man
bigappleram wrote:Kim Kardashian on the cover of Paper Magazine breaks the internet
Rhody ranked in late January breaks Keaney Blue
This would traditionally be a situation where Rod would come from the clouds and point out what a vapid skank she is, and rant on.
Miss that man. Carry on.
Re: Keaney Blue Forum Traffic crashing system
Posted: Mon Jan 22, 2018 11:03 pm
by reef
Yeah would love to hear Rods rants about the Kardashians
I am sure he felt the same way about LaVar Ball ??
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 23, 2018 11:37 am
by ATPTourFan
Let's keep this thread clear of posts unrelated to this issue, please.
I'm currently in contact with the hosting provider asking what the hell is going on today. Thanks for everyone's patience.
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 23, 2018 12:19 pm
by ATPTourFan
Ok so it’s not our site’s fault:
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 23, 2018 6:15 pm
by Ramulous
Back up plan needed.....a fall out shelter where we can meet to plot the future
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 23, 2018 7:27 pm
by ATPTourFan
I would, at minimum, be able to get another board up and running within a day. I have local backups of the database and forum files. I'm easy to find.
Re: Keaney Blue Forum Traffic crashing system
Posted: Tue Jan 23, 2018 7:29 pm
by steviep123
ATPTourFan wrote:I would, at minimum, be able to get another board up and running within a day. I have local backups of the database and forum files. I'm easy to find.
ATP is the man
Re: Keaney Blue Forum Traffic crashing system
Posted: Wed Jan 24, 2018 12:30 pm
by RhodyRams12
ATP, I’ve been getting this error message for the last 30 mins.
Re: Keaney Blue Forum Traffic crashing system
Posted: Wed Jan 24, 2018 12:39 pm
by ATPTourFan
Yep. thx for reporting. I've been in contact with the host. They are working this same issue that has been bothering us and many other customers for the last several days.
Re: Keaney Blue Forum Traffic crashing system
Posted: Thu Jan 25, 2018 9:49 am
by ATPTourFan
It is absolutely unbelievable that this server issue remains after 4 days. I continue to push for a response and resolution from the host provider.
In the mean time, I am looking for other hosts. I'm weary of moving the site to another host at this point of the season, but with these kinds of outages we presently experience, the risk is almost nullified.
Thank you to everyone for your patience during this unprecedented poor performance by BlueHost.
Re: Keaney Blue Forum Traffic crashing system
Posted: Thu Jan 25, 2018 6:37 pm
by Ramulous
Maybe we can head to the Scout forum if this site crashes so we can find any site you find ATP
Re: Keaney Blue Forum Traffic crashing system
Posted: Thu Jan 25, 2018 7:50 pm
by ATPTourFan
New site will still be keaneyblue.com
I'm looking to change hosts as early as late Saturday night.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sat Jan 27, 2018 7:13 pm
by section(105)
ATPTourFan wrote:New site will still be keaneyblue.com
I'm looking to change hosts as early as late Saturday night.
......just wondering, for low tech folks, anything going to look different? need to do anything?
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 11:37 am
by ATPTourFan
No. Nothing has changed and nothing would change. Any switch would be announced and there would be a scheduled period where the site would be locked.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 11:53 am
by ramster
"In Hurley we Trust"
"In ATP we Trust"
no worries
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 1:36 pm
by ATPTourFan
Thx Ramster. It appears our esteemed host provider has eliminated the issue, as we've gone a few days without interruptions. Correct me if I'm wrong.
Still going to find another host that can deliver the same if not better site speed and more importantly, much better reliability. That is a big decision and takes some research and careful planning. I'm hopeful we get through the rest of this season without incident so we can address this in the Spring.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 3:18 pm
by Ramulous
I like staying here....there is a comfort level.....but we need a back up plan......
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 3:25 pm
by ATPTourFan
Not sure you read my earlier reply, Ramulous. This is not in any way equivalent to when we were on Projo, without any control, and Projo cut the cord without warning. Fortunately, Steve Greenwell had the foresight of preparing a new spot for us and we transitioned there before Projo Forums went dark.
Re: Keaney Blue Forum Traffic crashing system
Posted: Sun Jan 28, 2018 3:27 pm
by Ramulous
I read everything ATP.....it is my comprehension that is problematic....