How to remove VACUUM lock?

From: Philip Bierhoff <flip(at)win(dot)tue(dot)nl>
To: pgsql-general(at)hub(dot)org
Subject: How to remove VACUUM lock?
Date: 1998-05-22 08:40:55
Message-ID: 199805220840.KAA15515@svstud.win.tue.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guyz,

Because of some strange reason my VACUUM command resulted in a complete
halt of the database PostgreSQL 6.3 on Linux 2.0.18 (already a simple
select * resulted in a halt). I had to manually close the postmaster and
all the locked backends before I could access my database again.

Now the select * query works again, but issuing "vacuum" gives:

Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: komal

komal=> vacuum;
ERROR: can't create lock file -- another vacuum cleaner running?
komal=> vacuum;
NOTICE: CreatePortal: portal <vacuum> already exists
ERROR: can't create lock file -- another vacuum cleaner running?
komal=>

What can I do to remove this portal ?

Philip

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Lorenz 1998-05-22 09:59:48 Extending SQL with a C function
Previous Message Oleg Broytmann 1998-05-21 06:40:11 Re: permissions ..