Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: transaction lost when delete clog file after normal shutdown - Mailing list pgsql-hackers

From 章晨曦@易景科技
Subject Re: Re: transaction lost when delete clog file after normal shutdown
Date
Msg-id tencent_0064182A1A7886832E88D318@qq.com
Whole thread Raw
In response to transaction lost when delete clog file after normal shutdown  ("章晨曦@易景科技" <zhangchenxi@halodbtech.com>)
Responses Re: transaction lost when delete clog file after normal shutdown
List pgsql-hackers
Tree view
S1:
When database normal shutdown, and clog file missing, the database cannot restart. And if make a zero clog file, database started but may cause transactions lost.

S2:
When database crashed, and  clog file missing, when database restart, it will try to recover. And everything is ok

So I think we may improve the database more reliable in some scenarios, e.g. Only clog file corrupted or missing, like S1

Regards,
Jet


Andrey Borodin<x4mmm@yandex-team.ru> 在 2024年12月23日 周一 17:51 写道：


> On 23 Dec 2024, at 14:12, 章晨曦@易景科技 <zhangchenxi@halodbtech.com> wrote:
>
> we simulate crash and clog file corrupt (delete the clog file)

Clog file cannot disappear as a result of a crash. What makes you think otherwise?


Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Repeatable read transaction doesn't see dropped table
Next
From: Daniil Davydov
Date:
Subject: Re: Repeatable read transaction doesn't see dropped table