Wow Posted February 1, 2014 Share Posted February 1, 2014 Yes, caching is and has been enabled. We're still going through all the logs to determine the cause of this error. It seems it's only affecting the sql processing. Overall server loads on both servers have been fine, even during our high traffic events. Link to comment Share on other sites More sharing options...
bmorelights Posted February 1, 2014 Share Posted February 1, 2014 Yes, caching is and has been enabled. We're still going through all the logs to determine the cause of this error. It seems it's only affecting the sql processing. Overall server loads on both servers have been fine, even during our high traffic events. Unless your http headers are lying, you're running php 5.2.17. That's pretty old. Not necessarily the source of the problem, but depending on the versions of MySQL(I assume) you're running, and the version of the MySQL client you've got, there could be some problems there. The likelier possibility, given that you mentioned it happens during large processing runs of model data, is that some code on your webserver, either IPB or your model processing code, is using something like mysql_pconnect, spawning too many long-running queries on multiple simultaneous connections, and failing a connect call somewhere. Either way, enterprise php app development (boy, that's a joke) is what I do for a living, and I'd be happy to take a look under the hood pro bono. I like this board. Link to comment Share on other sites More sharing options...
yoda Posted February 9, 2014 Share Posted February 9, 2014 Getting a few of the SQL errors just now Link to comment Share on other sites More sharing options...
nw baltimore wx Posted February 9, 2014 Share Posted February 9, 2014 Getting beat up pretty good over the past ten minutes. Link to comment Share on other sites More sharing options...
ravensrule Posted February 9, 2014 Share Posted February 9, 2014 Getting beat up pretty good over the past ten minutes. Lol, it took me 10 minutes just to post this because of all the errors i am getting. Link to comment Share on other sites More sharing options...
KAOS Posted February 9, 2014 Share Posted February 9, 2014 I know it's been said...but the server is horrible today. Link to comment Share on other sites More sharing options...
Bob Chill Posted February 9, 2014 Share Posted February 9, 2014 Live webcam feed from amwx server room ain't lookin to pretty Link to comment Share on other sites More sharing options...
ravensrule Posted February 10, 2014 Share Posted February 10, 2014 Getting the dreaded SQL errors again now. This is painful. Link to comment Share on other sites More sharing options...
motsco Posted February 10, 2014 Share Posted February 10, 2014 I have been getting SQL for about 2 weeks now, and tonight they are almost back to back, I thought it was a lurker block . Link to comment Share on other sites More sharing options...
nj2va Posted February 10, 2014 Share Posted February 10, 2014 The server performance is atrocious. Link to comment Share on other sites More sharing options...
yoda Posted February 10, 2014 Share Posted February 10, 2014 Seriously... please do something. Sorry if I sound annoyed... just a tad frustrated with 5 straight minutes of SQL and driver errors... its going to get even worse with the GFS and EURO runs Link to comment Share on other sites More sharing options...
nj2va Posted February 10, 2014 Share Posted February 10, 2014 Seriously... please do something. Sorry if I sound annoyed... just a tad frustrated with 5 straight minutes of SQL and driver errors... its going to get even worse with the GFS and EURO runs This. I've been patient the past few weeks but tonight has been really bad. Link to comment Share on other sites More sharing options...
dukeblue219 Posted February 10, 2014 Share Posted February 10, 2014 Unless your http headers are lying, you're running php 5.2.17. That's pretty old. Not necessarily the source of the problem, but depending on the versions of MySQL(I assume) you're running, and the version of the MySQL client you've got, there could be some problems there. The likelier possibility, given that you mentioned it happens during large processing runs of model data, is that some code on your webserver, either IPB or your model processing code, is using something like mysql_pconnect, spawning too many long-running queries on multiple simultaneous connections, and failing a connect call somewhere. Either way, enterprise php app development (boy, that's a joke) is what I do for a living, and I'd be happy to take a look under the hood pro bono. I like this board. As someone else somewhat experienced in PHP/MySQL development, and who runs a large message board myself, I cannot emphasize the above enough. I'm not surprised to hear that it's not a problem with overall CPU/mem load. That's rarely the case. It's far more likely the maximum number of simultaneous SQL connections being exceeded. This is where careful examination of log files, and perhaps addition of some debugging/error-handling code to the forum software, would be helpful. It may be as simple as substantially increasing a software limit, or it may require some rewriting to eliminate pconnects. Short answer - this is definitely fixable. Link to comment Share on other sites More sharing options...
KamuSnow Posted February 10, 2014 Share Posted February 10, 2014 About 45 minutes ago I got the same SQL and driver errors I've been seeing on and off for the last couple of weeks, but this was by far the worst episode to date, fwiw. Link to comment Share on other sites More sharing options...
JERSEYSNOWROB Posted February 10, 2014 Share Posted February 10, 2014 Yeah very frustrating. Getting same error messages. Link to comment Share on other sites More sharing options...
Morris Posted February 10, 2014 Share Posted February 10, 2014 Out of hand tonight. Link to comment Share on other sites More sharing options...
wxmeddler Posted February 10, 2014 Share Posted February 10, 2014 Can't even post some posts. It's bad tonight.. Link to comment Share on other sites More sharing options...
ThreeRedheads Posted February 10, 2014 Share Posted February 10, 2014 Getting errors about every 5th refresh. Link to comment Share on other sites More sharing options...
mattie g Posted February 10, 2014 Share Posted February 10, 2014 If you guys haven't already, please take note if the feedback you've gotten from folks with tech experience and know-how. Hopefully it can help you guys soothe the chapped asses around here. And thanks for making this board available to the weather geeks of the world... Link to comment Share on other sites More sharing options...
WEATHER53 Posted February 10, 2014 Share Posted February 10, 2014 Man with all of the ads and donation drives it certainly seems like <200 onliners should not crash this place. Several of the posters above have made explicit, expert recommendations so follow that advice. Link to comment Share on other sites More sharing options...
KamuSnow Posted February 10, 2014 Share Posted February 10, 2014 Live webcam feed from amwx server room ain't lookin to pretty amwxserver.JPG Try rebooting? Link to comment Share on other sites More sharing options...
ravensrule Posted February 10, 2014 Share Posted February 10, 2014 This has been beyond painful, i just wish you guys would tell us why you cannot fix this problem that has been happening for weeks. Link to comment Share on other sites More sharing options...
astarck Posted February 10, 2014 Share Posted February 10, 2014 Is the board hanging for anyone else? I'm not getting the SQL errors but pages will load forever. The only way I can see posts is to hit stop while the page loads. Link to comment Share on other sites More sharing options...
ravensrule Posted February 10, 2014 Share Posted February 10, 2014 Is the board hanging for anyone else? I'm not getting the SQL errors but pages will load forever. The only way I can see posts is to hit stop while the page loads. Same problem plus 2 SQL errors. Link to comment Share on other sites More sharing options...
KAOS Posted February 10, 2014 Share Posted February 10, 2014 No worries... Same problem plus 2 SQL errors. No worries...they're working on it as we speak. Link to comment Share on other sites More sharing options...
stormtracker Posted February 10, 2014 Author Share Posted February 10, 2014 ALthough I have no clue what I'm doing, I've disabled guest viewing and some other stuff. Let's see if that makes any difference. Link to comment Share on other sites More sharing options...
snowfan Posted February 10, 2014 Share Posted February 10, 2014 Whatever small changes have been made seem to be working. I had a few SQL errors yesterday, but nothing that was anything more than a slight inconvenience. Certainly nothing that F5 can't fix. Link to comment Share on other sites More sharing options...
astarck Posted February 10, 2014 Share Posted February 10, 2014 ALthough I have no clue what I'm doing, I've disabled guest viewing and some other stuff. Let's see if that makes any difference. Whatever you did - it's working. Running a lot better the last few minutes. Link to comment Share on other sites More sharing options...
mappy Posted February 10, 2014 Share Posted February 10, 2014 Whatever you did - it's working. Running a lot better the last few minutes. not here, had three SQL errors in the last 5 minutes Link to comment Share on other sites More sharing options...
MN Transplant Posted February 10, 2014 Share Posted February 10, 2014 Didn't get any SQL errors, but it was slow. Frankly, so was instantweathermaps, so the weather weenies are definitely out in force. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.