Thread: Vacuum and deadlock.

Vacuum and deadlock.

From
Sébastien HEITZMANN
Date:
Since some week I have some trouble with my database. I use postgres v 7.1.2 on redhat 7.0
 
The trouble is that the database lock when in the night some user left an application open ( which do some read on some table) and the night process of backup and vacuum happend.
The database stay in a deadlock until I restart it manually on the morning.
 
At the moment I've told the users to stop their application but it's not really a solution.
 
Does someone have any idea ?
 
Thanks
 
Sébastien HEITZMANN
2LE - http://www.2le.net
2le@2le.net - 03 89 32 76 22

Re: Vacuum and deadlock.

From
Jeremy Buchmann
Date:
On Wednesday, September 5, 2001, at 07:11 AM, Sébastien HEITZMANN wrote:

> Since some week I have some trouble with my database. I use postgres v
> 7.1.2 on redhat 7.0
>  
> The trouble is that the database lock when in the night some user left
> an application open ( which do some read on some table) and the night
> process of backup and vacuum happend.
> The database stay in a deadlock until I restart it manually on the
> morning.

Why don't you just kill all the connections before running vacuum?

Jeremy Buchmann  [jeremy@wellsgaming.com]