Friday, June 3, 2016

Drillbit Health Check script

Goal:

If drillbit gets hung, and queries may get stuck on that drillbit, this script can help you quickly do the health check for each drillbit.
Basically It will connect to each drillbit using JDBC and run a simple query.
If the script get stuck when connecting to one drillbit,  we need to troubleshoot by collecting jstack output and drillbit.log.

Solution:

Here is the source code for this script:
https://github.com/viadea/DrillRelated

Compile:

javac HealthCheck.java

Usage:

java -cp /opt/mapr/drill/drill-1.4.0/jars/jdbc-driver/drill-jdbc-all-1.4.0.jar:. HealthCheck <username> <password> <Initial_Host> <Drill_Port>
Default values for username and password are: mapr/mapr
Default value for Initial_Host is : localhost
Default value for Drill_Port is: 31010

Example:

# java -cp /opt/mapr/drill/drill-1.4.0/jars/jdbc-driver/drill-jdbc-all-1.4.0.jar:. HealthCheck

Step 1. Creating Drill Connection to : jdbc:drill:drillbit=localhost:31010
Step 2. Fetching all drillbits
Connecting to v2.poc.com:31010
Successful!
Connecting to v3.poc.com:31010
Successful!
Connecting to v4.poc.com:31010
Successful!
Connecting to v1.poc.com:31010
Successful!

Note: if this script gets stuck on one of the drillbits, before shutting down that drillbit, please remember to take jstack output for further RCA.
After shutting down that problematic drillbit, then re-run this script until every drillbit is working fine.

8 comments:

  1. Do you need buy clenbuterol? You are at the right place - topsteroids.com! buy clenbuterol to your home online fast and secure. Fast shippping. clenbuterol for sale

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Excellent information on your blog, thank you for taking the time to share with us. Amazing insight you have on this, it's nice to find a website that details so much information about different artists. Customer survey

    ReplyDelete
  4. Inversion therapy using an inversion table is a non-surgical ... therapy is not for the novice—it's best for people who are in superb health and ... to stretch muscles and ligaments, reduce muscle spasms, and improve circulation best inversion table for sciatica

    ReplyDelete
  5. Community health organizations across the nation will be posting their events under state listings on the National Association of Community Health Centers Week Events Map and attending any of these events gives you the chance to be part of something unique. Health N Fitness Vigilante Blog

    ReplyDelete
  6. I'd like to take the power of thanking you for that specialized guidance I've constantly enjoyed viewing your blog. https://aiclegal.org/what-you-should-know-before-choosing-a-penis-extender/

    ReplyDelete
  7. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. keto diet weight loss

    ReplyDelete
  8. I will span a wide variety of topics all designed to provide practical steps toward achieving the best state of health that you can achieve.Living Well Counselling Calgary

    ReplyDelete

Popular Posts