Hi Andries, There isn't actually a drillbit.log file, also no drillbit.out. The only thing that exists is the sqlline.log file which does not contain any warnings or error messages whatsoever.
Regards, Ralph -----Original Message----- From: Andries Engelbrecht [mailto:aengelbre...@maprtech.com] Sent: Monday, January 19, 2015 5:00 PM To: user@drill.apache.org Subject: Re: Connection timeout on port 2181 - apache-drill-0.7.0 Hi Ralph, See what is in your drillbit.log file and if there are any clues as to why the drillbit doesn't want to start. Have not used RHEL 6.6 with Drill, don't know if there is a major blocker for Drill between RHEL 6.5 and 6.6. -Andries On Jan 19, 2015, at 8:49 AM, Ralph Schlosser <ralph.schlos...@ericsson.com> wrote: > Hi Andries, > > Thanks for taking your time to look into this, I really appreciate it. > > I probably should have mentioned that I did use sqlline too. > > Just for completeness sake I ran the command again, as you suggested, and > cleared out the log directory beforehand: > > [vagrant@rhelbox apache-drill-0.7.0]$ cd log [vagrant@rhelbox log]$ ls > -la total 8 drwxrwxr-x. 2 vagrant vagrant 4096 Jan 19 16:39 . > drwxrwxr-x. 7 vagrant vagrant 4096 Jan 19 13:43 .. > [vagrant@rhelbox log]$ cd .. > [vagrant@rhelbox apache-drill-0.7.0]$ ./bin/sqlline -u > jdbc:drill:zk=local -n admin -p admin Drill log directory > /var/log/drill does not exist, defaulting to > /home/vagrant/opt/apache-drill-0.7.0/log > Error: Failure while attempting to start Drillbit in embedded mode. > (state=,code=0) sqlline version 1.1.6 > 0: jdbc:drill:zk=local> Connection is already closed. > > As you can see, this is still not working. > > I'm guessing this is related to the environment, RHEL 6.6, as it > successfully works in Ubuntu 14.04. > > Is there any other way to look into this in more detail, short of > re-compiling the source from scratch and attach a debugger etc? > > > Regards, > Ralph > -----Original Message----- > From: Andries Engelbrecht [mailto:aengelbre...@maprtech.com] > Sent: Monday, January 19, 2015 4:34 PM > To: user@drill.apache.org > Subject: Re: Connection timeout on port 2181 - apache-drill-0.7.0 > > Hi Ralph, > > With embedded mode the drill bit will start when using the sqlline command as > mentioned earlier. You don't need to run the drillbit.sh scrip to start the > drillbit. > > Try running-- ./bin/sqlline -u jdbc:drill:zk=local -n admin -p admin > (from the drill HOME directory). > This will actually start the drillbit for you in embedded mode. > > > Once it is up you can connect to the drill webUI using port 8047, and also > via ODBC to port 31010. > > -Andries > > > On Jan 19, 2015, at 8:21 AM, Ralph Schlosser <ralph.schlos...@ericsson.com> > wrote: > >> Hi Andries, >> >> That's exactly what I did, started in embedded mode simply by running >> "./drillbit.sh start". As this is my first encounter with Drill I >> followed the 10 minute quick start tutorial to the letter. :) >> >> The problem, though, is that Drill never seems to fully initialize, hence >> the error message. >> >> Issuing "netstat -an" confirms that no process is listening on 2181 >> (haven't changed anything from the default config) >> >> Is there a way to turn on some more detailed debug logs? >> >> >> Regards, >> Ralph >> -----Original Message----- >> From: Andries Engelbrecht [mailto:aengelbre...@maprtech.com] >> Sent: Monday, January 19, 2015 3:44 PM >> To: user@drill.apache.org >> Subject: Re: Connection timeout on port 2181 - apache-drill-0.7.0 >> >> Are you running Drill in embedded or distributed mode? >> >> If you are using embedded mode, you don't specify a port number >> simply start drill by using sqlline sqlline -u jdbc:drill:zk=local -n >> admin -p admin >> >> If using distributed mode, you connect to drill by using the >> zookeeper port number of the cluster >> (2181 for Apache ZK or 5181 for the Sanbox and MapR Hadoop Distros) >> >> See >> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=4499 >> 4 063#Starting/StoppingDrill-invokeSQLLine >> >> >> >> -Andries >> >> >> >> On Jan 19, 2015, at 6:35 AM, Ralph Schlosser <ralph.schlos...@ericsson.com> >> wrote: >> >>> Hi, >>> >>> I was trying to follow the Apache Drill tutorial but encountered the >>> following error in drillbit.out when starting drillbit: >>> >>> 11:14:52.901 [main] ERROR org.apache.curator.ConnectionState - >>> Connection timed out for connection string (127.0.0.1:2181) and >>> timeout (5000) / elapsed (10197) >>> org.apache.curator.CuratorConnectionLossException: KeeperErrorCode = >>> ConnectionLoss >>> at >>> org.apache.curator.ConnectionState.checkTimeouts(ConnectionState.java: >>> 198) [curator-client-2.5.0.jar:na] >>> >>> Also, this is my environment: >>> >>> [vagrant@rhelbox log]$ java -version java version "1.7.0_71" >>> Java(TM) SE Runtime Environment (build 1.7.0_71-b14) Java >>> HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode) >>> [vagrant@rhelbox log]$ cat /etc/redhat-release Red Hat Enterprise >>> Linux Server release 6.6 >>> (Santiago) [vagrant@rhelbox log]$ >>> >>> Note that SELinux is turned off (that was my first thought). >>> >>> Interestingly, this problem doesn't occur when starting drillbit on Ubuntu >>> 14.04 and netstat -an confirms the port is open. >>> >>> Any suggestions as to how to troubleshoot this further? >>> >>> >>> Regards, >>> Ralph >> >
