phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Bind Params with Union throw AvaticaSqlException
Date Thu, 12 Apr 2018 21:52:09 GMT
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
> 

Mime
View raw message