GitHub user TadiosAbebe added a comment to the discussion: setting custom timezone impacts VM HA
@DaanHoogland , Sorry for the late response. I'm not entirely sure how much effort this change would require or what kind of regression risk it might introduce, but in my opinion the most reliable long-term fix would be to standardize how time is retrieved across the codebase either always using the local server time or always using UTC. For MySQL/MariaDB specifically, using UTC_TIMESTAMP() would avoid the inconsistency we’re seeing, though I don’t have full visibility into all edge cases, so it might be best to leave it as-is for now. Regarding documentation updates, we could add a note under NTP configuration in the following sections: 1. Quick Installation Guide → Management Server Installation → Database Installation and Configuration 2. Installation Guide → General Installation → Management Server Installation → Preparing the Operating System With a note similar to: > Configuring servers (especially database hosts) to use non-UTC timezones may > interfere with VM HA tasks. Using UTC system time is recommended for > consistency. If this approach sounds acceptable, I can create a PR for the documentation. GitHub link: https://github.com/apache/cloudstack/discussions/12183#discussioncomment-15346873 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
