[ECODP-dev] ckan errors in logs

Fri Jan 25 16:20:06 UTC 2013

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