[CalendarServer-dev] Upgrade 9->9.1 and pg 9.4->10: Failed to handle lock timeout

[Axel Rau]

After upgrading from 9.0 to 9.1 together with upgrade of Postgresql server from 9.4 to 10, I’m getting:
	canceling statement due to statement timeout', u'while locking tuple (383,1) \
	in relation „calendar_object"

I see this at log level ‚warn‘, so I think it’s an unhandled exception, which should not happen.
This is triggered by random client activity regardless of „skip-locked" enabled or not in config.

I attach 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: caldavd.log
Type: application/octet-stream
Size: 8209 bytes
Desc: not available
URL: <http://lists.macosforge.org/pipermail/calendarserver-dev/attachments/20171101/7b7207ea/attachment.obj>
-------------- next part --------------
 and 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db-server.log
Type: application/octet-stream
Size: 2073 bytes
Desc: not available
URL: <http://lists.macosforge.org/pipermail/calendarserver-dev/attachments/20171101/7b7207ea/attachment-0001.obj>
-------------- next part --------------
(including logged SQL)

This has been already discussed with dre on IRC yesterday.

Axel
---
PGP-Key:29E99DD6  ☀  computing @ chaos claudius