[ECODP-dev] Reseting new database error with vocabularies

Dimitrios Mexis dimitrios.mexis at tenforce.com
Mon Sep 9 10:40:16 UTC 2013


*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
      o 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
      o 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
      o 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/c4470e60/attachment.html>


More information about the ecodp-dev mailing list