UTCERROR UTCSTATEMENT in postgres.log
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,
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@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 https://lists.macosforge.org/mailman/listinfo/calendarserver-users
On Nov 28, 2016, at 3:06 PM, Andre LaBranche <dre@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@gmail.com <mailto:monkeyfdude@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
Thank you so much for all the answers. On Mon, Nov 28, 2016 at 3:14 PM, Andre LaBranche <dre@apple.com> wrote:
On Nov 28, 2016, at 3:06 PM, Andre LaBranche <dre@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@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 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
participants (2)
-
Andre LaBranche
-
Gaurav Jain