[ovirt-devel] Ovirt upgrade job failing

[Martin Perina]

Here's fix that solves upgrade issue:

https://gerrit.ovirt.org/49319


Martin

----- Original Message -----
> From: "Michal Skrivanek" <michal.skrivanek at redhat.com>
> To: "Marek Libra" <mlibra at redhat.com>, "David Caro" <dcaro at redhat.com>
> Cc: devel at ovirt.org
> Sent: Friday, November 27, 2015 11:36:06 AM
> Subject: Re: [ovirt-devel] Ovirt upgrade job failing
> 
> 
> > On 27 Nov 2015, at 11:21, Marek Libra <mlibra at redhat.com> wrote:
> > 
> > Hi,
> > 
> > seems like backport of https://gerrit.ovirt.org/#/c/48255/
> > is adding 03_06_1930_change_cpu_name_ibm_power_8.sql which causes
> > the master's 03_06_1930_convert_hibernation_volumes_to_disks.sql not to run
> > when upgrading.
> > 
> > The 03_06_1930_convert_hibernation_volumes_to_disks.sql introduces the
> > snapshots.memory_metadata_disk_id .
> 
> Best short-term resolution is to revert the patch 48255
> It can be fixed properly later on, the bug is low severity anyway
> 
> > 
> > Marek
> > 
> > ----- Original Message -----
> >> From: "David Caro" <dcaro at redhat.com>
> >> To: devel at ovirt.org
> >> Sent: Friday, 27 November, 2015 11:08:37 AM
> >> Subject: [ovirt-devel] Ovirt upgrade job failing
> >> 
> >> 
> >> Hi!
> >> 
> >> Since yesterday morning the upgrade job from 3.6 to master [1] has been
> >> failing
> >> on applying the schema.sh, specifically:
> >> 
> >> 
> >> 2015-11-26 08:12:54 DEBUG
> >> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:941
> >> execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s',
> >> 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l',
> >> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20151126081101-884dt8.log',
> >> '-c', 'apply'] stderr:
> >> psql:/usr/share/ovirt-engine/dbscripts/create_views.sql:108: ERROR:
> >> column
> >> snapshots.memory_metadata_disk_id does not exist
> >> LINE 59:                 snapshots.memory_metadata_disk_id,
> >>                         ^
> >> FATAL: Cannot execute sql command:
> >> --file=/usr/share/ovirt-engine/dbscripts/create_views.sql
> >> 
> >> 
> >> 
> >> I see that the line was introduced by [2], though it did not fail back
> >> then
> >> (so
> >> the issue might not be there), it might also come from 3.6 branch, but I
> >> need
> >> a
> >> bit of help tracking that down from any of the db guys
> >> 
> >> This is making all the builds of that job fail, and it might be masking
> >> other
> >> errors (and giving -1 to a lot of patches).
> >> 
> >> 
> >> Thanks!
> >> 
> >> 
> >> [1]
> >> http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-3.6_el7_merged/986/
> >> [2] https://gerrit.ovirt.org/#/c/47262/
> >> 
> >> --
> >> David Caro
> >> 
> >> Red Hat S.L.
> >> Continuous Integration Engineer - EMEA ENG Virtualization R&D
> >> 
> >> Tel.: +420 532 294 605
> >> Email: dcaro at redhat.com
> >> IRC: dcaro|dcaroest@{freenode|oftc|redhat}
> >> Web: www.redhat.com
> >> RHT Global #: 82-62605
> >> 
> >> _______________________________________________
> >> Devel mailing list
> >> Devel at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/devel
> > _______________________________________________
> > Devel mailing list
> > Devel at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/devel
> 
> _______________________________________________
> Devel mailing list
> Devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>