You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Peder Jakobsen | gmail <pj...@gmail.com> on 2015/12/29 23:04:04 UTC

Drill 1.4 fails to start on Windows 7, JDK 1.7.0 - "Unable to deserialize"

C:\devel\apache-drill-1.4.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
DRILL_ARGS - " -u jdbc:drill:zk=local"
HADOOP_HOME not detected...
HBASE_HOME not detected...
Calculating Drill classpath...
Error: Failure in starting embedded Drillbit: java.lang.RuntimeException:
Unable
 to deserialize "/tmp/drill/sys.storage_plugins/hive.sys.drill"
(state=,code=0)
java.sql.SQLException: Failure in starting embedded Drillbit:
java.lang.RuntimeE
xception: Unable to deserialize
"/tmp/drill/sys.storage_plugins/hive.sys.drill"
        at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
Impl.java:127)
        at
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
lJdbc41Factory.java:64)
        at
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
va:69)
        at
net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.
java:126)
        at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
        at
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)

        at sqlline.Commands.connect(Commands.java:1083)
        at sqlline.Commands.connect(Commands.java:1015)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
a:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:742)
        at sqlline.SqlLine.initArgs(SqlLine.java:528)
        at sqlline.SqlLine.begin(SqlLine.java:596)
        at sqlline.SqlLine.start(SqlLine.java:375)
        at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: java.lang.RuntimeException: Unable to deserialize
"/tmp/drill/sys.sto
rage_plugins/hive.sys.drill"
        at
org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
140)
        at
org.apache.drill.exec.store.sys.local.FilePStore$Iter$DeferredEntry.g
etValue(FilePStore.java:219)
        at
org.apache.drill.exec.store.StoragePluginRegistry.createPlugins(Stora
gePluginRegistry.java:197)
        at
org.apache.drill.exec.store.StoragePluginRegistry.init(StoragePluginR
egistry.java:161)
        at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:213)
        at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
Impl.java:118)
        ... 18 more
Caused by: com.fasterxml.jackson.databind.JsonMappingException: No content
to ma
p due to end-of-input
 at [Source: [B@16c9ea3; line: 1, column: 1]
        at
com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingE
xception.java:148)
        at
com.fasterxml.jackson.databind.ObjectReader._initForReading(ObjectRea
der.java:1351)
        at
com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReade
r.java:1252)
        at
com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.ja
va:912)
        at
org.apache.drill.exec.store.sys.serialize.JacksonSerializer.deseriali
ze(JacksonSerializer.java:44)
        at
org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
138)
        ... 23 more
apache drill 1.4.0
"a drill is a terrible thing to waste"
0: jdbc:drill:zk=local>

Re: Drill 1.4 fails to start on Windows 7, JDK 1.7.0 - "Unable to deserialize"

Posted by Nathan Griffith <ng...@dremio.com>.
Hi again Peder,

Unfortunately I'm not currently in front of a Windows machine, but I
think it's C:\Windows\Temp

Also, I'm pretty sure that this is the folder Drill is talking about
whenever it references '/tmp' in Windows.

--Nathan

On Thu, Dec 31, 2015 at 7:03 AM, Peder Jakobsen | gmail
<pj...@gmail.com> wrote:
> Hi Nathan,   my environment variables are set according to the link you
> sent. But drill still will not start with out a Java Error and a long stack
> trace.    What is the "Windows installs's Temp directory"?
>
> Thanks,
>
> Peder J.
>
> On Wed, Dec 30, 2015 at 8:24 PM, Nathan Griffith <ng...@dremio.com>
> wrote:
>
>> Hi Peder!
>>
>> Try cleaning the Drill stuff out of your Windows install's Temp
>> directory, and make sure that the environment variables are set as per
>> this article:
>> http://www.dremio.com/blog/installing-apache-drill-on-microsoft-windows/
>>
>> Best,
>> Nathan
>>
>> On Tue, Dec 29, 2015 at 2:04 PM, Peder Jakobsen | gmail
>> <pj...@gmail.com> wrote:
>> > C:\devel\apache-drill-1.4.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
>> > DRILL_ARGS - " -u jdbc:drill:zk=local"
>> > HADOOP_HOME not detected...
>> > HBASE_HOME not detected...
>> > Calculating Drill classpath...
>> > Error: Failure in starting embedded Drillbit: java.lang.RuntimeException:
>> > Unable
>> >  to deserialize "/tmp/drill/sys.storage_plugins/hive.sys.drill"
>> > (state=,code=0)
>> > java.sql.SQLException: Failure in starting embedded Drillbit:
>> > java.lang.RuntimeE
>> > xception: Unable to deserialize
>> > "/tmp/drill/sys.storage_plugins/hive.sys.drill"
>> >         at
>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
>> > Impl.java:127)
>> >         at
>> > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
>> > lJdbc41Factory.java:64)
>> >         at
>> > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
>> > va:69)
>> >         at
>> > net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.
>> > java:126)
>> >         at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>> >         at
>> sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>> >         at
>> > sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
>> >
>> >         at sqlline.Commands.connect(Commands.java:1083)
>> >         at sqlline.Commands.connect(Commands.java:1015)
>> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> >         at
>> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>> > java:57)
>> >         at
>> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>> > sorImpl.java:43)
>> >         at java.lang.reflect.Method.invoke(Method.java:606)
>> >         at
>> > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
>> > a:36)
>> >         at sqlline.SqlLine.dispatch(SqlLine.java:742)
>> >         at sqlline.SqlLine.initArgs(SqlLine.java:528)
>> >         at sqlline.SqlLine.begin(SqlLine.java:596)
>> >         at sqlline.SqlLine.start(SqlLine.java:375)
>> >         at sqlline.SqlLine.main(SqlLine.java:268)
>> > Caused by: java.lang.RuntimeException: Unable to deserialize
>> > "/tmp/drill/sys.sto
>> > rage_plugins/hive.sys.drill"
>> >         at
>> > org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
>> > 140)
>> >         at
>> > org.apache.drill.exec.store.sys.local.FilePStore$Iter$DeferredEntry.g
>> > etValue(FilePStore.java:219)
>> >         at
>> > org.apache.drill.exec.store.StoragePluginRegistry.createPlugins(Stora
>> > gePluginRegistry.java:197)
>> >         at
>> > org.apache.drill.exec.store.StoragePluginRegistry.init(StoragePluginR
>> > egistry.java:161)
>> >         at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:213)
>> >         at
>> > org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
>> > Impl.java:118)
>> >         ... 18 more
>> > Caused by: com.fasterxml.jackson.databind.JsonMappingException: No
>> content
>> > to ma
>> > p due to end-of-input
>> >  at [Source: [B@16c9ea3; line: 1, column: 1]
>> >         at
>> > com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingE
>> > xception.java:148)
>> >         at
>> > com.fasterxml.jackson.databind.ObjectReader._initForReading(ObjectRea
>> > der.java:1351)
>> >         at
>> > com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReade
>> > r.java:1252)
>> >         at
>> > com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.ja
>> > va:912)
>> >         at
>> > org.apache.drill.exec.store.sys.serialize.JacksonSerializer.deseriali
>> > ze(JacksonSerializer.java:44)
>> >         at
>> > org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
>> > 138)
>> >         ... 23 more
>> > apache drill 1.4.0
>> > "a drill is a terrible thing to waste"
>> > 0: jdbc:drill:zk=local>
>>

Re: Drill 1.4 fails to start on Windows 7, JDK 1.7.0 - "Unable to deserialize"

Posted by Peder Jakobsen | gmail <pj...@gmail.com>.
Hi Nathan,   my environment variables are set according to the link you
sent. But drill still will not start with out a Java Error and a long stack
trace.    What is the "Windows installs's Temp directory"?

Thanks,

Peder J.

On Wed, Dec 30, 2015 at 8:24 PM, Nathan Griffith <ng...@dremio.com>
wrote:

> Hi Peder!
>
> Try cleaning the Drill stuff out of your Windows install's Temp
> directory, and make sure that the environment variables are set as per
> this article:
> http://www.dremio.com/blog/installing-apache-drill-on-microsoft-windows/
>
> Best,
> Nathan
>
> On Tue, Dec 29, 2015 at 2:04 PM, Peder Jakobsen | gmail
> <pj...@gmail.com> wrote:
> > C:\devel\apache-drill-1.4.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
> > DRILL_ARGS - " -u jdbc:drill:zk=local"
> > HADOOP_HOME not detected...
> > HBASE_HOME not detected...
> > Calculating Drill classpath...
> > Error: Failure in starting embedded Drillbit: java.lang.RuntimeException:
> > Unable
> >  to deserialize "/tmp/drill/sys.storage_plugins/hive.sys.drill"
> > (state=,code=0)
> > java.sql.SQLException: Failure in starting embedded Drillbit:
> > java.lang.RuntimeE
> > xception: Unable to deserialize
> > "/tmp/drill/sys.storage_plugins/hive.sys.drill"
> >         at
> > org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> > Impl.java:127)
> >         at
> > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
> > lJdbc41Factory.java:64)
> >         at
> > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
> > va:69)
> >         at
> > net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.
> > java:126)
> >         at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
> >         at
> sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> >         at
> > sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> >
> >         at sqlline.Commands.connect(Commands.java:1083)
> >         at sqlline.Commands.connect(Commands.java:1015)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at
> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> > java:57)
> >         at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> > sorImpl.java:43)
> >         at java.lang.reflect.Method.invoke(Method.java:606)
> >         at
> > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
> > a:36)
> >         at sqlline.SqlLine.dispatch(SqlLine.java:742)
> >         at sqlline.SqlLine.initArgs(SqlLine.java:528)
> >         at sqlline.SqlLine.begin(SqlLine.java:596)
> >         at sqlline.SqlLine.start(SqlLine.java:375)
> >         at sqlline.SqlLine.main(SqlLine.java:268)
> > Caused by: java.lang.RuntimeException: Unable to deserialize
> > "/tmp/drill/sys.sto
> > rage_plugins/hive.sys.drill"
> >         at
> > org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
> > 140)
> >         at
> > org.apache.drill.exec.store.sys.local.FilePStore$Iter$DeferredEntry.g
> > etValue(FilePStore.java:219)
> >         at
> > org.apache.drill.exec.store.StoragePluginRegistry.createPlugins(Stora
> > gePluginRegistry.java:197)
> >         at
> > org.apache.drill.exec.store.StoragePluginRegistry.init(StoragePluginR
> > egistry.java:161)
> >         at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:213)
> >         at
> > org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> > Impl.java:118)
> >         ... 18 more
> > Caused by: com.fasterxml.jackson.databind.JsonMappingException: No
> content
> > to ma
> > p due to end-of-input
> >  at [Source: [B@16c9ea3; line: 1, column: 1]
> >         at
> > com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingE
> > xception.java:148)
> >         at
> > com.fasterxml.jackson.databind.ObjectReader._initForReading(ObjectRea
> > der.java:1351)
> >         at
> > com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReade
> > r.java:1252)
> >         at
> > com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.ja
> > va:912)
> >         at
> > org.apache.drill.exec.store.sys.serialize.JacksonSerializer.deseriali
> > ze(JacksonSerializer.java:44)
> >         at
> > org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
> > 138)
> >         ... 23 more
> > apache drill 1.4.0
> > "a drill is a terrible thing to waste"
> > 0: jdbc:drill:zk=local>
>

Re: Drill 1.4 fails to start on Windows 7, JDK 1.7.0 - "Unable to deserialize"

Posted by Nathan Griffith <ng...@dremio.com>.
Hi Peder!

Try cleaning the Drill stuff out of your Windows install's Temp
directory, and make sure that the environment variables are set as per
this article: http://www.dremio.com/blog/installing-apache-drill-on-microsoft-windows/

Best,
Nathan

On Tue, Dec 29, 2015 at 2:04 PM, Peder Jakobsen | gmail
<pj...@gmail.com> wrote:
> C:\devel\apache-drill-1.4.0\bin>sqlline.bat -u "jdbc:drill:zk=local"
> DRILL_ARGS - " -u jdbc:drill:zk=local"
> HADOOP_HOME not detected...
> HBASE_HOME not detected...
> Calculating Drill classpath...
> Error: Failure in starting embedded Drillbit: java.lang.RuntimeException:
> Unable
>  to deserialize "/tmp/drill/sys.storage_plugins/hive.sys.drill"
> (state=,code=0)
> java.sql.SQLException: Failure in starting embedded Drillbit:
> java.lang.RuntimeE
> xception: Unable to deserialize
> "/tmp/drill/sys.storage_plugins/hive.sys.drill"
>         at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> Impl.java:127)
>         at
> org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(Dril
> lJdbc41Factory.java:64)
>         at
> org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.ja
> va:69)
>         at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.
> java:126)
>         at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
>         at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>         at
> sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
>
>         at sqlline.Commands.connect(Commands.java:1083)
>         at sqlline.Commands.connect(Commands.java:1015)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.jav
> a:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:742)
>         at sqlline.SqlLine.initArgs(SqlLine.java:528)
>         at sqlline.SqlLine.begin(SqlLine.java:596)
>         at sqlline.SqlLine.start(SqlLine.java:375)
>         at sqlline.SqlLine.main(SqlLine.java:268)
> Caused by: java.lang.RuntimeException: Unable to deserialize
> "/tmp/drill/sys.sto
> rage_plugins/hive.sys.drill"
>         at
> org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
> 140)
>         at
> org.apache.drill.exec.store.sys.local.FilePStore$Iter$DeferredEntry.g
> etValue(FilePStore.java:219)
>         at
> org.apache.drill.exec.store.StoragePluginRegistry.createPlugins(Stora
> gePluginRegistry.java:197)
>         at
> org.apache.drill.exec.store.StoragePluginRegistry.init(StoragePluginR
> egistry.java:161)
>         at org.apache.drill.exec.server.Drillbit.run(Drillbit.java:213)
>         at
> org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnection
> Impl.java:118)
>         ... 18 more
> Caused by: com.fasterxml.jackson.databind.JsonMappingException: No content
> to ma
> p due to end-of-input
>  at [Source: [B@16c9ea3; line: 1, column: 1]
>         at
> com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingE
> xception.java:148)
>         at
> com.fasterxml.jackson.databind.ObjectReader._initForReading(ObjectRea
> der.java:1351)
>         at
> com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReade
> r.java:1252)
>         at
> com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.ja
> va:912)
>         at
> org.apache.drill.exec.store.sys.serialize.JacksonSerializer.deseriali
> ze(JacksonSerializer.java:44)
>         at
> org.apache.drill.exec.store.sys.local.FilePStore.get(FilePStore.java:
> 138)
>         ... 23 more
> apache drill 1.4.0
> "a drill is a terrible thing to waste"
> 0: jdbc:drill:zk=local>