From: hjeancha@freesurf.fr
To: pgsql-admin@postgresql.org
Subject: vacuumdb not enough stack items
Date: Sat, 21 Jun 2008 15:47:52 +0200
Message-ID: <20080621154752.33867bg7xhmsv04c@webmail-html.freesurf.fr> (raw)
Hi,
i use postgresql version7.4.7 on i386-pc-linux-gnu, autovacuum is
configured to run on this database.
But recently, we lost data for a database, we were able to connect the
database but we couldn't see any table anymore.
I suspected a transaction ID wraparound, and to fix it, i just
imported data from a dump file.
I tried to execute the following query:
SELECT datname, age(datfrozenxid) FROM pg_database where age(datfrozenxid)<0;
template1=# SELECT datname, age(datfrozenxid) FROM pg_database where
age(datfrozenxid)<0;
datname | age
------------------------------------------+-------------
template0 | -597653514
ez_info1 | -205024652
XtDB | -205024658
Does the negative value of age means that a transaction ID wraparound
has already occured?
Doing a manual vacuumdb on each database raise an error message saying:
vacuumdb: vacuuming of database "ez_info1" failed: ERREUR: not enough
stack items
Have you an idea about what is happening,
Thank you for any suggestion.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: hjeancha@freesurf.fr
Subject: Re: vacuumdb not enough stack items
In-Reply-To: <20080621154752.33867bg7xhmsv04c@webmail-html.freesurf.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox