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]: crashes on synology box running dsm 7.xx #1355

New Issue
Closed
opened 2026-04-24 23:41:01 +02:00 by adam · 5 comments
adam commented 2026-04-24 23:41:01 +02:00
Owner
Copy Link
Copy Source

Originally created by @dirtymurt on GitHub (Sep 9, 2023).

Describe the issue

docker container crashes

the following log from docker

date stream content
2023-09-09T00:20:23.895369974Z stderr }
2023-09-09T00:20:23.895312746Z stderr parameters: {}
2023-09-09T00:20:23.895215678Z stderr sql: 'SELECT id, title, titleIgnorePrefix, author, releaseDate, feedURL, imageURL, description, itunesPageURL, itunesId, itunesArtistId, language, podcastType, explicit, autoDownloadEpisodes, autoDownloadSchedule, lastEpisodeCheck, maxEpisodesToKeep, maxNewEpisodesToDownload, coverPath, tags, genres, createdAt, updatedAt FROM podcasts AS podcast WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;',
2023-09-09T00:20:23.895068991Z stderr },
2023-09-09T00:20:23.894972123Z stderr sql: 'SELECT id, title, titleIgnorePrefix, author, releaseDate, feedURL, imageURL, description, itunesPageURL, itunesId, itunesArtistId, language, podcastType, explicit, autoDownloadEpisodes, autoDownloadSchedule, lastEpisodeCheck, maxEpisodesToKeep, maxNewEpisodesToDownload, coverPath, tags, genres, createdAt, updatedAt FROM podcasts AS podcast WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;'
2023-09-09T00:20:23.894915834Z stderr code: 'SQLITE_ERROR',
2023-09-09T00:20:23.894860335Z stderr errno: 1,
2023-09-09T00:20:23.894798306Z stderr original: [Error: SQLITE_ERROR: no such column: titleIgnorePrefix] {
2023-09-09T00:20:23.894743757Z stderr },
2023-09-09T00:20:23.894592620Z stderr sql: 'SELECT id, title, titleIgnorePrefix, author, releaseDate, feedURL, imageURL, description, itunesPageURL, itunesId, itunesArtistId, language, podcastType, explicit, autoDownloadEpisodes, autoDownloadSchedule, lastEpisodeCheck, maxEpisodesToKeep, maxNewEpisodesToDownload, coverPath, tags, genres, createdAt, updatedAt FROM podcasts AS podcast WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;'
2023-09-09T00:20:23.894533831Z stderr code: 'SQLITE_ERROR',
2023-09-09T00:20:23.894475423Z stderr errno: 1,
2023-09-09T00:20:23.894396864Z stderr parent: [Error: SQLITE_ERROR: no such column: titleIgnorePrefix] {
2023-09-09T00:20:23.894338215Z stderr name: 'SequelizeDatabaseError',
2023-09-09T00:20:23.894277067Z stderr at async Server.init (/server/Server.js:103:5) {
2023-09-09T00:20:23.894207838Z stderr at async Database.init (/server/Database.js:159:5)
2023-09-09T00:20:23.894133830Z stderr at async Database.cleanDatabase (/server/Database.js:666:39)
2023-09-09T00:20:23.894067481Z stderr at async Function.findAll (/node_modules/sequelize/lib/model.js:1140:21)
2023-09-09T00:20:23.893989363Z stderr at async SQLiteQueryInterface.select (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)
2023-09-09T00:20:23.893927644Z stderr at /node_modules/sequelize/lib/sequelize.js:315:28
2023-09-09T00:20:23.893861925Z stderr at Query.run (/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
2023-09-09T00:20:23.893801446Z stderr at new Promise ()
2023-09-09T00:20:23.893736738Z stderr at /node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
2023-09-09T00:20:23.893658449Z stderr at Database. (/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
2023-09-09T00:20:23.893602080Z stderr Error
2023-09-09T00:20:23.893550202Z stderr  
2023-09-09T00:20:23.893495603Z stderr ^
2023-09-09T00:20:23.893413374Z stderr triggerUncaughtException(err, true /* fromPromise */);
2023-09-09T00:20:23.726424261Z stderr node:internal/process/promises:279
2023-09-09T00:20:23.701556170Z stdout [2023-09-09 00:20:23] 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
2023-09-09T00:20:23.101648376Z stdout [2023-09-09 00:20:23] INFO: [Database] Db connection was successful
2023-09-09T00:20:22.892699622Z stdout [2023-09-09 00:20:22] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
2023-09-09T00:20:22.885738044Z stdout [2023-09-09 00:20:22] INFO: [Server] Init v2.3.4
2023-09-09T00:20:22.883045239Z stdout [2023-09-09 00:20:22] INFO: === Starting Server ===
2023-09-09T00:20:22.801838301Z stdout Config /config /metadata
</html>

Steps to reproduce the issue

  1. was working fine, restarting causes this to happen

Audiobookshelf version

2.3.4

How are you running audiobookshelf?

Docker

Originally created by @dirtymurt on GitHub (Sep 9, 2023). ### Describe the issue docker container crashes the following log from docker date | stream | content -- | -- | -- 2023-09-09T00:20:23.895369974Z | stderr | } 2023-09-09T00:20:23.895312746Z | stderr | parameters: {} 2023-09-09T00:20:23.895215678Z | stderr | sql: 'SELECT `id`, `title`, `titleIgnorePrefix`, `author`, `releaseDate`, `feedURL`, `imageURL`, `description`, `itunesPageURL`, `itunesId`, `itunesArtistId`, `language`, `podcastType`, `explicit`, `autoDownloadEpisodes`, `autoDownloadSchedule`, `lastEpisodeCheck`, `maxEpisodesToKeep`, `maxNewEpisodesToDownload`, `coverPath`, `tags`, `genres`, `createdAt`, `updatedAt` FROM `podcasts` AS `podcast` WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;', 2023-09-09T00:20:23.895068991Z | stderr | }, 2023-09-09T00:20:23.894972123Z | stderr | sql: 'SELECT `id`, `title`, `titleIgnorePrefix`, `author`, `releaseDate`, `feedURL`, `imageURL`, `description`, `itunesPageURL`, `itunesId`, `itunesArtistId`, `language`, `podcastType`, `explicit`, `autoDownloadEpisodes`, `autoDownloadSchedule`, `lastEpisodeCheck`, `maxEpisodesToKeep`, `maxNewEpisodesToDownload`, `coverPath`, `tags`, `genres`, `createdAt`, `updatedAt` FROM `podcasts` AS `podcast` WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;' 2023-09-09T00:20:23.894915834Z | stderr | code: 'SQLITE_ERROR', 2023-09-09T00:20:23.894860335Z | stderr | errno: 1, 2023-09-09T00:20:23.894798306Z | stderr | original: [Error: SQLITE_ERROR: no such column: titleIgnorePrefix] { 2023-09-09T00:20:23.894743757Z | stderr | }, 2023-09-09T00:20:23.894592620Z | stderr | sql: 'SELECT `id`, `title`, `titleIgnorePrefix`, `author`, `releaseDate`, `feedURL`, `imageURL`, `description`, `itunesPageURL`, `itunesId`, `itunesArtistId`, `language`, `podcastType`, `explicit`, `autoDownloadEpisodes`, `autoDownloadSchedule`, `lastEpisodeCheck`, `maxEpisodesToKeep`, `maxNewEpisodesToDownload`, `coverPath`, `tags`, `genres`, `createdAt`, `updatedAt` FROM `podcasts` AS `podcast` WHERE (SELECT count(*) FROM libraryItems li WHERE li.mediaId = podcast.id) = 0;' 2023-09-09T00:20:23.894533831Z | stderr | code: 'SQLITE_ERROR', 2023-09-09T00:20:23.894475423Z | stderr | errno: 1, 2023-09-09T00:20:23.894396864Z | stderr | parent: [Error: SQLITE_ERROR: no such column: titleIgnorePrefix] { 2023-09-09T00:20:23.894338215Z | stderr | name: 'SequelizeDatabaseError', 2023-09-09T00:20:23.894277067Z | stderr | at async Server.init (/server/Server.js:103:5) { 2023-09-09T00:20:23.894207838Z | stderr | at async Database.init (/server/Database.js:159:5) 2023-09-09T00:20:23.894133830Z | stderr | at async Database.cleanDatabase (/server/Database.js:666:39) 2023-09-09T00:20:23.894067481Z | stderr | at async Function.findAll (/node_modules/sequelize/lib/model.js:1140:21) 2023-09-09T00:20:23.893989363Z | stderr | at async SQLiteQueryInterface.select (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12) 2023-09-09T00:20:23.893927644Z | stderr | at /node_modules/sequelize/lib/sequelize.js:315:28 2023-09-09T00:20:23.893861925Z | stderr | at Query.run (/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12) 2023-09-09T00:20:23.893801446Z | stderr | at new Promise (<anonymous>) 2023-09-09T00:20:23.893736738Z | stderr | at /node_modules/sequelize/lib/dialects/sqlite/query.js:183:50 2023-09-09T00:20:23.893658449Z | stderr | at Database.<anonymous> (/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27) 2023-09-09T00:20:23.893602080Z | stderr | Error 2023-09-09T00:20:23.893550202Z | stderr |   2023-09-09T00:20:23.893495603Z | stderr | ^ 2023-09-09T00:20:23.893413374Z | stderr | triggerUncaughtException(err, true /* fromPromise */); 2023-09-09T00:20:23.726424261Z | stderr | node:internal/process/promises:279 2023-09-09T00:20:23.701556170Z | stdout | [2023-09-09 00:20:23] 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 2023-09-09T00:20:23.101648376Z | stdout | [2023-09-09 00:20:23] INFO: [Database] Db connection was successful 2023-09-09T00:20:22.892699622Z | stdout | [2023-09-09 00:20:22] INFO: [Database] Initializing db at "/config/absdatabase.sqlite" 2023-09-09T00:20:22.885738044Z | stdout | [2023-09-09 00:20:22] INFO: [Server] Init v2.3.4 2023-09-09T00:20:22.883045239Z | stdout | [2023-09-09 00:20:22] INFO: === Starting Server === 2023-09-09T00:20:22.801838301Z | stdout | Config /config /metadata <!--EndFragment--> </body> </html> ### Steps to reproduce the issue 1. was working fine, restarting causes this to happen ### Audiobookshelf version 2.3.4 ### How are you running audiobookshelf? Docker
adam added the bug label 2026-04-24 23:41:01 +02:00
adam closed this issue 2026-04-24 23:41:01 +02:00
adam commented 2026-04-24 23:41:01 +02:00
Author
Owner
Copy Link
Copy Source

@nichwall commented on GitHub (Sep 9, 2023):

Update to 2.4.0

@nichwall commented on GitHub (Sep 9, 2023): Update to 2.4.0
adam commented 2026-04-24 23:41:02 +02:00
Author
Owner
Copy Link
Copy Source

@INeedABrain commented on GitHub (Sep 9, 2023):

Exact same situation and crash here
Appeared when upgrading to 2.3.4.
Upgrading to 2.4.0 doesn't solve the problem.

@INeedABrain commented on GitHub (Sep 9, 2023): Exact same situation and crash here Appeared when upgrading to 2.3.4. Upgrading to 2.4.0 doesn't solve the problem.
adam commented 2026-04-24 23:41:02 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Sep 9, 2023):

@INeedABrain Are you sure you are upgrading to 2.4.0? That error should definitely not happen on 2.4.0, that was very specific

@advplyr commented on GitHub (Sep 9, 2023): @INeedABrain Are you sure you are upgrading to 2.4.0? That error should definitely not happen on 2.4.0, that was very specific
adam commented 2026-04-24 23:41:02 +02:00
Author
Owner
Copy Link
Copy Source

@INeedABrain commented on GitHub (Sep 9, 2023):

Hi @advplyr
You're right, for some reason I was using 2.3.5 while thinking it was 2.4.0.
I just reconfigured my container from scratch with 2.4.0 and now it's working properly
Thanks a lot !

@INeedABrain commented on GitHub (Sep 9, 2023): Hi @advplyr You're right, for some reason I was using 2.3.5 while thinking it was 2.4.0. I just reconfigured my container from scratch with 2.4.0 and now it's working properly Thanks a lot !
adam commented 2026-04-24 23:41:04 +02:00
Author
Owner
Copy Link
Copy Source

@advplyr commented on GitHub (Sep 9, 2023):

Nice!

@advplyr commented on GitHub (Sep 9, 2023): Nice!
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#1355
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?