pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_vlock / vacuum
2+ messages / 2 participants
[nested] [flat]

* pg_vlock / vacuum
@ 2002-02-01 14:36  David M. Richter <d.richter@dkfz-heidelberg.de>
  0 siblings, 1 reply; 2+ messages in thread

From: David M. Richter @ 2002-02-01 14:36 UTC (permalink / raw)
  To: pgsql-sql

Hello!

Ive got that message:

psql -c vacuum

NOTICE:  LockRelease: locktable lookup failed, no lock
ERROR:  Can't create lock file.  Is another vacuum cleaner running?
        If not, you may remove the pg_vlock file in the
/usr/local/pgsql/data/base/chili
        directory

Whats about this?
We are using Suse Linux 7.3 with postgres 6.5.3.

I cannot see a file named pg_vlock in that directory!

Did anyone of You got the same message?
Any experiences with pg_vlock?
What is pg_vlock exactly doing?

I will thankful appreciate every hint!

DAvid

Attachments:

d.richter.vcf (text/x-vcard, 498B) download begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum/German Cancer Research Center;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-17024 fn:David M. Richter end:vcard
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: pg_vlock / vacuum
@ 2002-02-01 20:39  Tom Lane <tgl@sss.pgh.pa.us>
  parent: David M. Richter <d.richter@dkfz-heidelberg.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2002-02-01 20:39 UTC (permalink / raw)
  To: David M. Richter <d.richter@dkfz-heidelberg.de>; +Cc: pgsql-sql

"David M. Richter" <d.richter@dkfz-heidelberg.de> writes:
> We are using Suse Linux 7.3 with postgres 6.5.3.

6.5.3?  Run, do not walk, to your nearest FTP server and get an update.

> I cannot see a file named pg_vlock in that directory!

Possibly restarting the postmaster would get you out of trouble.

However, the list of bugs fixed since 6.5.* is longer than you
really want to know about.  Please update ASAP.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-02-01 20:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-01 14:36 pg_vlock / vacuum David M. Richter <d.richter@dkfz-heidelberg.de>
2002-02-01 20:39 ` Tom Lane <tgl@sss.pgh.pa.us>

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