Duplicate entries in search_api_algolia_deleted_items

Created on 28 February 2023, over 1 year ago

Problem/Motivation

When an item is deleted in Drupal there are multiple entries created in the database table: search_api_algolia_deleted_items

mysql> select * from search_api_algolia_deleted_items;
+--------+-------------------------+----------------------+
| id     | index_id                | object_id            |
+--------+-------------------------+----------------------+
| 898051 | algolia_search_index_de | entity:node/79256:de |
| 898056 | resource_finder_de      | entity:node/79256:de |
| 898061 | algolia_search_index_de | entity:node/79256:de |
| 898066 | resource_finder_de      | entity:node/79256:de |
| 898071 | algolia_search_index_de | entity:node/79256:de |
| 898076 | resource_finder_de      | entity:node/79256:de |
| 898081 | algolia_search_index_de | entity:node/79256:de |
| 898086 | resource_finder_de      | entity:node/79256:de |
| 898091 | algolia_search_index_de | entity:node/79256:de |
| 898096 | resource_finder_de      | entity:node/79256:de |
| 898101 | algolia_search_index_de | entity:node/79256:de |
| 898106 | resource_finder_de      | entity:node/79256:de |
| 898111 | algolia_search_index_de | entity:node/79256:de |
| 898116 | resource_finder_de      | entity:node/79256:de |
| 898121 | algolia_search_index_de | entity:node/79256:de |
| 898126 | resource_finder_de      | entity:node/79256:de |
| 898131 | algolia_search_index_de | entity:node/79256:de |
| 898136 | resource_finder_de      | entity:node/79256:de |
| 898141 | algolia_search_index_de | entity:node/79256:de |
| 898146 | resource_finder_de      | entity:node/79256:de |
| 898151 | algolia_search_index_de | entity:node/79256:de |
| 898156 | resource_finder_de      | entity:node/79256:de |
| 898161 | algolia_search_index_de | entity:node/79256:de |
| 898166 | resource_finder_de      | entity:node/79256:de |
| 898171 | algolia_search_index_de | entity:node/79256:de |
| 898176 | resource_finder_de      | entity:node/79256:de |
| 898181 | algolia_search_index_de | entity:node/79256:de |
| 898186 | resource_finder_de      | entity:node/79256:de |
| 898191 | algolia_search_index_de | entity:node/79256:de |
| 898196 | resource_finder_de      | entity:node/79256:de |
| 898201 | algolia_search_index_de | entity:node/79256:de |
| 898206 | resource_finder_de      | entity:node/79256:de |
| 898211 | algolia_search_index_de | entity:node/79256:de |
| 898216 | resource_finder_de      | entity:node/79256:de |
| 898221 | algolia_search_index_de | entity:node/79256:de |
| 898226 | resource_finder_de      | entity:node/79256:de |
| 898231 | algolia_search_index_de | entity:node/79256:de |
| 898236 | resource_finder_de      | entity:node/79256:de |
| 898241 | algolia_search_index_de | entity:node/79256:de |
| 898246 | resource_finder_de      | entity:node/79256:de |
| 898251 | algolia_search_index_de | entity:node/79256:de |
| 898256 | resource_finder_de      | entity:node/79256:de |
| 898261 | algolia_search_index_de | entity:node/79256:de |
| 898266 | resource_finder_de      | entity:node/79256:de |
| 898271 | algolia_search_index_de | entity:node/79256:de |
| 898276 | resource_finder_de      | entity:node/79256:de |
| 898281 | algolia_search_index_de | entity:node/79256:de |
| 898286 | resource_finder_de      | entity:node/79256:de |
| 898291 | algolia_search_index_de | entity:node/79256:de |
| 898296 | resource_finder_de      | entity:node/79256:de |
| 898301 | algolia_search_index_de | entity:node/79256:de |
| 898306 | resource_finder_de      | entity:node/79256:de |
| 898311 | algolia_search_index_de | entity:node/79256:de |
| 898316 | resource_finder_de      | entity:node/79256:de |
| 898321 | algolia_search_index_de | entity:node/79256:de |
| 898326 | resource_finder_de      | entity:node/79256:de |
| 898331 | algolia_search_index_de | entity:node/79256:de |
| 898336 | resource_finder_de      | entity:node/79256:de |
| 898341 | algolia_search_index_de | entity:node/79256:de |
| 898346 | resource_finder_de      | entity:node/79256:de |
| 898351 | algolia_search_index_de | entity:node/79256:de |
| 898356 | resource_finder_de      | entity:node/79256:de |
| 898361 | algolia_search_index_de | entity:node/79256:de |
| 898366 | resource_finder_de      | entity:node/79256:de |
| 898371 | algolia_search_index_de | entity:node/79256:de |
| 898376 | resource_finder_de      | entity:node/79256:de |
| 898381 | algolia_search_index_de | entity:node/79256:de |
| 898386 | resource_finder_de      | entity:node/79256:de |
| 898391 | algolia_search_index_de | entity:node/79256:de |
| 898396 | resource_finder_de      | entity:node/79256:de 

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Active

Version

3.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States kcolwell

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024