While upgrading from 9.0 to 9.1, I’m getting: File "/usr/local/lib/python2.7/site-packages/twext/enterprise/adbapi2.py", line 246, in _reallyExecSQL self._cursor.execute(sql, args) File "/usr/local/lib/python2.7/site-packages/txdav/base/datastore/dbapiclient.py", line 82, in execute self.realCursor.execute(sql, args) File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 906, in execute self._c.execute(self, operation, args) File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 1940, in execute self.handle_messages(cursor) File "/usr/local/lib/python2.7/site-packages/pg8000/core.py", line 2088, in handle_messages raise self.error pg8000.core.ProgrammingError: (u’ERROR', u'42601', u'syntax error at or near "skip"', u'205', u'scan.l', u'1053', u'scanner_yyerror', u'', u'')
PostgreSQL 9.4 server log shows: "syntax error at or near ""skip""",,,,,,"select JOB_ID, WORK_TYPE, PRIORITY, WEIGHT, NOT_BEFORE, IS_ASSIGNED, ASSIGNED, OVERDUE, FAILED, PAUSE from JOB where IS_ASSIGNED = $1 and PAUSE = $2 and NOT_BEFORE <= $3 order by PRIORITY desc for update skip locked limit $4“,205,,“" Axel --- PGP-Key:29E99DD6 ☀ computing @ chaos claudius _______________________________________________ calendarserver-dev mailing list calendarserver-dev@lists.macosforge.org https://lists.macosforge.org/mailman/listinfo/calendarserver-dev