<div dir="ltr">Thank you so much for all the answers.</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 28, 2016 at 3:14 PM, Andre LaBranche <span dir="ltr"><<a href="mailto:dre@apple.com" target="_blank">dre@apple.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><br><div><span class=""><blockquote type="cite"><div>On Nov 28, 2016, at 3:06 PM, Andre LaBranche <<a href="mailto:dre@apple.com" target="_blank">dre@apple.com</a>> wrote:</div><br class="m_-844120730924984088Apple-interchange-newline"><div><div style="word-wrap:break-word">Hi,<div><br></div><div>These log lines are not an indication of a problem, but on busy / underpowered servers you might see them a lot. The way you can tell it's not an error is because of the "nowait" clause, which means "try to do this immediately, and if you can't, don't wait, just give up". When such a statement can't execute immediately, CS will retry. You can probably adjust the postgres settings to make such messages not appear if you desire.</div></div></div></blockquote><div><br></div></span><div>I asked the postgres folks, and they said this isn't possible. You can turn down the <a href="https://www.postgresql.org/docs/current/static/runtime-config-logging.html" target="_blank">logging</a>, but there's no way to exclude only 'nowait' statements from being logged.</div><div><br></div><div>-dre</div><span class=""><br><blockquote type="cite"><div><div style="word-wrap:break-word"><div><br></div><div>-dre</div><div><br><div><blockquote type="cite"><div>On Nov 28, 2016, at 2:57 PM, Gaurav Jain <<a href="mailto:monkeyfdude@gmail.com" target="_blank">monkeyfdude@gmail.com</a>> wrote:</div><br class="m_-844120730924984088Apple-interchange-newline"><div><div dir="ltr"><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1">Hi,</span></p><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1">I see following two lines in postgres.log.</span></p><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1">What needs to be done so that these lines do not appear in postgres.log?</span></p><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1"><br></span></p><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1">2016-11-28 17:45:15 UTCERROR: could not obtain lock on row in relation "push_notification_work"</span></p><p class="m_-844120730924984088gmail-p1"><span class="m_-844120730924984088gmail-s1">2016-11-28 17:45:15 UTCSTATEMENT: select WORK_ID, JOB_ID, PUSH_ID, PUSH_PRIORITY from PUSH_NOTIFICATION_WORK where PUSH_ID = $1 for update nowait</span></p><p class="m_-844120730924984088gmail-p1"><br></p><p class="m_-844120730924984088gmail-p1">Best Regards,</p></div>
______________________________<wbr>_________________<br>calendarserver-users mailing list<br><a href="mailto:calendarserver-users@lists.macosforge.org" target="_blank">calendarserver-users@lists.<wbr>macosforge.org</a><br><a href="https://lists.macosforge.org/mailman/listinfo/calendarserver-users" target="_blank">https://lists.macosforge.org/<wbr>mailman/listinfo/<wbr>calendarserver-users</a><br></div></blockquote></div><br></div></div>______________________________<wbr>_________________<br>calendarserver-users mailing list<br><a href="mailto:calendarserver-users@lists.macosforge.org" target="_blank">calendarserver-users@lists.<wbr>macosforge.org</a><br><a href="https://lists.macosforge.org/mailman/listinfo/calendarserver-users" target="_blank">https://lists.macosforge.org/<wbr>mailman/listinfo/<wbr>calendarserver-users</a><br></div></blockquote></span></div><br></div></blockquote></div><br></div>