You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2022/04/12 05:14:51 UTC

[GitHub] [cloudstack] AlexanderKgr opened a new issue, #6247: Upgrade - migrate to new host - os

AlexanderKgr opened a new issue, #6247:
URL: https://github.com/apache/cloudstack/issues/6247

   <!--
   Verify first that your issue/request is not already reported on GitHub.
   Also test if the latest release and main branch are affected too.
   Always add information AFTER of these HTML comments, but no need to delete the comments.
   -->
   
   ##### ISSUE TYPE
   <!-- Pick one below and delete the rest -->
    * Bug Report
    * Documentation Report
    * Other
   
   ##### COMPONENT NAME
   <!--
   Categorize the issue, e.g. API, VR, VPN, UI, etc.
   -->
   ~~~
   Cloudstack app
   ~~~
   
   ##### CLOUDSTACK VERSION
   <!--
   New line separated list of affected versions, commit ID for issues on main branch.
   -->
   
   ~~~
   4.16.1.0
   ~~~
   
   ##### CONFIGURATION
   <!--
   Information about the configuration if relevant, e.g. basic network, advanced networking, etc.  N/A otherwise
   -->
   Advanced networking
   
   ##### OS / ENVIRONMENT
   <!--
   Information about the environment if relevant, N/A otherwise
   -->
   Ubuntu Server
   
   ##### SUMMARY
   <!-- Explain the problem/feature briefly -->
   I am running the cloudstack app at a server based on Ubuntu Server 18.04.
   I want to migrate to other server and to update to 20.04
   Tried two scenarios.
   
   1st scenario.
   Create new server based on 20.04.
   Set up a new instance of cloudstack 
   Restored both dbs (cloud, cloud_usage)
   Cloudstack was running but i could not create new instance. 
   There was an issue with the db
   Mysql versions were different.
   
   2nd scenario.
   Create new server based on 18.04.
   Set up a new instance of cloudstack 
   Restored both dbs (cloud, cloud_usage)
   Cloudstack was running perfect. I was able of creating new instance, networks etc.
   Upgraded my server to 20.04.
   Cloudstack again was running but i could not create new instance.
   There was an issue with db and mysql versions were different
   
   On UbuntuServer 18.04 mysql is 5.7.37
   On UbuntuServer 20.04 mysql is 8.0.28
   
   ![image](https://user-images.githubusercontent.com/25532758/162884521-5d036085-d033-4442-ac3b-1f0865b3448f.png)
   
   Searched cloudstack documentation for migration of server but i didn't find anything.
   
   Also i tried to use mailing lists but it was really difficult to use.
   In the past it was possible to use gmail account login and use them but lately it was removed.
   It wasn't easy to use my client and respond to mailing list.
   
   
   ##### EXPECTED RESULTS
   <!-- What did you expect to happen when running the steps above? -->
   
   ~~~
   A successful migration with upgrade
   ~~~
   
   ##### ACTUAL RESULTS
   <!-- What actually happened? -->
   
   <!-- Paste verbatim command output between quotes below -->
   ~~~
   Couldn't use cloudstack and i had to revert to ubuntu server 18.04
   ~~~
   Thanks


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [cloudstack] AlexanderKgr commented on issue #6247: Upgrade - migrate to new host - os

Posted by GitBox <gi...@apache.org>.
AlexanderKgr commented on issue #6247:
URL: https://github.com/apache/cloudstack/issues/6247#issuecomment-1096270007

   > @AlexanderKgr this could be a consequence of the MySQL version - http://docs.cloudstack.apache.org/en/latest/upgrading/upgrade/mysql.html. After the migration, can you please try running the following query: `ALTER TABLE nics MODIFY COLUMN update_time timestamp DEFAULT CURRENT_TIMESTAMP;`
   
   thank you very much! it is fixed! you made my day! <3


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [cloudstack] AlexanderKgr closed issue #6247: Upgrade - migrate to new host - os

Posted by GitBox <gi...@apache.org>.
AlexanderKgr closed issue #6247: Upgrade - migrate to new host - os
URL: https://github.com/apache/cloudstack/issues/6247


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [cloudstack] Pearl1594 commented on issue #6247: Upgrade - migrate to new host - os

Posted by GitBox <gi...@apache.org>.
Pearl1594 commented on issue #6247:
URL: https://github.com/apache/cloudstack/issues/6247#issuecomment-1096233417

   @AlexanderKgr this could be a consequence of the MySQL version -  http://docs.cloudstack.apache.org/en/latest/upgrading/upgrade/mysql.html. After the migration, can you please try running the following query:
   `ALTER TABLE nics MODIFY COLUMN update_time timestamp DEFAULT CURRENT_TIMESTAMP;` 


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org