Postgres Pro
Downloads
Home   >   mailing lists

Problems with vacuum - Mailing list pgsql-general

From JotaComm
Subject Problems with vacuum
Date
Msg-id CAA8OQ6_x+AOKpTtHOiCUNJd=ORjvVTf4cpbYZt6sYNgQXV8Hog@mail.gmail.com
Whole thread Raw
Responses Re: Problems with vacuum  (sachin kotwal <kotsachin@gmail.com>)
List pgsql-general
Tree view
Hello, everbody

I have the following problem: My vacuum is running since 2013-08-27 18:58:41.527238-03.

billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]------------------
timestamp | 2013-09-04 11:23:06

billing=# SELECT pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.query_start FROM pg_stat_activity WHERE pg_stat_activity.current_query ~ 'public.mensagem' AND pg_stat_activity.procpid!=pg_backend_pid();
-[ RECORD 1 ]-+-----------------------------------------------------------
procpid       | 2738
current_query | autovacuum: VACUUM public.mensagem (to prevent wraparound)
query_start   | 2013-08-27 18:58:41.527238-03

I tried to cancel it but unsuccessful.

billing=# SELECT pg_cancel_backend(2738);
-[ RECORD 1 ]-----+--
pg_cancel_backend | t

billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]------------------
timestamp | 2013-09-04 11:23:18

billing=# SELECT pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.query_start FROM pg_stat_activity WHERE pg_stat_activity.current_query ~ 'public.mensagem' AND pg_stat_activity.procpid!=pg_backend_pid();
-[ RECORD 1 ]-+-----------------------------------------------------------
procpid       | 2738
current_query | autovacuum: VACUUM public.mensagem (to prevent wraparound)
query_start   | 2013-08-27 18:58:41.527238-03

Any idea? Any tips?

Best regards

--
JotaComm
http://jotacomm.wordpress.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Spurious error messages from pg_restore
Next
From: Giuseppe Broccolo
Date:
Subject: Re: FETCH FORWARD 0 and "cursor can only scan forward" error