SAP Knowledge Base Article - Preview

1934862 - DROP CONNECTION fails to drop an active connection from a SQL Anywhere database

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.