Bug 1279444

Summary: task cleaning utility gives error : psql:./taskcleaner_sp_3_5.sql:14: ERROR: type "command_entities" does not exist
Product: Red Hat Enterprise Virtualization Manager Reporter: Gajanan <gchakkar>
Component: ovirt-engine-setupAssignee: Yedidyah Bar David <didi>
Status: CLOSED NOTABUG QA Contact: Pavel Stehlik <pstehlik>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.4.5CC: amureini, bazulay, didi, ecohen, gklein, lsurette, oourfali, rbalakri, Rhev-m-bugs, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard: integration
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-10 10:30:54 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Gajanan 2015-11-09 13:23:02 UTC 
Description of problem:

Upgrade to RHEV 3.5 failed, the engine-setup failed with below error: 

+++++++++++
[ INFO ] Stage: Setup validation
During execution engine service will be stopped (OK, Cancel) [OK]:
[ INFO ] Cleaning stale zombie tasks and commands
[ ERROR ] Failed to execute stage 'Setup validation': Failed to clear zombie commands. Please access support in attempt to resolve the problem
[ INFO ] Stage: Clean up
Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20151109135655-1ta9ju.log
[ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20151109135807-setup.conf'
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ ERROR ] Execution of setup failed
+++++++++++

When trying to : ./taskcleaner.sh it gave another error as below: 

+++++++++++
# ./taskcleaner.sh -u engine -d engine -v -z
select exists (select * from information_schema.tables where table_schema = 'public' and table_name = 'command_entities');
psql:./taskcleaner_sp_3_5.sql:14: ERROR: type "command_entities" does not exist
FATAL: Cannot execute sql command: --file=./taskcleaner_sp_3_5.sql
+++++++++++

Suspect a bug with taskcleaner.sh, the current setup is at version:  rhevm-3.4.5-0.3
Comment 3 Oved Ourfali 2015-11-10 08:23:16 UTC 
Actually, it was last touched by Didi.
Didi - can you take a look?
Comment 4 Yedidyah Bar David 2015-11-10 09:17:29 UTC 
(In reply to Oved Ourfali from comment #3)
> Actually, it was last touched by Didi.
> Didi - can you take a look?

I don't think I touched it for 3.5, only in master. Gave it a look anyway. Will give more details in a private comment.