Re: PG9.2.3. Query hanging: SELECT count(*) FROM pg_catalog.pg_class...

On Fri, Feb 15, 2013 at 07:01:20PM -0600, Ren Romero Benavides wrote:
- I can confirm it comes from pgpool, and is very weird , I guess the pgp=
ool list=20
- would be a better fit.
- Cheers.

hmm, ok thanks I'll post there as well.

Also, if anyone else stumbles upon this, it only seems to happen with jru=
by.
I have standard ruby programs where this does not occur.



- On Friday, February 15, 2013 01:58:55 PM David Kerr wrote:
- > Howdy!
- >=20
- > This query is coming from PgPool I believe.
- >=20
- > SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname =3D
- > 'import_jobs' AND c.relpersistence =3D 'u'
- >=20
- > This is a very small database, like 10/15 tables, it's basically empt=
y.
- > If i run this query manually, it comes back immediatly.
- > However according to this it's been running for about an hour.
- >=20
- > v3=3D# select now();
- >               now
- > -------------------------------
- >  2013-02-15 21:49:34.470466+00
- > (1 row)
- >=20
- > -[ RECORD 5
- > ]----+---------------------------------------------------------------=
------
- > ------------------------------------ datid            | 16389
- > datname          | v3
- > pid              | 13905
- > usesysid         | 20415
- > usename          | workling
- > application_name |
- > client_addr      | 10.0.0.132
- > client_hostname  |
- > client_port      | 58009
- > backend_start    | 2013-02-15 20:49:09.098768+00
- > xact_start       | 2013-02-15 20:49:09.189625+00
- > query_start      | 2013-02-15 20:49:09.198742+00
- > state_change     | 2013-02-15 20:49:09.198743+00
- > waiting          | f
- > state            | active
- > query            | SELECT count(*) FROM pg_catalog.pg_class AS c WHER=
E
- > c.relname =3D 'import_jobs' AND c.relpersistence =3D 'u'
- >=20
- > (I actually restarted the application and now there are 4 of these)
- >=20
- > Any idea why the query would hang like this?
- >=20
- > I don't see it waiting on locks or anything like that.
- >=20
- > any ideas?
- >=20
- > Thanks
- --=20
- Ren=E9 Romero Benavides @iCodeiExist @PgsqlMx=20
-=20
- Postgresql Tips en espa=F1ol para la comunidad de M=E9xico e Hispanoam=E9=
rica.
- http://postgresql.org.mx=20
-=20
-=20
-=20
-=20
-=20