Re: Suppress 'duplicate key' at errorlog?

<p dir="ltr">I _do_ want to phone in on the whole duplicate key issue.</p>
<p dir="ltr">Sure, this could be a race condition. It could be bad programming. It could be a variety of things.</p>
<p dir="ltr">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.</p>
<p dir="ltr">Do NOT silently ignore something trying to add a duplicate key.</p>
<br/><div class="cm_quote" style=" color: #787878">On Mon, Mar 30, 2015 at 5:45 PM, David G. Johnston &lt;<a href="mailto:david(dot)g(dot)johnston(at)gmail(dot)com">david(dot)g(dot)johnston(at)gmail(dot)com</a>&gt; wrote:</div><br><div id="oldcontent" style="background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><blockquote style=""><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><span style="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">&lt;<a href="mailto:maria(dot)rossi(at)us(dot)pgds(dot)com">maria(dot)rossi(at)us(dot)pgds(dot)com</a>&gt;</span><span style="font-family:arial,sans-serif"> wrote:</span><br></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div lang="EN-US">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u>&nbsp;<u></u></p>
<p class="MsoNormal">Is there a way to suppress a ‘duplicate key’ msg &nbsp;from the errorlog?&nbsp; Due to a bug in a 3^rd party application,&nbsp; this keeps on appearing and I am concerned that it will fill up the filesystem.&nbsp;&nbsp;&nbsp; I can delete&nbsp; the old errorlog,&nbsp;
but if there is any other meaningful msgs out there, I would lose that too.<u></u><u></u></p>
<p class="MsoNormal"><u></u>&nbsp;<u></u></p>
<p class="MsoNormal">Thanks. <span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></p><span class="HOEnZb"><font color="#888888">
<p class="MsoNormal"><u></u>&nbsp;<u></u></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:&quot;Times New Roman&quot;,serif;color:teal">Maria
</span></b><span style="color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u>&nbsp;<u></u></p>
</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 there is 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">Stop thinking about the limited problem of removing the excessive messages and just learn how to deal with high-volume log situations generally.&nbsp; At worse you could a simple log rotation and archive with a cleanup "sed" script that deletes these messages.&nbsp; Suggest setting "application_name" in order to be more targeted.</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>