[ovirt-devel] Upgrade job is failing while upgrading from 3.4.4 to 3.5.2-snapshot:

[Yair Zaslavsky]

----- Original Message -----
> From: "Eli Mesika" <emesika at redhat.com>
> To: "Yedidyah Bar David" <didi at redhat.com>
> Cc: devel at ovirt.org, "Yair Zaslavsky" <yzaslavs at redhat.com>, "infra" <infra at ovirt.org>, "Sandro Bonazzola"
> <sbonazzo at redhat.com>
> Sent: Wednesday, January 28, 2015 3:56:56 PM
> Subject: Re: [ovirt-devel] Upgrade job is failing while upgrading from 3.4.4 to	3.5.2-snapshot:
> 
> I had succeeded to do the upgrade manually without any problem
> This seems to be related to the engine-setup when it calls the task cleaner
> SPs
> 
> Didi, can you have a look ?

Hi all,
The stored procedures do not run an INFORMATION_SCHEMA based code that checks if command_entities exists or not.
This part is done in taskcleaner.sh script , see -

http://gerrit.ovirt.org/#/c/36880/2/packaging/setup/dbutils/taskcleaner_sp.sql

However, it seems this is not enough, and the information_check should be done in all places in SPs that include functions that are common to 3.4 and 3.5 and relate to command_entities.
I will handle that.





> 
> ----- Original Message -----
> > From: "Sandro Bonazzola" <sbonazzo at redhat.com>
> > To: "Eli Mesika" <emesika at redhat.com>
> > Cc: devel at ovirt.org, "Yair Zaslavsky" <yzaslavs at redhat.com>, "infra"
> > <infra at ovirt.org>
> > Sent: Wednesday, January 28, 2015 2:09:31 PM
> > Subject: Re: [ovirt-devel] Upgrade job is failing while upgrading from
> > 3.4.4 to	3.5.2-snapshot:
> > 
> > Il 28/01/2015 14:05, Eli Mesika ha scritto:
> > > 
> > > 
> > > ----- Original Message -----
> > >> From: "Sandro Bonazzola" <sbonazzo at redhat.com>
> > >> To: devel at ovirt.org, "Yair Zaslavsky" <yzaslavs at redhat.com>, "infra"
> > >> <infra at ovirt.org>
> > >> Sent: Tuesday, January 27, 2015 5:54:24 PM
> > >> Subject: [ovirt-devel] Upgrade job is failing while upgrading from 3.4.4
> > >> to	3.5.2-snapshot:
> > >>
> > >> Upgrade job is failing while upgrading from 3.4.4 to 3.5.2-snapshot:
> > > 
> > > Sandro , please specify which git tags/commit hash matches the above so I
> > > can reproduce
> > 
> > 3.4.4 is from ovirt-3.4 repository, corresponding to the 3.4.4 tag.
> > 3.5.2-snapshot was at 652a8ef4c1a09ab98a6ca2783eaa74bf01be2cf1.
> > 
> > 
> > > 
> > > Thanks
> > > 
> > >>
> > >> 2015-01-27 15:02:46 DEBUG
> > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.upgrade.asynctasks
> > >> plugin.execute:866 execute-output:
> > >> ('/usr/share/ovirt-engine/setup/dbutils/taskcleaner.sh', '-l',
> > >> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20150127150216-p4ixpj.log',
> > >> '-u',
> > >> 'engine', '-s', 'localhost', '-p', '5432', '-d', 'engine', '-R', '-A',
> > >> '-J',
> > >> '-q') stderr:
> > >> psql:/usr/share/ovirt-engine/setup/dbutils/taskcleaner_sp.sql:145:
> > >> ERROR:
> > >> type "command_entities" does not exist
> > >> FATAL: Cannot execute sql command:
> > >> --file=/usr/share/ovirt-engine/setup/dbutils/taskcleaner_sp.sql
> > >>
> > >> 2015-01-27 15:02:46 DEBUG otopi.context context._executeMethod:152
> > >> method
> > >> exception
> > >> Traceback (most recent call last):
> > >>   File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in
> > >>   _executeMethod
> > >>     method['method']()
> > >>   File
> > >>   "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/asynctasks.py",
> > >>   line 422, in _validateZombies
> > >>     self._clearZombieTasks()
> > >>   File
> > >>   "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/upgrade/asynctasks.py",
> > >>   line 156, in _clearZombieTasks
> > >>     'Failed to clear zombie tasks. Please access support '
> > >> RuntimeError: Failed to clear zombie tasks. Please access support in
> > >> attempt
> > >> to resolve the problem
> > >> 2015-01-27 15:02:46 ERROR otopi.context context._executeMethod:161
> > >> Failed
> > >> to
> > >> execute stage 'Setup validation': Failed to clear zombie tasks. Please
> > >> access support in attempt to resolve the problem
> > >>
> > >> Please fix ASAP.
> > >>
> > >> Reference:
> > >> http://jenkins.ovirt.org/job/ovirt-engine_3.5_upgrade-from-3.4_merged/label=el6/1360/
> > >>
> > >>
> > >> --
> > >> Sandro Bonazzola
> > >> Better technology. Faster innovation. Powered by community
> > >> collaboration.
> > >> See how it works at redhat.com
> > >> _______________________________________________
> > >> Devel mailing list
> > >> Devel at ovirt.org
> > >> http://lists.ovirt.org/mailman/listinfo/devel
> > >>
> > 
> > 
> > --
> > Sandro Bonazzola
> > Better technology. Faster innovation. Powered by community collaboration.
> > See how it works at redhat.com
> > 
>