Biblios not always removed from Elasticsearch index after delete
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@koha-suomi.fi +358 40 021 3514
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@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@koha-suomi.fi +358 40 021 3514
_______________________________________________ Koha-devel mailing list Koha-devel@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/
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@koha-suomi.fi +358 40 021 3514 Jan 29, 2024, 18:27 by jonathan.druart@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@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@koha-suomi.fi +358 40 021 3514
_______________________________________________ Koha-devel mailing list Koha-devel@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/
participants (2)
-
Emmi Takkinen -
Jonathan Druart