drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Minnow Noir <minnown...@gmail.com>
Subject Drill 0.9 slowness/hanging
Date Mon, 11 May 2015 22:53:47 GMT
Experiencing some slowness after upgrading one of our servers from 0.8 to
0.9.  In particular, despite restarting the Drillbit, and even the server,
several times, the Drill web UI and sqlline are both so slow as to be
unusable.

For example, doing a show databases hangs indefinitely, until I CTRL-C the
command (e.g., after a minute).

 show databases;
+-------------+
| SCHEMA_NAME |
+-------------+
| INFORMATION_SCHEMA |
| cp.default  |
| dfs.default |
| dfs.root    |
| dfs.tmp     |
| test.default |
| test.schema1 |
| sys         |
+-------------+
8 rows selected (59.044 seconds)

I tried changing schemas, but had to cancel after waiting several minutes.

 use test.schema1;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | Default schema changed to 'test.schema1' |
+------------+------------+
1 row selected (208.089 seconds)

There are no errors or obvious issues in the logs. The server has plenty of
disk, CPU, and RAM free.  It's running a recent version of MAPR Hadoop on
CentOS 6.5 on EC2.  It feels like something is hanging

Note: This is just after starting sqlline; no actual work, which might have
slowed things down, has happened yet.

This is what's running from a Drill perspective:

 ps aux | grep drill
ec2-user 24662  0.0  0.0 106100  1328 pts/0    S    12:29   0:00 bash
bin/drillbit.sh internal_start drillbit
ec2-user 24697  0.3  2.3 6486240 730568 pts/0  Sl   12:29   0:36
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.79.x86_64/bin/java
-Dlog.path=/opt/mapr/drill/drill-0.9.0/logs/drillbit.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 -XX:+CMSClassUnloadingEnabled
-XX:+UseConcMarkSweepGC -cp
/opt/mapr/drill/drill-0.9.0/conf:/opt/mapr/drill/drill-0.9.0/jars/*:/opt/mapr/drill/drill-0.9.0/jars/ext/*:/opt/mapr/drill/drill-0.9.0/jars/3rdparty/*:/opt/mapr/drill/drill-0.9.0/jars/classb/*
org.apache.drill.exec.server.Drillbit

Drill has been started thusly:

bin/sqlline -u jdbc:drill:zk=theServer:5181

Any idea how I could troubleshoot this?

Anyone else experiencing slowness after upgrading?

Thank you

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message