Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

onedb upgrade from 5.12 -> 6.0 fails with PostgreSQL #5334

Closed
3 of 7 tasks
VMGuy opened this issue Apr 12, 2021 · 1 comment
Closed
3 of 7 tasks

onedb upgrade from 5.12 -> 6.0 fails with PostgreSQL #5334

VMGuy opened this issue Apr 12, 2021 · 1 comment

Comments

@VMGuy
Copy link

VMGuy commented Apr 12, 2021

Description
When running onedb upgrade -v -t postgresql -S localhost -u oneadmin -p <PASSWORD> -d opennebula it returns with this error on PostgreSQL:

undefined method `delete_idx' for #<BackEndPostgreSQL:0x000055cbdd5894f0>
/usr/lib/one/ruby/onedb/onedb.rb:302:in `upgrade'
...

I tried commenting this call in onedb.rb but then I hit the next error message:

PG::UndefinedObject: ERROR:  type "mediumtext" does not exist
LINE 1: ...(oid INTEGER PRIMARY KEY, name VARCHAR(128), body MEDIUMTEXT...
                                                             ^

To Reproduce
Install OpenNebula 5.12 with PostgreSQL.
Upgrade to 6.0 using opennebula-migration-community_6.0.0-2.ee_all.deb

Expected behavior
DB upgrade should work as it does with MySQL/MariaDB.

Details

  • Affected Component: onedb
  • Hypervisor: KVM
  • Version: 6.0

Progress Status

  • Branch created
  • Code committed to development branch
  • Testing - QA
  • Documentation
  • Release notes - resolved issues, compatibility, known issues
  • Code committed to upstream release/hotfix branches
  • Documentation committed to upstream release/hotfix branches
@paczerny
Copy link
Member

Fixed, the patch will be included in next release 6.0.1 for Enterprise Edition and 6.0.0.1 for Community Edition

rsmontero pushed a commit that referenced this issue Apr 26, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants