mirror of
https://github.com/advplyr/audiobookshelf.git
synced 2026-05-30 23:40:40 +02:00
[Bug]: Since 2.3.0 container crashes when connecting or playing local media with android app #1248
Assignees
adam (Adam Melkus)
Clear assignees
adam (Adam Melkus)
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/audiobookshelf#1248
Reference in New Issue
Block a user
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?
Originally created by @santschi on GitHub (Jul 16, 2023).
Describe the issue
Since v2.3.0 The container crashes every time the android app tries to save play state.
The web player/interface work as always.
Further I can no longer look at a series in the app (unsure if this is the same issue since the server doesn't crash)
Steps to reproduce the issue
Last log entry:
[PlaybackSessionManager] Inserting new session for "<omitted>" (play_local_31BunchMoreNumbers)Audiobookshelf version
v2.3.0
Android App Version
v0.9.65-beta
How are you running audiobookshelf?
Docker
@advplyr commented on GitHub (Jul 16, 2023):
I just fixed the series issue for a patch I will put out today. That is reported in #1914
For the downloaded books, unfortunately you will have to re-download them for now because it will take longer to release a patch on the mobile apps.
@advplyr commented on GitHub (Jul 16, 2023):
@santschi If you can get the log from the actual container for that crash that would be helpful. The full crash stack trace will be in the logs for the container
@santschi commented on GitHub (Jul 16, 2023):
@advplyr I took a look at the log output of the container itself, which outputs nothing after announcing it is healthy.
Further I took a look at the daily log file, but there was literally nothing else in there. (Start-up, debug message I posted and start up again)
No error or warning, certainly no stack trace.
If you are talking about a different log, or if there is some debug flag (besides the drop-down on the web ui for logs) I can enable I will gladly provide a log.
@mantas3 commented on GitHub (Jul 16, 2023):
I have same issue, container crashes when opening android app. Managed to pull some logs from docker:
@advplyr commented on GitHub (Jul 16, 2023):
@mantas3 I'm fixing this in the upcoming patch to the server
@mantas3 commented on GitHub (Jul 16, 2023):
Until that reinstalling mobile app seems to help.
@advplyr commented on GitHub (Jul 16, 2023):
The issue is with playing downloaded books. There still may be some issues until the patch
@advplyr commented on GitHub (Jul 17, 2023):
Fixed in v2.3.1
@PyroghostX commented on GitHub (Jul 17, 2023):
@advplyr I am on 2.3.1 and the container is crashing
[2023-07-17 15:01:53] INFO: [Watcher] Initializing watcher for "Audiobooks".
[2023-07-17 15:01:53] INFO: Listening on port :80
[2023-07-17 15:01:55] INFO: [Watcher] "Audiobooks" Ready
node:internal/process/promises:279
triggerUncaughtException(err, true /* fromPromise */);
^
Error
at Database. (/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
at /node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
at new Promise ()
at Query.run (/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
at /node_modules/sequelize/lib/sequelize.js:315:28
at async SQLiteQueryInterface.insert (/node_modules/sequelize/lib/dialects/abstract/query-interface.js:308:21)
at async PlaybackSession.save (/node_modules/sequelize/lib/model.js:2490:35)
at async Function.create (/node_modules/sequelize/lib/model.js:1362:12)
at async PlaybackSessionManager.syncLocalSession (/server/managers/PlaybackSessionManager.js:139:7)
at async PlaybackSessionManager.syncLocalSessionRequest (/server/managers/PlaybackSessionManager.js:189:20) {
name: 'SequelizeForeignKeyConstraintError',
parent: [Error: SQLITE_CONSTRAINT: FOREIGN KEY constraint failed] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO
playbackSessions(id,mediaItemId,mediaItemType,displayTitle,displayAuthor,duration,playMethod,mediaPlayer,startTime,currentTime,serverVersion,coverPath,timeListening,mediaMetadata,extraData,createdAt,updatedAt,userId,deviceId,libraryId) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20);'},
original: [Error: SQLITE_CONSTRAINT: FOREIGN KEY constraint failed] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO
playbackSessions(id,mediaItemId,mediaItemType,displayTitle,displayAuthor,duration,playMethod,mediaPlayer,startTime,currentTime,serverVersion,coverPath,timeListening,mediaMetadata,extraData,createdAt,updatedAt,userId,deviceId,libraryId) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20);'},
sql: 'INSERT INTO
playbackSessions(id,mediaItemId,mediaItemType,displayTitle,displayAuthor,duration,playMethod,mediaPlayer,startTime,currentTime,serverVersion,coverPath,timeListening,mediaMetadata,extraData,createdAt,updatedAt,userId,deviceId,libraryId) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20);',parameters: {},
table: undefined,
fields: undefined,
value: undefined,
index: undefined,
reltype: undefined
}
@santschi commented on GitHub (Jul 17, 2023):
I got a stack trace as well now. No idea what changed but this is mine:
This is with v2.3.1
@santschi commented on GitHub (Jul 17, 2023):
I deleted app cache & storage, deleted all the downloaded audiobooks.
Now everything works perfectly!
@advplyr Thanks for working on this app! It's fantastic.
@PyroghostX commented on GitHub (Jul 17, 2023):
My container is crashing seconds after starting. So not related to any
clients
On Mon, Jul 17, 2023, 10:34 AM Sebastien Santschi @.***>
wrote:
@advplyr commented on GitHub (Jul 17, 2023):
I believe I figured out why the crash was still happening and I will patch it today. Removing and re-adding the connection will also work
@advplyr commented on GitHub (Jul 18, 2023):
Fixed in v2.3.2
Let me know if there are still any crashes with local media playing from app