Search Postgresql Archives

vacuum process is hanging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings,
I've got an 8.1.10 instance running on Linux-i686.  The system hosts 5
databases, all of which get vacuumed via a cronjob 3 times a day.  All
of a sudden, the vacuum job for 1 of the databases is hanging
indefinitely.  It normally finishes in under 5 minutes.  There are no
errors in the output, it just stops producing any output.  The command
that I'm running is "vacuumdb -v -z -f -d inventory".  I also tried
removing the -z and -f options to see if that would at least get it to
complete, but that had no impact.  Here's the tail end of the output,
leading up to the hang:

INFO:  vacuuming "public.cuhc"
INFO:  index "cuhc_system_key" now contains 0 row versions in 4 pages
DETAIL:  1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "cuhc_system_index" now contains 0 row versions in 4 pages
DETAIL:  1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "cuhc_syststamp_index" now contains 0 row versions in 4 pages
DETAIL:  1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "cuhc_syststamprebooted_index" now contains 0 row
versions in 4 pages
DETAIL:  1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "cuhc": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  vacuuming "pg_toast.pg_toast_85894"
INFO:  index "pg_toast_85894_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_85894": found 0 removable, 0 nonremovable row
versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.


Anyone have any suggestions on what to try to debug this?

thanks!

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux