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
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
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Add the following lines below the existing configuration entries in the DATABASE.XML:
*Note*
If you have more than one node (clustered) this change will have to be made on each node!
Code: Select all
This change will perform a validation query to test borrowed connections to see if they are up before they try to use them.<entry key="validationQuery">SELECT 1</entry>
<entry key="testOnBorrow">true</entry>
*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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1