I've created an orchestration group to patch SQL Clusters. The pre- and post-scripts trigger scheduled tasks that run under the cluster administrator account to move cluster roles away from nodes starting orchestration.
I've run the orchestration 4 times (no manual triggering, starting upon entering the maintenance windows). The first and the third time, it all worked fine but the second and fourth time the orchestration seemed to have issues.
My Cluster has two nodes, node1 and node2. The Orchestration Group is configured to run in sequence, starting with node1.
Node1 runs it's pre script (triggering a scheduled task and moving the roles away), installs the pending updates and scheduled a reboot.
And in that state, node2 ran its pre script, moving the cluster role back to the node that is about to reboot.
How is that possible?
As I understand, in sequence mode (or any other mode of orchestration), a node should run the pre script, run the pending deployments, reboot if necessary and after the reboot run the post script. After the post script on a node has run, the next node in the sequence acquired the orchestration lock and starts with the pre script.
Thanks for your help
I've run the orchestration 4 times (no manual triggering, starting upon entering the maintenance windows). The first and the third time, it all worked fine but the second and fourth time the orchestration seemed to have issues.
My Cluster has two nodes, node1 and node2. The Orchestration Group is configured to run in sequence, starting with node1.
Node1 runs it's pre script (triggering a scheduled task and moving the roles away), installs the pending updates and scheduled a reboot.
And in that state, node2 ran its pre script, moving the cluster role back to the node that is about to reboot.
How is that possible?
As I understand, in sequence mode (or any other mode of orchestration), a node should run the pre script, run the pending deployments, reboot if necessary and after the reboot run the post script. After the post script on a node has run, the next node in the sequence acquired the orchestration lock and starts with the pre script.
Thanks for your help