taskcleaner.sh displays many errors when executed.

Solution Verified - Updated -

Issue

When running taskcleaner.sh against a RHEV database, many errors are displayed:

# ./taskcleaner.sh -z -R -J -A
psql:./taskcleaner_sp.sql:19: ERROR:  must be owner of function getasynctaskszombies
psql:./taskcleaner_sp.sql:28: ERROR:  must be owner of function deleteasynctaskzombiesbytaskid
psql:./taskcleaner_sp.sql:37: ERROR:  must be owner of function deleteasynctaskzombiesbycommandid
psql:./taskcleaner_sp.sql:44: ERROR:  must be owner of function deleteasynctaskbycommandid
psql:./taskcleaner_sp.sql:51: ERROR:  must be owner of function deleteasynctaskszombies
psql:./taskcleaner_sp.sql:58: ERROR:  must be owner of function deletejobstepsbytaskid
psql:./taskcleaner_sp.sql:68: ERROR:  must be owner of function deleteentitysnapshotbyzombietaskid
psql:./taskcleaner_sp.sql:78: ERROR:  must be owner of function deleteentitysnapshotbytaskid
psql:./taskcleaner_sp.sql:85: ERROR:  must be owner of function deleteentitysnapshotzombies
psql:./taskcleaner_sp.sql:92: ERROR:  must be owner of function deletejobstepsbyzombiecommandid
psql:./taskcleaner_sp.sql:99: ERROR:  must be owner of function deletejobstepsbycommandid
psql:./taskcleaner_sp.sql:106: ERROR:  must be owner of function deletejobstepszombies
psql:./taskcleaner_sp.sql:113: ERROR:  must be owner of function deletealljobs
psql:./taskcleaner_sp.sql:120: ERROR:  must be owner of function deleteallentitysnapshot
 This will remove all Zombie Tasks in async_tasks table, and all Job Steps and Compensation data!!! 
Caution, this operation should be used with care. Please contact support prior to running this command
Are you sure you want to proceed? [y/n]

Environment

  • Red Hat Enterprise Virtualization (RHEV) 3.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content