[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