{"id":31,"date":"2018-10-25T14:14:58","date_gmt":"2018-10-25T21:14:58","guid":{"rendered":"https:\/\/angrysysadmins.tech\/?p=31"},"modified":"2019-02-26T03:49:37","modified_gmt":"2019-02-26T11:49:37","slug":"ovirt-stop-all-running-tasks","status":"publish","type":"post","link":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/","title":{"rendered":"oVirt: Stop all running tasks"},"content":{"rendered":"\n

So you know what makes me angry? Tasks that won’t stop running. This happened to me at work and it infuriated me. I had to go though mailing lists to figure it out, but here is the solution.

SSH into ovirt-engine as root, then run:<\/p>\n\n\n\n

su postgres
psql -d engine -U postgres
select * from job order by start_time desc;<\/pre>\n\n\n\n
This group of commands switches us to the postgres user, allowing access to the oVirt database. Then we access said database and list all the columns and rows in the job table.

Grab the job_id for the task you want to delete, then use the DeleteJob procedure:<\/p>\n\n\n\n
select DeleteJob('UUID_HERE');<\/pre>\n\n\n\n
For example:<\/p>\n\n\n\n
select DeleteJob('8424f7a9-2a4c-4567-b528-45bbc1c2534f');<\/pre>\n\n\n\n
Give the web GUI a minute or so to catch up with you. The tasks should be gone. If it is still running, make sure the UUID was correct.

If when you try and run psql<\/code> you get command not found<\/code>, try using this after switching to the postgres user:

<\/p>\n\n\n\n
scl enable rh-postgresql10 \"psql -d engine -U postgres\"<\/pre>\n\n\n\n

And then picking up at the select command. 
<\/p>\n","protected":false},"excerpt":{"rendered":"
So you know what makes me angry? Tasks that won’t stop running. This happened to me at work and it infuriated me. I had to go though mailing lists to figure it out, but here is the solution. SSH into ovirt-engine as root, then run: su postgrespsql -d engine -U postgresselect * from job order 
Read More »<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,21,22],"tags":[20,17,19,18],"coauthors":[39],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-linux","category-ovirt","category-virtualization","tag-databases","tag-ovirt","tag-postgresql","tag-virtualization"],"yoast_head":"\noVirt: Stop all running tasks - Angry Sysadmins<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"oVirt: Stop all running tasks - Angry Sysadmins\" \/>\n<meta property=\"og:description\" content=\"So you know what makes me angry? Tasks that won’t stop running. This happened to me at work and it infuriated me. I had to go though mailing lists to figure it out, but here is the solution. SSH into ovirt-engine as root, then run: su postgrespsql -d engine -U postgresselect * from job order Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/\" \/>\n<meta property=\"og:site_name\" content=\"Angry Sysadmins\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-25T21:14:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-26T11:49:37+00:00\" \/>\n<meta name=\"author\" content=\"Ryan Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ryan Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/\"},\"author\":{\"name\":\"Ryan Parker\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/#\\\/schema\\\/person\\\/651321cd35645fb6a4d8a75b7bc7c199\"},\"headline\":\"oVirt: Stop all running tasks\",\"datePublished\":\"2018-10-25T21:14:58+00:00\",\"dateModified\":\"2019-02-26T11:49:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/\"},\"wordCount\":155,\"commentCount\":2,\"keywords\":[\"Databases\",\"Ovirt\",\"PostgreSQL\",\"Virtualization\"],\"articleSection\":[\"Linux\",\"oVirt\",\"Virtualization\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/\",\"url\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/\",\"name\":\"oVirt: Stop all running tasks - Angry Sysadmins\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/#website\"},\"datePublished\":\"2018-10-25T21:14:58+00:00\",\"dateModified\":\"2019-02-26T11:49:37+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/#\\\/schema\\\/person\\\/651321cd35645fb6a4d8a75b7bc7c199\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/2018\\\/10\\\/grassyloki\\\/ovirt-stop-all-running-tasks\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/angrysysadmins.tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"oVirt: Stop all running tasks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/#website\",\"url\":\"https:\\\/\\\/angrysysadmins.tech\\\/\",\"name\":\"Angry Sysadmins\",\"description\":\"A site full of angry sysadmins here to vent and help\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/angrysysadmins.tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/angrysysadmins.tech\\\/#\\\/schema\\\/person\\\/651321cd35645fb6a4d8a75b7bc7c199\",\"name\":\"Ryan Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g664d0e05248e51cb1d71b3f66c6f929d\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g\",\"caption\":\"Ryan Parker\"},\"description\":\"Professionally im a Infrastructure Security Specialist. I current maintain a homelab with about 3TB of RAM, 240+ TB of storage, tons of CPU cores, and 100gbit networking backbone in the garage running up my electricity bill.\",\"url\":\"https:\\\/\\\/angrysysadmins.tech\\\/index.php\\\/author\\\/grassyloki\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"oVirt: Stop all running tasks - Angry Sysadmins","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/","og_locale":"en_US","og_type":"article","og_title":"oVirt: Stop all running tasks - Angry Sysadmins","og_description":"So you know what makes me angry? Tasks that won’t stop running. This happened to me at work and it infuriated me. I had to go though mailing lists to figure it out, but here is the solution. SSH into ovirt-engine as root, then run: su postgrespsql -d engine -U postgresselect * from job order Read More »","og_url":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/","og_site_name":"Angry Sysadmins","article_published_time":"2018-10-25T21:14:58+00:00","article_modified_time":"2019-02-26T11:49:37+00:00","author":"Ryan Parker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ryan Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/#article","isPartOf":{"@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/"},"author":{"name":"Ryan Parker","@id":"https:\/\/angrysysadmins.tech\/#\/schema\/person\/651321cd35645fb6a4d8a75b7bc7c199"},"headline":"oVirt: Stop all running tasks","datePublished":"2018-10-25T21:14:58+00:00","dateModified":"2019-02-26T11:49:37+00:00","mainEntityOfPage":{"@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/"},"wordCount":155,"commentCount":2,"keywords":["Databases","Ovirt","PostgreSQL","Virtualization"],"articleSection":["Linux","oVirt","Virtualization"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/","url":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/","name":"oVirt: Stop all running tasks - Angry Sysadmins","isPartOf":{"@id":"https:\/\/angrysysadmins.tech\/#website"},"datePublished":"2018-10-25T21:14:58+00:00","dateModified":"2019-02-26T11:49:37+00:00","author":{"@id":"https:\/\/angrysysadmins.tech\/#\/schema\/person\/651321cd35645fb6a4d8a75b7bc7c199"},"breadcrumb":{"@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/angrysysadmins.tech\/index.php\/2018\/10\/grassyloki\/ovirt-stop-all-running-tasks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/angrysysadmins.tech\/"},{"@type":"ListItem","position":2,"name":"oVirt: Stop all running tasks"}]},{"@type":"WebSite","@id":"https:\/\/angrysysadmins.tech\/#website","url":"https:\/\/angrysysadmins.tech\/","name":"Angry Sysadmins","description":"A site full of angry sysadmins here to vent and help","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/angrysysadmins.tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/angrysysadmins.tech\/#\/schema\/person\/651321cd35645fb6a4d8a75b7bc7c199","name":"Ryan Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g664d0e05248e51cb1d71b3f66c6f929d","url":"https:\/\/secure.gravatar.com\/avatar\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc12b1a02765c8017062ee6f41eb34a7b14575bcd8acd7da40e176fe8f12b10f?s=96&d=mm&r=g","caption":"Ryan Parker"},"description":"Professionally im a Infrastructure Security Specialist. I current maintain a homelab with about 3TB of RAM, 240+ TB of storage, tons of CPU cores, and 100gbit networking backbone in the garage running up my electricity bill.","url":"https:\/\/angrysysadmins.tech\/index.php\/author\/grassyloki\/"}]}},"_links":{"self":[{"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":7,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":418,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/posts\/31\/revisions\/418"}],"wp:attachment":[{"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/tags?post=31"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/angrysysadmins.tech\/index.php\/wp-json\/wp\/v2\/coauthors?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}