This can be set in drill-override.conf, but this should not be an issue even for long running queries as we should be sending a heartbeat signal back throughout a query's execution, even if the query has not yet produced any real data. Can you share the query you are running and any errors you can find in the logs?
To adjust the timeout you can set a higher value for the drill.exec.user.timeout in conf/drill-override.conf, the value is specified in seconds. Jason Altekruse Software Engineer at Dremio Apache Drill Committer On Thu, Mar 24, 2016 at 9:20 AM, COUERON Damien (i-BP - MICROPOLE) < [email protected]> wrote: > Hi, > > I'm trying to use Drill with the sqlline command line on linux but I'm not > able to maintain a connection to my drillbits alive long enough to get the > results back. > The connection is reset after 30 seconds even while a query is running! > > I did find the "timeout" variable and set it to -1 but it does not change > a thing. > > The drillbit.log file contains the following lines : > 2016-03-24 17:15:37,651 [UserServer-1] INFO > o.a.drill.exec.rpc.user.UserServer - RPC connection /39.6.64.15:31010 > <--> /39.6.64.22:46641 (user client) timed out. Timeout was set to 30 > seconds. Closing connection. > > Anyone knows where I can modify this setting ? > > Best regards, > Damien > > > -----Message d'origine----- > De : Andries Engelbrecht [mailto:[email protected]] > Envoyé : jeudi 24 mars 2016 16:47 > À : [email protected] > Objet : Re: JDBC storage plugin fails > > I have also seen this fail if the supplied credentials are not valid. > > With MySQL it can be a bit tricky as credentials can depend on the > location of the client, so make sure the MySQL user credentials are for % > since Drill is a distributed system and any of the nodes may connect to > MySQL. > > --Andries > > > On Mar 24, 2016, at 8:39 AM, Christopher Matta <[email protected]> wrote: > > > > Scott, > > Could you paste the JSON you're using to define the MySQL storage > > plugin here? I've experienced that you get that error when either the > > JSON is invalid, or Drill can't find the class you defined. > > > > I've created a JIRA to improve this functionality: > > https://issues.apache.org/jira/browse/DRILL-4533 > > > > > > > > On Thursday, March 24, 2016, Wilburn, Scott > > <[email protected]> wrote: > > > >> Hello, > >> I am trying to connect to a mysql database using the jdbc storage > >> plugin using Drill 1.5 described here: > >> https://drill.apache.org/docs/rdbms-storage-plugin/ > >> > >> When I try to create the plugin through the web UI, I get the > >> following vague error: > >> "Please retry: error (unable to create/ update storage)" > >> > >> I tried to see if more information exists in the drillbit logs, but > >> didn't see anything relevant. Does anyone know where I can find a > >> better description of the problem, or is JDBC just broken in 1.5? I > >> found the following Jira with the same description for 1.2 > >> (DRILL-3977). Has it been broken since 1.2, or am I doing something > stupid? > >> > >> Any help would be appreciated. > >> > >> Thanks, > >> Scott Wilburn > >> > >> > > > > -- > > Chris Matta > > [email protected] > > 215-701-3146 > > > > __________ L'intégrité de ce message n'étant pas assurée sur Internet, la > société i-BP ne peut être tenue responsable de son contenu. Si vous n'êtes > pas destinataire de ce message, merci de le détruire et d'avertir > l'expéditeur. The integrity of this message cannot be guaranteed on the > Internet. The i-BP company cannot therefore be considered responsible for > the contents. If you are not the intended recipient of this message, then > please delete it and notify the sender. __________ >
