andrijapanicsb commented on pull request #212: URL: https://github.com/apache/cloudstack-documentation/pull/212#issuecomment-829047656
This was a one-time issue that our British friends have occurred when upgrading their test env from 4.13 to 4.15 while using a specific version of MySQL 5.6.xx - the SQL statement silently failed and the upgrade succeeded (SQL that failed was "ALTER TABLE nics MODIFY COLUMN update_time timestamp DEFAULT CURRENT_TIMESTAMP;" - this is the SQL statement required to support MySQL 8, but I've also seen this being required to be manually executed on MySQL 5.7.latest even with ACS 4.14 (Oracle backported something from 8.x to 5.7.latest) The British friends issue is what triggered Daan writing this statement, but that alone I think is not enough. The issue I saw is more worrying, that even MySQL 5.7.latest needs this manual fix for older version of ACS. -- 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
