Any chance you can share the complete stacktrace you see as well as the
version of Phoenix that you're using, Lew?
This code bridges Phoenix and Avatica -- having line numbers and a
version of code to compare against will help get to the bottom of the issue.
On 4/12/18 4:48 PM, Lew Jackman wrote:
Thanks for the recommendation Josh.
This looks like our issue:
https://issues.apache.org/jira/browse/PHOENIX-4450?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&focusedCommentId=16293699#comment-16293699
When we turn up the debug logging, we find this:
java.lang.RuntimeException: java.sql.SQLException: ERROR 2004 (INT05):
Parameter value unbound. Parameter at index 1 is unbound
org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:681)
org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:707)
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:208)
org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1195)
org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1166)
org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:95)
org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46)
org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:124)
Caused by: java.sql.SQLException: ERROR 2004 (INT05): Parameter value unbound.
Parameter at index 1 is unbound
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:464)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
at
org.apache.phoenix.jdbc.PhoenixParameterMetaData.getParam(PhoenixParameterMetaData.java:89)
at
org.apache.phoenix.jdbc.PhoenixParameterMetaData.isSigned(PhoenixParameterMetaData.java:138)
at org.apache.calcite.avatica.jdbc.JdbcMeta.parameters(JdbcMeta.java:267)
at org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:280)
at org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:701)
... 15 more