starred/audiobookshelf
1
0
Fork 0
mirror of https://github.com/advplyr/audiobookshelf.git synced 2026-05-30 23:40:40 +02:00
Code Issues 1.0k Packages Projects Releases 10 Wiki Activity

[Bug]: Quick Match causing crash #2519

New Issue
Closed
opened 2026-04-25 00:07:58 +02:00 by adam · 5 comments
adam commented 2026-04-25 00:07:58 +02:00
Owner
Copy Link
Copy Source

Originally created by @jbeck22 on GitHub (Jan 22, 2025).

What happened?

When trying to use the quick match feature my entire Audiobookshelf container crashes and I have to start the docker again.

What did you expect to happen?

use the quick match feature

Steps to reproduce the issue

  1. select book
  2. select quick match

Audiobookshelf version

2.18.1

How are you running audiobookshelf?

Docker

What OS is your Audiobookshelf server hosted from?

Other (list in "Additional Notes" box)

If the issue is being seen in the UI, what browsers are you seeing the problem on?

None

Logs

Additional Notes

unRaid

Originally created by @jbeck22 on GitHub (Jan 22, 2025). ### What happened? When trying to use the quick match feature my entire Audiobookshelf container crashes and I have to start the docker again. ### What did you expect to happen? use the quick match feature ### Steps to reproduce the issue 1. select book 2. select quick match ### Audiobookshelf version 2.18.1 ### How are you running audiobookshelf? Docker ### What OS is your Audiobookshelf server hosted from? Other (list in "Additional Notes" box) ### If the issue is being seen in the UI, what browsers are you seeing the problem on? None ### Logs ```shell ``` ### Additional Notes unRaid
adam added the bug label 2026-04-25 00:07:58 +02:00
adam closed this issue 2026-04-25 00:07:58 +02:00
adam commented 2026-04-25 00:08:00 +02:00
Author
Owner
Copy Link
Copy Source

@nichwall commented on GitHub (Jan 22, 2025):

Can you please provide logs from the crash?

@nichwall commented on GitHub (Jan 22, 2025): Can you please provide logs from the crash?
adam commented 2026-04-25 00:08:00 +02:00
Author
Owner
Copy Link
Copy Source

@jbeck22 commented on GitHub (Jan 22, 2025):

`[2025-01-22 09:47:23.680] FATAL: [Server] Unhandled rejection: Error: WHERE parameter "id" has invalid "undefined" value
at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
at Array.forEach ()
at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28)
at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37)
at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60)
at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13)
at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35)
promise: Promise {
Error: WHERE parameter "id" has invalid "undefined" value
at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
at Array.forEach ()
at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28)
at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37)
at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60)
at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13)
at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35)
}
[2025-01-22 09:48:43.641] WARN: Removed 1 sessions that were 3 seconds or less
[2025-01-22 09:55:08.120] FATAL: [Server] Unhandled rejection: Error: WHERE parameter "id" has invalid "undefined" value
at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
at Array.forEach ()
at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28)
at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37)
at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60)
at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13)
at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35)
promise: Promise {
Error: WHERE parameter "id" has invalid "undefined" value
at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13)
at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25
at Array.forEach ()
at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35)
at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19)
at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28)
at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37)
at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60)
at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13)
at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35)
}
[2025-01-22 09:28:09.419] INFO: [LibraryScanner] No important changes to scan for in folder "4c919adb-890a-46f4-a8e4-678c7186d928"
[2025-01-22 09:46:39.248] INFO: [SocketAuthority] Socket Connected to /audiobookshelf/socket.io PGYZxszgBAP2RPO7AAAi
[2025-01-22 09:47:23.601] INFO: [CoverManager] Downloaded libraryItem cover "/audiobooks/David Gemmell-Drenai Saga (Fantasy)/The Drenai Saga/01. Legend (1984) (64)/cover.jpg" from url "https://m.media-amazon.com/images/I/91e-w6pDXKL.jpg"
[2025-01-22 09:47:23.676] INFO: [Scanner] quickMatchBookBuildUpdatePayload: Added series "Drenai [publication order]" to "Legend"
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-01-22 09:48:42.374] INFO: === Starting Server ===
[2025-01-22 09:48:42.377] INFO: [Server] Init v2.18.1
[2025-01-22 09:48:42.378] INFO: [Server] Node.js Version: v20.18.1
[2025-01-22 09:48:42.378] INFO: [Server] Platform: linux
[2025-01-22 09:48:42.378] INFO: [Server] Arch: x64
[2025-01-22 09:48:42.388] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-01-22 09:48:42.453] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-01-22 09:48:42.454] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-01-22 09:48:42.455] INFO: [Database] Db supports unaccent and unicode foldings
[2025-01-22 09:48:42.455] INFO: [Database] Db connection was successful
[2025-01-22 09:48:42.470] INFO: [MigrationManager] Database is already up to date.
[2025-01-22 09:48:42.777] INFO: [Database] Db initialized with models: user, library, libraryFolder, book, podcast, podcastEpisode, libraryItem, mediaProgress, series, bookSeries, author, bookAuthor, collection, collectionBook, playlist, playlistMediaItem, device, playbackSession, feed, feedEpisode, setting, customMetadataProvider, mediaItemShare
[2025-01-22 09:48:43.665] INFO: [LogManager] Removed daily log: 2025-01-14.txt
[2025-01-22 09:48:43.668] INFO: [LogManager] Removed daily log: 2025-01-15.txt
[2025-01-22 09:48:43.668] INFO: [LogManager] Init current daily log filename: 2025-01-22.txt
[2025-01-22 09:48:43.740] INFO: [BackupManager] 2 Backups Found
[2025-01-22 09:48:43.788] INFO: [Watcher] Initializing watcher for "Audiobooks".
[2025-01-22 09:48:43.811] INFO: Listening on port :80
[2025-01-22 09:48:47.727] INFO: [SocketAuthority] Socket Connected to /audiobookshelf/socket.io d9m_udm4MvzQ9dh5AAAB
[2025-01-22 09:49:13.935] INFO: [Watcher] "Audiobooks" Ready
[2025-01-22 09:55:08.111] INFO: [CoverManager] Downloaded libraryItem cover "/audiobooks/David Gemmell-Drenai Saga (Fantasy)/The Drenai Saga/01. Legend (1984) (64)/cover.jpg" from url "https://m.media-amazon.com/images/I/91e-w6pDXKL.jpg"

** Press ANY KEY to close this window ** `

@jbeck22 commented on GitHub (Jan 22, 2025): `[2025-01-22 09:47:23.680] FATAL: [Server] Unhandled rejection: Error: WHERE parameter "id" has invalid "undefined" value at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13) at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25 at Array.forEach (<anonymous>) at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35) at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19) at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28) at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37) at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60) at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13) at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35) promise: Promise { <rejected> Error: WHERE parameter "id" has invalid "undefined" value at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13) at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25 at Array.forEach (<anonymous>) at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35) at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19) at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28) at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37) at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60) at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13) at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35) } [2025-01-22 09:48:43.641] WARN: Removed 1 sessions that were 3 seconds or less [2025-01-22 09:55:08.120] FATAL: [Server] Unhandled rejection: Error: WHERE parameter "id" has invalid "undefined" value at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13) at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25 at Array.forEach (<anonymous>) at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35) at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19) at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28) at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37) at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60) at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13) at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35) promise: Promise { <rejected> Error: WHERE parameter "id" has invalid "undefined" value at SQLiteQueryGenerator.whereItemQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1743:13) at /node_modules/sequelize/lib/dialects/abstract/query-generator.js:1734:25 at Array.forEach (<anonymous>) at SQLiteQueryGenerator.whereItemsQuery (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:1732:35) at SQLiteQueryGenerator.getWhereConditions (/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2075:19) at SQLiteQueryGenerator.deleteQuery (/node_modules/sequelize/lib/dialects/sqlite/query-generator.js:197:28) at SQLiteQueryInterface.delete (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:370:37) at BookSeries.destroy (/node_modules/sequelize/lib/model.js:2627:60) at async Scanner.quickMatchBookBuildUpdatePayload (/server/scanner/Scanner.js:338:13) at async Scanner.quickMatchLibraryItem (/server/scanner/Scanner.js:82:35) } [2025-01-22 09:28:09.419] INFO: [LibraryScanner] No important changes to scan for in folder "4c919adb-890a-46f4-a8e4-678c7186d928" [2025-01-22 09:46:39.248] INFO: [SocketAuthority] Socket Connected to /audiobookshelf/socket.io PGYZxszgBAP2RPO7AAAi [2025-01-22 09:47:23.601] INFO: [CoverManager] Downloaded libraryItem cover "/audiobooks/David Gemmell-Drenai Saga (Fantasy)/The Drenai Saga/01. Legend (1984) (64)/cover.jpg" from url "https://m.media-amazon.com/images/I/91e-w6pDXKL.jpg" [2025-01-22 09:47:23.676] INFO: [Scanner] quickMatchBookBuildUpdatePayload: Added series "Drenai [publication order]" to "Legend" Running in production mode. Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf [2025-01-22 09:48:42.374] INFO: === Starting Server === [2025-01-22 09:48:42.377] INFO: [Server] Init v2.18.1 [2025-01-22 09:48:42.378] INFO: [Server] Node.js Version: v20.18.1 [2025-01-22 09:48:42.378] INFO: [Server] Platform: linux [2025-01-22 09:48:42.378] INFO: [Server] Arch: x64 [2025-01-22 09:48:42.388] INFO: [Database] Initializing db at "/config/absdatabase.sqlite" [2025-01-22 09:48:42.453] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so [2025-01-22 09:48:42.454] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so [2025-01-22 09:48:42.455] INFO: [Database] Db supports unaccent and unicode foldings [2025-01-22 09:48:42.455] INFO: [Database] Db connection was successful [2025-01-22 09:48:42.470] INFO: [MigrationManager] Database is already up to date. [2025-01-22 09:48:42.777] INFO: [Database] Db initialized with models: user, library, libraryFolder, book, podcast, podcastEpisode, libraryItem, mediaProgress, series, bookSeries, author, bookAuthor, collection, collectionBook, playlist, playlistMediaItem, device, playbackSession, feed, feedEpisode, setting, customMetadataProvider, mediaItemShare [2025-01-22 09:48:43.665] INFO: [LogManager] Removed daily log: 2025-01-14.txt [2025-01-22 09:48:43.668] INFO: [LogManager] Removed daily log: 2025-01-15.txt [2025-01-22 09:48:43.668] INFO: [LogManager] Init current daily log filename: 2025-01-22.txt [2025-01-22 09:48:43.740] INFO: [BackupManager] 2 Backups Found [2025-01-22 09:48:43.788] INFO: [Watcher] Initializing watcher for "Audiobooks". [2025-01-22 09:48:43.811] INFO: Listening on port :80 [2025-01-22 09:48:47.727] INFO: [SocketAuthority] Socket Connected to /audiobookshelf/socket.io d9m_udm4MvzQ9dh5AAAB [2025-01-22 09:49:13.935] INFO: [Watcher] "Audiobooks" Ready [2025-01-22 09:55:08.111] INFO: [CoverManager] Downloaded libraryItem cover "/audiobooks/David Gemmell-Drenai Saga (Fantasy)/The Drenai Saga/01. Legend (1984) (64)/cover.jpg" from url "https://m.media-amazon.com/images/I/91e-w6pDXKL.jpg" ** Press ANY KEY to close this window ** `
adam commented 2026-04-25 00:08:00 +02:00
Author
Owner
Copy Link
Copy Source

@mikiher commented on GitHub (Jan 26, 2025):

I'll try to take a look at this.

@mikiher commented on GitHub (Jan 26, 2025): I'll try to take a look at this.
adam commented 2026-04-25 00:08:00 +02:00
Author
Owner
Copy Link
Copy Source

@mikiher commented on GitHub (Jan 26, 2025):

@jbeck22 if you can please provide a few of log lines from just before the FATAL error, that would be helpful.

No need, I was able to reproduce this.

@mikiher commented on GitHub (Jan 26, 2025): ~~@jbeck22 if you can please provide a few of log lines from just before the FATAL error, that would be helpful.~~ No need, I was able to reproduce this.
adam commented 2026-04-25 00:08:00 +02:00
Author
Owner
Copy Link
Copy Source

@github-actions[bot] commented on GitHub (Feb 2, 2025):

Fixed in v2.19.0.

@github-actions[bot] commented on GitHub (Feb 2, 2025): Fixed in [v2.19.0](https://github.com/advplyr/audiobookshelf/releases/tag/v2.19.0).
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
authentication
backlog
bug
chapter editor
config-issue
ebooks
encoding/embedding
enhancement
help wanted
listening sessions & progress
planned
possible plugin
progress sync
pull-request
Mirrored from GitHub Pull Request
 sorting/filtering/searching
unable to reproduce
upload
users & permissions
waiting
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/audiobookshelf#2519
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?