[CalendarServer-users] UTCERROR UTCSTATEMENT in postgres.log

[Gaurav Jain]

Thank you so much for all the answers.

On Mon, Nov 28, 2016 at 3:14 PM, Andre LaBranche <dre at apple.com> wrote:

>
> On Nov 28, 2016, at 3:06 PM, Andre LaBranche <dre at 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 <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
>
>
> _______________________________________________
> 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/3047db89/attachment.html>