I have a few questions for the fellow Alteryx Server admins out there:
- How often do you schedule MongoDB backups?
- Is the process automated?
- Have you ever run into the issue of the AlteryxService failing to stop, so the backup process hangs until manual intervention.
- How do you handle high-frequency, recurring schedules, and their overlap with the maintenance window?
A bit of context:
We have an automated script that runs the backup process nightly. In addition to the MongoDB dump, we also include a copy of the RuntimeSettings.xml, SystemConnections.xml, DSNs as a registry file, a copy of the controller token, etc. and have the process compress all of this into a single file using 7-Zip.
Very randomly, the AlteryxService shutdown hangs with a 'Stopping' state, thus the backup cannot proceed. Additionally, any jobs that are scheduled to run during this window are not processed and their schedules are marked as 'Completed', instead of the usual 'Active'. The only identified resolution to the 'stopping' state is to manually end the AlteryxService.exe task. It's worth noting that this occurs despite no active jobs running (ie. no instances of AlteryxEngineCmd.exe).
I'd love to hear some insights from other folks that have experience with Server administration.
Thanks.
