Used SA 12 (12.0.1 EBF 3311 on Linux; EBF 3324 on Windows). We have seen lock tables (using sa_locks() stored procedure). Than we try to drop some connections using DROP CONNECTION 'CONNID' command or using 'Disconnect' option in Sybase Central Connections folder. In both case it seems that connection is dropped, but when we check again connections exist and 'Last Request Type' is Fetch. Moreover we have restart application (java server based on JBOSS), connection still appears in connection list and in sa_locks() result. In Sybase Central 'Overview' folder message 'The number of requests waiting to be fullfilled: 6' appears. We will not stop/kill database server, want understand what is caused to this problem. Size of database is around 25G, running on Linux machine. Query/reports is running on tables having 173M and 63M records. Please help, explain drop connection problem
asked 05 Oct '11, 13:54
There is a known issue (CR #702733 - 22.214.171.12486, 126.96.36.19913) which allows connections to be 'undroppable' in rare circumstances (usually involving a parallelized query that makes use of a HashFilter). Setting the connection option 'MAX_QUERY_TASKS' to '1' or restarting the database server is a workaround for the issue.
For more information about this issue, see my response to this question here: http://sqlanywhere-forum.sap.com/questions/6164/connections-that-cannot-be-dropped/6197
answered 30 Mar '12, 14:20