rhtyd edited a comment on pull request #212: URL: https://github.com/apache/cloudstack-documentation/pull/212#issuecomment-829889920
The issue has been fixed in https://github.com/apache/cloudstack/pull/4068/files for users using ACS 4.15 with a fresh installed env with MySQL8, or users who upgrade to MySQL8 prior to upgrading to ACS 4.15. The specific issue of nics update_time column issue would still affect anyone who may upgrade CloudStack 4.15+ first and then later decide to upgrade their MySQL to 8+ (or as Andrija found newer minor version of MySQL 5.7.xxx). The root cause is a limitation/issue with older MySQL version which don't run the query (the query effectively doesn't change the column type). Since we can never know when a user may decide to upgrade to MySQL8/5.7.xxx and it's a MySQL issue, we can document it to say the users upgrading to certain MySQL versions can fix the nics exception issue by running the query (it doesn't require restarting of mgmt server or MySQL server, just fixing the column type before doing any nic/network/vm operations). Commit reference: https://github.com/apache/cloudstack/commit/d949302d0f6805b895307f68a561762bcbc87aff (query seen in 4.14->4.15 upgrade path). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
