Re: better error description on logical replication

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Re: better error description on logical replication
Дата
Msg-id CAB-JLwYSyUDn6vpNXWQJuoBKANu_dzLmSiaFOxUiEraoXGFeeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: better error description on logical replication  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: better error description on logical replication  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
I´m using 14.4.
These are some lines with that error, and context is empty.
And yes, if context had this info you wrote would be fine

2022-06-28 08:18:23.600 -03,,,20915,,62b9c77b.51b3,1328,,2022-06-27 12:06:35 -03,4/690182,433844252,ERROR,23505,"duplicate key value violates unique constraint ""pkcustomer""","Key (customer_id)=(530540) already exists.",,,,,,,,"","logical replication worker",,5539589780750922391
2022-06-28 08:18:23.609 -03,,,20377,,62bae37f.4f99,1,,2022-06-28 08:18:23 -03,4/690184,0,LOG,00000,"logical replication apply worker for subscription ""sub_replica_5"" has started",,,,,,,,,"","logical replication worker",,0
2022-06-28 08:18:23.929 -03,,,2009,,62b35392.7d9,88468,,2022-06-22 14:38:26 -03,,0,LOG,00000,"background worker ""logical replication worker"" (PID 20915) exited with exit code 1",,,,,,,,,"","postmaster",,0
2022-06-28 08:18:24.151 -03,,,20377,,62bae37f.4f99,2,,2022-06-28 08:18:23 -03,4/690187,433844253,ERROR,23505,"duplicate key value violates unique constraint ""pkcustomer""","Key (customer_id)=(530540) already exists.",,,,,,,,"","logical replication worker",,6675519194010520265
2022-06-28 08:18:24.160 -03,,,2009,,62b35392.7d9,88469,,2022-06-22 14:38:26 -03,,0,LOG,00000,"background worker ""logical replication worker"" (PID 20377) exited with exit code 1",,,,,,,,,"","postmaster",,0
2

thanks
Marcos


Em ter., 28 de jun. de 2022 às 23:52, Amit Kapila <amit.kapila16@gmail.com> escreveu:
On Tue, Jun 28, 2022 at 5:50 PM Marcos Pegoraro <marcos@f10.com.br> wrote:
>
> I don´t know how to create a patch, maybe someday, but for now I´m just sending this little problem if somebody can solve it.
>
> In a multi schema environment where several tables has same structure is a little bit hard to know which one already has that primary key.
>
> On log I see now on replica server.
> Message:duplicate key value violates unique constraint "pkcustomer"
> Detail: Key (customer_id)=(530540) already exists.
>
> So, I know what table is but I don´t know what schema it belongs.
>

On which version, have you tried this? In HEAD, I am getting below information:
ERROR:  duplicate key value violates unique constraint "idx_t1"
DETAIL:  Key (c1)=(1) already exists.
CONTEXT:  processing remote data for replication origin "pg_16388"
during "INSERT" for replication target relation "public.t1" in
transaction 739 finished at 0/150D640

You can see that CONTEXT has schema information. Will that serve your purpose?

--
With Regards,
Amit Kapila.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: OpenSSL 3.0.0 compatibility
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: better error description on logical replication