com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException

JIRA | Hadas | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    We use the plugin to show query results from a mySQL DB inside a Confluence page. The Page consists of 2 different queries At the beginning we used Data Source Profiles Then we moved to application server datasources Since that transition, on Every login to the page one query succeeds while the other shows an exception (which one fails is random...) After doing refresh (once or twice) it suddenly returns result for both The exception is this [Partiial]: Error rendering macro 'sql' : Unexpected program error: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3170) at com.mysql.jdbc.Connection.execSQL(Connection.java:3099) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1169) at com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:3731) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:353) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getTransactionIsolation(PoolingDataSource.java:250) at org.swift.confluence.sql.SqlMacro.process(SqlMacro.java:236) at org.swift.confluence.sql.SqlMacro.execute(SqlMacro.java:173) at org.randombits.support.confluence.ConfluenceMacro.execute(ConfluenceMacro.java:65) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.confluence.macro.xhtml.XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke(XhtmlMacroManager.java:225) at com.sun.proxy.$Proxy2518.execute(Unknown Source) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshalInternal(ViewMacroMarshaller.java:113) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:68) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:30) at com.atlassian.confluence.content.render.xhtml.UnmarshalMarshalFragmentTransformer.transform(UnmarshalMarshalFragmentTransformer.java:31) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transformFragment(DefaultFragmentTransformer.java:153) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transform(DefaultFragmentTransformer.java:129) at com.atlassian.confluence.content.render.xhtml.storage.StorageXhtmlTransformer.transform(StorageXhtmlTransformer.java:44) at com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:41) at com.atlassian.confluence.content.render.xhtml.PluggableTransformerChain.transform(PluggableTransformerChain.java:51) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:80) at com.atlassian.confluence.content.render.xhtml.DeviceTypeAwareRenderer.render(DeviceTypeAwareRenderer.java:56) at com.atlassian.confluence.content.render.xhtml.DefaultXhtmlContent.convertStorageToView(DefaultXhtmlContent.java:155) at sun.reflect.GeneratedMethodAccessor1494.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy272.convertStorageToView(Unknown Source) at sun.reflect.GeneratedMethodAccessor1494.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactor .......

    JIRA | 2 years ago | Hadas
    com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException

    Root Cause Analysis

    1. com.mysql.jdbc.CommunicationsException

      Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException

      at com.mysql.jdbc.MysqlIO.readFully()
    2. MySQL jdbc
      Connection.getTransactionIsolation
      1. com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913)
      2. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304)
      3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
      4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
      5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      6. com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
      7. com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
      8. com.mysql.jdbc.Statement.executeQuery(Statement.java:1169)
      9. com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:3731)
      9 frames
    3. org.apache.tomcat
      PoolingDataSource$PoolGuardConnectionWrapper.getTransactionIsolation
      1. org.apache.tomcat.dbcp.dbcp.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:353)
      2. org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getTransactionIsolation(PoolingDataSource.java:250)
      2 frames
    4. org.swift.confluence
      SqlMacro.execute
      1. org.swift.confluence.sql.SqlMacro.process(SqlMacro.java:236)
      2. org.swift.confluence.sql.SqlMacro.execute(SqlMacro.java:173)
      2 frames
    5. org.randombits.support
      ConfluenceMacro.execute
      1. org.randombits.support.confluence.ConfluenceMacro.execute(ConfluenceMacro.java:65)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    7. com.atlassian.confluence
      XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke
      1. com.atlassian.confluence.macro.xhtml.XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke(XhtmlMacroManager.java:225)
      1 frame
    8. com.sun.proxy
      $Proxy2518.execute
      1. com.sun.proxy.$Proxy2518.execute(Unknown Source)
      1 frame
    9. com.atlassian.confluence
      DefaultXhtmlContent.convertStorageToView
      1. com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshalInternal(ViewMacroMarshaller.java:113)
      2. com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:68)
      3. com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:30)
      4. com.atlassian.confluence.content.render.xhtml.UnmarshalMarshalFragmentTransformer.transform(UnmarshalMarshalFragmentTransformer.java:31)
      5. com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transformFragment(DefaultFragmentTransformer.java:153)
      6. com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transform(DefaultFragmentTransformer.java:129)
      7. com.atlassian.confluence.content.render.xhtml.storage.StorageXhtmlTransformer.transform(StorageXhtmlTransformer.java:44)
      8. com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:41)
      9. com.atlassian.confluence.content.render.xhtml.PluggableTransformerChain.transform(PluggableTransformerChain.java:51)
      10. com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:80)
      11. com.atlassian.confluence.content.render.xhtml.DeviceTypeAwareRenderer.render(DeviceTypeAwareRenderer.java:56)
      12. com.atlassian.confluence.content.render.xhtml.DefaultXhtmlContent.convertStorageToView(DefaultXhtmlContent.java:155)
      12 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1494.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      3. java.lang.reflect.Method.invoke(Unknown Source)
      3 frames
    11. com.atlassian.plugin
      DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke
      1. com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
      1 frame
    12. com.sun.proxy
      $Proxy272.convertStorageToView
      1. com.sun.proxy.$Proxy272.convertStorageToView(Unknown Source)
      1 frame
    13. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1494.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      3. java.lang.reflect.Method.invoke(Unknown Source)
      3 frames