[CalendarServer-users] UTCERROR UTCSTATEMENT in postgres.log

[Andre LaBranche]

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.

-dre

> On Nov 28, 2016, at 2:57 PM, Gaurav Jain <monkeyfdude at 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 at lists.macosforge.org
> https://lists.macosforge.org/mailman/listinfo/calendarserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.macosforge.org/pipermail/calendarserver-users/attachments/20161128/4150a728/attachment.html>