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

    Howto use a Tomcat connection pool with Toplinks essentials`

    Oracle Community | 8 years ago | 665845
    com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQLException: getConnection() time-out  error

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

    Hibernate Session Could not open for transaction issue

    Stack Overflow | 7 months ago | chandra prakash
    com.vnu.gmp.mule.consumers.ExecuteDataPrepConsumer: ExecuteDataPrepConsumer failed with exception for studyTag [S000001] workflowname [wf_Process_Data] and taskname [wklt_CMN_Initial_Load]. org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed: at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:596)

    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