Random error on MySql DB

[JayZ1]

I have a job that is reading from various databases and passing the data into another MySQL DB (Version 5.x) below is what we are doing there

This job and few others were all working flawlessly over the last 1.5 years but stopped working last week.

This is the error, i have tried googling and checking out other things but have been stuck on it for about two days now and wanted to see if anyone else had any idea??

 tMysqlOutput_3 Could not retrieve transation read-only status server

Exception in component tMysqlOutput_3

java.sql.SQLException: Could not retrieve transation read-only status server

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:949)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3976)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3947)

at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1356)

at .tMSSqlInput_1Process(

at tMSSqlConnection_1Process

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 5,351,314 milliseconds ago. The last packet sent successfully to the server was 18,957 milliseconds ago.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3715)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3604)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4155)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3970)

... 6 more

Caused by: java.net.SocketTimeoutException: Read timed out

at java.net.SocketInputStream.socketRead0(Native Method)

at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)

at java.net.SocketInputStream.read(SocketInputStream.java:171)

at java.net.SocketInputStream.read(SocketInputStream.java:141)

at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)

at sun.security.ssl.InputRecord.read(InputRecord.java:503)

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:990)

at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:948)

at sun.security.ssl.AppInputStream.read(AppInputStream.java:105)

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3158)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3615)

... 14 more

The database is totally up and running and has no issues, i have read write access so i should be able to add to the db, and there are no firewall issues.

[Anonymous]

Hi Team,

Can you please check the metadata connection for the same DB? Ensure you can connect to DB from the same studio machine. Could you also try to test with additional parameters such as useSSL=false and increase the wait timeout at db end such as SET GLOBAL wait_timeout = 28800.

Thank you

[Anonymous]

Hello,

Communications link failure error is due communication/network issue. This indicates that a TCP/IP connection could not be established to the target host.

Maybe there is long time issue for reading from various databases and passing the data.

From your job design, are you using t<DB>connection and use connection parameters in your MySQLOutput?

Best regards

Sabrina