agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feed(no subject)
3+ messages / 3 participants
[nested] [flat]
* (no subject)
@ 1995-02-02 13:52 Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>
1995-02-02 19:14 ` (no subject) Jolly Chen <jolly@postgres.Berkeley.EDU>
0 siblings, 1 reply; 3+ messages in thread
From: Sibel Clark @ 1995-02-02 13:52 UTC (permalink / raw)
To: legacy
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
==============================================================================
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* (no subject)
1995-02-02 13:52 (no subject) Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>
@ 1995-02-02 19:14 ` Jolly Chen <jolly@postgres.Berkeley.EDU>
1995-02-06 21:34 ` Re: vacuum Robert.Patrick@cs.cmu.edu
0 siblings, 1 reply; 3+ messages in thread
From: Jolly Chen @ 1995-02-02 19:14 UTC (permalink / raw)
To: Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>; +Cc: legacy
>
> 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: vacuum
1995-02-02 13:52 (no subject) Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>
1995-02-02 19:14 ` (no subject) Jolly Chen <jolly@postgres.Berkeley.EDU>
@ 1995-02-06 21:34 ` Robert.Patrick@cs.cmu.edu
0 siblings, 0 replies; 3+ messages in thread
From: Robert.Patrick@cs.cmu.edu @ 1995-02-06 21:34 UTC (permalink / raw)
To: legacy; +Cc: legacy
I have a similar problem; every time I run vacuum, I get the following error:
FATAL: no response from backend: detected in PQexec
Removing the pg_vlock allows me to run the command again but I still get
the error.
The thing is that I can here the command working (i.e., the disk grinds
for 15-20 seconds even though the database is small). It seems to me
that the problem is being caused by the vacuum command itself.
Robert
==============================================================================
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1995-02-06 21:34 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-02-02 13:52 Sibel Clark <sclark%sparc2@ksv1001.ksc.nasa.gov>
1995-02-02 19:14 ` Jolly Chen <jolly@postgres.Berkeley.EDU>
1995-02-06 21:34 ` Re: vacuum Robert.Patrick@cs.cmu.edu
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox