Timeout errors since migrating to MySQL
Posted: Tue Nov 12, 2013 11:18 am
Hello,
Recently we migrated our GoAnywhere Services to use a MySQL 5.1.47 instance running on a separate server - after making the switch, we've noticed many of the following errors in our logs and some users reporting issues uploading or downloading files sporadically.
I'm using the default connection string for the database.
Is there a keepalive parameter I need to add to the connection string so that they won't get closed? Other services utilizing the MySQL server don't seem to have any issues.
Recently we migrated our GoAnywhere Services to use a MySQL 5.1.47 instance running on a separate server - after making the switch, we've noticed many of the following errors in our logs and some users reporting issues uploading or downloading files sporadically.
I'm using the default connection string for the database.
Is there a keepalive parameter I need to add to the connection string so that they won't get closed? Other services utilizing the MySQL server don't seem to have any issues.
Code: Select all
The last packet successfully received from the server was 127,054 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
11/11/13 6:41:04 AM INFO at com.linoma.dpa.security.WebUserLoginUtilities.getWebUserDetails(Unknown Source)
11/11/13 6:41:04 AM INFO at com.linoma.dpa.gftp.GFTPUserManager.handleLogin(Unknown Source)
11/11/13 6:41:04 AM INFO at com.linoma.dpa.gftp.GFTPUserManager.authenticate(Unknown Source)
11/11/13 6:41:04 AM INFO at org.apache.ftpserver.command.impl.PASS.execute(Unknown Source)
11/11/13 6:41:04 AM INFO at org.apache.ftpserver.impl.DefaultFtpHandler.messageReceived(Unknown Source)
11/11/13 6:41:04 AM INFO at org.apache.ftpserver.listener.nio.FtpHandlerAdapter.messageReceived(Unknown Source)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:722)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802)
11/11/13 6:41:04 AM INFO at org.apache.ftpserver.listener.nio.FtpLoggingFilter.messageReceived(Unknown Source)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.IoFilterEvent.fire(IoFilterEvent.java:59)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.logging.MdcInjectionFilter.filter(MdcInjectionFilter.java:137)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.util.CommonEventFilter.messageReceived(CommonEventFilter.java:70)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:392)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:228)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.filterchain.IoFilterEvent.fire(IoFilterEvent.java:59)
11/11/13 6:41:04 AM INFO at org.apache.mina.core.session.IoEvent.run(IoEvent.java:64)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTask(OrderedThreadPoolExecutor.java:552)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTasks(OrderedThreadPoolExecutor.java:544)
11/11/13 6:41:04 AM INFO at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.run(OrderedThreadPoolExecutor.java:488)
11/11/13 6:41:04 AM INFO at java.lang.Thread.run(Thread.java:619)
11/11/13 6:41:04 AM INFO Caused by: com.linoma.dpa.dao.DAOException: Communications link failure