Thread: Problems with vacuum
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
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
Please look at following topic:- http://www.postgresql.org/docs/9.0/static/functions-admin.html try using #SELECT pg_terminate_backend(2738); ----- Thanks and Regards, Sachin Kotwal NTT-DATA-OSS Center (Pune) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Problems-with-vacuum-tp5769548p5772158.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.