>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3579517. --> Reported by: [mxr576](https://www.drupal.org/user/315522) Related to !64 >>> <p>[Tracker]<br> <strong>Update Summary: </strong>[One-line status update for stakeholders]<br> <strong>Check-in Date: </strong>MM/DD/YYYY<br> <strong>Blocked by: </strong>[#XXXXXX] (New issues on new lines)<br> <strong>Additional Collaborators: </strong> @username1, @username2<br> <em>Metadata is used by the <a href="https://www.drupalstarforge.ai/" title="AI Tracker">AI Tracker.</a> Docs and additional fields <a href="https://www.drupalstarforge.ai/ai-dashboard/docs" title="AI Issue Tracker Documentation">here</a>.</em><br> [/Tracker]</p> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>Clicking on "Clear all indexed data" in one search index that uses VDB1 also drops indexed data of other search indexes that uses the same same database.</p> <p>The root cause should be <code>\Drupal\ai_provider_amazeeio\Vdb\Postgres\PostgresPgvectorClient::dropCollection()</code> drops the complete table instead of just dropping entries that belongs to <code>index_id</code></p> <p>Call stack<br> * <code>\Drupal\ai\Base\AiVdbProviderClientBase::deleteAllItems()</code> - by purpose drops and recreates tables, which could be problematic<br> * <code>\Drupal\ai_provider_amazeeio\Vdb\Postgres\Plugin\VdbProvider\PostgresProvider::dropCollection()</code><br> * <code>\Drupal\ai_provider_amazeeio\Vdb\Postgres\PostgresPgvectorClient::dropCollection()</code> </p> <p>Flagged this as critical because when clearing index on Index A also clears indexed data by Index B at the storage level, Search API looses track of that deletion and still believes the all data is indexed.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <h3 id="summary-remaining-tasks">Target date or deadline</h3> <h3 id="summary-remaining-tasks">Remaining tasks</h3> <h3 id="summary-ai-usage">AI usage (if applicable)</h3> <p>[ ] AI Assisted Issue<br> This issue was generated with AI assistance, but was reviewed and refined by the creator.</p> <p>[ ] AI Assisted Code<br> This code was mainly generated by a human, with AI autocompleting or parts AI generated, but under full human supervision.</p> <p>[ ] AI Generated Code<br> This code was mainly generated by an AI with human guidance, and reviewed, tested, and refined by a human.</p> <p>[ ] Vibe Coded<br> This code was generated by an AI and has only been functionally tested.</p>