<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Nov 28, 2016, at 3:06 PM, Andre LaBranche <<a href="mailto:dre@apple.com" class="">dre@apple.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=us-ascii" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">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 class=""></div><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" class="">logging</a>, but there's no way to exclude only 'nowait' statements from being logged.</div><div><br class=""></div><div>-dre</div><br class=""><blockquote type="cite" class=""><div class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class=""><br class=""></div><div class="">-dre</div><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Nov 28, 2016, at 2:57 PM, Gaurav Jain <<a href="mailto:monkeyfdude@gmail.com" class="">monkeyfdude@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><p class="gmail-p1"><span class="gmail-s1">Hi,</span></p><p class="gmail-p1"><span class="gmail-s1">I see following two lines in postgres.log.</span></p><p class="gmail-p1"><span class="gmail-s1">What needs to be done so that these lines do not appear in postgres.log?</span></p><p class="gmail-p1"><span class="gmail-s1"><br class=""></span></p><p class="gmail-p1"><span class="gmail-s1">2016-11-28 17:45:15 UTCERROR: could not obtain lock on row in relation "push_notification_work"</span></p><p class="gmail-p1"><span class="gmail-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="gmail-p1"><br class=""></p><p class="gmail-p1">Best Regards,</p></div>
_______________________________________________<br class="">calendarserver-users mailing list<br class=""><a href="mailto:calendarserver-users@lists.macosforge.org" class="">calendarserver-users@lists.macosforge.org</a><br class=""><a href="https://lists.macosforge.org/mailman/listinfo/calendarserver-users" class="">https://lists.macosforge.org/mailman/listinfo/calendarserver-users</a><br class=""></div></blockquote></div><br class=""></div></div>_______________________________________________<br class="">calendarserver-users mailing list<br class=""><a href="mailto:calendarserver-users@lists.macosforge.org" class="">calendarserver-users@lists.macosforge.org</a><br class="">https://lists.macosforge.org/mailman/listinfo/calendarserver-users<br class=""></div></blockquote></div><br class=""></body></html>