Saru Posted February 7, 2006 #1 Share Posted February 7, 2006 Some of you have been reporting SQL database errors on the site at various times. We're currently experiencing some problems with the database server, if you receive an SQL error message then please wait a few seconds and then refresh the page. Unfortunately while I've been trying to resolve this issue an even bigger problem has cropped up to do with the site's bandwidth usage, which will have to take priority. I very much hope to have these issues under control as soon as possible. Link to comment Share on other sites More sharing options...
Daughter of the Nine Moons Posted February 7, 2006 #2 Share Posted February 7, 2006 Thanks for the heads up SaRu Link to comment Share on other sites More sharing options...
Yona Posted February 7, 2006 #3 Share Posted February 7, 2006 I had the same problem, didn't know everyone else was having it also. but mine didn't go away untill I rebooted my computer. Link to comment Share on other sites More sharing options...
Rykster Posted February 7, 2006 #4 Share Posted February 7, 2006 Had to reboot a few times, but I figured it out. Get yer sh** together! *smiles* Link to comment Share on other sites More sharing options...
Snowbaby Posted February 7, 2006 #5 Share Posted February 7, 2006 *hugs saru* It's great fun when things go wrong huh? Link to comment Share on other sites More sharing options...
Saru Posted February 7, 2006 Author #6 Share Posted February 7, 2006 mine didn't go away untill I rebooted my computer. These problems are at our end, rebooting your computer won't make any difference. It's great fun when things go wrong huh? You can say that again. Link to comment Share on other sites More sharing options...
Purplos Posted February 7, 2006 #7 Share Posted February 7, 2006 It was very emotionally devestating to be forced away from these boards for a while. I'm glad the SQL thingie is cleared up. Link to comment Share on other sites More sharing options...
Saru Posted February 7, 2006 Author #8 Share Posted February 7, 2006 Just to clarify, this issue is still ongoing and has not yet been resolved. Link to comment Share on other sites More sharing options...
BurnSide Posted February 7, 2006 #9 Share Posted February 7, 2006 I was wondering why there was only 19 members on board. Link to comment Share on other sites More sharing options...
Rykster Posted February 7, 2006 #10 Share Posted February 7, 2006 Just to clarify, this issue is still ongoing and has not been resolved. Gonna leave you alone. Ya have enuff stuff to deal with. Link to comment Share on other sites More sharing options...
Mr. Fahrenheit Posted February 7, 2006 #11 Share Posted February 7, 2006 Ugh. I hope it gts fixed soon. Link to comment Share on other sites More sharing options...
Saru Posted February 9, 2006 Author #12 Share Posted February 9, 2006 There will be a short period of downtime (probably no more than 15 minutes) later on today, hopefully within the next 12-24 hours, in which new hardware will be installed on both our servers. This upgrade will resolve both the database and bandwidth issues mentioned above. Please bear with us. Link to comment Share on other sites More sharing options...
Rykster Posted February 9, 2006 #13 Share Posted February 9, 2006 YAY! New hardware! I like the sound of that. Just make it quick, I am addicted to this site! Link to comment Share on other sites More sharing options...
__Kratos__ Posted February 9, 2006 #14 Share Posted February 9, 2006 Thanks for the heads up, SaRuMaN and for the extra work keeping the site running smoothly. Link to comment Share on other sites More sharing options...
Saru Posted February 10, 2006 Author #15 Share Posted February 10, 2006 The memory upgrade is now complete, we are still waiting on the fix for the bandwidth problem but we should no longer be seeing any SQL errors. If you do experience any further database/SQL errors, please let me know. Thanks. Link to comment Share on other sites More sharing options...
Guest Lottie Posted February 10, 2006 #16 Share Posted February 10, 2006 Thank you!!! Link to comment Share on other sites More sharing options...
__Kratos__ Posted February 11, 2006 #17 Share Posted February 11, 2006 If you do experience any further database/SQL errors, please let me know. I just got a SQL error, at 8:53 am (my time) as a guest, trying to view the Islam topic. Link to comment Share on other sites More sharing options...
Saru Posted February 11, 2006 Author #18 Share Posted February 11, 2006 Any SQL errors received this morning were a result of work being performed on the database server to accomodate the new hardware upgrade, so you shouldn't see any more of them now. If you do experience any more from this point however, please let me know. If possible, try to copy+paste the error message aswell as it helps me diagnose the problem. Thanks. Link to comment Share on other sites More sharing options...
Saru Posted February 12, 2006 Author #19 Share Posted February 12, 2006 Again in the early hours of this morning, site was down for about five hours while I was asleep because a linux configuration file magically reset itself and essentially forgot the new routing rules I put in. Could have fixed it at any point had it not done it in the middle of the night. Typically bad timing, sorry about that. Link to comment Share on other sites More sharing options...
jesspy Posted February 12, 2006 #20 Share Posted February 12, 2006 (edited) Again in the early hours of this morning, site was down for about five hours while I was asleep because a linux configuration file magically reset itself and essentially forgot the new routing rules I put in. Could have fixed it at any point had it not done it in the middle of the night. Typically bad timing, sorry about that. Its okay The SQL message came up but I didnt copy it sorry. I just waited and tried again and here i am Edited February 12, 2006 by jesspy Link to comment Share on other sites More sharing options...
Rykster Posted February 12, 2006 #21 Share Posted February 12, 2006 Heh, the gremlins at work. What did I tell ya big guy? Link to comment Share on other sites More sharing options...
__Kratos__ Posted February 13, 2006 #22 Share Posted February 13, 2006 Just got one: Screen Shot of Error Link to comment Share on other sites More sharing options...
Rykster Posted February 13, 2006 #23 Share Posted February 13, 2006 (edited) Two on the same page, but if you were restarting the server, that could explain them... SQL error: Server shutdown in progress SQL error code: Date: Monday 13th of February 2006 06:35:11 PM SQL error: Lost connection to MySQL server during query SQL error code: Date: Monday 13th of February 2006 06:35:11 PM Edit - Removed a couple of lines as they were distorting the page. Since this error is explainable (see below) we don't need to keep those lines up anyway. Edit: Gotcha! Edited February 13, 2006 by Rykster Link to comment Share on other sites More sharing options...
Saru Posted February 13, 2006 Author #24 Share Posted February 13, 2006 Rykster, as you suspected those errors were due to me restarting the database server to implement a possible fix for the error Kratos posted. Restarting SQL takes less than five seconds, so you must have tried to access a page during that window. The original error (errno 11) is very hard to diagnose, as despite a lot of people reporting it on Google there is next to no documentation detailing what is causing it or how to solve it apart from a few vague hints which don't really help. I've tweaked a few settings on the database server which may have been causing the problem, if this error persists however then i'll have to ask around on various database forums to try and find a more effective solution to it. Let me know if you see the error again and if so, how often it occurs. Link to comment Share on other sites More sharing options...
Rykster Posted February 13, 2006 #25 Share Posted February 13, 2006 Dunno if this will help, but what da heck. (feel free to delete this post if you want) Increasing max connections alone is not enough. The user running the apache/mysql must get permission to run that many processes. To find out if there are limits you should run ulimit as that user. A typical output of ulimit -a (debian): core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) unlimited virtual memory (kbytes, -v) unlimited It limits my open files to 1024... each mysql connection/thread probably has at least 1 file opened, but I have not limit on processes (which a thread also counts as on linux)... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now