oneadmin@one02:~$ onedb upgrade -v -u opennebula -d opennebula -p ************ Version read: Shared tables 4.6.0 : OpenNebula 4.8.0 daemon bootstrap Local tables 4.7.80 : OpenNebula 4.8.0 daemon bootstrap MySQL dump stored in /var/lib/one/mysql_localhost_opennebula_2016-11-3_13:17:24.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/4.6.0_to_4.11.80.rb > Done in 0.21s > Running migrator /usr/lib/one/ruby/onedb/shared/4.11.80_to_4.90.0.rb > Done in 0.25s > Running migrator /usr/lib/one/ruby/onedb/shared/4.90.0_to_5.2.0.rb > Done in 0.07s Database migrated from 4.6.0 to 5.2.0 (OpenNebula 5.2.0) by onedb command. >>> Running migrators for local tables > Running migrator /usr/lib/one/ruby/onedb/local/4.7.80_to_4.9.80.rb > Done in 0.48s > Running migrator /usr/lib/one/ruby/onedb/local/4.9.80_to_4.10.3.rb > Done in 0.03s > Running migrator /usr/lib/one/ruby/onedb/local/4.10.3_to_4.11.80.rb > Done in 1.01s > Running migrator /usr/lib/one/ruby/onedb/local/4.11.80_to_4.13.80.rb ************************************************************** * WARNING WARNING WARNING WARNING WARNING WARNING WARNING * ************************************************************** OpenNebula 4.13.80 improves the management of FAILED VMs Please remove (onevm delete) any FAILED VM before continuing. ************************************************************** * WARNING WARNING WARNING WARNING WARNING WARNING WARNING * ************************************************************** The scheduler (and oned) has been update to enforce access rights on system datastores. This new version also checks that the user can access the System DS. This *may require* to update system DS rights of your cloud Do you want to proceed ? [y/N]y Mysql::Error: Duplicate entry '0' for key 'PRIMARY' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:175:in `query' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:175:in `block in _execute' /usr/lib/ruby/vendor_ruby/sequel/database/logging.rb:33:in `log_yield' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:175: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/adapters/mysql.rb:160:in `execute_insert' /usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:922:in `execute_insert' /usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:335:in `insert' /usr/lib/one/ruby/onedb/local/4.11.80_to_4.13.80.rb:106:in `block (2 levels) in up' /usr/lib/ruby/vendor_ruby/sequel/dataset/actions.rb:139:in `block in each' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:312:in `block (2 levels) in fetch_rows' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:367:in `yield_rows' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:312:in `block in fetch_rows' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:177: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/mysql.rb:351:in `execute' /usr/lib/ruby/vendor_ruby/sequel/adapters/mysql.rb:296: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/4.11.80_to_4.13.80.rb:101:in `block in up' /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/4.11.80_to_4.13.80.rb:99: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:313:in `block (2 levels) in
' /usr/lib/one/ruby/cli/command_parser.rb:449:in `call' /usr/lib/one/ruby/cli/command_parser.rb:449:in `run' /usr/lib/one/ruby/cli/command_parser.rb:76:in `initialize' /usr/bin/onedb:222:in `new' /usr/bin/onedb:222:in `
' The database will be restored MySQL DB opennebula at localhost restored. oneadmin@one02:~$