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.
2 posts Page 1 of 1

mathyou2

Posts: 2
Joined: Sun Feb 19, 2012 1:33 am

Post by 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

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by 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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1