# Db upgrade community 6.0.0 to 6.2.0 **URL:** \ **Category:** Installation & Configuration\ **Created:** [November 6, 2021, 12:22am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099 "2021-11-06T00:22:10Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![DennisTait](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/dennistait/32/4330_2.png) [@DennisTait](https://forum.opennebula.io/u/DennisTait)\ **Post date:** [November 6, 2021, 12:22am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/1 "2021-11-06T00:22:10Z")
After upgrading one from 6.0.0 to 6.2.0 I’m not able to start one. onedb upgrade -v --sqlite ./one.db ```auto oneadmin@one-mast-01:~$ onedb upgrade -v --sqlite ./one.db Version read: Shared tables 6.0.0 : Database migrated from 5.12.0 to 6.0.0 (OpenNebula 6.0.0) by onedb command. Local tables 6.0.0 : Database migrated from 5.12.0 to 6.0.0 (OpenNebula 6.0.0) by onedb command. Sqlite database backup stored in /var/lib/one/one.db_2021-11-6_0:24:44.bck Use 'onedb restore' to restore the DB. >>> Running migrators for shared tables Database already uses version 6.0.0 >>> Running migrators for local tables Database already uses version 6.0.0 Total time: 0.06s ERROR: Database upgrade to the latest versions (local 6.0.0, shared 6.0.0) wasn't successful due to missing migration descriptors. Migrators are provided as part of Enterprise Edition for customers with active subscription. For community with non-commercial deployments they are provided via a dedicated migration package, which must be obtained separately. The database will be restored Sqlite database backup restored in ./one.db ``` ````auto ---------------------------------------- Sat Nov 6 00:14:06 2021 [Z0][ONE][I]: Log level:3 [0=ERROR,1=WARNING,2=INFO,3=DEBUG] Sat Nov 6 00:14:06 2021 [Z0][ONE][I]: Support for xmlrpc-c > 1.31: yes Sat Nov 6 00:14:06 2021 [Z0][ONE][I]: Using hostname: one-mast-01 Sat Nov 6 00:14:06 2021 [Z0][ONE][I]: sqlite has enabled: SQLITE_ENABLE_UPDATE_DELETE_LIMIT Sat Nov 6 00:14:06 2021 [Z0][ONE][I]: Checking database version. Sat Nov 6 00:14:06 2021 [Z0][ONE][E]: Database version mismatch ( local_db_versioning). Installed OpenNebula 6.2.0 (c84c3303) needs DB version '6.2.0', and existing DB version is '6.0.0'. Sat Nov 6 00:14:06 2021 [Z0][ONE][E]: Use onedb to upgrade DB. "/var/log/one/oned.log" 301L, 15378C ``` ```` ---
**Author:** ![matchett808](https://avatars.discourse-cdn.com/v4/letter/m/e495f1/32.png) [@matchett808](https://forum.opennebula.io/u/matchett808)\ **Post date:** [November 8, 2021, 1:38am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/2 "2021-11-08T01:38:17Z")
I think you need to contact support to get the migrations ---
**Author:** ![DennisTait](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/dennistait/32/4330_2.png) [@DennisTait](https://forum.opennebula.io/u/DennisTait)\ **Post date:** [November 8, 2021, 4:38pm UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/3 "2021-11-08T16:38:58Z")
Thanks for the reminder. Email requested the migration packages for opennebula 6.2 CE. Sent to [community-manager@opennebula.io](mailto:community-manager@opennebula.io) ---
**Author:** ![DennisTait](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/dennistait/32/4330_2.png) [@DennisTait](https://forum.opennebula.io/u/DennisTait)\ **Post date:** [November 9, 2021, 6:31pm UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/4 "2021-11-09T18:31:36Z")
After installing the 6.2 migration deb, and applyimg the onedb upgrade openenebula 6.2 came up. Initially I was able to login to a running vm via sunstone but since upgrading via apt update && apt upgrade I am not able to login to the sunstone console. How can I get sunstone working? The command line however seems to be working ok. My next test is with terraform. ```auto oneadmin@one-mast-01:~$ onehost list ID NAME CLUSTER TVM ALLOCATED_CPU ALLOCATED_MEM STAT 3 one-node-03 default 0 0 / 800 (0%) 0K / 31G (0%) on 2 one-node-02 default 0 0 / 800 (0%) 0K / 31G (0%) err 1 one-node-01 default 0 0 / 1600 (0%) 0K / 31G (0%) on 0 one-mast-01 default 1 200 / 3200 (6%) 4G / 61.8G (6%) on oneadmin@one-mast-01:~$ onevm list ID USER GROUP NAME STAT CPU MEM HOST TIME 398 oneadmin oneadmin CentOS 7 cicd-398 poff 2 4G one-mast-01 0d 20h16 oneadmin@one-mast-01:~$ onevnet list ID USER GROUP NAME CLUSTERS BRIDGE LEASES 93 oneadmin lab-ks-o lab-ks-one-node-vnet 0 br0 0 92 oneadmin dev-ks-o dev-ks-one-node-vnet 0 br0 0 0 oneadmin oneadmin public-net 0 br0 1 ``` As you can see from the following screenshots the original sunstone login page is rendered but when I login I get a Sinatra error page. I can however see the oneprovision dashboard. /var/log/one/ ```auto ./ 398.log fireedge.error fireedge.log monitor.log novnc.log oned.log oneflow.log onegate.log onehem.log sched.log sunstone.log vcenter_monitor.log ``` /var/log/one/fireedge.log ```auto ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m ^[[31m Error: ENOENT: no such file or directory, open '/usr/lib/one/fireedge/etc/fireedge-server.conf' ^[[0m [HPM] Proxy created: /fireedge/vmrc -> http://localhost:2616 [HPM] Subscribed to http-proxy events: ['error', 'close'] ^[[32m Server listen in 0.0.0.0:2616 ^[[0m ``` /var/log/one/fireedge.error ```auto Warning: Invalid argument supplied to oneOfType. Expected an array of check functions, but received undefined at index 0. ``` ![opennebula-oneprovision](https://canada1.discourse-cdn.com/flex031/uploads/opennebula/original/2X/e/e5789fb1dd235cad679987a1db830fe1003d0ca7.jpeg) ![opennebula-login](https://canada1.discourse-cdn.com/flex031/uploads/opennebula/original/2X/8/8bb4ce4f7c8851547432b64ba513d3bef0b6ebc3.png) ![opennebula-sunstone-login](https://canada1.discourse-cdn.com/flex031/uploads/opennebula/original/2X/a/a1322abf384519731537c02cf25d64bcc145de8f.png) ---
**Author:** ![DennisTait](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/dennistait/32/4330_2.png) [@DennisTait](https://forum.opennebula.io/u/DennisTait)\ **Post date:** [November 10, 2021, 1:54pm UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/5 "2021-11-10T13:54:10Z")
Hi All, My sunstone problem has gone away after another apt-update/upgrade. I can now login and use the sunstone dashboard. ---
**Author:** ![jlobo](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/jlobo/32/5955_2.png) [@jlobo](https://forum.opennebula.io/u/jlobo)\ **Post date:** [November 11, 2021, 10:56am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/6 "2021-11-11T10:56:18Z")
@DennisTait Do you have something in the ONE\_LOCATION variable? ---
**Author:** ![DennisTait](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/dennistait/32/4330_2.png) [@DennisTait](https://forum.opennebula.io/u/DennisTait)\ **Post date:** [November 11, 2021, 4:12pm UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/7 "2021-11-11T16:12:55Z")
Hi, After checking /etc/one/oned.conf I have not defined ONE\_LOCATION Looking at the following snippet I am not changing the location /etc/one/ just using the default and everything so far seems to be working fine, I can login via sunstone and oneprovision. I have not tested any of the oneprovision features available in opennebula 6.2.0 CE yet. ```auto # ******************************************************************************* # Hook Manager Configuration # ******************************************************************************* # The Driver (HM_MAD) # ----------------------------------------------- # # Used to execute the Hooks: # executable: path of the hook driver executable, can be an # absolute path or relative to $ONE_LOCATION/lib/mads (or # /usr/lib/one/mads/ if OpenNebula was installed in /) # # arguments : for the driver executable, can be an absolute path or relative # to $ONE_LOCATION/etc (or /etc/one/ if OpenNebula was installed. # in /) # ``` I can also confirm Terraform 0.3.0 also allows me to create vm’s using ini, plan, apply and destroy. I’l raise a separate ticket for terraform issue I have, when the terraform vm creation loop completes, the vm’s are running but I get an error which stops the ansible configuration scripts from running. ```auto 16:02 $ ./terraform-init-dev.sh Providers required by configuration: . ├── provider[registry.terraform.io/opennebula/opennebula] ~> 0.3.0 ├── provider[registry.terraform.io/hashicorp/local] ├── provider[registry.terraform.io/hashicorp/template] ├── provider[registry.terraform.io/hashicorp/null] └── module.core Initializing modules... Initializing the backend... Initializing provider plugins... - Reusing previous version of hashicorp/null from the dependency lock file - Reusing previous version of opennebula/opennebula from the dependency lock file - Reusing previous version of hashicorp/local from the dependency lock file - Reusing previous version of hashicorp/template from the dependency lock file - Using previously-installed hashicorp/template v2.2.0 - Using previously-installed hashicorp/null v3.1.0 - Using previously-installed opennebula/opennebula v0.3.0 - Using previously-installed hashicorp/local v2.1.0 Terraform has been successfully initialized! You may now begin working with Terraform. Try running "terraform plan" to see any changes that are required for your infrastructure. All Terraform commands should now work. If you ever set or change modules or backend configuration for Terraform, rerun this command to reinitialize your working directory. If you forget, other commands will detect it and remind you to do so if necessary ``` ---
**Author:** ![MDeblin](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/mdeblin/32/7455_2.png) [@MDeblin](https://forum.opennebula.io/u/MDeblin)\ **Post date:** [May 23, 2022, 11:52am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/9 "2022-05-23T11:52:43Z")
> [@DennisTait](#): > > After installing the 6.2 migration deb, and applyimg the onedb upgrade openenebula 6.2 came up Where can I get the migration deb? ---
**Author:** ![MDeblin](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/mdeblin/32/7455_2.png) [@MDeblin](https://forum.opennebula.io/u/MDeblin)\ **Post date:** [May 23, 2022, 11:52am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/10 "2022-05-23T11:52:47Z")
Hi All! I upgraded from opennebula 6.0 CE to 6.2 CE on debian11 and got the error “OpenNebula is not running or there was a server exception. Please check the server logs.” Searching the Internet for a solution, I found this post, wrote a letter to support, sent here =) I am using MariaDB. In /var/log/one/oned.log I found the following: Fri May 20 17:02:00 2022 [Z0][ONE][I]: Set up 50 DB connections using encoding utf8mb4 Fri May 20 17:02:00 2022 [Z0][ONE][I]: Using 10.5.15-mariadb-0+deb11u1 (100515) with: Fri May 20 17:02:00 2022 [Z0][ONE][I]: FTS enabled Fri May 20 17:02:00 2022 [Z0][ONE][I]: Checking database version. Fri May 20 17:02:00 2022 [Z0][ONE][E]: Database version mismatch ( local\_db\_versioning). Installed OpenNebula 6.2.0 (c84c3303) needs DB version ‘6.2.0’, and existing DB version is ‘6.0.0’. Fri May 20 17:02:00 2022 [Z0][ONE][E]: Use onedb to upgrade DB. How can I update the version of the opennebula database while keeping the virtual machine data in opennebula? Perhaps the best solution would be to upgrade to 6.4 CE? Thanks in advance. ---
**Author:** ![atodorov\_storpool](https://yyz1.discourse-cdn.com/flex031/user_avatar/forum.opennebula.io/atodorov_storpool/32/5327_2.png) [@atodorov\_storpool](https://forum.opennebula.io/u/atodorov_storpool)\ **Post date:** [May 23, 2022, 11:58am UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/11 "2022-05-23T11:58:31Z")
AFAIK the migration packages for opennebula 6.2 CE are not released yet. They are usually released a few weeks later as a minor update after the release of the next major version. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex031/uploads/opennebula/original/2X/1/14d66f1130b9cd292905f575da9b68a9f574dd03.png) [@system](https://forum.opennebula.io/u/system)\ **Post date:** [July 8, 2025, 3:53pm UTC](https://forum.opennebula.io/t/db-upgrade-community-6-0-0-to-6-2-0/10099/12 "2025-07-08T15:53:48Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.