Message-ID: <20080621154752.33867bg7xhmsv04c@webmail-html.freesurf.fr>
Date: Sat, 21 Jun 2008 15:47:52 +0200
From: hjeancha@freesurf.fr
To: pgsql-admin@postgresql.org
Subject: vacuumdb not enough stack items
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1;
	DelSp="Yes";
	format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
User-Agent: Internet Messaging Program (IMP) H3 (4.2-RC2)

Hi,

i use postgresql version7.4.7 on i386-pc-linux-gnu, autovacuum is =20
configured to run on this database.
But recently, we lost data for a database, we were able to connect the =20
database but we couldn't see any table anymore.
I suspected a transaction ID wraparound, and to fix it, i just =20
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=3D# SELECT datname, age(datfrozenxid) FROM pg_database where =20
age(datfrozenxid)<0;
                  datname                  |     age
------------------------------------------+-------------
  template0                                |  -597653514
  ez_info1                                 |  -205024652
  XtDB                                     |  -205024658


Does the negative value of age means that a transaction ID wraparound =20
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 =20
stack items

Have you an idea about what is happening,

Thank you for any suggestion.