intfiction.org

The Interactive Fiction Community Forum
It is currently Sat May 18, 2013 9:53 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 25 posts ]  Go to page Previous  1, 2, 3  Next
Author Message
 Post subject: Re: SQL Errors
PostPosted: Mon Mar 26, 2012 7:50 am 
Offline

Joined: Wed Jul 20, 2011 4:24 pm
Posts: 38
... and today, I'm getting Server Sent No Data from Chrome on almost every attempt to load a thread or a subforum, and it's taking five or six refreshes to get it to work - if it's six, the fifth refresh gets me the SQL error. Once I have the thread up, I have no trouble going page-to-page. But going back to the subforum level or from the subforum to a thread brings the error back.


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Mon Mar 26, 2012 7:55 am 
Offline
Site Admin
User avatar

Joined: Sat Dec 22, 2007 9:54 am
Posts: 951
Location: Wichita, KS
There were quite a few rpm update processes running -- presumably stuck. Killing them freed up plenty of memory. Until then, things were running pretty much maxed out.

I think it happened a few days ago when I was attempting to update the server. It sounds like the SQL errors were much more common since around that time. I hadn't been getting them, but I'm not on nearly as much as others. The MySQL log showed plenty, on an ongoing basis.

At some point, I'm going to need to take HTTPD and MYSQLD down (possibly) and attempt another server update. But when I do, I'll check the processes to help avoid this from happening again.

I don't know if this will completely solve the memory problems, but it should help tremendously. You shouldn't be getting SQL out of memory errors now, at least.


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Mon Mar 26, 2012 9:36 am 
Offline

Joined: Tue Apr 27, 2010 1:02 pm
Posts: 797
Thanks Merk!


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Mon Mar 26, 2012 10:53 am 
Offline

Joined: Sun Feb 17, 2008 3:51 pm
Posts: 256
bcressey wrote:
Thanks Merk!

+1 :)

_________________
Skinny Mike


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Tue Mar 27, 2012 5:05 pm 
Offline

Joined: Wed Jul 20, 2011 4:24 pm
Posts: 38
bcressey wrote:
Thanks Merk!

Ditto :)


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Wed Mar 28, 2012 7:14 am 
Offline
User avatar

Joined: Tue Apr 20, 2010 2:48 pm
Posts: 680
You might want to reboot the machine more often. Maybe once a day.


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Fri Mar 30, 2012 5:45 pm 
Offline
Site Admin
User avatar

Joined: Sat Dec 22, 2007 9:54 am
Posts: 951
Location: Wichita, KS
I could, but I think that was a fluke due to the botched system update. Are you still getting SQL out of memory errors even now?


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Sat Mar 31, 2012 12:30 am 
Offline
User avatar

Joined: Wed Feb 03, 2010 4:25 pm
Posts: 264
Location: Sweden
I haven't seen any errors since.

_________________
"The thing I like about deadlines is the wonderful whooshing noise they make as they go past."
- Douglas Adams


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Sat Mar 31, 2012 11:00 pm 
Offline

Joined: Wed Jul 20, 2011 4:24 pm
Posts: 38
The problem seems to have cleared up. Thanks!


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Sun Apr 01, 2012 2:31 am 
Offline
User avatar

Joined: Tue Apr 20, 2010 2:48 pm
Posts: 680
Merk wrote:
I could, but I think that was a fluke due to the botched system update. Are you still getting SQL out of memory errors even now?

Just the usual amount of them.


Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 25 posts ]  Go to page Previous  1, 2, 3  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group