How to remove VACUUM lock?
От | Philip Bierhoff |
---|---|
Тема | How to remove VACUUM lock? |
Дата | |
Msg-id | 199805220840.KAA15515@svstud.win.tue.nl обсуждение исходный текст |
Ответы |
Re: [GENERAL] How to remove VACUUM lock?
|
Список | 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
В списке pgsql-general по дате отправления: