cannot kill MaxDB-ODBC session

[hubert_heitzer]

Hello,

we use MaxDB Rel. 7.7.07.028 and Database Manager 7.6.

I tried to kill an ODBC-session with Database Manager -> Menu "Instance" -> Sessions.

The session did remain, even when the client, which initiated the ODBC-request was shutdown.

What else can I do to kill such sessions?

Regards, Hubert

[Former Member · Accepted solution]

Hello Hubert,

the kill session doesn't really terminates the kernel task.

It only sends a cancel request to the kernel and terminates the connection.

The kernel self checks for this cancel request and terminates the task.

It is a good will action and should ensure consistency.

On an infinite loop in case of an errror the cancel byte will never check.

Kind regards,

Burkhard

btw. ODBC reconnects automatically with the next command if it has detected connection problems.

[former_member206552]

Hi Hubert,

please have a look at the following

http://lists.mysql.com/maxdb/3733

Best Regards

Marius