RE: Logical Replication of sequences - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: Logical Replication of sequences
Date
Msg-id OS7PR01MB145594DAC6544508FDBD88099F589A@OS7PR01MB14559.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: Logical Replication of sequences
List pgsql-hackers
Dear Alexander,

> FWIW, this issue is not reproduced at 7a485bd64~1, maybe this should be
> taken into account.

To confirm, are you saying that the issue cannot be reproduced before 7a485bd64
right? I think it's because try_relation_open() is used in pg_get_sequence_data().
Before the commit we forcibly open the relation and raise an ERROR if it fails.
The sequencesync worker exits and tries again - everything is OK.

After the commit, however, we allow to fail opening and the SQL function returns
NULL - this can cause the assertion failure.

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Rob Moore
Date:
Subject: Proposal: Add backup start time to pg_stat_progress_basebackup
Next
From: Tatsuo Ishii
Date:
Subject: Re: Row pattern recognition