Downtime, apparently - Page 4

shiney · 11-12-2015, 11:44 AM

Figured it out. Apache was taking all the available memory and MYSQL was not able to grab anything so it was barfing. Problem should be resolved permanently but what's actually going to happen is it will crash again in the morning.

tacticslion · 11-12-2015, 09:53 PM

Quote:

Originally Posted by Mauve Mage

It lives again! Thanks shiney and Nikose!

Hurray! Thank you!

Spooniest · 11-13-2015, 12:55 PM

We're back!! And we have the combination to the airshield!!

phil_ · 03-15-2016, 11:29 PM

Ok, that's two times in (I guess) a week. What's the problem, shineysunshine?

shiney · 03-16-2016, 08:30 AM

There's something horribly wrong with the database that is crashing it frequently when attempting to write. Some RAM allocation errors too. Working on it.

---------- Post added at 08:30 AM ---------- Previous post was at 08:08 AM ----------

It's super pissed but I will continue giving it hell.

shiney · 03-17-2016, 12:39 PM

It was really super duper pissed but I gave it hell.

Hi.

Nikose Tyris · 03-17-2016, 12:46 PM

And I helped

mauve · 03-17-2016, 12:52 PM

It liiiiives!

shiney · 03-17-2016, 03:23 PM

We'll go with that, yes.

This one was a big problem and it may not be entirely resolved. Apache (our http server) is consuming a lot of available RAM which causes MYSQL (the database) to freak out and shut down. I tried to install Lighttpd, which is a much more lightweight and low-mem webserver solution, but I couldn't get the virtual hosting to work, and then it was not playing nicely with MYSQL. So I went back to Apache but then there were some different problems with MYSQL and the socket file which I had to create a link to and...

[devolves into technical babble....]

...so now it works!

---------- Post added at 03:23 PM ---------- Previous post was at 12:54 PM ----------

And then stopped working again, so I tore down the entire instance and launched a new one.

SO NOW IT WORKS GODDAMMIT

Overcast · 03-17-2016, 07:01 PM

Hmm, I get a database error every time I head to my User CP, otherwise seems good.

11-12-2015, 11:44 AM	#31
shiney Derrrrrrrrrrrrrp. Join Date: Nov 2003 Location: The land of fartz and buttz Posts: 8,266	Figured it out. Apache was taking all the available memory and MYSQL was not able to grab anything so it was barfing. Problem should be resolved permanently but what's actually going to happen is it will crash again in the morning. __________________ boop

11-13-2015, 12:55 PM	#33
Spooniest Press Start Join Date: Sep 2011 Location: Nashville, TN Posts: 84	We're back!! And we have the combination to the airshield!! __________________ My Soundcloud Profile

03-15-2016, 11:29 PM	#34
phil_ Just sleeping Join Date: Mar 2004 Location: At home, probably in bed. Posts: 6,482	DATABASE! DATABASE! error Ok, that's two times in (I guess) a week. What's the problem, shineysunshine? __________________ Be T-Rexcellent to each other, tako.

03-16-2016, 08:30 AM	#35
shiney Derrrrrrrrrrrrrp. Join Date: Nov 2003 Location: The land of fartz and buttz Posts: 8,266	There's something horribly wrong with the database that is crashing it frequently when attempting to write. Some RAM allocation errors too. Working on it. ---------- Post added at 08:30 AM ---------- Previous post was at 08:08 AM ---------- It's super pissed but I will continue giving it hell. __________________ boop

03-17-2016, 12:39 PM	#36
shiney Derrrrrrrrrrrrrp. Join Date: Nov 2003 Location: The land of fartz and buttz Posts: 8,266	It was really super duper pissed but I gave it hell. Hi. __________________ boop

03-17-2016, 12:52 PM	#38
mauve So Dreamy Join Date: Apr 2005 Location: Someplace magical Posts: 6,863	It liiiiives! __________________ Yoo Hoo!

03-17-2016, 03:23 PM	#39
shiney Derrrrrrrrrrrrrp. Join Date: Nov 2003 Location: The land of fartz and buttz Posts: 8,266	We'll go with that, yes. This one was a big problem and it may not be entirely resolved. Apache (our http server) is consuming a lot of available RAM which causes MYSQL (the database) to freak out and shut down. I tried to install Lighttpd, which is a much more lightweight and low-mem webserver solution, but I couldn't get the virtual hosting to work, and then it was not playing nicely with MYSQL. So I went back to Apache but then there were some different problems with MYSQL and the socket file which I had to create a link to and... [devolves into technical babble....] ...so now it works! ---------- Post added at 03:23 PM ---------- Previous post was at 12:54 PM ---------- And then stopped working again, so I tore down the entire instance and launched a new one. SO NOW IT WORKS GODDAMMIT __________________ boop

03-17-2016, 07:01 PM	#40
Overcast Cinderella Join Date: Mar 2005 Location: Trespassing in the graveyard Posts: 3,076	Hmm, I get a database error every time I head to my User CP, otherwise seems good. __________________ Time to bust out the glow sticks!