If database down, Exponent 2.0.2 launches installer for upgrade
-
Richard Toohey
HHhhhmmm, I see what you are saying, but don't agree.
It doesn't seem to be a good situation to say "I cannot connect, therefore assume I have to install and create a file on the server" - especially when you present that to Joe Public web client.
I was looking for a more graceful handling of the situation when checking the version string - don't assume because you can't connect that an upgrade is required.
If I've got 50 Exponent sites, I have to put all 50 in maintenance mode to gracefully cope with the 10 second downtime while MySQL stops & the new binary starts?
Remember that there might be a transient condition - for some reason MySQL is briefly unavailable (it just happened to me during an upgrade.) You might not have time to put the site(s) into Maintenance mode. So, you are hosting your 75 Exponent sites on provider X's server - provider X has an issue with MySQL being down for 30 minutes. Provider X's tech guys fix the situation as quickly as they can - but you now have 75 sites all telling the end user that they need to install tables as part of an upgrade ... that really does not sound right.
I'll see if I can offer some code to make things work better for me. (Shut up & hack.)
Thanks for the prompt response.
-
Richard Toohey
A little light-bulb is illuminating ... back to your earlier comment:
"Exponent can NOT operate without a functional database! If it can't connect or find a few basic tables, it assumes the database has been deleted/moved and enters the routine to install or upgrade."
To me, that absence of a database means a fatal condition - one that means we need to stop and say "something's wrong here" and give up at that point. It's not safe (in my opinion) to continue. (So sysadmin can scuttle off, find out what's happened to the database, fix it.)
But to Exponent (as designed), the absence of a database means "assume that we need to upgrade/install, so ask the user(s) currently viewing the webpage what to do"
I can see what you mean now (thanks for taking the time to spell it out), but I still think it's odd to present the next visitor of your website with a message that says "let's play with database tables." Personally I would prefer the next visitor (assuming MySQL/database down) to see a message along the lines of "Database down, come back soon" (or maybe the 2.0.3 changes you mentioned above will do something along those lines) and then the visitor after that (assuming MySQL/database back by then) to see the normal site. No web visitor gets to see that. Forcing the site(s) into an unavoidable upgrade routine because of a transient database issue just doesn't "feel" right to me.
I'll still proceed to see what I can come back with, but I understand what you are saying - this is a conscious design choice in Exponent.
Thanks.
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.