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] https://gerrit.ovirt.org/#/c/58584 On Mon, Jun 6, 2016 at 9:55 AM, Eyal Edri <ee...@redhat.com> wrote: > Martin, > Maybe still related to the db issue we saw last week? > > On Mon, Jun 6, 2016 at 10:46 AM, David Caro <dc...@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" <gerr...@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" <masa...@redhat.com>, "Yevgeny Zaspitsky" < >> > yzasp...@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/534/ >> > : FAILURE >> > >> > >> http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-master_el7_merged/547/ >> > : 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/534/ >> > : SUCCESS >> > >> > >> http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged/78/ >> > : 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 <yzasp...@redhat.com> >> > Gerrit-Reviewer: Alona Kaplan <alkap...@redhat.com> >> > Gerrit-Reviewer: Jenkins CI >> > Gerrit-Reviewer: Moti Asayag <masa...@redhat.com> >> > Gerrit-Reviewer: Piotr Kliczewski <piotr.kliczew...@gmail.com> >> > Gerrit-Reviewer: Yevgeny Zaspitsky <yzasp...@redhat.com> >> > Gerrit-Reviewer: gerrit-hooks <automat...@ovirt.org> >> > Gerrit-HasComments: No >> >> > _______________________________________________ >> > Infra mailing list >> > Infra@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: dc...@redhat.com >> IRC: dcaro|dcaroest@{freenode|oftc|redhat} >> Web: www.redhat.com >> RHT Global #: 82-62605 >> >> _______________________________________________ >> Infra mailing list >> Infra@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) >
_______________________________________________ Infra mailing list Infra@ovirt.org http://lists.ovirt.org/mailman/listinfo/infra