[ECODP-dev] upgradeing an backup

Wed Jun 19 13:53:55 UTC 2013

Hi Bert,

On the first line, paster is trying to load development.ini for some
reaaon instead of ecportal.ini. This seems very unusual given that command,
is this on the acceptance server? That path to development.ini is not even
the default so I don't know where it is getting that from. I would need to
have a look at the server.

For the second command, the database does not seem to be in the expected
state. However, could you please confirm by using the paster command that I
supplied in the release notes instead of that shell script.

Regards,
John

On Wednesday, June 19, 2013, Bert Van Nuffelen wrote:

> 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 <javascript:;>
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen
>
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org <javascript:;>
> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130619/6f190d08/attachment.html>