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
  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
  2. 0

    Loosing database connectivity after idle time

    Oracle Community | 1 decade ago | 843859
    com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException
  3. 0

    JDBC, MySQL, Communications link failure

    Oracle Community | 10 years ago | 843859
    org.hibernate.exception.JDBCConnectionException: could not initialize a collection: [imarine2.Category.stuff#547]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    this error often appears

    Coderanch | 1 decade ago | Migrated From Jforum.net
    com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException
  6. 0

    Help~~~ cannot login after rollback to 2.1.6 from 2.1.7

    Coderanch | 10 years ago | Migrated From Jforum.net
    java.lang.reflect.InvocationTargetException

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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