Re: Suppress 'duplicate key' at errorlog?
От | David G. Johnston |
---|---|
Тема | Re: Suppress 'duplicate key' at errorlog? |
Дата | |
Msg-id | CAKFQuwZFarfPsDbHicpaugT7EA7FzrXa_WMrH47K=HCfRRW4DA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Suppress 'duplicate key' at errorlog? (Scott Whitney <scott@journyx.com>) |
Список | pgsql-admin |
On Mon, Mar 30, 2015 at 5:45 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:Hi,
Is there a way to suppress a ‘duplicate key’ msg from the errorlog? Due to a bug in a 3rd party application, this keeps on appearing and I am concerned that it will fill up the filesystem. I can delete the old errorlog, but if there is any other meaningful msgs out there, I would lose that too.
Thanks.
Maria
Not in any way that doesn't also entail the "but if there is any other meaningful msgs out there, I would lose that too." risk.Stop thinking about the limited problem of removing the excessive messages and just learn how to deal with high-volume log situations generally. At worse you could a simple log rotation and archive with a cleanup "sed" script that deletes these messages. Suggest setting "application_name" in order to be more targeted.David J.
I _do_ want to phone in on the whole duplicate key issue.
Sure, this could be a race condition. It could be bad programming. It could be a variety of things.
You ABSOLUTELY do not want to ignore that. Ignoring and moving on will cause consistency problems. Catch it and add it to a log or an email. Continue.
Do NOT silently ignore something trying to add a duplicate key.
В списке pgsql-admin по дате отправления: