Timeout errors since migrating to MySQL

Post any question you may have in regards to GoAnywhere Services and let our talented support staff and other users assist you.

Timeout errors since migrating to MySQL

Postby mathyou2 » 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.

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
mathyou2
 
Posts: 2
Joined: Sun Feb 19, 2012 1:33 am

Re: Timeout errors since migrating to MySQL

Postby Support_Rick » Wed Nov 13, 2013 3:03 pm

Add the following lines below the existing configuration entries in the DATABASE.XML:

Code: Select all
<entry key="validationQuery">SELECT 1</entry>
<entry key="testOnBorrow">true</entry>


This change will perform a validation query to test borrowed connections to see if they are up before they try to use them.

*Note*
If you have more than one node (clustered) this change will have to be made on each node!
Rick Elliott
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 172
Joined: Tue Jul 17, 2012 2:12 pm


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest