[ckan-dev] Dataset upload error

Cliff Ingham inghamn at bloomington.in.gov
Wed Feb 5 17:14:28 UTC 2014


I am getting a postgresql error when attempting to upload a file for a
dataset.

(ProgrammingError) permission denied for relation _table_metadata

I have tried the Alter Table command as described from an older email in
this mailing list:
https://lists.okfn.org/pipermail/ckan-dev/2012-October/003227.html

ALTER DEFAULT PRIVILEGES FOR USER "{writeuser}" IN SCHEMA public
   GRANT SELECT ON TABLES TO "{readonlyuser}";

But still, no luck.  I am unfamiliar with Postgres and am not sure where
the _table_metadata table is. (This is my first use of Postgres, I have
only use MySQL, Oracle, and MSSql before.)

Here's the full error from the log:

(ProgrammingError) permission denied for relation _table_metadata
 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
(u'2bba4af2-95e4-43c4-b555-970d0d59a10d',)
Traceback (most recent call last):
  File "/srv/sites/ckan/python_env/src/ckan/ckan/model/modification.py",
line 79, in notify
    observer.notify(entity, operation)
  File
"/srv/sites/ckan/python_env/src/ckan/ckan/lib/search/__init__.py", line
128, in notify
    {'id': entity.id}),
  File "/srv/sites/ckan/python_env/src/ckan/ckan/logic/__init__.py",
line 419, in wrapped
    result = _action(context, data_dict, **kw)
  File "/srv/sites/ckan/python_env/src/ckan/ckan/logic/action/get.py",
line 856, in package_show
    resource_dict = item.before_show(resource_dict)
  File
"/srv/sites/ckan/python_env/src/ckan/ckanext/datastore/plugin.py", line
245, in before_show
    resource_dict['id']
  File
"/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1449, in execute
    params)
  File
"/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1628, in _execute_text
    statement, parameters
  File
"/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
    context)
  File
"/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
    context)
  File
"/srv/sites/ckan/python_env/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) permission denied for relation
_table_metadata
 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
(u'2bba4af2-95e4-43c4-b555-970d0d59a10d',)
Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError)
permission denied for relation _table_metadata, referer:
http://rogue.bloomington.in.gov/ckan/dataset/new_resource/video-services-franchise-revenue-history
 'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
(u'2bba4af2-95e4-43c4-b555-970d0d59a10d',), referer:
http://rogue.bloomington.in.gov/ckan/dataset/new_resource/video-services-franchise-revenue-history
-- 
Cliff Ingham
http://www.ohloh.net/accounts/inghamn



More information about the ckan-dev mailing list