agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Jolly Chen <jolly@postgres.Berkeley.EDU>
To: Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>
Cc: postgres@postgres.Berkeley.EDU
Date: Thu, 02 Feb 95 11:14:01 -0800
Message-ID: <199502021914.LAA27095@arcadia.CS.Berkeley.EDU> (raw)
In-Reply-To: <9502021852.AA03909@sparc2>


> 
> Hi,
> 
> Everytime we decide to use "vacuum" command on our database, we get the following fail message.  We can't find another vacuum cleaner running anywhere.
> What can be the cause of this?
> 
> Here is the message:
> 
> % vacuum dles
> WARN:Feb  2 13:12:06:can't create lock file -- another vacuum cleaner running?
> vacuum: database vacuum failed on dles.
> 
> Thanks,
> 
> Sibel Clark 
> 

Check to see if you have a file named pg_vlock in your database
directory.  The vacuum cleaner creates it and deletes it when finished,
but perhaps you have one left over from a vacuum cleaner process that
died prematurely due to some failure.

- Jolly Chen

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/

reply

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: postgres@postgres.berkeley.edu
  Cc: jolly@postgres.Berkeley.EDU, sclark%sparc2@ksv1001.ksc.nasa.gov
  Subject: Re: 
  In-Reply-To: <199502021914.LAA27095@arcadia.CS.Berkeley.EDU>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox