Bug 1425705

Summary: taskcleaner.sh fails on non existing columns in command_entities table
Product: [oVirt] ovirt-engine Reporter: Fred Rolland <frolland>
Component: BLL.InfraAssignee: Fred Rolland <frolland>
Status: CLOSED CURRENTRELEASE QA Contact: Petr Matyáš <pmatyas>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 4.1.0CC: bugs, mperina
Target Milestone: ovirt-4.1.1Flags: rule-engine: ovirt-4.1+
pstehlik: testing_ack+
Target Release: 4.1.1.3   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-04-21 09:49:02 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Fred Rolland 2017-02-22 07:50:26 UTC
Description of problem:


Version-Release number of selected component (if applicable):
4.1

How reproducible:
100$

Steps to Reproduce:
1. run:
PGPASSWORD=engine $HOME/ovirt-engine/share/ovirt-engine/setup/dbutils/taskcleaner.sh -T -u engine -d engine


Actual results:

 t
ERROR:  column "job_id" does not exist
LINE 1: ...created_at,status,return_value,return_value_class,job_id,ste...
                                                             ^
FATAL: Cannot execute sql command: --command=SELECT command_id,command_type,root_command_id,command_parameters,command_params_class,created_at,status,return_value,return_value_class,job_id,step_id,executed FROM GetAllCommandsWithRunningTasks();

Expected results:
Return the running tasks
t
 62278f90-7730-498e-81c5-57914aaaaaa8 |          225 | 6b2fed39-6476-40d4-8ff9-338e1e7fb14f | {                                                                                 +| org.ovirt.e
ngine.core.common.action.MoveOrCopyImageGroupParameters | 2017-02-22 09:48:31.03851+02 | ACTIVE | {                                                                     +| org.ovirt.engine.co
re.common.action.VdcReturnValueBase | t



Additional info:

Comment 1 Petr Matyáš 2017-03-29 11:38:10 UTC
Verified on 4.1.1-7