Bug 1279444 - task cleaning utility gives error : psql:./taskcleaner_sp_3_5.sql:14: ERROR: type "command_entities" does not exist
Summary: task cleaning utility gives error : psql:./taskcleaner_sp_3_5.sql:14: ERROR: ...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-setup
Version: 3.4.5
Hardware: All
OS: Linux
unspecified
high
Target Milestone: ---
: ---
Assignee: Yedidyah Bar David
QA Contact: Pavel Stehlik
URL:
Whiteboard: integration
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-11-09 13:23 UTC by Gajanan
Modified: 2019-08-15 05:52 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-11-10 10:30:54 UTC
oVirt Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.