Questions about Logical Replication - Issue ???

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Questions about Logical Replication - Issue ???

FOUTE K. Jaurès
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.

--
Jaurès FOUTE
Reply | Threaded
Open this post in threaded view
|

Re: Questions about Logical Replication - Issue ???

Kyotaro Horiguchi-4
Hi,

At Thu, 30 Jul 2020 14:54:08 +0100, FOUTE K. Jaurès <[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

Re: Questions about Logical Replication - Issue ???

FOUTE K. Jaurès
hello Kyotaro,

thx for you feedback and clarification.



Le ven. 31 juil. 2020 à 02:13, Kyotaro Horiguchi <[hidden email]> a écrit :
Hi,

At Thu, 30 Jul 2020 14:54:08 +0100, FOUTE K. Jaurès <[hidden email]> 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