Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-25 Thread K, Niranjan (NSN - IN/Bangalore)
gards, Niranjan -Original Message- From: ext Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2008 8:03 PM To: Gregory Stark Cc: K, Niranjan (NSN - IN/Bangalore); pgsql-bugs@postgresql.org Subject: Re: [BUGS] Psql or test application hangs when interface is down for the DB s

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Valentin Bogdanov
t;[EMAIL PROTECTED]> wrote: > From: Gregory Stark <[EMAIL PROTECTED]> > Subject: Re: [BUGS] Psql or test application hangs when interface is down for > the DB server > To: [EMAIL PROTECTED] > Cc: "ext Tom Lane" <[EMAIL PROTECTED]>, "K, Niranjan (NS

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Valentin Bogdanov
t;[EMAIL PROTECTED]> wrote: > From: Gregory Stark <[EMAIL PROTECTED]> > Subject: Re: [BUGS] Psql or test application hangs when interface is down for > the DB server > To: [EMAIL PROTECTED] > Cc: "ext Tom Lane" <[EMAIL PROTECTED]>, "K, Niranjan (NS

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Gregory Stark
"Valentin Bogdanov" <[EMAIL PROTECTED]> writes: > I have noticed this as well. Blocks in poll(), timeout parameter -1, Oh good point. non-blocking sockets and poll/select let you control the timeout too. > meaning infinite then after 4 minutes on my system poll() returns 1 and > getsockopt() i

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Valentin Bogdanov
your own timeout value. Regards Val --- On Wed, 16/7/08, K, Niranjan (NSN - IN/Bangalore) <[EMAIL PROTECTED]> wrote: > From: K, Niranjan (NSN - IN/Bangalore) <[EMAIL PROTECTED]> > Subject: Re: [BUGS] Psql or test application hangs when interface is down for > the DB serve

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "K, Niranjan (NSN - IN/Bangalore)" <[EMAIL PROTECTED]> writes: >> Is there any other workaround or alternative so that the situation about >> the interface is down is known and based on that the 'PQexec' does not >> get blocked for ~15 minutes. > Absent

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-16 Thread Gregory Stark
"K, Niranjan (NSN - IN/Bangalore)" <[EMAIL PROTECTED]> writes: > Is there any other workaround or alternative so that the situation about > the interface is down is known and based on that the 'PQexec' does not > get blocked for ~15 minutes. Absent threads I think you have to use alarm() and a SI

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-15 Thread K, Niranjan (NSN - IN/Bangalore)
- IN/Bangalore) Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] Psql or test application hangs when interface is down for the DB server "K, Niranjan (NSN - IN/Bangalore)" <[EMAIL PROTECTED]> writes: > In the postgres database there is table 'COUNTER_TABLE' with column

Re: [BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-15 Thread Tom Lane
"K, Niranjan (NSN - IN/Bangalore)" <[EMAIL PROTECTED]> writes: > In the postgres database there is table 'COUNTER_TABLE' with column > integer type 'COUNTER'. The test application attached in this mail, will > start a transaction, gets the current value in the COUNTER, increments > the value and up

[BUGS] Psql or test application hangs when interface is down for the DB server

2008-07-15 Thread K, Niranjan (NSN - IN/Bangalore)
Hi, Environment used: Postgres 8.3.1 psqlODBC 08.03.0200 Testcase: In the postgres database there is table 'COUNTER_TABLE' with column integer type 'COUNTER'. The test application attached in this mail, will start a transaction, gets the current value in the COUNTER, increments the value and