Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

mysql communications link failure!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql communications link failure!

    Hi All,

    Again, I came across another exception while trying to get the Mirth Working.
    Has anybody come across this problem. Please find the details below

    Thanks in advance,
    Ali

    ERROR:

    com.webreach.mirth.client.core.ClientException: method failed: HTTP/1.1 500 com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
    --- The error occurred in mysql/mysql-channel.xml.
    --- The error occurred while executing query.
    --- Check the SELECT ID, REVISION FROM CHANNEL .
    --- Check the SQL Statement (preparation failed).
    --- Cause: java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


    ** BEGIN NESTED EXCEPTION **

    com.mysql.jdbc.CommunicationsException
    MESSAGE: 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:1905 )
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 1 ms ago.

    STACKTRACE:

    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:1905 )
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 1 ms ago.
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **


    Caused by: java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:


    ** BEGIN NESTED EXCEPTION **

    com.mysql.jdbc.CommunicationsException
    MESSAGE: 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:1905 )
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 1 ms ago.

    STACKTRACE:

    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:1905 )
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **



    Last packet sent to the server was 1 ms ago.
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2563)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 71)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2988)
    at com.mysql.jdbc.Connection.rollbackNoChecks(Connect ion.java:4837)
    at com.mysql.jdbc.Connection.rollback(Connection.java :4734)
    at com.ibatis.common.jdbc.SimpleDataSource.popConnect ion(SimpleDataSource.java:629)
    at com.ibatis.common.jdbc.SimpleDataSource.getConnect ion(SimpleDataSource.java:222)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.init(JdbcTransaction.java:48)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTran saction.getConnection(JdbcTransaction.java:89)
    at com.ibatis.sqlmap.engine.mapping.statement.General Statement.executeQueryForList(GeneralStatement.jav a:123)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:615)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForList(SqlMapExecutorDelegate.java:589)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelega te.queryForMap(SqlMapExecutorDelegate.java:706)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.qu eryForMap(SqlMapSessionImpl.java:152)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.que ryForMap(SqlMapClientImpl.java:129)
    at com.webreach.mirth.server.controllers.ChannelContr oller.getChannelSummary(ChannelController.java:152 )
    at com.webreach.mirth.server.servlets.ChannelServlet. doPost(ChannelServlet.java:68)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:616)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:428)
    at org.mortbay.jetty.servlet.ServletHandler.dispatch( ServletHandler.java:666)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:568)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1530)
    at org.mortbay.http.HttpContext.handle(HttpContext.ja va:1482)
    at org.mortbay.http.HttpServer.service(HttpServer.jav a:909)
    at org.mortbay.http.HttpConnection.service(HttpConnec tion.java:816)
    at org.mortbay.http.HttpConnection.handleNext(HttpCon nection.java:982)
    at org.mortbay.http.HttpConnection.handle(HttpConnect ion.java:833)
    at org.mortbay.http.SocketListener.handleConnection(S ocketListener.java:244)
    at org.mortbay.util.ThreadedServer.handle(ThreadedSer ver.java:357)
    at org.mortbay.util.ThreadPool$PoolThread.run(ThreadP ool.java:534)


    ** END NESTED EXCEPTION **


    com.webreach.mirth.client.core.ServerConnection.ex ecutePostMethod(ServerConnection.java:99)
    com.webreach.mirth.client.core.Client.getChannelSu mmary(Client.java:170)
    com.webreach.mirth.client.ui.Frame.retrieveChannel s(Frame.java:1692)
    com.webreach.mirth.client.ui.Frame$12.doInBackgrou nd(Frame.java:1656)
    com.webreach.mirth.client.ui.Frame$12.doInBackgrou nd(Frame.java:1660)
    org.jdesktop.swingworker.SwingWorker$1.call(Unknow n Source)
    java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source)
    java.util.concurrent.FutureTask.run(Unknown Source)
    org.jdesktop.swingworker.SwingWorker.run(Unknown Source)
    java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
    java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
    java.lang.Thread.run(Unknown Source)
Working...
X