Hi,
I try to update one of my installation from 5.4.13 to 5.5.9
Versions of the related components and OS (frontend, hypervisors, VMs):
Debian 8 + KVM
Steps to reproduce:
(to update)
apt-get install -y opennebula-sunstone opennebula
Current results:
The install is OK, but the service won’t start
fooserver$ systemctl status opennebula.service
● opennebula.service - OpenNebula Cloud Controller Daemon
Loaded: loaded (/lib/systemd/system/opennebula.service; disabled)
Active: activating (auto-restart) (Result: exit-code) since Mon 2019-10-28 13:24:34 -03; 1s ago
Process: 56458 ExecStopPost=/usr/share/one/follower_cleanup (code=exited, status=0/SUCCESS)
Process: 56411 ExecStart=/usr/bin/oned -f (code=exited, status=255)
Process: 56407 ExecStartPre=/usr/sbin/logrotate -f /etc/logrotate.d/opennebula -s /var/lib/one/.logrotate.status (code=exited, status=0/SUCCESS)
Main PID: 56411 (code=exited, status=255)
Oct 28 13:24:34 au-kvm99-p systemd[1]: Failed to start OpenNebula Cloud Controller Daemon.
Oct 28 13:24:34 au-kvm99-p systemd[1]: Unit opennebula.service entered failed state.
I try to update the DB with:
onedb upgrade -v -S localhost -u oneadmin -p PASSW0RD -d opennebula
But I get:
Version read:
Shared tables 5.4.1 : Database migrated from 5.4.0 to 5.4.1 (OpenNebula 5.4.1) by onedb command.
Local tables 5.4.1 : Database migrated from 5.4.0 to 5.4.1 (OpenNebula 5.4.1) by onedb command.
MySQL dump stored in /var/lib/one/mysql_localhost_opennebula_2019-10-28_13:27:27.sql
Use 'onedb restore' or restore the DB using the mysql command:
mysql -u user -h server -P port db_name < backup_file
>>> Running migrators for shared tables
> Running migrator /usr/lib/one/ruby/onedb/shared/5.4.1_to_5.5.80.rb
> Done in 0.00s
Database migrated from 5.4.1 to 5.5.80 (OpenNebula 5.5.80) by onedb command.
>>> Running migrators for local tables
> Running migrator /usr/lib/one/ruby/onedb/local/5.4.1_to_5.5.80.rb
> Old Az file not found, skipping Az host migration
undefined method `add_child' for nil:NilClass
/usr/lib/one/ruby/onedb/local/5.4.1_to_5.5.80.rb:212:in `block (2 levels) in bug_2189'
/usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:139:in `block in each'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:159:in `block (2 levels) in fetch_rows'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:159:in `each'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:159:in `block in fetch_rows'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:90:in `_execute'
/usr/lib/ruby/vendor_ruby/sequel/adapters/shared/mysql_prepared_statements.rb:34:in `block in execute'
/usr/lib/ruby/vendor_ruby/sequel/database/connecting.rb:250:in `block in synchronize'
/usr/lib/ruby/vendor_ruby/sequel/connection_pool/threaded.rb:91:in `hold'
/usr/lib/ruby/vendor_ruby/sequel/database/connecting.rb:250:in `synchronize'
/usr/lib/ruby/vendor_ruby/sequel/adapters/shared/mysql_prepared_statements.rb:34:in `execute'
/usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:906:in `execute'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:191:in `execute'
/usr/lib/ruby/vendor_ruby/sequel/adapters/mysql2.rb:153:in `fetch_rows'
/usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:139:in `each'
/usr/lib/ruby/vendor_ruby/sequel/database/dataset.rb:46:in `fetch'
/usr/lib/one/ruby/onedb/local/5.4.1_to_5.5.80.rb:203:in `block in bug_2189'
/usr/lib/ruby/vendor_ruby/sequel/database/transactions.rb:126:in `_transaction'
/usr/lib/ruby/vendor_ruby/sequel/database/transactions.rb:100:in `block in transaction'
/usr/lib/ruby/vendor_ruby/sequel/database/connecting.rb:250:in `block in synchronize'
/usr/lib/ruby/vendor_ruby/sequel/connection_pool/threaded.rb:104:in `hold'
/usr/lib/ruby/vendor_ruby/sequel/database/connecting.rb:250:in `synchronize'
/usr/lib/ruby/vendor_ruby/sequel/database/transactions.rb:89:in `transaction'
/usr/lib/one/ruby/onedb/local/5.4.1_to_5.5.80.rb:202:in `bug_2189'
/usr/lib/one/ruby/onedb/local/5.4.1_to_5.5.80.rb:40:in `up'
/usr/lib/one/ruby/onedb/onedb.rb:232:in `apply_migrators'
/usr/lib/one/ruby/onedb/onedb.rb:179:in `upgrade'
/usr/bin/onedb:389:in `block (2 levels) in <main>'
/usr/lib/one/ruby/cli/command_parser.rb:457:in `call'
/usr/lib/one/ruby/cli/command_parser.rb:457:in `run'
/usr/lib/one/ruby/cli/command_parser.rb:84:in `initialize'
/usr/bin/onedb:294:in `new'
/usr/bin/onedb:294:in `<main>'
The database will be restored
MySQL DB opennebula at localhost restored.
Expected results:
Start without problem after update.
Any help are welcomed.
Cheers