gresql.org
Subject: Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
On 31 Dec 2010, at 5:14, tamanna madaan wrote:
> Moreover, it cant be waiting for a lock as
> other processes were able to update the same table at the same time.
That only means it wasn't wa
On Fri, Dec 31, 2010 at 09:44:43AM +0530, tamanna madaan wrote:
> However, This is not a very long running query.
> This was supposed to update only one row in a table.
That it's supposed to update only one row does not mean it wasn't a
very long running query.
> Moreover, it cant be waiting for
On 31 Dec 2010, at 5:14, tamanna madaan wrote:
> Moreover, it cant be waiting for a lock as
> other processes were able to update the same table at the same time.
That only means it wasn't waiting on a TABLE-lock, occurrences of which are
quite rare in Postgres. But if, for example, an other upd
lto:t...@sss.pgh.pa.us]
Sent: Thu 12/30/2010 11:23 PM
To: tamanna madaan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
"tamanna madaan" writes:
> I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to
> connect
"tamanna madaan" writes:
> I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to
> connect
> to the databse. One of the queries I executed from my appilcation have got
> stuck for an
> indefinite amount of time causing my application to hang.
Are you sure you didn't simpl
On 30/12/2010 10:28, tamanna madaan wrote:
Hi All
I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to
connect
I'd imagine you're going to get a *flood* of responses saying this, but
here goes anyway - the version of Postgres you're using is VERY old, and
missing 21 s
Hi All
I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to
connect
to the databse. One of the queries I executed from my appilcation have got
stuck for an
indefinite amount of time causing my application to hang. So I cored the
application. The
core file gives a backtr
