[PR #3533] [MERGED] Add a REINDEX NOCASE v2.15.1 migration and update v2.15.0 migration #4010

Closed
opened 2026-04-25 00:17:57 +02:00 by adam · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/advplyr/audiobookshelf/pull/3533
Author: @mikiher
Created: 10/18/2024
Status: Merged
Merged: 10/18/2024
Merged by: @advplyr

Base: masterHead: reindex-nocase-migraton


📝 Commits (3)

  • 3b3162a Add REINDEX NOCASE migration and update v2.15.0 migration
  • 8199c1e Update v2.15.0 migration test
  • c97de81 Fix typo

📊 Changes

4 files changed (+107 additions, -52 deletions)

View changed files

📝 server/migrations/changelog.md (+4 -3)
📝 server/migrations/v2.15.0-series-column-unique.js (+4 -0)
server/migrations/v2.15.1-reindex-nocase.js (+43 -0)
📝 test/server/migrations/v2.15.0-series-column-unique.test.js (+56 -49)

📄 Description

This is a migration aimed at fixing potential hidden old database index corruptiuons due to the faulty introduction of the unicode extension in v2.12.0. It perform a reindexing of all NOCASE indices in the database.

Migration v.2.15.0 is also updated to include the same fix, since we've seen that migration fail due these corruptions.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/advplyr/audiobookshelf/pull/3533 **Author:** [@mikiher](https://github.com/mikiher) **Created:** 10/18/2024 **Status:** ✅ Merged **Merged:** 10/18/2024 **Merged by:** [@advplyr](https://github.com/advplyr) **Base:** `master` ← **Head:** `reindex-nocase-migraton` --- ### 📝 Commits (3) - [`3b3162a`](https://github.com/advplyr/audiobookshelf/commit/3b3162aec144e183dc7bdfded96017a7304a3bba) Add REINDEX NOCASE migration and update v2.15.0 migration - [`8199c1e`](https://github.com/advplyr/audiobookshelf/commit/8199c1e327f62f76f03f9f9804938d1c302d5fc8) Update v2.15.0 migration test - [`c97de81`](https://github.com/advplyr/audiobookshelf/commit/c97de815578503a3bffd68cfaccd9955f773250b) Fix typo ### 📊 Changes **4 files changed** (+107 additions, -52 deletions) <details> <summary>View changed files</summary> 📝 `server/migrations/changelog.md` (+4 -3) 📝 `server/migrations/v2.15.0-series-column-unique.js` (+4 -0) ➕ `server/migrations/v2.15.1-reindex-nocase.js` (+43 -0) 📝 `test/server/migrations/v2.15.0-series-column-unique.test.js` (+56 -49) </details> ### 📄 Description This is a migration aimed at fixing potential hidden old database index corruptiuons due to the faulty introduction of the unicode extension in v2.12.0. It perform a reindexing of all NOCASE indices in the database. Migration v.2.15.0 is also updated to include the same fix, since we've seen that migration fail due these corruptions. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
adam added the pull-request label 2026-04-25 00:17:57 +02:00
adam closed this issue 2026-04-25 00:17:57 +02:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/audiobookshelf#4010