public inbox for [email protected]  

help / color / mirror / Atom feed

From: Hayato Kuroda (Fujitsu) <[email protected]>
To: Takamichi Osumi (Fujitsu) <[email protected]>
To: 'Amit Kapila' <[email protected]>
To: Kyotaro Horiguchi <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: RE: Time delayed LR (WAS Re: logical replication restrictions)
Date: Tue, 27 Dec 2022 07:09:31 +0000
Message-ID: <TYAPR01MB58662BA30277F63E8A83BAEBF5ED9@TYAPR01MB5866.jpnprd01.prod.outlook.com> (raw)
In-Reply-To: <TYCPR01MB83734F23F653233EB87E1433EDE99@TYCPR01MB8373.jpnprd01.prod.outlook.com>
References: <CAA4eK1+npWUVr78+vZWW19Z29GTN+7dmvUrmfQZnX6r2TFgXSg@mail.gmail.com>
	<[email protected]>
	<TYAPR01MB5866360932F60714625192F9F5E09@TYAPR01MB5866.jpnprd01.prod.outlook.com>
	<[email protected]>
	<CAA4eK1Lq+h8qo+rqGU-E+hwJKAHYocV54y4pvou4rLysCgYD-g@mail.gmail.com>
	<TYCPR01MB83730A3E21E921335F6EFA38EDE89@TYCPR01MB8373.jpnprd01.prod.outlook.com>
	<TYCPR01MB83734F23F653233EB87E1433EDE99@TYCPR01MB8373.jpnprd01.prod.outlook.com>

Hi hackers,

> On Thursday, December 22, 2022 3:02 PM Takamichi Osumi (Fujitsu)
> <[email protected]> wrote:
> > Attached the updated patch.
> > Again, I used one basic patch in another thread to wake up logical replication
> > worker shared in [2] for TAP tests.
> The v11 caused a cfbot failure in [1]. But, failed tests looked irrelevant
> to the feature to me at present.
> 
> While waiting for another test execution of cfbot, I'd like to check the detailed
> reason
> and update the patch if necessary.

I have investigated the failure and it seemed that it has been caused by VACUUM FREEZE.
Followings were copied from the server log.

```
2022-12-23 08:50:20.175 UTC [34653][postmaster] LOG:  server process (PID 37171) was terminated by signal 6: Abort trap
2022-12-23 08:50:20.175 UTC [34653][postmaster] DETAIL:  Failed process was running: VACUUM FREEZE tab_freeze;
2022-12-23 08:50:20.175 UTC [34653][postmaster] LOG:  terminating any other active server processes
```

Same error has been raised in other threads [1], so we have concluded that this is not related with the patch.
The report was raised in another thread [2].

[1]: https://cirrus-ci.com/task/5630405437554688
[2]: https://www.postgresql.org/message-id/TYAPR01MB5866B24104FD80B5D7E65C3EF5ED9%40TYAPR01MB5866.jpnprd0...


Best Regards,
Hayato Kuroda
FUJITSU LIMITED

view thread (93+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: RE: Time delayed LR (WAS Re: logical replication restrictions)
  In-Reply-To: <TYAPR01MB58662BA30277F63E8A83BAEBF5ED9@TYAPR01MB5866.jpnprd01.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox