java.sql.SQLException

While closing connection

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web5087

  • via Apache's JIRA Issue Tracker by Victoria Markman, 1 year ago
    While closing connection
  • [Amazon](500150) Error setting/closing connection: Connection timed out.
  • [Amazon](500150) Error setting/closing connection: Connection refused.
  • Stack trace

    • java.sql.SQLException: While closing connection at net.hydromatic.avatica.Helper.createException(Helper.java:40) at net.hydromatic.avatica.AvaticaConnection.close(AvaticaConnection.java:137) at sqlline.Commands.close(Commands.java:929) at sqlline.Commands.quit(Commands.java:889) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) at sqlline.SqlLine.dispatch(SqlLine.java:734) at sqlline.SqlLine.initArgs(SqlLine.java:548) at sqlline.SqlLine.begin(SqlLine.java:587) at sqlline.SqlLine.start(SqlLine.java:366) at sqlline.SqlLine.main(SqlLine.java:259) Caused by: java.lang.IllegalStateException: Failure while closing accountor. Expected private and shared pools to be set to initial values. However, one or more were not. Stats are zone init allocated delta private 0 0 0 shared 8589934592 8589934115 477. at org.apache.drill.exec.memory.AtomicRemainder.close(AtomicRemainder.java:200) at org.apache.drill.exec.memory.Accountor.close(Accountor.java:390) at org.apache.drill.exec.memory.TopLevelAllocator.close(TopLevelAllocator.java:185) at org.apache.drill.exec.client.DrillClient.close(DrillClient.java:261) at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:376) at org.apache.drill.jdbc.impl.DrillHandler.onConnectionClose(DrillHandler.java:36) at net.hydromatic.avatica.AvaticaConnection.close(AvaticaConnection.java:135) ... 12 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.