Обсуждение: Fix buffer refcount leak with FDW bulk inserts

Поиск
Список
Период
Сортировка

Fix buffer refcount leak with FDW bulk inserts

От
ROHIT SACHDEVA
Дата:
Hi Team,

I am using postgres 14 version and I am using fdw.

Error 
When i am try to increase the batch_size parameter and do the insertion part i received this error.
WARNING:  buffer refcount leak: [1733373] (rel=base/19360/251000, blockNum=809

What is the impact of this error should I perform the insertion again.

Let me asap.

--
Have a Good day !!!

Regards
Rohit Sachdeva

Re: Fix buffer refcount leak with FDW bulk inserts

От
Tom Lane
Дата:
ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> writes:
> When i am try to increase the batch_size parameter and do the insertion
> part i received this error.
> WARNING:  buffer refcount leak: [1733373] (rel=base/19360/251000,
> blockNum=809

That's just a warning, not an error.  It's pretty harmless.

> What is the impact of this error should I perform the insertion again.

No.

What you should do is update to the current minor release (14.8),
which contains a fix for a bug matching this symptom.

(If you can still reproduce the warning on 14.8, we'd be interested
to see a self-contained test case.)

            regards, tom lane