[one-users] Migration issue(s) from 3.7 to 4.2

[Federico Zani]

Hi,
   I am experiencing some issues after the update from 3.7 to 4.2 
(frontend on a CentOS 6.4 and hosts with KVM virt manager), this is what 
I did :

  - Stopped one and sunstone and backed up /etc/one
  - yum localinstall opennebula-4.2.0-1.x86_64.rpm 
opennebula-java-4.2.0-1.x86_64.rpm opennebula-ruby-4.2.0-1.x86_64.rpm 
opennebula-server-4.2.0-1.x86_64.rpm opennebula-sunstone-4.2.0-1.x86_64.rpm
  - duplicated im and vmm for kvm mads as specified here 
http://opennebula.org/documentation:archives:rel4.0:upgrade#driver_names
  - checked for other mismatch in one.conf but actually I found nothing 
to be fixed
  - onedb upgrade -v --sqlite /var/lib/one/one.db (no errors, just a few 
warning about manual fixes needed - that I did)
  - moved vm description files from /var/lib/one/[0-9]* to 
/var/lib/one/vms/

Then I tried to fsck the sqlite db but got the following error :
--------------
onedb fsck -f -v -s /var/lib/one/one.db
Version read:
4.2.0 : Database migrated from 3.7.80 to 4.2.0 (OpenNebula 4.2.0) by 
onedb command.

Sqlite database backup stored in /var/lib/one/one.db.bck
Use 'onedb restore' or copy the file back to restore the DB.
   > Running fsck

Datastore 0 is missing fom Cluster 101 datastore id list
Image 127 is missing fom Datastore 101 image id list
undefined method `elements' for nil:NilClass
Error running fsck version 4.2.0
The database will be restored
Sqlite database backup restored in /var/lib/one/one.db
-----------

I also tried to reinstall ruby gems with /usr/share/one/install_gems but 
still got the same issue.

After a few searching, I  tried to start one and sunstone-server anyway, 
and this is the result :
  - I can do "onevm list" and "onehost list" correctly
  - When I do a "onevm show" on a terminated vm it shows me the correct 
information
  - When I do a "onevm show" (on a running vm) or "onehost show", it 
returns a "[VirtualMachineInfo] Error getting virtual machine [312]." or 
either "[HostInfo] Error getting host [30]."

In the log file (/var/log/oned.log) I can see the following errors, when 
issuing those commands :
----------
Tue Aug  6 12:49:40 2013 [ONE][E]: SQL command was: SELECT body FROM 
host_pool WHERE oid = 30, error: callback requested query abort
Tue Aug  6 12:49:40 2013 [ONE][E]: SQL command was: SELECT body FROM 
vm_pool WHERE oid = 312, error: callback requested query abort
------------

I am still able to see datastores informations and the overall situation 
of my private cloud through the sunstone dashboard, but it seems I 
cannot access informations related to running vms and hosts: it leads to 
an unusable private cloud (can't stop vms, can't run a new one, etc...)

Any clues ?

Federico.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130808/7f2d8414/attachment.htm>