[ 
https://issues.apache.org/jira/browse/CALCITE-1565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde updated CALCITE-1565:
---------------------------------
    Description: 
PQS started raising ArrayIndexOutOfBoundsException sporadically and goes away 
when it is restarted. 

Environment:
* CDH 5.7.2
* HBase: 1.2.0
* Phoenix: 4.7

Here is an error stack for "closeStatement" request:

{noformat}
{"level":"TRACE","message":" server.AvaticaJsonHandler: response: Response: 
{"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException: -1
        at java.util.ArrayList.fastRemove(ArrayList.java:528)
        at java.util.ArrayList.remove(ArrayList.java:511)
        at 
org.apache.phoenix.jdbc.PhoenixResultSet.close(PhoenixResultSet.java:165)
        at 
org.apache.calcite.avatica.jdbc.JdbcMeta.closeStatement(JdbcMeta.java:559)
        at 
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:256)
        at 
org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1529)
        at 
org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1511)
        at 
org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
        at 
org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:43)
        at 
org.apache.calcite.avatica.server.AvaticaJsonHandler.handle(AvaticaJsonHandler.java:73)
        at 
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
        at org.eclipse.jetty.server.Server.handle(Server.java:497)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
        at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
        at 
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
        at java.lang.Thread.run(Thread.java:745)
"],"errorMessage":"ArrayIndexOutOfBoundsException: 
-1","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
 Status:500"}
{noformat}

Another response during fetch:

{noformat}
TRACE server.AvaticaJsonHandler: request: {"connectionId": 
"0359595b-509a-41e2-9348-d3f8fcec65df", "request": "fetch", "fetchMaxRowCount": 
2000, "offset": 100, "statementId": 181894}
TRACE jdbc.JdbcMeta: fetching 0359595b-509a-41e2-9348-d3f8fcec65df::181894 
offset:100 fetchMaxRowCount:2000
TRACE server.AvaticaJsonHandler: response: Response: 
{"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException\n"],"errorMessage":"ArrayIndexOutOfBoundsException:
 (null exception 
message)","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
 Status:500
DEBUG server.Server: RESPONSE /  500 handled=true
{noformat}

  was:
PQS started raising ArrayIndexOutOfBoundsException sporadically and goes away 
when it is restarted. 

CDH 5.7.2
HBase: 1.2.0
Phoenix: 4.7

Here is an error stack for "closeStatement" request:

{"level":"TRACE","message":" server.AvaticaJsonHandler: response: Response: 
{"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException: -1
        at java.util.ArrayList.fastRemove(ArrayList.java:528)
        at java.util.ArrayList.remove(ArrayList.java:511)
        at 
org.apache.phoenix.jdbc.PhoenixResultSet.close(PhoenixResultSet.java:165)
        at 
org.apache.calcite.avatica.jdbc.JdbcMeta.closeStatement(JdbcMeta.java:559)
        at 
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:256)
        at 
org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1529)
        at 
org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1511)
        at 
org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
        at 
org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:43)
        at 
org.apache.calcite.avatica.server.AvaticaJsonHandler.handle(AvaticaJsonHandler.java:73)
        at 
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
        at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
        at org.eclipse.jetty.server.Server.handle(Server.java:497)
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
        at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
        at 
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
        at 
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
        at java.lang.Thread.run(Thread.java:745)
"],"errorMessage":"ArrayIndexOutOfBoundsException: 
-1","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
 Status:500"}

Another response during fetch:
TRACE server.AvaticaJsonHandler: request: {"connectionId": 
"0359595b-509a-41e2-9348-d3f8fcec65df", "request": "fetch", "fetchMaxRowCount": 
2000, "offset": 100, "statementId": 181894}
TRACE jdbc.JdbcMeta: fetching 0359595b-509a-41e2-9348-d3f8fcec65df::181894 
offset:100 fetchMaxRowCount:2000
TRACE server.AvaticaJsonHandler: response: Response: 
{"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException\n"],"errorMessage":"ArrayIndexOutOfBoundsException:
 (null exception 
message)","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
 Status:500
DEBUG server.Server: RESPONSE /  500 handled=true


> ArrayIndexOutOfBoundsException from Phoenix Query Server
> --------------------------------------------------------
>
>                 Key: CALCITE-1565
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1565
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Tulasi P
>            Assignee: Julian Hyde
>
> PQS started raising ArrayIndexOutOfBoundsException sporadically and goes away 
> when it is restarted. 
> Environment:
> * CDH 5.7.2
> * HBase: 1.2.0
> * Phoenix: 4.7
> Here is an error stack for "closeStatement" request:
> {noformat}
> {"level":"TRACE","message":" server.AvaticaJsonHandler: response: Response: 
> {"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException: 
> -1
>       at java.util.ArrayList.fastRemove(ArrayList.java:528)
>       at java.util.ArrayList.remove(ArrayList.java:511)
>       at 
> org.apache.phoenix.jdbc.PhoenixResultSet.close(PhoenixResultSet.java:165)
>       at 
> org.apache.calcite.avatica.jdbc.JdbcMeta.closeStatement(JdbcMeta.java:559)
>       at 
> org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:256)
>       at 
> org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1529)
>       at 
> org.apache.calcite.avatica.remote.Service$CloseStatementRequest.accept(Service.java:1511)
>       at 
> org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
>       at 
> org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:43)
>       at 
> org.apache.calcite.avatica.server.AvaticaJsonHandler.handle(AvaticaJsonHandler.java:73)
>       at 
> org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>       at 
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>       at org.eclipse.jetty.server.Server.handle(Server.java:497)
>       at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
>       at 
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
>       at 
> org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
>       at 
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>       at 
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
>       at java.lang.Thread.run(Thread.java:745)
> "],"errorMessage":"ArrayIndexOutOfBoundsException: 
> -1","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
>  Status:500"}
> {noformat}
> Another response during fetch:
> {noformat}
> TRACE server.AvaticaJsonHandler: request: {"connectionId": 
> "0359595b-509a-41e2-9348-d3f8fcec65df", "request": "fetch", 
> "fetchMaxRowCount": 2000, "offset": 100, "statementId": 181894}
> TRACE jdbc.JdbcMeta: fetching 0359595b-509a-41e2-9348-d3f8fcec65df::181894 
> offset:100 fetchMaxRowCount:2000
> TRACE server.AvaticaJsonHandler: response: Response: 
> {"response":"error","exceptions":["java.lang.ArrayIndexOutOfBoundsException\n"],"errorMessage":"ArrayIndexOutOfBoundsException:
>  (null exception 
> message)","errorCode":-1,"sqlState":"00000","severity":"UNKNOWN","rpcMetadata":{"response":"rpcMetadata","serverAddress":"pqs_hostname:8765"}},
>  Status:500
> DEBUG server.Server: RESPONSE /  500 handled=true
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to