search_api_update_8107: Integrity constraint violation: 1062 Duplicate entry

Thanks for reporting this problem, and sorry it took me so long to respond!
As it turns out, that update function was a complete disaster anyways, see #3247781: Database update fails, database schema problem on latest release → . We finally removed and reverted it there, so hopefully this isn’t a problem anymore in more recent releases of the module.
Accordingly, I’m closing this issue.

Reopening as I am running into the same problem.

Drupal 9.5.10
Search_api 8.x-1.29

One server with 2 indexes of which one index keeps running fine, the other keeps reporting 0 nodes and terms to index.
Rebuild tracking information gives a: "The website encountered an unexpected error. Please try again later."
Dave's work around #3 doesn't seem to work either.

I also tried to setup a new server and index, to no avail.

Problem started when I disabled a taxonomy from indexing. Index kept reporting not to be able to find terms from disabled taxonomy.
Then I did a rebuild tracking info causing the index from reporting 0 content to be indexed.

The complete error message for your reference:

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '63-search_api_task' for key 'PRIMARY': INSERT INTO "ip_posts" ("type", "id", "ip") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => search_api_task [:db_insert_placeholder_1] => 63 [:db_insert_placeholder_2] => 1303258487 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 50 of /home/***/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Unless this error occurs while executing search_api_update_8107() it is a different problem. Please create a separate ticket for it.

like #3 saied Execute drush search-api:clear works