Friday, August 31, 2018

Clean up hanging/stuck ambari background operations manually



login ambari database and find out tasking ID required to clean up:

select task_id,role,role_command from host_role_command where status='IN_PROGRESS';
select task_id,role,role_command from host_role_command where status='QUEUED';
select task_id,role,role_command from host_role_command where status='PENDING';

update identified task_id to aborted status:

update host_role_command set status='ABORTED' where task_id in (264,266);



17 comments:

  1. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. https://www.markedcardspoker.com/marked-cards-tricks.shtml

    ReplyDelete
  2. I think this is a really good article. You make this information interesting and engaging. You give readers a lot to think about and I appreciate that kind of writing. Digital Marketing Sydney

    ReplyDelete
  3. It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. dungeons and dragons dice

    ReplyDelete
  4. I am definitely enjoying your website. You definitely have some great insight and great stories. dice for dungeons and dragons

    ReplyDelete
  5. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also zeppe emanuelle vee

    ReplyDelete
  6. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. company formation in dubai

    ReplyDelete
  7. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. Casino Blog

    ReplyDelete
  8. Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. poker qq

    ReplyDelete
  9. I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy. แทงบอลออนไลน์

    ReplyDelete
  10. I really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best! real instagram likes uk

    ReplyDelete
  11. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. click here

    ReplyDelete
  12. I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. rengøring

    ReplyDelete
  13. Excellent post. I was always checking this blog, and I’m impressed! Extremely useful info specially the last part, I care for such information a lot. I was exploring this particular info for a long time. Thanks to this blog my exploration has ended. PU release agent manufacturer in China

    ReplyDelete
  14. Enjoyed every single word of your blog article. Thanks to share it!

    hitachi 1.5 ton 3 star split inverter ac

    ReplyDelete
  15. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. Asheville Maids

    ReplyDelete
  16. The individuals who have their tiles cleaned will see this slender white substance between the tile joints all the more unmistakably.office cleaner melbourne

    ReplyDelete
  17. Very neat article. Really looking forward to read more. Fantastic.
    https://guttercleaningclacton.co.uk/

    ReplyDelete