Symptom
- A database user executes a query that may be taking a long time to complete and cancels the query. The query plan involves [Exchange] tasks.
- The user disconnects from the database, but running the system stored procedure sa_conn_info() / sa_locks() shows that the user still has an active connection or held locks.
- The TCP/IP port for the database client is closed (if using a TCP/IP network connection for database communications).
- The SQL statement "DROP CONNECTION <connection-id>" returns successfully, without dropping the connection.
- The connection is consuming active CPU cycles.
- The connection ID for the active connection exceeds the number 1,000,000,000.
- The public database option MAX_QUERY_TASKS is set to "0" (the default) or a number higher than "1".
Read more...
Environment
- SAP Sybase SQL Anywhere 10 (all platforms)
- SAP Sybase SQL Anywhere 11 (all platforms)
- SAP Sybase SQL Anywhere 12 (all platforms)
Product
SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0
Keywords
11645875 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.