Ovirt upgrade job failing
--7JfCtLOvnd9MIVvH Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi! Since yesterday morning the upgrade job from 3.6 to master [1] has been fai= ling 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/dbscrip= ts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engi= ne', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20151126081101-8= 84dt8.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=3D/usr/share/ovirt-engine/dbscrip= ts/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 ne= ed 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 oth= er errors (and giving -1 to a lot of patches). Thanks! [1] http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-3.6_el7_m= erged/986/ [2] https://gerrit.ovirt.org/#/c/47262/ --=20 David Caro Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D Tel.: +420 532 294 605 Email: dcaro@redhat.com IRC: dcaro|dcaroest@{freenode|oftc|redhat} Web: www.redhat.com RHT Global #: 82-62605 --7JfCtLOvnd9MIVvH Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQEcBAEBAgAGBQJWWCulAAoJEEBxx+HSYmnDEZoH/jf2irBeWjodBz0P92j/jR5N augKMd7fXE86swmrb3lhYvKit/+/hIhLNeQ8vlI1SC/IM47n4KZLGeXtVpRsE5Q5 ds2RVlDc0aCrsbZxrzw2FoaZpM7zxp+3z5ggJc+R0cOLsgDZ1EKkmL65xxe9xyvH 9XSO/vnvpKIy+U5vtDkv3XY27y114hvacqRtQVN1tvWHgfri+0RuVh8+AW9fXH/8 +PNQaYuhwrhryawxALxNqFrSzL/b3IAI0Jy2GRsvLlEPXmgPdrnSWjKEIAB1v3Ah mOFBxEVKfiU7Vf3Dk0mqAZ7lJun972lA67+p2Hedstf0iX3ODtizQXqJwu5ehQ4= =ElTZ -----END PGP SIGNATURE----- --7JfCtLOvnd9MIVvH--
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" <dcaro@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... [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@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
On 27 Nov 2015, at 11:21, Marek Libra <mlibra@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@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... [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@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
Here's fix that solves upgrade issue: https://gerrit.ovirt.org/49319 Martin ----- Original Message -----
From: "Michal Skrivanek" <michal.skrivanek@redhat.com> To: "Marek Libra" <mlibra@redhat.com>, "David Caro" <dcaro@redhat.com> Cc: devel@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@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@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... [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@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
participants (4)
-
David Caro -
Marek Libra -
Martin Perina -
Michal Skrivanek