intfiction.org

The Interactive Fiction Community Forum
It is currently Wed Jun 19, 2013 6:27 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 25 posts ]  Go to page Previous  1, 2, 3
Author Message
 Post subject: Re: SQL Errors
PostPosted: Mon Apr 02, 2012 7:54 am 
Offline
Site Admin
User avatar

Joined: Sat Dec 22, 2007 9:54 am
Posts: 951
Location: Wichita, KS
The usual amount should be none at all if everything's working correctly...


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Mon Apr 02, 2012 9:44 am 
Offline

Joined: Tue Apr 27, 2010 1:02 pm
Posts: 798
I haven't seen any at all since your fix.


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Tue Apr 03, 2012 5:03 am 
Offline

Joined: Sun Feb 17, 2008 3:51 pm
Posts: 256
No errors here since the fix as well.

_________________
Skinny Mike


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Wed Apr 11, 2012 11:31 am 
Offline

Joined: Tue Apr 27, 2010 1:02 pm
Posts: 798
The SQL errors came back last night and have continued this morning.


Top
 Profile Send private message  
 
 Post subject: Re: SQL Errors
PostPosted: Sat Apr 14, 2012 1:37 pm 
Offline
Site Admin
User avatar

Joined: Sat Dec 22, 2007 9:54 am
Posts: 951
Location: Wichita, KS
At the rate of about one a day, an "rpmq" process is getting stuck. These compound until the server is out of memory. I thought it was strictly due to the failed system update from a while back, but that might not be the case.

This morning, I rebooted the server, shut off MySQL and Apache, and attempted to run the system update again. I think there's something wrong with the rpm package that's currently installed. However, the update ran for well over an hour without a status update, so ultimately I killed it and rebooted the server again.

I'm still trying to find out what can be done to get the system updated. In the meanwhile, I think I'm going to have to kill stray rpmq processes on a regular basis to keep things running smoothly.

I've had memory problems on the server almost since the beginning, which is probably what I get for trying to host on the cheap. Never had significant problems when I leased whole servers, rather than virtual space. Hopefully I'll come up with a permanent solution that doesn't involve moving, because that's usually a weekend project and something I generally dread.


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


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