Skip site navigation (1) Skip section navigation (2)

Re: "Hanging Connection" blocks access to table (JBossMQ)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, PostGIS Development Discussion <postgis-devel(at)postgis(dot)refractions(dot)net>
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Date: 2006-10-13 15:55:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> Tom Lane wrote:
>> I don't think it'd be a net win to add cycles to every query to check
>> the connection every so often.

> The SIGIO could set a flag variable via the interrupt handler,

SIGIO isn't portable (nowhere to be seen in Single Unix Spec), and where
it does exist, it seems to report I/O ready on *any* descriptor not only
the one you want.  That would lead to a whole lot of useless interrupts
and status-checks.

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Ashish GoelDate: 2006-10-18 11:24:33
Subject: IO error while sending to backend
Previous:From: Markus SchaberDate: 2006-10-13 15:31:02
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group