From the series "random things that happen", and hopefully of use to someone else, these are the lessons from updating one system from 12.2.0+hf2 to 12.2.1-2019-02-02.
This was an old-style update, since we don't do ZDU for the time being. The manual was found to be lacking severely in clarity. The chapter on Hotfix updates (whether applicable here or not) seems to have gotten truncated between 12.1 and 12.2 a lot (effectively improving it), but overall the procedures remains very unclear. After being severely puzzled and some fruitless discussion, we had to ditch the manual and went with a plain "shut down, update files, update db and bring it back up" approach.
Some small findings:
- when ucybdbld says
U00038127 Loading in upgrade mode is not possible while the system is running.
after shutting down the system, this means you needed to stop all clients. You do not need to empty EH (i.e. stop all activities), although Automic has recommended that in the past. But do stop all clients BEFORE you bring down the system or you won't be able to update the database.
- it appears, at least for us, the 12.2.0 SQL agent in Service Mode is not compatible with 12.2.1. We needed to update to the latest SQL agent to get it to register with the engine after the update.
The rest was smooth sailing.