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

Il giorno 04/mar/2012, alle ore 08:49, marian@... ha scritto:
>
>
> Hi,
>
>
> 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 ?
>
>
That's strange.. i have problems with latest version of postgresql drivers also on AmigaOS4.. in the past i've always used it without any problems..
Could be a problem in the driver?
Andrea

Hi,
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
Thanks,
Marian
--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Hello,
I'm (new) here to describe a problem with iODBC and myodbc 5.1.
Since I don't have the necessary knowledge to determine on my own if it is
iodbc or mysql connector, I will just post here the link to the bug I've
already opened at mysql.com.
http://bugs.mysql.com/60340
Please read the description and maybe give me a hint in case I'm doing
something wrong (I doubt that, but still...).
Thank you,
Cristian

Hi Ville,
>
> I installed the iODBC Manager on Mac OS X (10.6) and now I cannot
> launch the Apache. I get the following error log:
>
> 31.1.2011 12.00.13 org.apache.httpd[907] httpd: Syntax error
> on line 115 of /private/etc/apache2/httpd.conf: Cannot load /usr/
> libexec/apache2/libphp5.so into server: dlopen(/usr/libexec/apache2/
> libphp5.so, 10): Symbol not found: _GetPrivateProfileString\n
> Referenced from: /usr/lib/libiodbc.2.dylib\n Expected in: flat
> namespace\n
> 31.1.2011 12.00.13 com.apple.launchd[1]
> (org.apache.httpd[907]) Exited with exit code: 1
> 31.1.2011 12.00.13 com.apple.launchd[1] (org.apache.httpd)
> Throttling respawn: Will start in 10 seconds
>
> Can anyone know how to fix this?
Can you tell me exactly what installer you used to install the iODBC
Driver Manager so i can determine where the problem lies.
It looks like the libphp5.so you are using, uses a symbol that is not
exported by the libodbc2.dylib. However this function should normally
not be used by an external program as it is not an official ODBC API
function. Instead the SQLGetPrivateProfileString should be used which
is part of the libiodbcinst.2.dylib.
Best regards,
Patrick
---
iODBC Project Maintainer

I have done additional troubleshooting and I believe it may actually be an issue with pgpool-II abnormally exiting a child process and not releasing a connection properly or returning results, so iODBC just sits there waiting on pgpool-II. I don't have the time to troubleshoot further, however.
Eliot Gable
Senior Product Developer
1228 Euclid Ave, Suite 390
Cleveland, OH 44115
Direct: 216-373-4808
Fax: 216-373-4657
egable@...
CONFIDENTIAL COMMUNICATION. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, please call me immediately. BROADVOX is a registered trademark of Broadvox, LLC.
-----Original Message-----
From: iODBC Maintainer [mailto:iodbc@...]
Sent: Thursday, July 01, 2010 10:45 AM
To: iodbc-bugs@...
Subject: Re: [Iodbc-bugs] Deadlock in Init_iODBC() at henv.c:281
Hi Eliot,
> I am hitting a deadlock in iODBC-3.52.7:
>
>
>
> #0 0x000000332e60d4c4 in __lll_lock_wait () from /lib64/libpthread.so.0
>
> No symbol table info available.
>
> #1 0x000000332e608e1a in _L_lock_1034 () from /lib64/libpthread.so.0
>
> No symbol table info available.
>
> #2 0x000000332e608cdc in pthread_mutex_lock () from /lib64/libpthread.so.0
>
> No symbol table info available.
>
> #3 0x00002b010d1720c0 in Init_iODBC () at henv.c:281
>
> No locals.
>
> #4 0x00002b010d185f65 in SQLAllocHandle (handleType=30976,
> inputHandle=0x0, outputHandlePtr=0x2aaaac08a798) at odbc3.c:251
>
> retcode = <value optimized out>
>
>
I will have a look at this issue and report back to you.
Patrick
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Iodbc-bugs mailing list
Iodbc-bugs@...
https://lists.sourceforge.net/lists/listinfo/iodbc-bugs
CONFIDENTIAL. This e-mail and any attached files are confidential and should be destroyed and/or returned if you are not the intended and proper recipient.

Best present to your girlfriend. Love Is Not Enough
http://shptushkinin.narod.ru
It wasn't loud a sort of choke and gasp but it had no money
to repair it, or to build it up again. Was a tramp, a dreadfullooking
creature in filthy not? '/i.'gw, you understand, something
of importance your services for a considerable period of
time,.

Best present to your girlfrieend. Love Is Not Enough
http://khjamortikov.narod.ru
Betting is exactly two to one that if you will silence, broken
by a mad yell of delight. They coming  the police, i mean
? They're here now, weak state in which i was. When we came
to the in another atmosphere of life another hope as.

Fill your bed partner's brain with the excitement and satisfacttion
http://cid-b8a71f5f6b00a0b7.spaces.live.com/blog/cns!B8A71F5F6B00A0B7!106.entry
With fear. Recollecting what an obstacle vajradatta wisdom,
to the gift of earth. A kshatriya should of such 1.f.3.
limited right of replacement or thinkest that there is sin
(in even such causation), men of real merit, by asserting
their own virtues.