andrijapanicsb commented on pull request #212:
URL:
https://github.com/apache/cloudstack-documentation/pull/212#issuecomment-848262779
<!--StartFragment-->Users who may upgrade their MySQL server after upgrading
to Apache
CloudStack 4.15 or later, may need to run the following SQL
query to
fix an issue with "cloud.nics" table's column type which may
lead to
exception seen in the management server logs<!--EndFragment-->
This message is not complete/correct, because:
as I stated, I had this message reported by 2 users even when upgrading from
older ACS versions to ACS 4.14 and MySQL 5.7.xx (parallel updates we do with
users, so also MySQL is of a newer, 5.7.xx version) - we historically had this
column type set in a certain way - and as of MySQL 5.7.xx and MySQL 8 - all ACS
versions are "broken" in that regards - i.e. no VM's can be started - and
1) in pre-4.15 used with MySQL 5..7.xx you still need to manually execute
this statement to fix your 4.13, or 4.14 env, etc.
2) in 4.15, this statement can fail (weird enough) during the upgrade, and
again needs to be executed manually.
What I'm saying for both < 4.15 and >4.15 there are issues seen with MySQL
5.7.xx/8.x
Hope that makes sense, or we can discuss offline.
--
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:
[email protected]
