From: Scott Whitney <scott@journyx.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Rossi, Maria <maria.rossi@us.pgds.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Suppress 'duplicate key' at errorlog?
Date: Mon, 30 Mar 2015 17:54:21 -0500 (CDT)
Message-ID: <1114474783.754620.1427756060642.JavaMail.zimbra@zimbra.int.journyx.com> (raw)
In-Reply-To: <CAKFQuwaQVcyePbseX56S3joRspLYAnmiVuDqbcdQ1zSRJHD19Q@mail.gmail.com>
References: <33A4D5087BF0D44DA69C5EEF666BC1D74263DD2C@usprmbp01c>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<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 <<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;"><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"><<a href="mailto:maria.rossi@us.pgds.com">maria.rossi@us.pgds.com</a>></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> <u></u></p>
<p class="MsoNormal">Is there a way to suppress a ‘duplicate key’ msg from the errorlog? Due to a bug in a 3<sup>rd</sup> 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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <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> <u></u></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Times New Roman",serif;color:teal">Maria
</span></b><span style="color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <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. 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.</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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, david.g.johnston@gmail.com, maria.rossi@us.pgds.com
Subject: Re: Suppress 'duplicate key' at errorlog?
In-Reply-To: <1114474783.754620.1427756060642.JavaMail.zimbra@zimbra.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox