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

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, <https://www.lyra-network.com/> Nelson LAMEIRAS Ingénieur Systèmes et Réseaux / Systems and Networks engineer Tel: +33 5 32 09 09 70 <+33%205%2032%2009%2009%2070> nelson.lameiras(a)lyra-network.com www.lyra-network.com | www.payzen.eu <https://payzen.eu> <https://www.youtube.com/channel/UCrVl1CO_Jlu3KbiRH-tQ_vA> <https://www.linkedin.com/company/lyra-network_2> <https://twitter.com/LyraNetwork> <https://payzen.eu> ------------------------------ Lyra Network, 109 rue de l'innovation, 31670 Labège, FRANCE _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users