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