Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id LAA26283 for postgres-redist; Thu, 2 Feb 1995 11:14:45 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199502021914.LAA26283@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from arcadia.CS.Berkeley.EDU (arcadia.CS.Berkeley.EDU [128.32.37.59]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id LAA26273 for ; Thu, 2 Feb 1995 11:14:44 -0800 Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by arcadia.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id LAA27095; Thu, 2 Feb 1995 11:14:01 -0800 Message-Id: <199502021914.LAA27095@arcadia.CS.Berkeley.EDU> X-Authentication-Warning: arcadia.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol To: sclark%sparc2@ksv1001.ksc.nasa.gov (Sibel Clark) cc: postgres@postgres.Berkeley.EDU In-reply-to: Your message of "Thu, 02 Feb 95 13:52:47 EST." <9502021852.AA03909@sparc2> Date: Thu, 02 Feb 95 11:14:01 -0800 From: Jolly Chen Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Thu, 02 Feb 95 11:14:45 -0800 Resent-XMts: smtp > > 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/