Questions about Logical Replication - Issue ???

Hi,

At Thu, 30 Jul 2020 14:54:08 +0100, FOUTE K. Jaurès <jauresfoute@gmail.com> wrote in

Hi everyone,

Situation:

- A Master Database on the HQ
- i make a dump of the master database to the Subdivision Server
- I create à Publication like: CREATE PUBLICATION
iNOV_MasterData_Table_Pub FOR TABLE M_Product; On the Master Database
- On the Subdivision Server, I create a Subscription like: CREATE
SUBSCRIPTION iNOV_MasterData_Table_XXX_Sub CONNECTION '........'
PUBLICATION iNOV_MasterData_Table_Pub;
- On the log, I have this error:
- 2020-07-30 14:32:59.366 WAT [8022] ERROR: duplicate key value
violates unique constraint "m_product_pkey"
2020-07-30 14:32:59.366 WAT [8022] DETAIL: Key
(m_product_id)=(1001426) already exists.
2020-07-30 14:32:59.366 WAT [8022] CONTEXT: COPY m_product, line 1
2020-07-30 14:32:59.369 WAT [1536] LOG: background worker "logical
replication worker" (PID 8022) exited with exit code 1

What can I do to solve this? Is it normal ? It
BTW: When I create Subscription With the option (copy_data = false), I am
able to replicate the new record.

As you know, initial table copy happens defaultly at subscription
creation (the COPY command in the above log lines was doing that). If
you are sure that the publisher table is in-sync with the subscriber
one, you can use copy_data=false safely and it's the proper operation.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

hello Kyotaro,

thx for you feedback and clarification.

Le ven. 31 juil. 2020 à 02:13, Kyotaro Horiguchi <horikyota.ntt@gmail.com>
a écrit :

Hi,

At Thu, 30 Jul 2020 14:54:08 +0100, FOUTE K. Jaurès <jauresfoute@gmail.com>
wrote in

Hi everyone,

Situation:

- A Master Database on the HQ
- i make a dump of the master database to the Subdivision Server
- I create à Publication like: CREATE PUBLICATION
iNOV_MasterData_Table_Pub FOR TABLE M_Product; On the Master Database
- On the Subdivision Server, I create a Subscription like: CREATE
SUBSCRIPTION iNOV_MasterData_Table_XXX_Sub CONNECTION '........'
PUBLICATION iNOV_MasterData_Table_Pub;
- On the log, I have this error:
- 2020-07-30 14:32:59.366 WAT [8022] ERROR: duplicate key value
violates unique constraint "m_product_pkey"
2020-07-30 14:32:59.366 WAT [8022] DETAIL: Key
(m_product_id)=(1001426) already exists.
2020-07-30 14:32:59.366 WAT [8022] CONTEXT: COPY m_product, line 1
2020-07-30 14:32:59.369 WAT [1536] LOG: background worker "logical
replication worker" (PID 8022) exited with exit code 1

What can I do to solve this? Is it normal ? It
BTW: When I create Subscription With the option (copy_data = false), I

am

able to replicate the new record.

As you know, initial table copy happens defaultly at subscription
creation (the COPY command in the above log lines was doing that). If
you are sure that the publisher table is in-sync with the subscriber
one, you can use copy_data=false safely and it's the proper operation.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

--
Jaurès FOUTE