Re: Truncation of mapped catalogs (whether local or shared) leads to server crash

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Truncation of mapped catalogs (whether local or shared) leads to server crash
Date: 2024-06-18 14:13:44
Message-ID: CA+TgmoZEYnXBtiar1+9cB_T+b-ovmCCKr7RHffR3OGUWK3_UOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 18, 2024 at 8:10 AM Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com> wrote:
> I've noticed that truncating mapped catalogs causes the server to
> crash due to an assertion failure. Here are the details:
>
> Executing below commands:
>
> -- set allow_system_table_mods TO on;
> -- truncate table pg_type;

If the operation isn't allowed without turning on
allow_system_table_mods, that means that doing it is probably a bad
idea and will probably break stuff, as happened here.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-06-18 14:20:26 Re: Truncation of mapped catalogs (whether local or shared) leads to server crash
Previous Message Andres Freund 2024-06-18 14:11:03 Re: may be a buffer overflow problem