Major Site Upgrade

[Mike Bobbitt]

Made a change this morning to stop the error log from filling up. Side effect: nobody could post or possibly even log in.

Fixed, error log is back to growing fast enough to run us out of space in about a week. (I just have to remember to empty it, weekly, until I find a better way.)

 

[Colin Parkinson]

thanks for the work

 

[Kat Stevens]

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Getting this continuously, to the point of aggravation.

 

[dapaterson]

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Getting this continuously, to the point of aggravation.

I start pounding on F5 to refresh the page when it comes up.  Very intermittent - it will come up continuously for a while, but then go away.

 

[PMedMoe]

I start pounding on F5 to refresh the page when it comes up.  Very intermittent - it will come up continuously for a while, but then go away.

Same experience here.

 

[Mike Bobbitt]

Unfortunately a known issue. We simply hit too many connections for the database server to handle, and new connections are deferred until things ease up. Been looking at way to optimize database access for as long as the screen has been coming up, but clearly haven't made significant progress yet.

The issue sort of stems (ironically) from the recent server upgrade. We have two pieces, the front end (web server) and back end (database). We upgraded the front end a couple of months ago, giving us room to stretch our legs a bit more. Doing so is now overloading the back end, which has not been upgraded in 2+ years.  :-\


Cheers
Mike

 

[SeaKingTacco]

Thanks Mike! Keep up the good work.

 

[Kirkhill]

Ditto to SKT, Mike.

On your own time!  :nod:

 

[kev994]

For the past ~3 weeks I've been unable to connect with Tapatalk during peak periods but usually have no issues using Safari on the same phone. Fair assumption it's the same capacity issue?

 

[Mike Bobbitt]

Yes, we are hitting a high number of concurrent database connections, so the "last in" time out or are dropped outright depending on how far over the limit we go. Tapatalk adds more connections. As a test I may temporarily disable it to see if it is a key contributor to the issue. I suspect it is not though.

 

[Kat Stevens]

Yes, we are hitting a high number of concurrent database connections, so the "last in" time out or are dropped outright depending on how far over the limit we go. Tapatalk adds more connections. As a test I may temporarily disable it to see if it is a key contributor to the issue. I suspect it is not though.

No skin off my rump if TapaTalk never comes back.  How it`s supposed to make forums easier beats me, I hate it.  8)

 

[Fishbone Jones]

I installed it and took it out within the hour. It wants too many permissions and wants to filter all your internet activity through the program. I wish there was a way to kill the banner request to 'enjoy tapatalk'. I hate turning it off everytime I visit.

 

[Colin Parkinson]

Getting lot of these on Government supported (ha!) Firefox

"Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

 

[Mike Bobbitt]

It's our server, not the browser. Still tweaking the configuration to try to get the maximum out of it, but we are hitting some hard limits.

 

[Mike Bobbitt]

Folks,

I am converting our database from (slow) magnetic to (fast) SSD. This will have an adverse effect on performance during the conversion but "should" help long term. I'll post again when the conversion is complete.


Cheers
Mike

 

[Mike Bobbitt]

...and it's complete. Fingers crossed this will be a "good" change.

 

[Infant_Tree]

Folks,

I am converting our database from (slow) magnetic to (fast) SSD. This will have an adverse effect on performance during the conversion but "should" help long term. I'll post again when the conversion is complete.


Cheers
Mike

...and it's complete. Fingers crossed this will be a "good" change.

Yeah just noticed the site's no longer down and it seems to be running smoothly I appreciate the hard work you did upgrading the site for us all.

 

[mariomike]

I appreciate the hard work you did upgrading the site for us all.

A way to show your appreciation,

Milnet.ca Subscriptions
http://milnet.ca/subscribe/index.php?action=profile;u=16

 

[Loachman]

And it only took thirty minutes between the two posts.

You make it look so easy, Mike. You should work on your Scottyness a bit more - "I canna do it in less than three days, Captain".

It may be (I hope) the DWAN connection, but I got a "Server too busy, please try again in a few minutes..." message when trying to compose this response.

 

[kev994]

It's working much better for me, everything has loaded instantly, I normally have to wait a while at this time of night.