Could you file a JIRA for this? I see the potential sources where the bug originated and there doesn’t seem to be sufficient logging, so it gets hard to narrow it down.
-----Original Message----- From: Akshay Joshi [mailto:joshiakshay0...@gmail.com] Sent: Tuesday, October 31, 2017 10:04 PM To: user@drill.apache.org Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB Hi Arjun/Kunal, Just to add to my previous mail I am using *Apache Drill version 1.11.0.* Thanks, Akshay On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi <joshiakshay0...@gmail.com> wrote: > Hi Arjun/Kunal, > > Error message is not getting logged in drillbit.out as well once "create" > button is clicked. None of the log files is getting updated in drill UI. > > Tried with curl command and getting the same error *(unable to create/ > update storage) *without much stacktrace about error. PFB more details > about curl command and o/p. HTTPS is not enabled. > Just to add I am able to connect my oracle DB using sqldeveloper client. > > *COMMAND* > curl -v -X POST -H "Content-Type: application/json" -d > '{"name":"oracle1", > "config": {"type": "jdbc", "enabled": true,"driver": "oracle.dbc.driver. > OracleDriver", > "url":"jdbc:oracle:thin:<user>/<password>@<oracle > server>:<port>/<schema>" }}' http://<<drill-server-ip>>: > 8047/storage/query.json > > *CURL O/P* > * About to connect() to <<drill-server-ip>> port 8047 (#0) > * Trying <<drill-server-ip>>... connected > * Connected to <<drill-server-ip>> (<<drill-server-ip>>) port 8047 > (#0) > > POST /storage/query.json HTTP/1.1 > > User-Agent: curl/7.19.7 <<user-agent>> > > Host: <<drill-server-ip>>:8047 > > Accept: */* > > Content-Type: application/json > > Content-Length: 179 > > > < HTTP/1.1 200 OK > < Content-Type: application/json > < Content-Length: 59 > < Server: Jetty(9.1.5.v20140505) > < > { > "result" : "error (unable to create/ update storage)" > * Connection #0 to host <<drill-server-ip>> left intact > * Closing connection #0 > } > > Kindly let me know if any other thoughts. > > Thanks, > Akshay > > > On Wed, Nov 1, 2017 at 12:20 AM, Arjun kr <arjun...@outlook.com> wrote: > >> >> Can you try with CURL as well ? >> >> curl -v -X POST -H "Content-Type: application/json" -d >> '{"name":"oracle1", "config": {"type": "jdbc", "enabled": true,"driver": >> "oracle.jdbc.driver.OracleDriver", >> "url":"jdbc:oracle:thin:<user>/<password>@<oracle >> server>:<port>/<schema>" }}' http://<<http://<drill> >> drill_server>:8047/storage/oracle1.json >> >> Please refer to this blog for curl command if you have HTTPS enabled. >> >> http://www.openkb.info/2016/02/how-to-use-rest-api-to-submit-queries. >> html >> >> Also assume that you are able to connect with this connection URL >> using any other jdbc application. >> >> Thanks, >> >> Arjun >> ________________________________ >> From: Kunal Khatua <kkha...@mapr.com> >> Sent: Tuesday, October 31, 2017 11:57 PM >> To: user@drill.apache.org >> Subject: RE: Apache drill : Error while creating storage plugin for >> Oracle DB >> >> There are other logs that might be reporting the error. >> >> Look at the other logs in the Drill UI ... one of them that can carry >> more information would be drillbit.out >> >> -----Original Message----- >> From: Akshay Joshi [mailto:joshiakshay0...@gmail.com] >> Sent: Tuesday, October 31, 2017 11:06 AM >> To: user@drill.apache.org >> Subject: Re: Apache drill : Error while creating storage plugin for >> Oracle DB >> >> Hi Arjun, >> >> No error message getting logged in drillbit.log once I click on "create" >> button. >> >> Thanks, >> Akshay >> >> On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr <arjun...@outlook.com> wrote: >> >> > >> > Do you see any specific error message in drillbit.log ? >> > >> > Thanks, >> > >> > Arjun >> > >> > ________________________________ >> > From: Akshay Joshi <joshiakshay0...@gmail.com> >> > Sent: Tuesday, October 31, 2017 11:10 PM >> > To: user@drill.apache.org >> > Subject: Re: Apache drill : Error while creating storage plugin for >> > Oracle DB >> > >> > Hi Arjun, >> > >> > Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and >> > restarted the drillbits on all nodes. >> > >> > Thanks and Regards, >> > Akshay >> > On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr <arjun...@outlook.com> wrote: >> > >> > > Hi Akshay, >> > > >> > > >> > > Did you copy jdbc driver to all the drill nodes and restarted >> drillbits ? >> > > >> > > >> > > Thanks, >> > > >> > > >> > > Arjun >> > > >> > > >> > > ________________________________ >> > > From: Akshay Joshi <joshiakshay0...@gmail.com> >> > > Sent: Tuesday, October 31, 2017 9:46 PM >> > > To: user@drill.apache.org >> > > Subject: Apache drill : Error while creating storage plugin for >> > > Oracle DB >> > > >> > > Hi Team, >> > > >> > > I have configured drill on 4 node cluster and getting error while >> > creating >> > > storage plugin for Oracle DB. >> > > >> > > Error : Please retry: error (unable to create/ update storage) >> > > >> > > Oracle DB Version : *12.1.0.2.0* >> > > >> > > Following steps followed to create storage plugin: >> > > 1. copied ojdbc7.jar to jars/3rdparty folder 2. Storage plugin >> > > configuration { >> > > "type": "jdbc", >> > > "driver": "oracle.jdbc.driver.OracleDriver", >> > > "url": >> > > "jdbc:oracle:thin:<<username>>/<<password>>@<<IP>>:<<PORT>>/ >> > ORCL", >> > > "enabled": true >> > > } >> > > 3. drill-override.conf file >> > > drill.exec: { >> > > cluster-id: "drillbits1", >> > > drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/ >> > > apache-drill-1.11.0", >> > > zk.connect: "<<IP>>:<<PORT>" >> > > } >> > > >> > > Thanks and Regards, >> > > Akshay >> > > >> > >> > >
