Re: Problem in SQLFreeHandle (Statement)

On 06/12/2014 05:30 AM, Jade Koskela wrote:
> Hello,
> I am using psql-odbc 9.3 on OSX.

Which version, exactly? There were some changes to locking in
SQLFreeHandle in 09.03.0200. Not sure if those changes might've fixed
this, or caused it.

Can easily you test on another platform, or with different version of
unixODBC?

> I have one thread running a query, and
> another thread cancels the query using SQLCancel. The thread running the
> query successfully cancels and exits the driver code. When we try to free
> the statement handle, it blocks on a mutex doing ENTER_CONN_CS, or
> something similar in SQLFreeHandle.
>
> Does anyone have any input on this problem? I don't see who is holding the
> mutex, the thread running the query is done.

I tried to reproduce this with the attached little test program. It
works fine. Can you post the test program you're using, or modify the
attached so that it exhibits the behavior you're seeing, please?

- Heikki