| From: | JotaComm <jota(dot)comm(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Problems with vacuum |
| Date: | 2013-09-04 14:31:40 |
| Message-ID: | CAA8OQ6_x+AOKpTtHOiCUNJd=ORjvVTf4cpbYZt6sYNgQXV8Hog@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giuseppe Broccolo | 2013-09-04 16:26:17 | Re: FETCH FORWARD 0 and "cursor can only scan forward" error |
| Previous Message | Adrian Klaver | 2013-09-04 14:20:58 | Re: Spurious error messages from pg_restore |