[ckan-dev] Internal Server Error while creating Dataset

Bhavesh Patel bhavesh.bece.13 at gmail.com
Wed Oct 8 12:12:34 UTC 2014


Dear CKAN Team,

As continue with last mail..

I am able to run CKAN application using Apache (
http://docs.ckan.org/en/latest/maintaining/installing/deployment.html) as
suggested by Nigel Babu (nigel.babu at okfn.org) Thanks to Nigel Babu for help.

I have attached the log file there may be some permission issue.. but I am
not able to get where it is..in postgresql or file upload directory or
else..? please guide me. While uploading any file - clicking on Additional
Data button then It's shows Internal Server Error

I am waiting for the reply..

Thanks for your support and help..

Thanks & Regards,
*Bhavesh R. Patel *

   - www.bhaveshpatel.info
   - www.onlinequizportal.com
   - www.hindisuvichar.com

"Never leave till tomorrow which you can do today"
*Please consider the environment before printing this e-mail.*

On Wed, Oct 8, 2014 at 2:02 PM, Bhavesh Patel <bhavesh.bece.13 at gmail.com>
wrote:

> Dear CKAN team,
>
> We have install CKAN from Source into Ubuntu12.04 - 64-bit
>
> Installation Document that we follow:
> http://docs.ckan.org/en/latest/maintaining/installing/install-from-source.html
>  and we have install CKAN 2.2 (Point 2. b)
>
> Now the problem is while uploading the Data..into second step shown into
> below figure.. clicking on Additional info button it will shows "Internal
> Server Error"
>
>
> [image: Inline image 1]
>
> [image: Inline image 2]
>
>
> Dear Team I have some questions for Running CKAN
>
> 1. Jetty is required for webserver or only Apache will work ?
> ​ (because during setting the filestore document :
> http://docs.ckan.org/en/latest/maintaining/filestore.html)
> ​ there apache service we have to restart but while following the
> installation document there is no command to install apache webserver so I
> am confused for that)​
>
> 2. Once installing the CKAN how to run CKAN through Apache ?
> ​ (currently CKAN is only running through paster command like :
> http://localhost:5000)​
>
> ​Please help me on this.​
>
>
> Thanks & Regards,
> *Bhavesh R. Patel *
>
>    - www.bhaveshpatel.info
>    - www.onlinequizportal.com
>    - www.hindisuvichar.com
>
> "Never leave till tomorrow which you can do today"
> *Please consider the environment before printing this e-mail.*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141008/00094116/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 99411 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141008/00094116/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 35138 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141008/00094116/attachment-0007.png>
-------------- next part --------------
[Wed Oct 08 17:25:50 2014] [error] 2014-10-08 17:25:50,329 INFO  [ckan.lib.base]  / render time 0.911 seconds
[Wed Oct 08 17:25:52 2014] [error] 2014-10-08 17:25:52,516 INFO  [ckan.lib.base]  /api/i18n/en render time 0.002 seconds
[Wed Oct 08 17:26:05 2014] [error] 2014-10-08 17:26:05,722 INFO  [ckan.lib.base]  / render time 0.501 seconds
[Wed Oct 08 17:26:05 2014] [error] 2014-10-08 17:26:05,846 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:07 2014] [error] 2014-10-08 17:26:07,446 INFO  [ckan.lib.base]  / render time 0.068 seconds
[Wed Oct 08 17:26:07 2014] [error] 2014-10-08 17:26:07,613 INFO  [ckan.lib.base]  /api/i18n/en render time 0.002 seconds
[Wed Oct 08 17:26:07 2014] [error] 2014-10-08 17:26:07,983 INFO  [ckan.lib.base]  / render time 0.100 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,113 INFO  [ckan.lib.base]  / render time 0.204 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,370 INFO  [ckan.lib.base]  / render time 0.434 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,376 INFO  [ckan.lib.base]  / render time 0.409 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,558 INFO  [ckan.lib.base]  / render time 0.521 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,625 INFO  [ckan.lib.base]  / render time 0.558 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,659 INFO  [ckan.lib.base]  / render time 0.655 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,733 INFO  [ckan.lib.base]  / render time 0.556 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,734 INFO  [ckan.lib.base]  / render time 0.617 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,751 INFO  [ckan.lib.base]  / render time 0.607 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,787 INFO  [ckan.lib.base]  / render time 0.537 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,806 INFO  [ckan.lib.base]  / render time 0.571 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,810 INFO  [ckan.lib.base]  / render time 0.424 seconds
[Wed Oct 08 17:26:08 2014] [error] 2014-10-08 17:26:08,811 INFO  [ckan.lib.base]  / render time 0.402 seconds
[Wed Oct 08 17:26:09 2014] [error] 2014-10-08 17:26:09,025 INFO  [ckan.lib.base]  /api/i18n/en render time 0.002 seconds
[Wed Oct 08 17:26:10 2014] [error] 2014-10-08 17:26:10,450 INFO  [ckan.lib.base]  /user/login render time 0.180 seconds
[Wed Oct 08 17:26:10 2014] [error] 2014-10-08 17:26:10,568 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:15 2014] [error] 2014-10-08 17:26:15,234 INFO  [ckan.lib.base]  /user/logged_in render time 0.008 seconds
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,171 INFO  [ckan.lib.base]  /user/logged_in render time 0.868 seconds
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,527 CRITI [ckan.logic] Action `user_followee_list` is being called directly all action calls should be accessed via logic.get_action
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,532 CRITI [ckan.logic] Action `dataset_followee_list` is being called directly all action calls should be accessed via logic.get_action
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,538 CRITI [ckan.logic] Action `group_followee_list` is being called directly all action calls should be accessed via logic.get_action
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,542 CRITI [ckan.logic] Action `dashboard_activity_list` is being called directly all action calls should be accessed via logic.get_action
[Wed Oct 08 17:26:16 2014] [error] 2014-10-08 17:26:16,842 INFO  [ckan.lib.base]  /dashboard render time 0.618 seconds
[Wed Oct 08 17:26:17 2014] [error] 2014-10-08 17:26:17,001 INFO  [ckan.lib.base]  /api/i18n/en render time 0.002 seconds
[Wed Oct 08 17:26:21 2014] [error] 2014-10-08 17:26:21,655 INFO  [ckan.lib.base]  /dataset render time 0.157 seconds
[Wed Oct 08 17:26:21 2014] [error] 2014-10-08 17:26:21,787 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:23 2014] [error] 2014-10-08 17:26:23,286 INFO  [ckan.lib.base]  /dataset/new render time 0.151 seconds
[Wed Oct 08 17:26:23 2014] [error] 2014-10-08 17:26:23,421 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:34 2014] [error] 2014-10-08 17:26:34,534 INFO  [ckan.lib.base]  /dataset/new render time 0.802 seconds
[Wed Oct 08 17:26:34 2014] [error] 2014-10-08 17:26:34,694 INFO  [ckan.lib.base]  /dataset/new_resource/hello render time 0.144 seconds
[Wed Oct 08 17:26:34 2014] [error] 2014-10-08 17:26:34,935 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:51 2014] [error] 2014-10-08 17:26:51,616 INFO  [ckan.lib.base]  /api/2/util/resource/format_autocomplete render time 0.011 seconds
[Wed Oct 08 17:26:53 2014] [error] 2014-10-08 17:26:53,861 ERROR [ckan.model.modification] (ProgrammingError) permission denied for relation _table_metadata
[Wed Oct 08 17:26:53 2014] [error]  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL' (u'9a54d157-2617-495c-8e01-4b44f1aa6ab1',)
[Wed Oct 08 17:26:53 2014] [error] Traceback (most recent call last):
[Wed Oct 08 17:26:53 2014] [error]   File "/home/bhavesh/ckan/lib/default/src/ckan/ckan/model/modification.py", line 79, in notify
[Wed Oct 08 17:26:53 2014] [error]     observer.notify(entity, operation)
[Wed Oct 08 17:26:53 2014] [error]   File "/home/bhavesh/ckan/lib/default/src/ckan/ckan/lib/search/__init__.py", line 128, in notify
[Wed Oct 08 17:26:53 2014] [error]     {'id': entity.id}),
[Wed Oct 08 17:26:53 2014] [error]   File "/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/__init__.py", line 419, in wrapped
[Wed Oct 08 17:26:53 2014] [error]     result = _action(context, data_dict, **kw)
[Wed Oct 08 17:26:53 2014] [error]   File "/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/action/get.py", line 856, in package_show
[Wed Oct 08 17:26:53 2014] [error]     resource_dict = item.before_show(resource_dict)
[Wed Oct 08 17:26:53 2014] [error]   File "/home/bhavesh/ckan/lib/default/src/ckan/ckanext/datastore/plugin.py", line 245, in before_show
[Wed Oct 08 17:26:53 2014] [error]     resource_dict['id']
[Wed Oct 08 17:26:53 2014] [error]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
[Wed Oct 08 17:26:53 2014] [error]     params)
[Wed Oct 08 17:26:53 2014] [error]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
[Wed Oct 08 17:26:53 2014] [error]     statement, parameters
[Wed Oct 08 17:26:53 2014] [error]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
[Wed Oct 08 17:26:53 2014] [error]     context)
[Wed Oct 08 17:26:53 2014] [error]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
[Wed Oct 08 17:26:53 2014] [error]     context)
[Wed Oct 08 17:26:53 2014] [error]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
[Wed Oct 08 17:26:53 2014] [error]     cursor.execute(statement, parameters)
[Wed Oct 08 17:26:53 2014] [error] ProgrammingError: (ProgrammingError) permission denied for relation _table_metadata
[Wed Oct 08 17:26:53 2014] [error]  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL' (u'9a54d157-2617-495c-8e01-4b44f1aa6ab1',)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) permission denied for relation _table_metadata
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL' (u'9a54d157-2617-495c-8e01-4b44f1aa6ab1',)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] URL: http://192.168.251.87:8080/dataset/new_resource/hello
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/errormiddleware.py', line 162 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   app_iter = self.application(environ, sr_checker)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   resp = self.call_func(req, *args, **self.kwargs)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return self.func(req, *args, **kwargs)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/publisher.py', line 234 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return request.get_response(self.app)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_response
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   application, catch_exc_info=False)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_application
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   app_iter = application(self.environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   resp = self.call_func(req, *args, **self.kwargs)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return self.func(req, *args, **kwargs)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/injector.py', line 54 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   response = request.get_response(self.app)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_response
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   application, catch_exc_info=False)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_application
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   app_iter = application(self.environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/beaker/middleware.py', line 73 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return self.app(environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/beaker/middleware.py', line 155 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return self.wrap_app(environ, session_start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/routes/middleware.py', line 131 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   response = self.app(environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 125 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   response = self.dispatch(controller, environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 324 in dispatch
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return controller(environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/lib/base.py', line 346 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   res = WSGIController.__call__(self, environ, start_response)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 221 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   response = self._dispatch_call()
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 172 in _dispatch_call
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   response = self._inspect_call(func)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 107 in _inspect_call
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   result = self._perform_call(func, args)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 60 in _perform_call
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return func(**args)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/controllers/package.py', line 669 in new_resource
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   get_action('resource_create')(context, data)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/__init__.py', line 419 in wrapped
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   result = _action(context, data_dict, **kw)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/action/create.py', line 279 in resource_create
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   model.repo.commit()
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/vdm/sqlalchemy/tools.py', line 102 in commit
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   self.session.commit()
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/scoping.py', line 114 in do
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   return getattr(self.registry(), name)(*args, **kwargs)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/session.py', line 656 in commit
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   self.transaction.commit()
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/session.py', line 314 in commit
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   self._prepare_impl()
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/orm/session.py', line 290 in _prepare_impl
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   self.session.dispatch.before_commit(self.session)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/event.py', line 291 in __call__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   fn(*args, **kw)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/model/extension.py', line 112 in before_commit
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   methodcaller('before_commit', session)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/model/extension.py', line 92 in notify_observers
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   func(observer)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/model/modification.py', line 72 in before_commit
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   self.notify(obj, domain_object.DomainObjectOperation.changed)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/model/modification.py', line 79 in notify
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   observer.notify(entity, operation)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/lib/search/__init__.py', line 128 in notify
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   {'id': entity.id}),
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/__init__.py', line 419 in wrapped
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   result = _action(context, data_dict, **kw)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckan/logic/action/get.py', line 856 in package_show
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   resource_dict = item.before_show(resource_dict)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/home/bhavesh/ckan/lib/default/src/ckan/ckanext/datastore/plugin.py', line 245 in before_show
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   resource_dict['id']
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1449 in execute
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   params)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1628 in _execute_text
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   statement, parameters
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1698 in _execute_context
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   context)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1691 in _execute_context
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   context)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py', line 331 in do_execute
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   cursor.execute(statement, parameters)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] ProgrammingError: (ProgrammingError) permission denied for relation _table_metadata
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]  'SELECT 1 FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL' (u'9a54d157-2617-495c-8e01-4b44f1aa6ab1',)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] CGI Variables
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] -------------
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   AUTH_TYPE: 'cookie'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   CKAN_CURRENT_URL: '/dataset/new_resource/hello'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   CKAN_LANG: 'en'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   CKAN_LANG_IS_DEFAULT: True
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   CONTENT_TYPE: 'multipart/form-data; boundary=----WebKitFormBoundarywNlTBw6KqTpYjBTT; charset=utf-8'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   DOCUMENT_ROOT: '/etc/apache2/htdocs'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   GATEWAY_INTERFACE: 'CGI/1.1'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_ACCEPT_ENCODING: 'gzip,deflate'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_ACCEPT_LANGUAGE: 'en-US,en;q=0.8'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_CACHE_CONTROL: 'max-age=0'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_CONNECTION: 'keep-alive'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_COOKIE: 'auth_tkt="57cd52acd34476321acb44d6e15187445435265fbhavesh!userid_type:unicode"; ckan=f51371b805834ead19331df38d0a5e379c7145a864d0effd8a82446da2c1814021744b25'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_HOST: '192.168.251.87:8080'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_ORIGIN: 'http://192.168.251.87:8080'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_REFERER: 'http://192.168.251.87:8080/dataset/new_resource/hello'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_USER_AGENT: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   HTTP_X_FORWARDED_FOR: 'unknown'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   PATH_INFO: '/dataset/new_resource/hello'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   PATH_TRANSLATED: '/etc/ckan/default/apache.wsgi/dataset/new_resource/hello'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REMOTE_ADDR: '192.168.32.7'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REMOTE_PORT: '38789'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REMOTE_USER: u'bhavesh'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REMOTE_USER_DATA: 'userid_type:unicode'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REMOTE_USER_TOKENS: ['']
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REQUEST_METHOD: 'POST'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   REQUEST_URI: '/dataset/new_resource/hello'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SCRIPT_FILENAME: '/etc/ckan/default/apache.wsgi'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_ADDR: '192.168.251.87'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_ADMIN: '[no address given]'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_NAME: '192.168.251.87'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_PORT: '8080'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_PROTOCOL: 'HTTP/1.0'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_SIGNATURE: '<address>Apache/2.2.22 (Ubuntu) Server at 192.168.251.87 Port 8080</address>\\n'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   SERVER_SOFTWARE: 'Apache/2.2.22 (Ubuntu)'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] WSGI Variables
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] --------------
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   application: <fanstatic.publisher.Delegator object at 0x7f4746ad8890>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   beaker.cache: <beaker.cache.CacheManager object at 0x7f4746ab86d0>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   beaker.get_session: <bound method SessionMiddleware._get_session of <beaker.middleware.SessionMiddleware object at 0x7f4746ab81d0>>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   beaker.session: {'_accessed_time': 1412769413.919585, '_creation_time': 1412769376.17096}
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   fanstatic.needed: <fanstatic.core.NeededResources object at 0x7f47341b22d0>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.application_group: '192.168.251.87:8080|'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.callable_object: 'application'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.handler_script: ''
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.input_chunked: '0'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.listener_host: ''
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.listener_port: '8080'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.process_group: 'ckan_default'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.request_handler: 'wsgi-script'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.script_reloading: '1'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   mod_wsgi.version: (3, 3)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   paste.cookies: (<SimpleCookie: auth_tkt='57cd52acd34476321acb44d6e15187445435265fbhavesh!userid_type:unicode' ckan='f51371b805834ead19331df38d0a5e379c7145a864d0effd8a82446da2c1814021744b25'>, 'auth_tkt="57cd52acd34476321acb44d6e15187445435265fbhavesh!userid_type:unicode"; ckan=f51371b805834ead19331df38d0a5e379c7145a864d0effd8a82446da2c1814021744b25')
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   paste.registry: <paste.registry.Registry object at 0x7f47341b2a50>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   paste.throw_errors: True
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   pylons.action_method: <bound method PackageController.new_resource of <ckan.controllers.package.PackageController object at 0x7f4740035110>>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   pylons.controller: <ckan.controllers.package.PackageController object at 0x7f4740035110>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   pylons.environ_config: {'session': 'beaker.session', 'cache': 'beaker.cache'}
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   pylons.pylons: <pylons.util.PylonsContext object at 0x7f47400359d0>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   pylons.routes_dict: {'action': u'new_resource', 'controller': u'package', 'id': u'hello'}
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   repoze.who.identity: <repoze.who identity (hidden, dict-like) at 139943993214688>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   repoze.who.logger: <logging.Logger object at 0x7f4746ad8410>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   repoze.who.plugins: {'openid': <OpenIdIdentificationPlugin 139944105183504>, 'friendlyform': <FriendlyFormPlugin 139944105184272>, 'ckan.lib.authenticator:UsernamePasswordAuthenticator': <ckan.lib.authenticator.UsernamePasswordAuthenticator object at 0x7f4747292ed0>, 'auth_tkt': <AuthTktCookiePlugin 139944105184592>, 'ckan.lib.authenticator:OpenIDAuthenticator': <ckan.lib.authenticator.OpenIDAuthenticator object at 0x7f4747292e90>}
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   routes.route: <routes.route.Route object at 0x7f4746ee70d0>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   routes.url: <routes.util.URLGenerator object at 0x7f4740032710>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   webob._parsed_post_vars: (MultiDict([('id', ''), ('url', ''), ('upload', FieldStorage('upload', 'worldbankdataonindia1.csv')), ('clear_upload', ''), ('name', 'hello test'), ('description', 'hello test'), ('format', 'csv'), ('save', 'go-metadata')]), <FakeCGIBody at 0x7f4740032d10 viewing MultiDict([('id...a')])>)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   webob._parsed_query_vars: (GET([]), '')
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   webob.adhoc_attrs: {'errors': 'ignore', 'response': <Response at 0x7f4740058450 200 OK>, 'language': 'en-us'}
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   webob.is_body_readable: True
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   webob.is_body_seekable: False
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   wsgi process: 'Multi process AND threads (?)'
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f473417cb70>
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   wsgi.version: (1, 1)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f4740032710>, {'action': u'new_resource', 'controller': u'package', 'id': u'hello'})
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] ------------------------------------------------------------
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]             <p>Additionally an error occurred while sending the <weberror.reporter.EmailReporter object at 0x7f474014fd10> report:
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] 
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]             <pre>Traceback (most recent call last):
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/errormiddleware.py", line 450, in send_report
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     rep.report(exc_data)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/reporter.py", line 45, in report
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     server = smtplib.SMTP(self.smtp_server)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/python2.7/smtplib.py", line 249, in __init__
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     (code, msg) = self.connect(host, port)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/python2.7/smtplib.py", line 309, in connect
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     self.sock = self._get_socket(host, port, self.timeout)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/python2.7/smtplib.py", line 284, in _get_socket
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     return socket.create_connection((port, host), timeout)
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]   File "/usr/lib/python2.7/socket.py", line 571, in create_connection
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]     raise err
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] error: [Errno 111] Connection refused
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7] </pre>
[Wed Oct 08 17:26:54 2014] [error] 2014-10-08 17:26:54,299 INFO  [ckan.lib.base]  /dataset/new_resource/hello render time 0.058 seconds
[Wed Oct 08 17:26:54 2014] [error] [client 192.168.32.7]             </p>
[Wed Oct 08 17:26:54 2014] [error] 2014-10-08 17:26:54,433 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:26:59 2014] [error] 2014-10-08 17:26:59,710 INFO  [ckan.lib.base]  /dataset render time 0.235 seconds
[Wed Oct 08 17:26:59 2014] [error] 2014-10-08 17:26:59,832 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds
[Wed Oct 08 17:27:01 2014] [error] 2014-10-08 17:27:01,541 INFO  [ckan.lib.base]  /dataset/world-bank render time 0.263 seconds
[Wed Oct 08 17:27:01 2014] [error] 2014-10-08 17:27:01,696 INFO  [ckan.lib.base]  /api/i18n/en render time 0.002 seconds
[Wed Oct 08 17:27:05 2014] [error] 2014-10-08 17:27:05,293 INFO  [ckan.lib.base]  /dataset render time 0.058 seconds
[Wed Oct 08 17:27:05 2014] [error] 2014-10-08 17:27:05,417 INFO  [ckan.lib.base]  /api/i18n/en render time 0.001 seconds


More information about the ckan-dev mailing list