Re: [Iodbc-bugs] hang at SQLAllocStmt]

[Patrick v. K. <pk...@op...>]

Hi Marian,

> 
> 
>    I am running into a death lock with iODBC and postgreSQL for function
> SQLAllocStmt().
> The stack in the always the same and it hangs when SQLAllocStmt() is reached.
> 
>    The same code works with unixODBC. Is there any way to baypass that
> lock ? Anyone seen this problem before ?
> 
> 
> #0  0x00007f2113f4ec74 in __lll_lock_wait () from
> /usr/local/thekompany/lib/libpthread.so.0
> #1  0x00007f2113f4a179 in _L_lock_953 () from
> /usr/local/thekompany/lib/libpthread.so.0
> #2  0x00007f2113f49f9b in pthread_mutex_lock () from
> /usr/local/thekompany/lib/libpthread.so.0
> #3  0x00007f2116580f72 in SQLAllocStmt (hdbc=0x2dd47c0, phstmt=0x80) at
> hstmt.c:427
> #4  0x00007f2116580a08 in SQLAllocStmt_Internal (hdbc=0x2a03670,
> phstmt=0x2d91750) at hstmt.c:241
> #5  0x00007f2116590d32 in SQLAllocHandle (handleType=3,
> inputHandle=0x2a03670, outputHandlePtr=0x2d91750) at odbc3.c:276
> 

What version of iODBC are you using at this time. Also it will help if I know either version of the PostgreSQL ODBC driver you are using as well as the OS.

Also please add the following lines to your ODBC.ini file:

    [ODBC]
    TraceFile = /tmp/iodbc.log
    Trace =1

Next run your app again and send me the output of this trace for analysis as well.


Patrick
--
OpenLink Software