[ECODP-dev] ckan errors in logs

Mon Feb 4 09:33:47 UTC 2013

Thanks Bert, it looks like there was an error while indexing that
particular dataset for some reason. I will check the logs to see if this is
still happening.

John

On 25 January 2013 17:20, Bert Van Nuffelen
<bert.van.nuffelen at tenforce.com>wrote:

> Hi,
>
> I am searching for the reason why package_update calls return OK but
> the changes are not taken into account. This is ODP-194.
>
> This is a frequent line, but I believe this is connected with the
> create REST call we do as we do not know if the dataset is already in
> CKAN or not.
> 2013-01-25 16:05:11,116 ERROR [ckan.controllers.api] Validation error:
> "{'__type': 'Validation Error', 'name': [u'That URL is already in
> use.']}"
>
> Here is another line I encountered. Maybe it has nothing with the
> topic to do, but whatever I encounter I share.
>
> 2013-01-25 09:42:45,191 ERROR [ckan.lib.search] Error while indexing
> dataset e4caf741-5753-42e0-bab0-5717419bf032: (ProgrammingError)
> relation "resource_revision" does not exist
> LINE 2: FROM resource_revision JOIN resource_group ON resource_group...
>              ^
>  'SELECT resource_revision.id, resource_revision.resource_group_id,
> resource_revision.url, resource_revision.format,
> resource_revision.description, resource_revision.hash,
> resource_revision.position, resource_revision.name,
> resource_revision.resource_type, resource_revision.mimetype,
> resource_revision.mimetype_inner, resource_revision.size,
> resource_revision.created, resource_revision.last_modified,
> resource_revision.cache_url, resource_revision.cache_last_updated,
> resource_revision.webstore_url,
> resource_revision.webstore_last_updated, resource_revision.extras,
> resource_revision.state, resource_revision.revision_id,
> resource_revision.continuity_id, resource_revision.expired_id,
> resource_revision.revision_timestamp,
> resource_revision.expired_timestamp, resource_revision.current \nFROM
> resource_revision JOIN resource_group ON resource_group.id =
> resource_revision.resource_group_id \nWHERE resource_group.package_id
> = %(package_id_1)s AND resource_revision.current = %(current_1)s'
> {'package_id_1': u'e4caf741-5753-42e0-bab0-5717419bf032', 'current_1':
> True}
>
> 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
>
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org
> 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/20130204/b5a7b385/attachment.html>