How to remove lots of sqlline process - Drill

Document created by rsingh on Feb 13, 2016
Version 1Show Document
  • View in full screen mode

Author: Rajkumar Singh

 

Original Publication Date: May 3, 2015

 

Env:

M5/M7

Drill-0.8

 

Goal:

sqlline is a jdbc client to connect to the drill, user can see many sqlline process running on the node if he wont exit sqlline cleanly.

 

[mapr@hostname bin]$ jps

26644 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

26034 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

8259 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

14107 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

10200 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

7560 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

6630 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

3606 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

16198 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

14307 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

26689 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

18529 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

1651 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

2332 SqlLine -Dlog.path=/opt/mapr/drill/drill-0.7.0/logs/sqlline.log -Xms1G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf -Dzookeeper.sasl.client=false

Solution:

Use !quit instead of crtl+z or crtl+d.

for hung sqlline process use kill -9 to kill the sqlline process.

Attachments

    Outcomes