Re: BUG #14941: Vacuum crashes

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Lyes Ameddah <lyes(dot)amd(at)gmail(dot)com>
Cc: "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14941: Vacuum crashes
Date: 2017-12-04 14:51:48
Message-ID: CA+TgmobBsYxLT586dHBtcsHHeSsJ7T6tr447tY3C08X5fFFraQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Dec 4, 2017 at 8:59 AM, Lyes Ameddah <lyes(dot)amd(at)gmail(dot)com> wrote:
> sorry guys, yes I'm talking about a FULL VACUUM and not about Auto-Vacuum.
> Thank you very match for your feedback.

OK, but that's not the confusion. What you said is that it CRASHES,
but the behavior you described is that it BLOCKS waiting for a lock.
Blocking and crashing are not the same thing.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Сергей А. Фролов 2017-12-04 15:01:22 Re: BUG #14940: Duplicated records inspite of primary key and unique constraint
Previous Message Tomas Vondra 2017-12-04 14:36:23 Re: BUG #14940: Duplicated records inspite of primary key and unique constraint

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Kuzmenkov 2017-12-04 15:07:10 Re: [HACKERS] Proposal for CSN based snapshots
Previous Message Craig Ringer 2017-12-04 14:13:56 Re: Would a BGW need shmem_access or database_connection to enumerate databases?