Ckan Datapusher Troubleshooting

[Bart Praats]

Hi all,

I am deploying a Ckan instance on an Abuntu server and I ran into some trouble lately.

After installing the Datapusher, together with the datastore, I got an error when trying to push a file to the datastore.

This is the stacktrace:

Exception on /job [POST]
Traceback (most recent call last):
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/flask/app.py", line 1687, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/flask/app.py", line 1360, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/flask/app.py", line 1358, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/flask/app.py", line 1344, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/web.py", line 642, in job
    return run_asynchronous_job(asynchronous_job, job_id, job_key, input)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/web.py", line 680, in run_asynchronous_job
    db.add_pending_job(job_id, job_key, **input)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/ckanserviceprovider/db.py", line 253, in add_pending_job
    job_key=job_key))
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/usr/lib/ckan/datapusher/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) attempt to write a readonly database u'INSERT INTO jobs (job_id, job_type, status, requested_timestamp, sent_data, result_url, api_key, job_key) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' (u'96ceba83-1056-4716-973b-665cedb5977a', u'push_to_datastore', u'pending', '2015-11-13 11:03:16.655717', u'{}', u'http://localhost:5820/api/3/action/datapusher_hook', u'e3a7497d-6a2f-4f7a-a924-a716fbd956fe', u'3dd2c40a-33a6-4dec-80a1-e3f5f1c7deee')

I tested the datapusher with the command

curl 0.0.0.0:8800

And got back a clean JSON response object.

My datapusher is deployed with Apache as mentioned in the tutorial.

I tried looking for the database file in order to change the file permissions but I can't seem to find it.

Any suggestions are welcome.

Thx!

[David Read]

Bart,

Could you ask for technical help on Stack Overflow rather than on this list?

While you're there, check out these answers:
https://stackoverflow.com/questions/33693780/ckan-datastore-permission-denied-for-table-metadata
https://stackoverflow.com/questions/22449566/ckan-load-test-data-permission-denied-for-table-metadata

Regards,
David

> --
> You received this message because you are subscribed to the Google Groups
> "CKAN Global User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to ckan-global-user-...@googlegroups.com.
> To post to this group, send email to
> ckan-global...@googlegroups.com.
> Visit this group at http://groups.google.com/group/ckan-global-user-group.
> To view this discussion on the web, visit
> https://groups.google.com/d/msgid/ckan-global-user-group/ecd25a91-2fc9-4c67-ba20-ca4d0d125244%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.