xloader-permission-denied-jobs-error.md

xloader-permission-denied-jobs-error.md

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/rq/worker.py", line 588, in perform_job
    rv = job.perform()
  File "/usr/local/lib/python2.7/dist-packages/rq/job.py", line 498, in perform
    self._result = self.func(*self.args, **self.kwargs)
  File "/src/ckanext-xloader/ckanext/xloader/jobs.py", line 81, in xloader_data_into_datastore
    job_id, traceback.format_tb(sys.exc_traceback)[-1] + repr(e))
  File "/src/ckanext-xloader/ckanext/xloader/db.py", line 363, in mark_job_as_errored
    _update_job(job_id, update_dict)
  File "/src/ckanext-xloader/ckanext/xloader/db.py", line 311, in _update_job
    .values(**job_dict))
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1690, in execute
    return connection.execute(statement, *multiparams, **params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 727, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 824, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 954, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
    exc_info
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 435, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) permission denied for relation jobs
 'UPDATE jobs SET status=%(status)s, error=%(error)s, finished_timestamp=%(finished_timestamp)s WHERE jobs.job_id = %(job_id_1)s' {'status': 'error', 'finished_timestamp': datetime.datetime(2018, 2, 15, 19, 33, 52, 708255), 'job_id_1': u'a855444c-0ed2-4898-8dbe-67f9866fdc04', 'error': u'{"message": "  File \\"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\\", line 435, in do_execute\\n    cursor.execute(statement, parameters)\\nProgrammingError(\'(ProgrammingError) permission denied for relation jobs\\\\n\',)"}'}
2018-02-15 19:33:52,843 WARNI [rq.worker] Moving job to u'failed' queue
2018-02-15 19:33:52,850 INFO  [ckan.lib.jobs] Worker rq:worker:illmannered-camel-ckan-rq-worker-678487c56c-bqmmv.6 has finished job a855444c-0ed2-4898-8dbe-67f9866fdc04 from queue "default"