[ovirt-users] problem while updating oVirt from 3.6 to 4.0

[Nelson Lameiras]

Hello, 

Not sure if I should post here, or on the dev mailling list. 

I had a serious problem when upgrading an oVirt cluster from 3.6 to 4.0 (before updating to 4.1) 

The error on engine-setup log was : 
"schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_00_0930_disallow_boot_protocol_to_be_null.sql" 

After long hours of debuguing and analysing I found out the problem. On database, some entries on table network_attachements had a NULL value which were incompatible with the sql file above. 
I'm guessing this is an "exotic situation" which shouldn't exist... in theory ;) 

Anyway, I'm fairly sure that the solution for this problem would be to patch the following file 'ovirt-engine/packaging/dbscripts/upgrade/04_00_0910_do_not_allow_null_boot_protocol.sql' 
by adding the following line " update network_attachments set boot_protocol = ' NONE ' where boot_protocol is null ;" 

If a dev want to discuss it further, I'll be happy to explain my thoughts on this matter. 

cordialement, regards, 


	Nelson LAMEIRAS 
Ingénieur Systèmes et Réseaux / Systems and Networks engineer 
Tel: +33 5 32 09 09 70 
nelson.lameiras at lyra-network.com 

www.lyra-network.com | www.payzen.eu 

	
	
	

Lyra Network, 109 rue de l'innovation, 31670 Labège, FRANCE 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: element-signature_logo_lyra_115x94.jpg
Type: image/jpeg
Size: 3846 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: element-signature_logo_YouTube_32x28.jpg
Type: image/jpeg
Size: 1604 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0006.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: element-signature_logo_LinkedIn_41x28.jpg
Type: image/jpeg
Size: 1635 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0007.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: element-signature_logo_Twitter_42x28.jpg
Type: image/jpeg
Size: 1629 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0008.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: element-signature_payzen_61x28.jpg
Type: image/jpeg
Size: 1864 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170511/f27fc9c9/attachment-0009.jpg>