[ECODP-dev] Reseting new database error with vocabularies
John Glover
john.glover at okfn.org
Mon Sep 9 10:57:22 UTC 2013
Hi Dimitrios,
It looks like your database is out of sync, can you run:
paster --plugin=ckan db upgrade -c <ckan config>
and confirm that this fixes the issue.
If so, I am not sure why this database has not been upgraded, we have not
introduced any new database migrations between release 09 and release 1.
Regards,
John
On 9 September 2013 12:40, Dimitrios Mexis <dimitrios.mexis at tenforce.com>wrote:
> *STATUS:*
> *a*) taking backup from OKF database and applying the reset BUT changing
> from create-vocab to update-vocab plus the publishers without files, seems
> to be working.
>
> *b*) taking backup from ODP, where is a 09 release I applied the
> following :
>
> - (ecportal)[root at tffvirt-rh-template bin]# paster
> --plugin=ckanext-ecportal ecportal migrate-odp-namespace -c
> /applications/ecodp/users/ecodp/ckan/conf/ecportal.ini
> - Completed No error
> - (ecportal)[root at tffvirt-rh-template bin]# paster
> --plugin=ckanext-ecportal ecportal update-all-vocabs -c
> /applications/ecodp/users/ecodp/ckan/conf/ecportal.ini
> - Completed No error
> - (ecportal)[root at tffvirt-rh-template bin]# paster
> --plugin=ckanext-ecportal ecportal update-publishers -c
> /applications/ecodp/users/ecodp/ckan/conf/ecportal.ini
> - Completed No error
>
> 2013-09-09 12:33:06,555 WARNI [root] No english version of Association
> française de normalisation [afn]. Skipping
> 2013-09-09 12:33:06,555 WARNI [root] No english version of НЕОКОНЧАТЕЛНИ
> ДАННИ [op_datpro]. Skipping
>
> - (ecportal)[root at tffvirt-rh-template bin]#
>
>
> *So now I go back to the testing server and I get 500. In the logs I have
> something like that:*
> [root at tffvirt-rh-template bin]# tail -f /var/log/httpd/ecodp.error.log
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._autorollback()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1345, in _autorollback
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._rollback_impl()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1265, in _rollback_impl
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._handle_dbapi_exception(e, None, None, None, None)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1262, in _rollback_impl
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self.engine.dialect.do_rollback(self.connection)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
> line 300, in do_rollback
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> connection.rollback()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] InterfaceError:
> (InterfaceError) connection already closed None None
> q^C
> [root at tffvirt-rh-template bin]# cat /var/log/httpd/ecodp.error.log
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] Error - <class
> 'sqlalchemy.exc.OperationalError'>: (OperationalError) terminating
> connection due to administrator command
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] 'SELECT
> "user".password AS user_password, "user".id AS user_id, "user".name AS
> user_name, "user".openid AS user_openid, "user".fullname AS user_fullname,
> "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS
> user_created, "user".reset_key AS user_reset_key, "user".about AS
> user_about \\nFROM "user" \\nWHERE "user".name = %(name_1)s ORDER BY
> "user".name \\n LIMIT %(param_1)s' {'name_1': u'api', 'param_1': 1}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] URL:
> https://192.168.35.139/data/
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/weberror/errormiddleware.py',
> line 162 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] app_iter =
> self.application(environ, sr_checker)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 73 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> self.app(environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 155 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> self.wrap_app(environ, session_start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/repoze/who/middleware.py',
> line 87 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] app_iter =
> app(environ, wrapper.wrap_start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/routes/middleware.py',
> line 131 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] response =
> self.app(environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 125 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] response =
> self.dispatch(controller, environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 324 in dispatch
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> controller(environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 238 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] res =
> WSGIController.__call__(self, environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 217 in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] response =
> self._inspect_call(self.__before__)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 107 in _inspect_call
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] result =
> self._perform_call(func, args)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 60 in _perform_call
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> func(**args)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/controllers/home.py',
> line 20 in __before__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> BaseController.__before__(self, action, **env)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 171 in __before__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self._identify_user()
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 205 in _identify_user
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] c.userobj =
> model.User.by_name(c.user)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/model/domain_object.py',
> line 44 in by_name
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> .filter_by(name=name).first()
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2156 in first
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] ret =
> list(self[0:1])
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2023 in __getitem__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> list(res)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2227 in __iter__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> self._execute_and_instances(context)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2242 in _execute_and_instances
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] result =
> conn.execute(querycontext.statement, self._params)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1449 in execute
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] params)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1584 in _execute_clauseelement
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] compiled_sql,
> distilled_params
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1698 in _execute_context
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1691 in _execute_context
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py',
> line 331 in do_execute
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> cursor.execute(statement, parameters)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> OperationalError: (OperationalError) terminating connection due to
> administrator command
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] 'SELECT
> "user".password AS user_password, "user".id AS user_id, "user".name AS
> user_name, "user".openid AS user_openid, "user".fullname AS user_fullname,
> "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS
> user_created, "user".reset_key AS user_reset_key, "user".about AS
> user_about \\nFROM "user" \\nWHERE "user".name = %(name_1)s ORDER BY
> "user".name \\n LIMIT %(param_1)s' {'name_1': u'api', 'param_1': 1}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] CGI Variables
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] -------------
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> CKAN_CURRENT_URL: '/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] CKAN_LANG:
> 'en'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] CONTENT_TYPE:
> '; charset=utf-8'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> DOCUMENT_ROOT: '/applications/ecodp/users/ecodp/drupal/www'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> GATEWAY_INTERFACE: 'CGI/1.1'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] HTTP_ACCEPT:
> 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_ENCODING: 'gzip,deflate,sdch'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_LANGUAGE: 'el-GR,el;q=0.8'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_CACHE_CONTROL: 'max-age=0'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_CONNECTION: 'close'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] HTTP_COOKIE:
> 'Drupal.tableDrag.showWeight=0; Drupal.toolbar.collapsed=0;
> ckan=c44390ed42adb654b37348bb779c4b23e2c849ecb01b8d929420438f8a366c2a436bee16'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] HTTP_HOST:
> '192.168.35.139'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] HTTP_PRAGMA:
> 'no-cache'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] HTTP_REFERER:
> 'https://192.168.35.139/en/data/user/api'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_USER_AGENT: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36
> (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_X_FORWARDED_FOR: '192.168.33.95'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> HTTP_X_SCHEME: 'https'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] PATH_INFO: '/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> PATH_TRANSLATED: 'redirect:/index.php/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] REMOTE_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] REMOTE_PORT:
> '41758'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] REMOTE_USER:
> u'api'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> REQUEST_METHOD: 'GET'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] REQUEST_URI:
> '/en/data/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> SCRIPT_FILENAME: '/applications/ecodp/users/ecodp/ckan/conf/wsgi.py'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SCRIPT_NAME:
> '/data'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SCRIPT_URI: '
> http://192.168.35.139:8008/en/data/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SCRIPT_URL:
> '/en/data/'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SERVER_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SERVER_ADMIN:
> 'root at localhost'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SERVER_NAME:
> '192.168.35.139'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] SERVER_PORT:
> '8008'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> SERVER_PROTOCOL: 'HTTP/1.0'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> SERVER_SIGNATURE: '<address>Apache/2.2.15 (Red Hat) Server at
> 192.168.35.139 Port 8008</address>\\n'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> SERVER_SOFTWARE: 'Apache/2.2.15 (Red Hat)'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] WSGI Variables
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] --------------
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] application:
> <beaker.middleware.CacheMiddleware object at 0x7f772e3d3dd0>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] beaker.cache:
> <beaker.cache.CacheManager object at 0x7f772e3d3e10>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> beaker.get_session: <bound method SessionMiddleware._get_session of
> <beaker.middleware.SessionMiddleware object at 0x7f772e3d3ed0>>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> beaker.session: {'_accessed_time': 1378722816.2212901, 'repoze.who.tkt':
> u'api', '_creation_time': 1378453025.985662}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.application_group: '127.0.0.1:8008|/data'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.callable_object: 'application'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.handler_script: ''
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.input_chunked: '0'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_host: ''
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_port: '8008'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.process_group: 'ecodp'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.request_handler: 'wsgi-script'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.script_reloading: '1'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> mod_wsgi.version: (3, 2)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> paste.registry: <paste.registry.Registry object at 0x7f77283545d0>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> paste.throw_errors: True
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> pylons.controller: <ckan.controllers.home.HomeController object at
> 0x7f772e231710>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> pylons.environ_config: {'session': 'beaker.session', 'cache':
> 'beaker.cache'}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> pylons.pylons: <pylons.util.PylonsContext object at 0x7f772e231a90>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> pylons.routes_dict: {'action': u'index', 'controller': u'home'}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> repoze.who.api: <repoze.who.api.API object at 0x7f772854d8d0>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> repoze.who.identity: <repoze.who identity (hidden, dict-like) at
> 140149614773552>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> repoze.who.logger: <logging.Logger instance at 0x7f772e3d4830>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> repoze.who.plugins: {'use_beaker': <UseBeakerPlugin 140149854761616>,
> 'ckan.lib.authenticator:UsernamePasswordAuthenticator':
> <ckan.lib.authenticator.UsernamePasswordAuthenticator object at
> 0x7f772e3ccf90>, 'friendlyform': <FriendlyFormPlugin 140149853601680>,
> 'ckan.lib.authenticator:BeakerSessionAuthenticator':
> <ckan.lib.authenticator.BeakerSessionAuthenticator object at
> 0x7f772e3ccb90>}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] routes.route:
> <routes.route.Route object at 0x7f772e0eead0>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] routes.url:
> <routes.util.URLGenerator object at 0x7f7728e5d6d0>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> webob._parsed_query_vars: (GET([]), '')
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> webob.adhoc_attrs: {'language': 'en-us'}
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] wsgi process:
> 'Multi process AND threads (?)'
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object
> at 0x7f772e4f8a80>
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] wsgi.version:
> (1, 1)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f7728e5d6d0>,
> {'action': u'index', 'controller': u'home'})
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> ------------------------------------------------------------
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] mod_wsgi
> (pid=5666): Exception occurred processing WSGI script
> '/applications/ecodp/users/ecodp/ckan/conf/wsgi.py'.
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] Traceback (most
> recent call last):
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/conf/wsgi.py", line 26, in application
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> _application(environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/apachemiddleware/__init__.py",
> line 37, in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> self.app(environ, start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/gzipper.py",
> line 38, in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> response.gzip_start_response)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/config/middleware.py",
> line 323, in __call__
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self.engine.execute(sql, key, data.get('url'), data.get('type'))
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 2447, in execute
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] return
> connection.execute(statement, *multiparams, **params)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1449, in execute
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] params)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1628, in _execute_text
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] statement,
> parameters
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1698, in _execute_context
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1829, in _handle_dbapi_exception
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self._autorollback()
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1345, in _autorollback
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self._rollback_impl()
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1265, in _rollback_impl
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self._handle_dbapi_exception(e, None, None, None, None)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1262, in _rollback_impl
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> self.engine.dialect.do_rollback(self.connection)
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
> line 300, in do_rollback
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139]
> connection.rollback()
> [Mon Sep 09 12:33:36 2013] [error] [client 192.168.35.139] InterfaceError:
> (InterfaceError) connection already closed None None
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] Error - <class
> 'sqlalchemy.exc.OperationalError'>: (OperationalError) terminating
> connection due to administrator command
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] 'SELECT
> "user".password AS user_password, "user".id AS user_id, "user".name AS
> user_name, "user".openid AS user_openid, "user".fullname AS user_fullname,
> "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS
> user_created, "user".reset_key AS user_reset_key, "user".about AS
> user_about \\nFROM "user" \\nWHERE "user".name = %(name_1)s ORDER BY
> "user".name \\n LIMIT %(param_1)s' {'name_1': u'api', 'param_1': 1}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] URL:
> https://192.168.35.139/data/
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/weberror/errormiddleware.py',
> line 162 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] app_iter =
> self.application(environ, sr_checker)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 73 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> self.app(environ, start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 155 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> self.wrap_app(environ, session_start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/repoze/who/middleware.py',
> line 87 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] app_iter =
> app(environ, wrapper.wrap_start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/routes/middleware.py',
> line 131 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] response =
> self.app(environ, start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 125 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] response =
> self.dispatch(controller, environ, start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 324 in dispatch
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> controller(environ, start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 238 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] res =
> WSGIController.__call__(self, environ, start_response)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 217 in __call__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] response =
> self._inspect_call(self.__before__)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 107 in _inspect_call
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] result =
> self._perform_call(func, args)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 60 in _perform_call
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> func(**args)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/controllers/home.py',
> line 20 in __before__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> BaseController.__before__(self, action, **env)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 171 in __before__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> self._identify_user()
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 205 in _identify_user
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] c.userobj =
> model.User.by_name(c.user)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/model/domain_object.py',
> line 44 in by_name
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> .filter_by(name=name).first()
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2156 in first
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] ret =
> list(self[0:1])
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2023 in __getitem__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> list(res)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2227 in __iter__
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] return
> self._execute_and_instances(context)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py',
> line 2242 in _execute_and_instances
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] result =
> conn.execute(querycontext.statement, self._params)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1449 in execute
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] params)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1584 in _execute_clauseelement
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] compiled_sql,
> distilled_params
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1698 in _execute_context
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1691 in _execute_context
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py',
> line 331 in do_execute
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> cursor.execute(statement, parameters)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> OperationalError: (OperationalError) terminating connection due to
> administrator command
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] 'SELECT
> "user".password AS user_password, "user".id AS user_id, "user".name AS
> user_name, "user".openid AS user_openid, "user".fullname AS user_fullname,
> "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS
> user_created, "user".reset_key AS user_reset_key, "user".about AS
> user_about \\nFROM "user" \\nWHERE "user".name = %(name_1)s ORDER BY
> "user".name \\n LIMIT %(param_1)s' {'name_1': u'api', 'param_1': 1}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] CGI Variables
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] -------------
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> CKAN_CURRENT_URL: '/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] CKAN_LANG:
> 'en'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] CONTENT_TYPE:
> '; charset=utf-8'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> DOCUMENT_ROOT: '/applications/ecodp/users/ecodp/drupal/www'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> GATEWAY_INTERFACE: 'CGI/1.1'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] HTTP_ACCEPT:
> 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_ENCODING: 'gzip,deflate,sdch'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_LANGUAGE: 'el-GR,el;q=0.8'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_CACHE_CONTROL: 'max-age=0'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_CONNECTION: 'close'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] HTTP_COOKIE:
> 'Drupal.tableDrag.showWeight=0; Drupal.toolbar.collapsed=0;
> ckan=c44390ed42adb654b37348bb779c4b23e2c849ecb01b8d929420438f8a366c2a436bee16'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] HTTP_HOST:
> '192.168.35.139'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] HTTP_PRAGMA:
> 'no-cache'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] HTTP_REFERER:
> 'https://192.168.35.139/en/data/user/api'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_USER_AGENT: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36
> (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_X_FORWARDED_FOR: '192.168.33.95'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> HTTP_X_SCHEME: 'https'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] PATH_INFO: '/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> PATH_TRANSLATED: 'redirect:/index.php/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] REMOTE_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] REMOTE_PORT:
> '41786'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] REMOTE_USER:
> u'api'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> REQUEST_METHOD: 'GET'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] REQUEST_URI:
> '/en/data/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> SCRIPT_FILENAME: '/applications/ecodp/users/ecodp/ckan/conf/wsgi.py'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SCRIPT_NAME:
> '/data'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SCRIPT_URI: '
> http://192.168.35.139:8008/en/data/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SCRIPT_URL:
> '/en/data/'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SERVER_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SERVER_ADMIN:
> 'root at localhost'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SERVER_NAME:
> '192.168.35.139'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] SERVER_PORT:
> '8008'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> SERVER_PROTOCOL: 'HTTP/1.0'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> SERVER_SIGNATURE: '<address>Apache/2.2.15 (Red Hat) Server at
> 192.168.35.139 Port 8008</address>\\n'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> SERVER_SOFTWARE: 'Apache/2.2.15 (Red Hat)'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] WSGI Variables
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] --------------
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] application:
> <beaker.middleware.CacheMiddleware object at 0x7f772b7ccc10>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] beaker.cache:
> <beaker.cache.CacheManager object at 0x7f772b7ccc50>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> beaker.get_session: <bound method SessionMiddleware._get_session of
> <beaker.middleware.SessionMiddleware object at 0x7f772b7ccd10>>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> beaker.session: {'repoze.who.tkt': u'api', '_accessed_time':
> 1378722817.1219549, '_creation_time': 1378453025.985662}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.application_group: '127.0.0.1:8008|/data'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.callable_object: 'application'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.handler_script: ''
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.input_chunked: '0'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_host: ''
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_port: '8008'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.process_group: 'ecodp'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.request_handler: 'wsgi-script'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.script_reloading: '1'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> mod_wsgi.version: (3, 2)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> paste.registry: <paste.registry.Registry object at 0x7f772b7c4a10>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> paste.throw_errors: True
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> pylons.controller: <ckan.controllers.home.HomeController object at
> 0x7f772b7d8d50>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> pylons.environ_config: {'session': 'beaker.session', 'cache':
> 'beaker.cache'}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> pylons.pylons: <pylons.util.PylonsContext object at 0x7f772b7d8d90>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> pylons.routes_dict: {'action': u'index', 'controller': u'home'}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> repoze.who.api: <repoze.who.api.API object at 0x7f772b7d88d0>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> repoze.who.identity: <repoze.who identity (hidden, dict-like) at
> 140149614789648>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> repoze.who.logger: <logging.Logger instance at 0x7f772b7ca710>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> repoze.who.plugins: {'use_beaker': <UseBeakerPlugin 140149807472848>,
> 'ckan.lib.authenticator:UsernamePasswordAuthenticator':
> <ckan.lib.authenticator.UsernamePasswordAuthenticator object at
> 0x7f772b7d6b10>, 'friendlyform': <FriendlyFormPlugin 140149807435216>,
> 'ckan.lib.authenticator:BeakerSessionAuthenticator':
> <ckan.lib.authenticator.BeakerSessionAuthenticator object at
> 0x7f772b7d6210>}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] routes.route:
> <routes.route.Route object at 0x7f772b4bca90>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] routes.url:
> <routes.util.URLGenerator object at 0x7f772b7d8590>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> webob._parsed_query_vars: (GET([]), '')
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> webob.adhoc_attrs: {'language': 'en-us'}
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] wsgi process:
> 'Multi process AND threads (?)'
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object
> at 0x7f7728e625d0>
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139] wsgi.version:
> (1, 1)
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f772b7d8590>,
> {'action': u'index', 'controller': u'home'})
> [Mon Sep 09 12:33:37 2013] [error] [client 192.168.35.139]
> ------------------------------------------------------------
> [Mon Sep 09 12:33:54 2013] [error] [client 192.168.35.139] Error - <class
> 'sqlalchemy.exc.OperationalError'>: (OperationalError) terminating
> connection due to administrator command
> [Mon Sep 09 12:33:54 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:54 2013] [error] [client 192.168.35.139] 'SELECT
> term_translation.term, term_translation.term_translation,
> term_translation.lang_code \\nFROM term_translation \\nWHERE
> term_translation.term != term_translation.term AND
> term_translation.lang_code IN (%(lang_code_1)s, %(lang_code_2)s)'
> {'lang_code_2': 'en', 'lang_code_1': 'en'}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] URL:
> http://192.168.35.139/data/
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/weberror/errormiddleware.py',
> line 162 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] app_iter =
> self.application(environ, sr_checker)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 73 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> self.app(environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/beaker/middleware.py',
> line 155 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> self.wrap_app(environ, session_start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/repoze/who/middleware.py',
> line 87 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] app_iter =
> app(environ, wrapper.wrap_start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/routes/middleware.py',
> line 131 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] response =
> self.app(environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 125 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] response =
> self.dispatch(controller, environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/wsgiapp.py',
> line 324 in dispatch
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> controller(environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/base.py',
> line 238 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] res =
> WSGIController.__call__(self, environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 221 in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] response =
> self._dispatch_call()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 172 in _dispatch_call
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] response =
> self._inspect_call(func)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 107 in _inspect_call
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] result =
> self._perform_call(func, args)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/pylons/controllers/core.py',
> line 60 in _perform_call
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> func(**args)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/controllers/home.py',
> line 51 in index
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] context,
> data_dict)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/logic.py',
> line 398 in package_search
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> logic.action.get.package_search(context, data_dict)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/logic/action/get.py',
> line 1196 in package_search
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> search_results = item.after_search(search_results,data_dict)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckanext/multilingual/plugin.py',
> line 192 in after_search
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] 'lang_codes':
> (desired_lang_code, fallback_lang_code)})
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/logic/action/get.py',
> line 1590 in term_translation_show
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] cursor =
> conn.execute(q)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1449 in execute
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] params)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1584 in _execute_clauseelement
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] compiled_sql,
> distilled_params
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1698 in _execute_context
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py',
> line 1691 in _execute_context
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> '/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py',
> line 331 in do_execute
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> cursor.execute(statement, parameters)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> OperationalError: (OperationalError) terminating connection due to
> administrator command
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] FATAL:
> terminating connection due to administrator command
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] 'SELECT
> term_translation.term, term_translation.term_translation,
> term_translation.lang_code \\nFROM term_translation \\nWHERE
> term_translation.term != term_translation.term AND
> term_translation.lang_code IN (%(lang_code_1)s, %(lang_code_2)s)'
> {'lang_code_2': 'en', 'lang_code_1': 'en'}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] CGI Variables
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] -------------
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> CKAN_CURRENT_URL: '/'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] CKAN_LANG:
> 'en'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] CONTENT_TYPE:
> '; charset=utf-8'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> DOCUMENT_ROOT: '/applications/ecodp/users/ecodp/drupal/www'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> GATEWAY_INTERFACE: 'CGI/1.1'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] HTTP_ACCEPT:
> 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_ENCODING: 'gzip,deflate,sdch'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_ACCEPT_LANGUAGE: 'el-GR,el;q=0.8'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_CONNECTION: 'close'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] HTTP_COOKIE:
> 'Drupal.tableDrag.showWeight=0; Drupal.toolbar.collapsed=0'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] HTTP_HOST: '
> 192.168.35.139:80'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_USER_AGENT: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36
> (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_X_FORWARDED_FOR: '192.168.33.95'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> HTTP_X_SCHEME: 'http'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] PATH_INFO: '/'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> PATH_TRANSLATED: 'redirect:/index.php/'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] REMOTE_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] REMOTE_PORT:
> '41817'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> REQUEST_METHOD: 'GET'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] REQUEST_URI:
> '/en/data'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> SCRIPT_FILENAME: '/applications/ecodp/users/ecodp/ckan/conf/wsgi.py'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SCRIPT_NAME:
> '/data'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SCRIPT_URI: '
> http://192.168.35.139/en/data'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SCRIPT_URL:
> '/en/data'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SERVER_ADDR:
> '192.168.35.139'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SERVER_ADMIN:
> 'root at localhost'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SERVER_NAME:
> '192.168.35.139'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] SERVER_PORT:
> '80'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> SERVER_PROTOCOL: 'HTTP/1.0'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> SERVER_SIGNATURE: '<address>Apache/2.2.15 (Red Hat) Server at
> 192.168.35.139 Port 80</address>\\n'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> SERVER_SOFTWARE: 'Apache/2.2.15 (Red Hat)'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] WSGI Variables
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] --------------
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] application:
> <beaker.middleware.CacheMiddleware object at 0x7f773aded190>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] beaker.cache:
> <beaker.cache.CacheManager object at 0x7f773aded1d0>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> beaker.get_session: <bound method SessionMiddleware._get_session of
> <beaker.middleware.SessionMiddleware object at 0x7f773aded290>>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> beaker.session: {'_accessed_time': 1378722834.913377, '_creation_time':
> 1378722834.913377}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.application_group: '127.0.0.1|/data'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.callable_object: 'application'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.handler_script: ''
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.input_chunked: '0'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_host: ''
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.listener_port: '8008'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.process_group: 'ecodp'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.request_handler: 'wsgi-script'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.script_reloading: '1'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> mod_wsgi.version: (3, 2)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> paste.registry: <paste.registry.Registry object at 0x7f77200abf10>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> paste.throw_errors: True
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> pylons.action_method: <bound method HomeController.index of
> <ckan.controllers.home.HomeController object at 0x7f77200b54d0>>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> pylons.controller: <ckan.controllers.home.HomeController object at
> 0x7f77200b54d0>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> pylons.environ_config: {'session': 'beaker.session', 'cache':
> 'beaker.cache'}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> pylons.pylons: <pylons.util.PylonsContext object at 0x7f77200b5650>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> pylons.routes_dict: {'action': u'index', 'controller': u'home'}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> repoze.who.api: <repoze.who.api.API object at 0x7f77200ab110>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> repoze.who.logger: <logging.Logger instance at 0x7f773adeb4d0>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> repoze.who.plugins: {'use_beaker': <UseBeakerPlugin 140150065503504>,
> 'ckan.lib.authenticator:UsernamePasswordAuthenticator':
> <ckan.lib.authenticator.UsernamePasswordAuthenticator object at
> 0x7f773ade9d90>, 'friendlyform': <FriendlyFormPlugin 140150065517392>,
> 'ckan.lib.authenticator:BeakerSessionAuthenticator':
> <ckan.lib.authenticator.BeakerSessionAuthenticator object at
> 0x7f773ade9cd0>}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] routes.route:
> <routes.route.Route object at 0x7f773ab6f5d0>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] routes.url:
> <routes.util.URLGenerator object at 0x7f77200abc50>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> webob._parsed_query_vars: (GET([]), '')
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> webob.adhoc_attrs: {'language': 'en-us'}
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] wsgi process:
> 'Multi process AND threads (?)'
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object
> at 0x7f77200a3cd8>
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] wsgi.version:
> (1, 1)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f77200abc50>,
> {'action': u'index', 'controller': u'home'})
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> ------------------------------------------------------------
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] mod_wsgi
> (pid=5665): Exception occurred processing WSGI script
> '/applications/ecodp/users/ecodp/ckan/conf/wsgi.py'.
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] Traceback (most
> recent call last):
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/conf/wsgi.py", line 26, in application
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> _application(environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/apachemiddleware/__init__.py",
> line 37, in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> self.app(environ, start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/gzipper.py",
> line 38, in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> response.gzip_start_response)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/config/middleware.py",
> line 323, in __call__
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self.engine.execute(sql, key, data.get('url'), data.get('type'))
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 2447, in execute
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] return
> connection.execute(statement, *multiparams, **params)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1449, in execute
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] params)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1628, in _execute_text
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] statement,
> parameters
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1698, in _execute_context
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] context)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1829, in _handle_dbapi_exception
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._autorollback()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1345, in _autorollback
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._rollback_impl()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1265, in _rollback_impl
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self._handle_dbapi_exception(e, None, None, None, None)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
> line 1262, in _rollback_impl
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> self.engine.dialect.do_rollback(self.connection)
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] File
> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
> line 300, in do_rollback
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139]
> connection.rollback()
> [Mon Sep 09 12:33:55 2013] [error] [client 192.168.35.139] InterfaceError:
> (InterfaceError) connection already closed None None
> [root at tffvirt-rh-template bin]# date
> Mon Sep 9 12:36:56 CEST 2013
> [root at tffvirt-rh-template bin]#
>
>
> On 6/09/2013 10:33, Dimitrios Mexis wrote:
>
> Hello John/David,
>
> under directory */applications/ecodp/users/ecodp/ckan/bin/*
> there is the script :
> /applications/ecodp/users/ecodp/ckan/bin/*ckan_reset_db.sh*
>
> which uses the paster commands to reset database and import the necessary
> staff.
>
> We get an error. check please the last line. the db is unusable later.
> Keep in mind that we reset a database that is already upgraded.
>
> Initialising DB: SUCCESS
> Creating the search_query table ...
> done.
> Creating the search_popular_latest table ...
> done.
> Creating the search_popular_approved table ...
> done.
> Creating the search_query_date index ...
> done.
> 2013-09-06 10:25:50,739 INFO [ckan.lib.search] Rebuilding search index...
> 2013-09-06 10:25:50,742 INFO [ckan.lib.search] Rebuilding the whole
> index...
> 2013-09-06 10:25:50,825 INFO [ckan.lib.search] Finished rebuilding search
> index.
> 2013-09-06 10:25:50,832 INFO [ckan.lib.search] Commited pending changes
> on the search index
> *2013-09-06 10:25:51,853 ERROR [root] Command "create-all-vocabs" not
> recognized*
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130909/50682072/attachment.html>
More information about the ecodp-dev
mailing list