[ckan-dev] Warning when rebuilding Solr search index

[vikesh rambaran]

Hi

After some more testing, here's what we found:

This issue seems to be related to the CKAN harvester extension.

If we delete and purge all datasets, then run the solr rebuild, no warning
is generated.
Manually creating the dataset with resource does not generate a warning.

Creating and running a harvest, triggers the warning.
For the test, the harvest source was not accessible, therefore no data was
inserted into CKAN.
However, the posgres output shows two entries in the package table, one of
type harvest and the other of type dataset.

Hopefully this will help in isolating the problem.

Thanx for your help
V

On Thu, Oct 25, 2018 at 10:06 AM vikesh rambaran <vikesh.rambaran at gmail.com>
wrote:

> Hi
>
> We are using CKAN version 2.8
>
> When rebuilding the solr search index, the following warning is generated:
>
> /usr/lib/ckan/default/local/lib/python2.7/site-packages/sqlalchemy/sql/compiler.py:624:
> SAWarning: Can't resolve label reference 'error_count desc'; converting to
> text() (this warning may be suppressed after 10 occurrences)
>   util.ellipses_string(element.element))
>
> The command used to build the index is: paster --plugin=ckan search-index
> rebuild --config=/etc/ckan/default/production.ini
>
> The rest of the indexing seems to complete ok. The datasets and search
> function, still seem to work ok in the CKAN web front end.
>
> What does the warning mean?
> What is the implication on data loss or corruption ?
> What can be done to resolve the warning ?
>
> Thanx for your help
> Vikesh
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20181025/5507fa8f/attachment-0002.html>