You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by waterwagen <wa...@gmail.com> on 2020/04/09 00:43:20 UTC
Re: SQL Error [08006]: Failed to communicate with Ignite cluster
<-- BinaryObjectException: Not enough data to read the value
I had the exact same error with select statements submitted from DBeaver
7.0.2, which comes with ignite-core 2.8.0.
I solved the problem by updating the Ignite driver settings in DBeaver to
downgrade to ignite-core 2.7.6.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SQL Error [08006]: Failed to communicate with Ignite cluster
<-- BinaryObjectException: Not enough data to read the value
Posted by VeenaMithare <v....@cmcmarkets.com>.
Do you have security enabled in your project ? I think sqls not being able to
run on dbeaver is a known issue on 2.8.0 for security enabled projects :
https://issues.apache.org/jira/browse/IGNITE-12833
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: SQL Error [08006]: Failed to communicate with Ignite cluster <--
BinaryObjectException: Not enough data to read the value
Posted by Joshua Taylor <wa...@gmail.com>.
It's the same stacktrace as in the original post from Devin (just with a
different value for position in the cause). The Ignite instance I'm
connecting to is v2.7.6.
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [08006]: Failed
to communicate with Ignite cluster.
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:134)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:491)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:426)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:170)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:418)
at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:778)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2942)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:111)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:170)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:109)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$17.run(ResultSetViewer.java:3478)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: Failed to communicate with Ignite cluster.
at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:916)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:231)
at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:559)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:338)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
... 12 more
Caused by: class org.apache.ignite.binary.BinaryObjectException: Not
enough data to read the value [position=4016, requiredBytes=1,
remainingBytes=0]
at org.apache.ignite.internal.binary.streams.BinaryAbstractInputStream.ensureEnoughData(BinaryAbstractInputStream.java:305)
at org.apache.ignite.internal.binary.streams.BinaryAbstractInputStream.readByte(BinaryAbstractInputStream.java:35)
at org.apache.ignite.internal.binary.streams.BinaryAbstractInputStream.readBoolean(BinaryAbstractInputStream.java:53)
at org.apache.ignite.internal.binary.BinaryReaderExImpl.readBoolean(BinaryReaderExImpl.java:548)
at org.apache.ignite.internal.processors.odbc.jdbc.JdbcQueryExecuteResult.readBinary(JdbcQueryExecuteResult.java:167)
at org.apache.ignite.internal.processors.odbc.jdbc.JdbcResult.readResult(JdbcResult.java:207)
at org.apache.ignite.internal.processors.odbc.jdbc.JdbcResponse.readBinary(JdbcResponse.java:153)
at org.apache.ignite.internal.jdbc.thin.JdbcThinTcpIo.readResponse(JdbcThinTcpIo.java:451)
at org.apache.ignite.internal.jdbc.thin.JdbcThinTcpIo.sendRequest(JdbcThinTcpIo.java:423)
at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:890)
... 16 more
On Thu, Apr 9, 2020 at 1:08 AM Denis Magda <dm...@apache.org> wrote:
> What’s the exception you see in DBeaver?
>
> Denis
>
> On Wednesday, April 8, 2020, waterwagen <wa...@gmail.com> wrote:
>
>> I had the exact same error with select statements submitted from DBeaver
>> 7.0.2, which comes with ignite-core 2.8.0.
>>
>> I solved the problem by updating the Ignite driver settings in DBeaver to
>> downgrade to ignite-core 2.7.6.
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>
>
> --
> -
> Denis
>
>
Re: SQL Error [08006]: Failed to communicate with Ignite cluster <--
BinaryObjectException: Not enough data to read the value
Posted by Denis Magda <dm...@apache.org>.
What’s the exception you see in DBeaver?
Denis
On Wednesday, April 8, 2020, waterwagen <wa...@gmail.com> wrote:
> I had the exact same error with select statements submitted from DBeaver
> 7.0.2, which comes with ignite-core 2.8.0.
>
> I solved the problem by updating the Ignite driver settings in DBeaver to
> downgrade to ignite-core 2.7.6.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
--
-
Denis