[pgpool-general: 1398] Re: SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = 'import_jobs' AND c.relpersistence = 'u' sort of hangs.

[Tatsuo Ishii]

> Howdy!
> 
> I posted this to the PG general list and it was suggested that I ask it here instead.
> 
> I'll add the additional detail that this only seems to happen with jruby (jdbc) and not with ruby. Any ideas?
> 
> This query is coming from PgPool I believe.
> 
> SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = 'import_jobs' AND c.relpersistence = 'u'
> 
> This is a very small database, like 10/15 tables, it's basically empty.
> If i run this query manually, it comes back immediatly.
> However according to this it's been running for about an hour.
> 
> v3=# select now();
>               now
> -------------------------------
>  2013-02-15 21:49:34.470466+00
> (1 row)
> 
> -[ 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 WHERE c.relname = 'import_jobs' AND
> +c.relpersistence = 'u'
> 
> (I actually restarted the application and now there are 4 of these)
> 
> Any idea why the query would hang like this?
> 
> I don't see it waiting on locks or anything like that.
> 
> any ideas?

Yes, the query is generated by pgpool-II.
What pgpool and PostgreSQL version?

What does ps command show?

ps aux|grep pgpool
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp