we switched one of our production server systems from ASA 9 to ASA 12 (64 bit).
The database is running on one VM and there are three other VM's running EAServer that are connecting to the database using the ASA 12 32 bit odbc driver using TCP/IP. Liveness timeout is set to 0 and idle timeout is set to 240.
We are getting random disconnects of the connections from the EAServer processes. The time between these is much less than the 240 minutes in the idle timeout. The majority of the time it runs fine, but we get these disconnects about every 30 minutes on each server. They do not happen at the same time on all servers. We see the disconnects as the EAServer is processing a query and gets an error back stating the the connection was terminated cm__odbc_error: SQLError: -308, SQLState: 08S01, [Sybase][ODBC Driver][SQL Anywhere]Connection was terminated.
asked 31 Oct '11, 14:58
We are aware of one issue affecting heavily loaded servers and disconnecting clients:
We are also aware of other bugs in the database server that may cause sporadic connection drops:
We have also had sporadic reports of TCP/IP "localhost" connections dropping in some virtualized environments, although we strongly suspect these are related to underlying OS issues with name resolution as changing the client connection to use "127.0.0.1" as the target address for the server have resolved the issue.
Other timeouts or disconnections would currently be undiagnosed and would likely require additional investigation via a technical support case.
answered 20 Nov '13, 11:07