From: | Steve Wampler <swampler(at)noao(dot)edu> |
---|---|
To: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
Cc: | "'Postgres-ODBC'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Help with hang on empty query (PG 7.3.2, |
Date: | 2003-11-10 16:47:02 |
Message-ID: | 1068482822.11726.7.camel@weaver.tuc.noao.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On Sun, 2003-11-09 at 10:15, Steve Wampler wrote:
> On Sat, 2003-11-08 at 16:33, Hiroshi Inoue wrote:
> > > -----Original Message-----
> > > From: Steve Wampler
> > >
> > > On Fri, 2003-11-07 at 09:05, Steve Wampler wrote:
> > > > I recently upgraded a system from RedHat 8 to RedHat 9, which
> > > > meant an upgrade of PG 7.2 to 7.3.2. Several applications
> > > > that are written in a language that relies upon odbc to access
> > > > postgresql have stopped working.
> > >
> > > I've now verified that the same hang occurs when using the
> > > odbctest program that comes with libiodbc.
> > >
> > > Can anyone suggest a way to track this down further? Thanks!
> >
> > Could you try to remove ENTER_CONN_CS in CC_send_query
> > in connection.c and change all RETURN_AFTER_LEAVE_CS(self, ..)
> > to "return ..(the 2nd parameter) "?
>
> Hi Hiroshi,
>
> Thanks for the suggestion. I get the same behavior, but
> the mylog file has more information in it (the other logs
> are unchanged):
I've done a bit more digging and the apps are hanging in
a call to pthread_mutex_lock() inside SC_execute(). (I had
configured the pgsqlodbc library with pthread support.)
Dropping pthread support has fixed the problem, whatever it
was...
--
Steve Wampler -- swampler(at)noao(dot)edu
Quantum materiae materietur marmota monax si marmota
monax materiam possit materiari?
From | Date | Subject | |
---|---|---|---|
Next Message | alexandre :: aldeia digital | 2003-11-10 18:30:42 | Use Declare/Fetch and PG 7.4 |
Previous Message | TANIDA Yutaka | 2003-11-10 07:28:44 | Re: Bug in SQLColumns() and SQLTables() with "Parse Statement". |