Re: Suppress 'duplicate key' at errorlog?
От | Scott Whitney |
---|---|
Тема | Re: Suppress 'duplicate key' at errorlog? |
Дата | |
Msg-id | 1114474783.754620.1427756060642.JavaMail.zimbra@zimbra.int.journyx.com обсуждение исходный текст |
Ответ на | Re: Suppress 'duplicate key' at errorlog? ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: Suppress 'duplicate key' at errorlog?
|
Список | pgsql-admin |
<p dir="ltr">I _do_ want to phone in on the whole duplicate key issue.<p dir="ltr">Sure, this could be a race condition.It could be bad programming. It could be a variety of things.<p dir="ltr">You ABSOLUTELY do not want to ignorethat. Ignoring and moving on will cause consistency problems. Catch it and add it to a log or an email. Continue.<pdir="ltr">Do NOT silently ignore something trying to add a duplicate key.<br /><div class="cm_quote" style=" color:#787878">On Mon, Mar 30, 2015 at 5:45 PM, David G. Johnston <<a href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>>wrote:</div><br /><div id="oldcontent" style="background-color:rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><blockquotestyle=""><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><spanstyle="font-family:arial,sans-serif">On Mon, Mar 30, 2015 at 2:03 PM,Rossi, Maria </span><span dir="ltr" style="font-family:arial,sans-serif"><<a href="mailto:maria.rossi@us.pgds.com">maria.rossi@us.pgds.com</a>></span><spanstyle="font-family:arial,sans-serif"> wrote:</span><br/></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US"><div><p class="MsoNormal">Hi,<u></u><u></u><pclass="MsoNormal"><u></u> <u></u><p class="MsoNormal">Is there a way to suppress a ‘duplicatekey’ msg from the errorlog? Due to a bug in a 3<sup>rd</sup> party application, this keeps on appearing andI am concerned that it will fill up the filesystem. I can delete the old errorlog, but if there is any other meaningfulmsgs out there, I would lose that too.<u></u><u></u><p class="MsoNormal"><u></u> <u></u><p class="MsoNormal">Thanks.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span><span class="HOEnZb"><fontcolor="#888888"><p class="MsoNormal"><u></u> <u></u><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"TimesNew Roman",serif;color:teal">Maria </span></b><span style="color:#1f497d"><u></u><u></u></span><p class="MsoNormal"><u></u> <u></u></font></span></div></div></blockquote></div><br/></div><div class="gmail_extra"><div class="gmail_default"style="font-family:arial,helvetica,sans-serif">Not in any way that doesn't also entail the "but if thereis any other meaningful msgs out there, I would lose that too." risk.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br/></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Stopthinking about the limited problem of removing the excessive messagesand just learn how to deal with high-volume log situations generally. At worse you could a simple log rotation andarchive with a cleanup "sed" script that deletes these messages. Suggest setting "application_name" in order to be moretargeted.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br /></div><div class="gmail_default"style="font-family:arial,helvetica,sans-serif">David J.</div><br /></div></div></blockquote></div>
В списке pgsql-admin по дате отправления: