> On Nov 28, 2016, at 3:06 PM, Andre LaBranche <d...@apple.com> wrote:
> 
> Hi,
> 
> 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.

I asked the postgres folks, and they said this isn't possible. You can turn 
down the logging 
<https://www.postgresql.org/docs/current/static/runtime-config-logging.html>, 
but there's no way to exclude only 'nowait' statements from being logged.

-dre

> 
> -dre
> 
>> On Nov 28, 2016, at 2:57 PM, Gaurav Jain <monkeyfd...@gmail.com 
>> <mailto:monkeyfd...@gmail.com>> wrote:
>> 
>> Hi,
>> 
>> I see following two lines in postgres.log.
>> 
>> What needs to be done so that these lines do not appear in postgres.log?
>> 
>> 
>> 
>> 2016-11-28 17:45:15 UTCERROR:  could not obtain lock on row in relation 
>> "push_notification_work"
>> 
>> 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
>> 
>> 
>> 
>> Best Regards,
>> 
>> _______________________________________________
>> calendarserver-users mailing list
>> calendarserver-users@lists.macosforge.org 
>> <mailto:calendarserver-users@lists.macosforge.org>
>> https://lists.macosforge.org/mailman/listinfo/calendarserver-users
> 
> _______________________________________________
> calendarserver-users mailing list
> calendarserver-users@lists.macosforge.org
> https://lists.macosforge.org/mailman/listinfo/calendarserver-users

_______________________________________________
calendarserver-users mailing list
calendarserver-users@lists.macosforge.org
https://lists.macosforge.org/mailman/listinfo/calendarserver-users

Reply via email to