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 pgpool list - 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 jruby. I have standard ruby programs where this does not occur. - On Friday, February 15, 2013 01:58:55 PM David Kerr wrote: - > Howdy! - > - > 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? - > - > Thanks - -- - René Romero Benavides @iCodeiExist @PgsqlMx - - Postgresql Tips en español para la comunidad de México e Hispanoamérica. - http://postgresql.org.mx - - - - - -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
