[ECODP-dev] upgradeing an backup

Wed Jun 19 11:58:59 UTC 2013

Hi,

after upgrading a v1.7 db to v1.8 which gave the proper result.

the searchcloud raised this exception

[root at rpm-tester bin]#
/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster
--plugin=ckanext-ecportal ecportal searchcloud-install-tables –c
/applications/ecodp/users/ecodp/ckan/conf/ecportal.ini
Traceback (most recent call last):
  File "/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster",
line 9, in <module>
    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 104, in run
    invoke(command, command_name, options, args[1:])
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 143, in invoke
    exit_code = runner.run(args)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 238, in run
    result = self.command()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
line 89, in command
    self._load_config()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/cli.py",
line 76, in _load_config
    raise AssertionError('Config filename %r does not exist.' % self.filename)
AssertionError: Config filename
'/applications/ecodp/users/ecodp/ckan/bin/development.ini' does not
exist.

afterwards the reindexing returns the next error:

[root at rpm-tester bin]# ./ckan_reindex.sh
2013-06-19 13:58:30,958 INFO  [ckan.lib.search] Rebuilding search index...
2013-06-19 13:58:31,028 INFO  [ckan.lib.search] Rebuilding the whole index...
2013-06-19 13:58:31,100 ERROR [ckan.lib.search] Error while indexing
dataset cce68e10-1641-4d4d-8a2c-0487c8269a26: (ProgrammingError)
relation "tracking_summary" does not exist
LINE 2: FROM tracking_summary
             ^
 'SELECT tracking_summary.url AS tracking_summary_url,
tracking_summary.package_id AS tracking_summary_package_id,
tracking_summary.tracking_type AS tracking_summary_tracking_type,
tracking_summary.count AS tracking_summary_count,
tracking_summary.running_total AS tracking_summary_running_total,
tracking_summary.recent_views AS tracking_summary_recent_views,
tracking_summary.tracking_date AS tracking_summary_tracking_date
\nFROM tracking_summary \nWHERE tracking_summary.url = %(url_1)s ORDER
BY tracking_date desc \n LIMIT %(param_1)s' {'param_1': 1, 'url_1':
u'http://forest.jrc.ec.europa.eu/download/data/forest-data-download/'}
Traceback (most recent call last):
  File "/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster",
line 9, in <module>
    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 104, in run
    invoke(command, command_name, options, args[1:])
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 143, in invoke
    exit_code = runner.run(args)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
line 238, in run
    result = self.command()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/cli.py",
line 344, in command
    self.rebuild()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/cli.py",
line 366, in rebuild
    defer_commit=(not self.options.commit_each))
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/search/__init__.py",
line 183, in rebuild
    {'id': pkg_id}
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/logic.py",
line 224, in package_show
    result = logic.action.get.package_show(context, data_dict)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/logic/action/get.py",
line 601, in package_show
    package_dict = model_dictize.package_dictize(pkg, context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/dictization/model_dictize.py",
line 184, in package_dictize
    result_dict["resources"] = resource_list_dictize(result, context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/dictization/model_dictize.py",
line 50, in resource_list_dictize
    resource_dict = resource_dictize(res, context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/lib/dictization/model_dictize.py",
line 104, in resource_dictize
    tracking = model.TrackingSummary.get_for_resource(res.url)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/model/tracking.py",
line 35, in get_for_resource
    data = obj.filter_by(url=url).order_by('tracking_date desc').first()
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py",
line 2156, in first
    ret = list(self[0:1])
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py",
line 2023, in __getitem__
    return list(res)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py",
line 2227, in __iter__
    return self._execute_and_instances(context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/orm/query.py",
line 2242, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1449, in execute
    params)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
    context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
    context)
  File "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation
"tracking_summary" does not exist
LINE 2: FROM tracking_summary
             ^
 'SELECT tracking_summary.url AS tracking_summary_url,
tracking_summary.package_id AS tracking_summary_package_id,
tracking_summary.tracking_type AS tracking_summary_tracking_type,
tracking_summary.count AS tracking_summary_count,
tracking_summary.running_total AS tracking_summary_running_total,
tracking_summary.recent_views AS tracking_summary_recent_views,
tracking_summary.tracking_date AS tracking_summary_tracking_date
\nFROM tracking_summary \nWHERE tracking_summary.url = %(url_1)s ORDER
BY tracking_date desc \n LIMIT %(param_1)s' {'param_1': 1, 'url_1':
u'http://forest.jrc.ec.europa.eu/download/data/forest-data-download/'}

kind regards,

Bert

--
Bert Van Nuffelen

Semantic Technologies Software Architect at TenForce
www.tenforce.be

Bert.Van.Nuffelen at tenforce.com
Office: +32 (0)16 31 48 60
Mobile:+32 479 06 24 26
skype: bert.van.nuffelen