From: | Clemens Eisserer <linuxhippy(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | How to diagnose application "hangs" in pg_receive? |
Date: | 2011-05-21 14:08:10 |
Message-ID: | BANLkTin_F0DVziRuw7jWn+CAB7PYKZLHew@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
A hibernate based application I wrote suffers from "hangs" - the
thread which should fetch the data is stuck at pg_receive (the
function reading back data from the socket).
My first idea were threading errors, however after careful code review
I couldn't find suspicious code.
The application doesn't do any explicit locking, an excerpt of the
locking table is at the end of the email.
Any idea what could be going wrong here?
Except a broken connction, what could be the reason for never arriving
reply from the server?
Thank you in advance, Clemens
datname | relname | mode
| granted | usename | substr |
query_start | age | procpid
-------------+--------------------------------+--------------------------+---------+----------+--------------------------------+-------------------------------+-----------------+---------
khbldb_prod | startkladde_pkey | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | startkladde |
ShareUpdateExclusiveLock | t | postgres | autovacuum: VACUUM
public.star | 2011-05-21 11:19:51.780587+01 | 03:43:21.367065 |
18241
khbldb_prod | kladde_flugnr_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_schleppid_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_lehrer_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_nachplatzid_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_bmok_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_vonplatzid_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | | ExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_datum_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | statusindex | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_pilot_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | bzbisindex | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_flugzeug_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
khbldb_prod | kladde_geschlepptid_index | RowExclusiveLock
| t | postgres | autovacuum: VACUUM public.star | 2011-05-21
11:19:51.780587+01 | 03:43:21.367065 | 18241
//No eclusive locks are held by the application:
khbldb_prod | verkauf_type_index | AccessShareLock
| t | khbl | <IDLE> in transaction | 2011-05-21
13:04:53.930505+01 | 01:58:19.217147 | 18637
khbldb_prod | rechnungsstatus_pkey | AccessShareLock
| t | khbl | <IDLE> in transaction | 2011-05-21
13:04:53.930505+01 | 01:58:19.217147 | 18637
khbldb_prod | bzbisindex | AccessShareLock
| t | khbl | <IDLE> in transaction | 2011-05-21
13:04:53.930505+01 | 01:58:19.217147 | 18637
khbldb_prod | rechnungsstatus | AccessShareLock
| t | khbl | <IDLE> in transaction | 2011-05-21
13:04:53.930505+01 | 01:58:19.217147 | 18637
khbldb_prod | kladde_lehrer_index | AccessShareLock
| t | khbl | <IDLE> in transaction | 2011-05-21
13:04:53.930505+01 | 01:58:19.217147 | 18637
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2011-05-21 15:45:19 | Re: How to diagnose application "hangs" in pg_receive? |
Previous Message | Silvio Brandani | 2011-05-20 07:48:21 | Re: Postgres Server Odbc driver compatibility matrix |