com.mysql.jdbc.CommunicationsException

weblike

Hi,

Last week I have migrated my server to Windows Server 2012 and MySql 5.6. Since than I see a lot of messages like those bellow:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException
MESSAGE: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at com.bas.basserver.persistence.EntityDBPersister.A(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.getReferencesTo(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.getReferencesTo(Unknown Source)
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.shared.B.B.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.A.E.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.updateEntity(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.updateEntity(Unknown Source)
at com.bas.basserver.executionengine.rliproc.I.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.P.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeChildProcess(Unknown Source)
at com.bas.basserver.executionengine.rliproc.E.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.P(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.M(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeProcess(Unknown Source)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.bas.basserver.bsmanager.F.B(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at com.bas.openadaptor.A$_A.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.

STACKTRACE:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at com.bas.basserver.persistence.EntityDBPersister.A(Unknown Source)
at com.bas.basserver.persistence.EntityDBPersister.getReferencesTo(Unknown Source)
at com.bas.basserver.persistence.PersistenceManager.getReferencesTo(Unknown Source)
at com.bas.basserver.executionengine.X.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.C.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.shared.B.B.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown S
ource)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.A.E.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.A(Unknown Source)
at com.bas.basserver.executionengine.A.G.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.updateEntity(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.updateEntity(Unknown Source)
at com.bas.basserver.executionengine.rliproc.I.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.P.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeChildProcess(Unknown Source)
at com.bas.basserver.executionengine.rliproc.E.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.P(Unknown Source)
at com.bas.basserver.executionengine.rliproc.D.M(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.C(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.T(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.B(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.A(Unknown Source)
at com.bas.basserver.executionengine.rliproc.F.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.A(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeProcess(Unknown Source)
at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.bas.basserver.bsmanager.F.B(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.bsmanager.F.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at com.bas.openadaptor.A$_A.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

** END NESTED EXCEPTION **

Any advice would be much appreciated.

thank you

aware_support

Your connection with MySQL is not working reliably. We don't know the reason for this - you need to check your MySQL Server/installation.

Also, I don't know how reliable MySQL 6.0 yet. Last time we checked it had lots of problems.

weblike

Hi,
Thank you for the reply
Don't get it. The sql is 5.6 not 6 and is on the same machine as the AwareIM.
I don't see why should not communicate ok as the both servers are on same PC.

thx.

Rennur

Try updating your Connector/J from default 3.1.12 to 5.1.34.
Instructions:
https://github.com/RennurApps/AwareIM-resources#database

Cheers

weblike

Thx Rennur,

It worked. No more error messages like I mentioned...

I have to add this step for next updates (to replace the original .jar file on every new update).

Support, the default jdbc connector embedded in installation package is old (from 2005 I guess) ..It is a strategy not to include the newest one???

Thank you,