[ckan-dev] Datastore setup for ckan 2.0
Stefán Þór Finnsson
stefan.thor.finnsson at reykjavik.is
Thu Feb 28 16:53:02 UTC 2013
Hello :)
When I have added the datastore extension and done the config for it I get this error in my ckan log and the system does not work. Without the datastore it works fine. I´m lost in what could be causing this error, anyone here with a quick answer for me :)
[Thu Feb 28 16:46:48 2013] [info] [client 82.112.70.95] mod_wsgi (pid=28703, process='', application='ckan-test|'): Loading WSGI script '/usr/local/ckan-test/pyenv/bin/ckan-test.py'.
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] mod_wsgi (pid=28703): Target WSGI script '/usr/local/ckan-test/pyenv/bin/ckan-test.py' cannot be loaded as Python module.
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] mod_wsgi (pid=28703): Exception occurred processing WSGI script '/usr/local/ckan-test/pyenv/bin/ckan-test.py'.
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] Traceback (most recent call last):
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/bin/ckan-test.py", line 11, in <module>
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] application = loadapp('config:%s' % config_filepath)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/paste/deploy/loadwsgi.py", line 247, in loadapp
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] return loadobj(APP, uri, name=name, **kw)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/paste/deploy/loadwsgi.py", line 272, in loadobj
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] return context.create()
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/paste/deploy/loadwsgi.py", line 710, in create
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] return self.object_type.invoke(self)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/paste/deploy/loadwsgi.py", line 146, in invoke
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] return fix_call(context.object, context.global_conf, **context.local_conf)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/paste/deploy/util.py", line 56, in fix_call
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] val = callable(*args, **kw)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/src/ckan/ckan/config/middleware.py", line 54, in make_app
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] load_environment(global_conf, app_conf)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/src/ckan/ckan/config/environment.py", line 349, in load_environment
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] plugin.configure(config)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/src/ckan/ckanext/datastore/plugin.py", line 68, in configure
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] self._create_alias_table()
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/src/ckan/ckanext/datastore/plugin.py", line 206, in _create_alias_table
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] connection.execute(create_alias_table_sql)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] params)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] statement, parameters
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] context)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] context)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] File "/usr/local/ckan-test/pyenv/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] cursor.execute(statement, parameters)
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] ProgrammingError: (ProgrammingError) function concat(name, name) does not exist
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] LINE 3: substr(md5(concat(dependee.relname, dependen...
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] ^
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] HINT: No function matches the given name and argument types. You might need to add explicit type casts.
[Thu Feb 28 16:46:49 2013] [error] [client 82.112.70.95] 'CREATE OR REPLACE VIEW "_table_metadata" AS \\n SELECT DISTINCT\\n substr(md5(concat(dependee.relname, dependent.relname)), 0, 17) AS "_id",\\n dependee.relname AS name,\\n dependee.oid AS oid,\\n dependent.relname AS alias_of\\n -- dependent.oid AS oid\\n FROM\\n pg_class AS dependee\\n LEFT OUTER JOIN pg_rewrite AS r ON r.ev_class = dependee.oid\\n LEFT OUTER JOIN pg_depend AS d ON d.objid = r.oid\\n LEFT OUTER JOIN pg_class AS dependent ON d.refobjid = dependent.oid\\n WHERE\\n (dependee.oid != dependent.oid OR dependent.oid IS NULL) AND\\n (dependee.relname IN (SELECT tablename FROM pg_catalog.pg_tables)\\n OR dependee.relname IN (SELECT viewname FROM pg_catalog.pg_views)) AND\\n dependee.relnamespace = (SELECT oid FROM pg_namespace WHERE nspname=\\'public\\')\\n ORDER BY dependee.oid DESC;\\n ' {}
__________________________________
Reglur um trúnað í tölvupóstsamskiptum: http://www.reykjavik.is/trunadur
Leiddu hugann að umhverfinu áður en þú prentar út þennan tölvupóst. Prentaðu á báðar hliðar í svarthvítu ef nauðsyn krefur.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130228/420bd249/attachment.html>
More information about the ckan-dev
mailing list