[Koha-devel] Biblios not always removed from Elasticsearch index after delete

[Emmi Takkinen]

Hi Jonathan,

There are no jobs stuck and no "No jobs found" in the logs. All the jobs with failed biblionumbers in data column are marked as "finished". So everything seems to be working as it should with background workers. We did some digging and this could be an error on Elasticsearch which isn't properly caught on sub delete_index.

Regards,
Emmi

---
Emmi Takkinen
Järjestelmäkehittäjä
Koha-Suomi Oy
emmi.takkinen at koha-suomi.fi
+358 40 021 3514




Jan 29, 2024, 18:27 by jonathan.druart at bugs.koha-community.org:

> Hi Emmi,
>
> Search for "No job found" in the worker logs. Do you have jobs (in DB
> table background_jobs) stuck in "new" (with
> type="update_elastic_index")?
> If so, search in the data column for your biblionumbers.
> See also bug 35819.
>
> Regards,
> Jonathan
>
> Le lun. 29 janv. 2024 à 13:32, Emmi Takkinen via Koha-devel
> <koha-devel at lists.koha-community.org> a écrit :
>
>>
>> Hello all!
>>
>> We've had some reports that biblios which have been deleted via "Merge records" aren't always deleted from index and are shown in the search result list. When one opens such a result, Koha of course says there is no such a record in database. Some of these biblios have been deleted from database weeks ago and I'm able to remove them manually from index. So it's not a case where Elasticsearch is just slow deleting them or that there is something wrong with the Elastic object. I've also searched our logs for errors, but haven't found anything that could explain this.
>>
>> Has anyone faced a same sort of problem? We are running Koha version 22.11.00.001 <https://github.com/KohaSuomi/Koha-22x/commit/02c0a3b48a0854e2bbba0bd0064590b4a736ddea> with Elasticsearch 6.8.9.
>>
>> Regards,
>> Emmi
>> ---
>> Emmi Takkinen
>> Järjestelmäkehittäjä
>> Koha-Suomi Oy
>> emmi.takkinen at koha-suomi.fi
>> +358 40 021 3514
>>
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at lists.koha-community.org
>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> website : https://www.koha-community.org/
>> git : https://git.koha-community.org/
>> bugs : https://bugs.koha-community.org/
>>