No it's not, this is some strange failure in 3.5 upgrade script which seems
to me impossible. The patch [1] didn't contain any db related stuff, so
upgrade from master before this patch to master with this patch shouldn't
fail (and I just verified locally that this upgrade works fine). So I
assume this was some kind of mess in db content prior the upgrade job.
Martin
[1]
Martin,
Maybe still related to the db issue we saw last week?
On Mon, Jun 6, 2016 at 10:46 AM, David Caro <dcaro(a)redhat.com> wrote:
> On 06/06 00:37, Yevgeny Zaspitsky wrote:
> > Below are the details of one my patches that failed in CI.
> > How surprising the fact that it failed with two different reasons and
> both
> > aren't patch related!
> > ---------- Forwarded message ----------
> > From: "Jenkins CI" <gerrit2(a)gerrit.ovirt.org>
> > Date: Jun 5, 2016 11:37 PM
> > Subject: Change in ovirt-engine[master]: core: update vdsm-jsonrpc-java
> to
> > verion 1.2.3
> > To: "Moti Asayag" <masayag(a)redhat.com>, "Yevgeny
Zaspitsky" <
> > yzaspits(a)redhat.com>
> > Cc:
> >
> > Jenkins CI has posted comments on this change.
> >
> > Change subject: core: update vdsm-jsonrpc-java to verion 1.2.3
> > ......................................................................
> >
> >
> > Patch Set 2:
> >
> > Build Failed
> >
> >
>
http://jenkins.ovirt.org/job/ovirt-engine_master_check-merged-el7-x86_64/...
> > : FAILURE
> >
> >
>
http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-master_el7_...
> > : FAILURE
>
> This one looks like a real issue:
>
>
>
> 2016-06-05 20:29:27 DEBUG
> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:926
> 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-20160605202840-w8dvo1.log',
> '-c', 'apply'] stderr:
>
psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0580_add_default_instance_types.sql:131:
> ERROR: duplicate key value violates unique constraint "pk_permissions_id"
> DETAIL: Key (id)=(00000004-0004-0004-0004-000000000355) already exists.
> CONTEXT: SQL statement "INSERT INTO permissions(id,
> role_id,
> ad_element_id,
> object_id,
> object_type_id)
> SELECT uuid_generate_v1(),
> 'DEF00009-0000-0000-0000-DEF000000009', --
> UserTemplateBasedVm
> 'EEE00000-0000-0000-0000-**FILTERED**789EEE', -- Everyone
> v_instance_type_id,
> 4 -- template"
> PL/pgSQL function do_insert_instance_type(character varying,character
> varying,integer,integer,integer) line 93 at SQL statement
> SQL statement "SELECT do_insert_instance_type('Tiny', 'Tiny
instance
> type', 512, 1, 1)"
> PL/pgSQL function insert_default_instance_types() line 5 at PERFORM
> FATAL: Cannot execute sql command:
>
--file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0580_add_default_instance_types.sql
>
>
> Does not seem related to your patch though.
>
> >
> >
>
http://jenkins.ovirt.org/job/ovirt-engine_master_check-merged-fc23-x86_64...
> > : SUCCESS
> >
> >
>
http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_mer...
> > : SUCCESS
> >
> > --
> > To view, visit
https://gerrit.ovirt.org/58584
> > To unsubscribe, visit
https://gerrit.ovirt.org/settings
> >
> > Gerrit-MessageType: comment
> > Gerrit-Change-Id: Iae15520c831c0b8de36169f0287057684033d376
> > Gerrit-PatchSet: 2
> > Gerrit-Project: ovirt-engine
> > Gerrit-Branch: master
> > Gerrit-Owner: Yevgeny Zaspitsky <yzaspits(a)redhat.com>
> > Gerrit-Reviewer: Alona Kaplan <alkaplan(a)redhat.com>
> > Gerrit-Reviewer: Jenkins CI
> > Gerrit-Reviewer: Moti Asayag <masayag(a)redhat.com>
> > Gerrit-Reviewer: Piotr Kliczewski <piotr.kliczewski(a)gmail.com>
> > Gerrit-Reviewer: Yevgeny Zaspitsky <yzaspits(a)redhat.com>
> > Gerrit-Reviewer: gerrit-hooks <automation(a)ovirt.org>
> > Gerrit-HasComments: No
>
> > _______________________________________________
> > Infra mailing list
> > Infra(a)ovirt.org
> >
http://lists.ovirt.org/mailman/listinfo/infra
>
>
> --
> David Caro
>
> Red Hat S.L.
> Continuous Integration Engineer - EMEA ENG Virtualization R&D
>
> Tel.: +420 532 294 605
> Email: dcaro(a)redhat.com
> IRC: dcaro|dcaroest@{freenode|oftc|redhat}
> Web:
www.redhat.com
> RHT Global #: 82-62605
>
> _______________________________________________
> Infra mailing list
> Infra(a)ovirt.org
>
http://lists.ovirt.org/mailman/listinfo/infra
>
>
--
Eyal Edri
Associate Manager
RHEV DevOps
EMEA ENG Virtualization R&D
Red Hat Israel
phone: +972-9-7692018
irc: eedri (on #tlv #rhev-dev #rhev-integ)