Skip site navigation (1) Skip section navigation (2)

VACUUM warning/error (?)

From: Nicolas Kowalski <Nicolas(dot)Kowalski(at)imag(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM warning/error (?)
Date: 2001-01-18 08:36:29
Message-ID: (view raw or whole thread)
Lists: pgsql-admin

We are running a small Intranet database, using PostgreSQL 7.0.2 on a
Debian GNU/Linux 2.2 server. All works fine. Great job PostgreSQL guys !

However, I used to backup our database every night (pg_dumpall), and
now, I want to clean up it just before the dump, when nobody uses it.
The command is : 

# echo "VACUUM" | su -c "psql datavm" - postgres

...but the cron daemon just told me this morning :

NOTICE:  FlushRelationBuffers(trace_sql, 162): block 239 is referenced
0, global 1)
FATAL 1:  VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
connection to server was lost

All seems to work, in particular this 'trace_sql' table, but what does
mean this error message ?



pgsql-admin by date

Next:From: Richie DugganDate: 2001-01-18 11:44:20
Subject: Pictures(.gif)
Previous:From: Arathi,SDate: 2001-01-18 05:47:53
Subject: Problems in creating table while migrating from Foxpro to Postgress using JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group