Too frequent warnings for wraparound failure

From: "Milen A(dot) Radev" <milen(at)securax(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Too frequent warnings for wraparound failure
Date: 2005-03-08 11:36:31
Message-ID: 422D8E3F.3070302@securax.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I have installed a script that executes vacuumdb for all DBs in my
cluster (run by cron every night):

BEGIN------------------------------------------------
#!/bin/sh
# cron script to vacuum pgsql databases
#

PG_VACUUM_LOG=/var/log/pg_vacuum

echo Starting at `date "+%Y-%m-%d %H:%M:%S"` >> $PG_VACUUM_LOG
exec /usr/local/pgsql/bin/vacuumdb -U postgres -h localhost \
- --all --analyze >>$PG_VACUUM_LOG 2>&1

END--------------------------------------------------

I review the log every morning. In the beginning I got "wraparound
failure" warnings every third day. But from a week I got those warnings
every day. Well we have one table in one database where there are a lot
of inserts, but not that many - around 30-40 thousand per day.

Any ideas what could be cause? And is it an symptom for some kind of
failure coming?

Here is the excerpt from the log (for today and yesterday):

Starting at 2005-03-07 02:25:04
vacuumdb: vacuuming database "xxx1"
WARNING: some databases have not been vacuumed in 1774832854 transactions
HINT: Better vacuum them within 372650793 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx2"
WARNING: some databases have not been vacuumed in 1774828277 transactions
HINT: Better vacuum them within 372655370 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx3"
WARNING: some databases have not been vacuumed in 1774893888 transactions
HINT: Better vacuum them within 372589759 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "template1"
WARNING: some databases have not been vacuumed in 1774909701 transactions
HINT: Better vacuum them within 372573946 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx4"
WARNING: some databases have not been vacuumed in 1774907572 transactions
HINT: Better vacuum them within 372576075 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx5"
WARNING: some databases have not been vacuumed in 1774908235 transactions
HINT: Better vacuum them within 372575412 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx6"
WARNING: some databases have not been vacuumed in 1774903764 transactions
HINT: Better vacuum them within 372579883 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx7"
WARNING: some databases have not been vacuumed in 1774905224 transactions
HINT: Better vacuum them within 372578423 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx8"
WARNING: some databases have not been vacuumed in 1774904273 transactions
HINT: Better vacuum them within 372579374 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx9"
WARNING: some databases have not been vacuumed in 1774814127 transactions
HINT: Better vacuum them within 372669520 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx10"
VACUUM

Starting at 2005-03-08 02:25:57
vacuumdb: vacuuming database "xxx1"
WARNING: some databases have not been vacuumed in 1744400306 transactions
HINT: Better vacuum them within 403083341 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx2"
WARNING: some databases have not been vacuumed in 1744361223 transactions
HINT: Better vacuum them within 403122424 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx3"
WARNING: some databases have not been vacuumed in 1744427176 transactions
HINT: Better vacuum them within 403056471 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "template1"
WARNING: some databases have not been vacuumed in 1744450173 transactions
HINT: Better vacuum them within 403033474 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx4"
WARNING: some databases have not been vacuumed in 1744460006 transactions
HINT: Better vacuum them within 403023641 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx5"
WARNING: some databases have not been vacuumed in 1744461917 transactions
HINT: Better vacuum them within 403021730 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx6"
WARNING: some databases have not been vacuumed in 1744465388 transactions
HINT: Better vacuum them within 403018259 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx7"
WARNING: some databases have not been vacuumed in 1744466073 transactions
HINT: Better vacuum them within 403017574 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx8"
WARNING: some databases have not been vacuumed in 1744464553 transactions
HINT: Better vacuum them within 403019094 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx9"
WARNING: some databases have not been vacuumed in 1744489170 transactions
HINT: Better vacuum them within 402994477 transactions, or you may have
a wraparound failure.
VACUUM
vacuumdb: vacuuming database "xxx10"
VACUUM

- --
Milen A. Radev
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCLY4/qGlhYx0/sboRAoIiAJ9KAYFVnJIt1IKHhYnXplgWo4PmlACfQFSA
T226YAeea82Jxf3fAg4V96o=
=xRrs
-----END PGP SIGNATURE-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-03-08 13:59:25 Re: help!!!!!!
Previous Message Matteo Beccati 2005-03-08 08:59:20 Re: Postgres schema comparison.