We have a SQL Anywhere 12 64-bit installation using the most recent 3519 EBF running under Linux. From our ETL application we get the following error though only intermittently:
Error connecting to database: (using class sybase.jdbc4.sqlanywhere.IDriver) [Sybase][JDBC Driver][SQL Anywhere]Connection error: Timeout occurred while waiting for connection response
I enabled the LOG connection parameter on the client to try and get more detailed logging. This has shown the following: Communication function sconn::receive code 4
I cannot find much information if any in the Sybase documentation on this error. I've looked at CPU, memory and IO on the db server using iostat during times we get this error and it doesn't seem to be stressed. We do have Foxhound running to monitor our Production database but haven't found any ovbious problem like blocked or excessive waiting connections. I'd appreciate any information to help further troubleshoot. Thanks.
asked 22 Mar '12, 21:33
This means that the client made a connection to the database server and then sent a packet but waited for the timeout value (30 seconds for TCP/IP, 5 minutes for shared memory) without receiving a response from the server. This could happen if the server is very busy or (for TCP/IP connections) if there is an intermittent network problem in between the two machines.
Try using the
answered 22 Mar '12, 23:27