View Full Version : No Available Nodes Error?
We're going to be replacing the database server soon to resolve the issue.
Javery
10-28-2009, 02:19 PM
I just got it trying to read this thread. LOL.
CheapyD
10-29-2009, 06:29 AM
Ordering a new database server with Solid State drives today...
Liquid 2
10-29-2009, 09:16 PM
Was it a hardware issue or was it a load issue? Or something else?
CheapyD
10-30-2009, 12:12 AM
John can give a more in-depth answer, but its my understanding that we didn't have a great kernel installed on the DB server.
Here's the stats on the new DB server that will work in conjunction with the two webservers.
Dual Xeon E5520 Quad Core (Gainstown)
8GB DDR RAM
4 x 32GB Intel Solid State Drives / Hardware Raid 10
Liquid 2
10-31-2009, 02:07 PM
If that was the problem, why not just back it up and install a better database system rather than replace the whole thing?
(Unless CAG needed the new server anyways, of course.)
If that was the problem, why not just back it up and install a better database system rather than replace the whole thing?
(Unless CAG needed the new server anyways, of course.)
A few reasons:
- Less downtime (considering we'd need have needed a complete OS reload anyway).
- The old db server was two years old, so we're getting a lot more performance now out of the new hardware for the same money.
- It's a good opportunity for us to upgrade to SSDs, which suit our purposes perfectly.
Nebenator
11-02-2009, 01:20 PM
Just got the error for one minute
The Crotch
11-02-2009, 06:34 PM
Just got it a few seconds ago. Not that that really matters much now, I'm sure.
transparent
11-03-2009, 12:27 AM
I was getting it an hour or so ago, but it looks like you already have the solution coming.
tyhana
11-03-2009, 06:35 PM
Just happened for me, didn't last more than a minute.
New server now in, but we're still tweaking. (If you got a node error in the past 10 minutes, that was my fault.)
Everything has been overhauled and the site should be significantly faster now.
CheapyD
11-07-2009, 07:20 PM
Additional downtime at 7AM EST for RAM upgrade
shrike4242
11-07-2009, 10:55 PM
I've noticed a change in the speed of the site just for the transition to the new DB servers and the SSD's.
The RAM upgrade should be another step up in speed.
RAM upgrade complete. I'll be doing some tweaking over the next few days, but we should be fast and reliable from now on.
Edit: Scratch that, we're going to have some more downtime shortly to replace some faulty hardware. (Hooray.)
Scorch
11-08-2009, 02:05 PM
Just happened again. Lasted about 5 minutes.
Just happened again. Lasted about 5 minutes.
Yeah, our new database server has faulty hardware. The fun never ends...
FriskyTanuki
11-08-2009, 06:12 PM
My UserCP is giving me a database error, though I was able to use an open thread to get here easily so it's just the UserCP. It's been doing it for about five minutes now and continues to do it, so I'll update when it's back.
zewone
11-08-2009, 06:25 PM
My UserCP is giving me a database error, though I was able to use an open thread to get here easily so it's just the UserCP. It's been doing it for about five minutes now and continues to do it, so I'll update when it's back.
Same.
Demontooth
11-09-2009, 12:00 AM
The site is still slow to load.
The site is still slow to load.
The new database server had hardware issues and had to be taken down, so we're back on the old setup until the hosting company fixes it.
spideymike
11-09-2009, 12:59 AM
Okay, gotcha. Still got another node error and wondered what was up with that.
darthbudge
11-09-2009, 07:53 PM
I just got the nodes error and then a database error.
MillerTime2523
11-09-2009, 07:54 PM
Same with me, budge.
I just got the nodes error and then a database error.
Yep, it was a database restart. Nothing to worry about.
FriskyTanuki
11-09-2009, 09:33 PM
Just got one about a minute ago, which was back to normal when I refreshed the page a few seconds later.
There will be node errors from now until we get the new database server back online - I'll let everyone know when that is.
Ok, the new server is online and I've been making tweaks throughout the afternoon. Node errors should be rarer from now on.
dmaul1114
11-10-2009, 03:55 PM
Good to hear it's up and running. Site is much faster than it's been in a LONG time.
While it hasn't been running long enough for me to call it stable, it seems that we're over the bulk of the issues we've been having with the new database hardware.
Z(+)DIAC
11-11-2009, 03:27 PM
Received this message about 30 mins. ago.
Seriously, what the hell is going on?
Blackout
11-11-2009, 03:41 PM
Just got the node error twice, each lasting over 5 minutes.
What were you doing at the time?
manthing
11-11-2009, 04:55 PM
Can't speak for the others, but when I got the missing nodes at that time, I was just trying to get the the main forums page.
darthbudge
11-11-2009, 07:00 PM
When I got the missing nodes error earlier today (when all the others mentioned it) I was just trying to load the off topic forum.
Blackout
11-11-2009, 10:01 PM
I was just trying to access a thread in the PS3 forum. The second time, I was trying to open this thread.
shrike4242
11-13-2009, 08:19 PM
Work in the ModCP panel, as well as mod functions like "Delete Posts As Spam" are making No available node errors. Had 2 or 3 of them in the last 5-10 minutes.
Work in the ModCP panel, as well as mod functions like "Delete Posts As Spam" are making No available node errors. Had 2 or 3 of them in the last 5-10 minutes.
The load balancer outputs the nodes error, and we don't use the load balancer anymore - so I'm not sure how it's even possible for you to be having that problem. Could you do me a favour and ping www.cheapassgamer.com, and let me know what IP the domain name resolves to?
Ronzilla
11-13-2009, 08:42 PM
Is anyone else also getting "CAG down for maintenance"? Happened to me about 3 times in the last week or so. Not sure if it's related.
Is anyone else also getting "CAG down for maintenance"? Happened to me about 3 times in the last week or so. Not sure if it's related.
It only happens when CAG is down for maintenance.
Ronzilla
11-13-2009, 08:47 PM
It only happens when CAG is down for maintenance.
That many times in 1 week? Is CAG at maximum capacity or something?
That many times in 1 week?
About 5 times over the past week. We're over the worst of it now, though.
PR Mega X
11-13-2009, 08:55 PM
Got a database error about a half hour ago -- surfing through the Target thread, happened as I tried to move on to the next page.
shrike4242
11-14-2009, 09:53 PM
The load balancer outputs the nodes error, and we don't use the load balancer anymore - so I'm not sure how it's even possible for you to be having that problem. Could you do me a favour and ping www.cheapassgamer.com (http://www.cheapassgamer.com), and let me know what IP the domain name resolves to?Comes up as lb.cheapassgamer.com and IP address of 209.59.169.33 .
Flushing out my DNS cache didn't change the above values.
Blackout
11-27-2009, 04:21 AM
Just got hit with the error. :bomb:
PR Mega X
11-27-2009, 04:23 AM
Just got hit with the error. :bomb:
Ditto. Browsing the BF deal thread.
Nebenator
11-27-2009, 04:24 AM
It didn't last very long, about a minute for me.
dmaul1114
12-09-2009, 01:25 AM
Got an error I hadn't seen before a few times around 12:15 AM EST.
Came up with a screen with a message in a box that read: "The server is too busy at the moment. Please try again later."
StarKnightX
12-09-2009, 01:47 AM
Got an error I hadn't seen before a few times around 12:15 AM EST.
Came up with a screen with a message in a box that read: "The server is too busy at the moment. Please try again later."
Got that a little while ago myself , and had it for around 5-10 minutes yesterday.
PR Mega X
12-10-2009, 01:59 PM
Got an error I hadn't seen before a few times around 12:15 AM EST.
Came up with a screen with a message in a box that read: "The server is too busy at the moment. Please try again later."
I got that same message last night when going to XBox.com, and a similar one today when going to BestBuy.com. I think someone broke the internet.
Nebenator
12-10-2009, 02:00 PM
I think someone broke the internet.
http://www.cheapassgamer.com/forums/blog.php?b=11727