[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 Tel.: +420 532 294 605 Email: dc...@redhat.com IRC: dcaro|dcaroest@{freenode|oftc|redhat} Web: www.redhat.com RHT Global #: 82-62605 signature.asc Description: PGP signature ___ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
Re: [ovirt-devel] Ovirt upgrade job failing
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 . Marek - Original Message - > From: "David Caro" <dc...@redhat.com> > To: devel@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 > > Tel.: +420 532 294 605 > Email: dc...@redhat.com > IRC: dcaro|dcaroest@{freenode|oftc|redhat} > Web: www.redhat.com > RHT Global #: 82-62605 > > ___ > Devel mailing list > Devel@ovirt.org > http://lists.ovirt.org/mailman/listinfo/devel ___ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
Re: [ovirt-devel] Ovirt upgrade job failing
> On 27 Nov 2015, at 11:21, Marek Libra <mli...@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" <dc...@redhat.com> >> To: devel@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 >> >> Tel.: +420 532 294 605 >> Email: dc...@redhat.com >> IRC: dcaro|dcaroest@{freenode|oftc|redhat} >> Web: www.redhat.com >> RHT Global #: 82-62605 >> >> ___ >> Devel mailing list >> Devel@ovirt.org >> http://lists.ovirt.org/mailman/listinfo/devel > ___ > Devel mailing list > Devel@ovirt.org > http://lists.ovirt.org/mailman/listinfo/devel ___ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel