mirror of
https://github.com/advplyr/audiobookshelf.git
synced 2026-05-30 23:40:40 +02:00
[Bug]: 2.12.1 Unicode DB Crash #2151
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#2151
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 @BlwAvg on GitHub (Aug 5, 2024).
What happened?
Full crash - Database issues continued.
What did you expect to happen?
The application to run as expected.
Steps to reproduce the issue
Audiobookshelf version
2.12.1
How are you running audiobookshelf?
Debian/PPA
What OS is your Audiobookshelf server hosted from?
Linux
If the issue is being seen in the UI, what browsers are you seeing the problem on?
Other (list in "Additional Notes" box)
Logs
Additional Notes
Rolling back fixes the issue.
sudo apt install audiobookshelf=2.11.0
@BlwAvg commented on GitHub (Aug 5, 2024):
I should note the "Kørner Werner Series" mentioned is not an empty series.
@devnoname120 commented on GitHub (Aug 6, 2024):
Can you try
2.12.1?Edit: sorry I meant
2.12.0.@BlwAvg commented on GitHub (Aug 6, 2024):
Hey @devnoname120. If I am reading the logs posted correctly this should be running 2.12.1. I think this could be related to the Unicode error because it seems obvious there is an issue with the "ø". This could be an issue with gcompat?
Let me know if I am reading this wrong, but I believe I upgraded to 2.12.1.
I can upgrade again and try or trouble shoot some more. I guess I could unicodedata in python to normalize the string and then try and update the database. Or just remove the entry entirely. I am a bit out of my depth doing that, but I want to try and be helpful.
EDIT: I rolled back to 2.11.0 and things are working. So this isnt a priority issue and I can replicate in another VM or just take the VM down to gather more data. Just let me know.
@wpisarski commented on GitHub (Aug 6, 2024):
I can confirm this issue in 2.12.1 on items and authors with only standard ASCII characters. If this issue happens for one book of an author, it will happen for all of their books.
I've not yet confirmed this, but I think it happens on duplicated books. I feed my Calibre library to ABS and in the problematic case there are two identical PDF files as separate Calibre items for the same author.
It happens on both autoremove of missing items and on manual delete. Dropping the row directly in DB from
libraryItemsworks fine, ABS starts and appears to work correctly. Subsequent (auto)deletions fail on other items.I will dig deeper if I find the time.
@BlwAvg commented on GitHub (Aug 6, 2024):
Hey! I am not alone!
Thank you for your input @wpisarski
@wpisarski commented on GitHub (Aug 6, 2024):
@BlwAvg Did you check for any duplicates in your library?
@BlwAvg commented on GitHub (Aug 6, 2024):
The series mentioned in my error is not a duplicate. I checked my the files just now. I do have a couple duplicates that I would guess would have been hit before this series and none of them got hit.
I have a higher priority on folder structure and duplicates I found have a slightly varied series name.
Author > Series > Title > .m4b and metadata.
@devnoname120 commented on GitHub (Aug 6, 2024):
Sorry I meant to ask if the issue happened on 2.12.0 as well.
On Aug 6, 2024, 20:52 +0200, DirkIngo @.***>, wrote:
@BlwAvg commented on GitHub (Aug 6, 2024):
Looks like 2.12.0 works for me.
@BlwAvg commented on GitHub (Aug 6, 2024):
Ooh now this is interesting. If I upgrade to 2.12.0 to 2.12.1 I dont get the database corruption issue.
I tried to upgrade from 2.12.0 to 2.12.1 just to see what would happen... And now it works?
@kuldan5853 commented on GitHub (Aug 6, 2024):
I can confirm I have the same bug - in my case it's caused by editing the metadata for a book (no duplicate) that contains the german letter "ö" in the title. 2.12.1 (Windows) updated from 2.11.0 today:
[2024-08-06 22:09:08.565] FATAL: [Server] Unhandled rejection: SequelizeDatabaseError: SQLITE_CORRUPT: database disk image is malformed, promise: Promise {
Error
at Database. (C:\snapshot\audiobookshelf\node_modules\sequelize\lib\dialects\sqlite\query.js:185:27)
at C:\snapshot\audiobookshelf\node_modules\sequelize\lib\dialects\sqlite\query.js:183:50
at new Promise ()
at Query.run (C:\snapshot\audiobookshelf\node_modules\sequelize\lib\dialects\sqlite\query.js:183:12)
at C:\snapshot\audiobookshelf\node_modules\sequelize\lib\sequelize.js:315:28
at async SQLiteQueryInterface.update (C:\snapshot\audiobookshelf\node_modules\sequelize\lib\dialects\abstract\query-interface.js:355:12)
at async Book.save (C:\snapshot\audiobookshelf\node_modules\sequelize\lib\model.js:2490:35)
at async Book.update (C:\snapshot\audiobookshelf\node_modules\sequelize\lib\model.js:2598:12)
at async libraryItem.fullUpdateFromOld (C:\snapshot\audiobookshelf\server\models\LibraryItem.js)
at async Database.updateLibraryItem (C:\snapshot\audiobookshelf\server\Database.js) {
name: 'SequelizeDatabaseError',
parent: [Error: SQLITE_CORRUPT: database disk image is malformed] {
errno: 11,
code: 'SQLITE_CORRUPT',
sql: 'UPDATE
booksSETtitle=$1,titleIgnorePrefix=$2,subtitle=$3,publisher=$4,description=$5,asin=$6,language=$7,narrators=$8,coverPath=$9,tags=$10,genres=$11,updatedAt=$12 WHEREid= $13'},
original: [Error: SQLITE_CORRUPT: database disk image is malformed] {
errno: 11,
code: 'SQLITE_CORRUPT',
sql: 'UPDATE
booksSETtitle=$1,titleIgnorePrefix=$2,subtitle=$3,publisher=$4,description=$5,asin=$6,language=$7,narrators=$8,coverPath=$9,tags=$10,genres=$11,updatedAt=$12 WHEREid= $13'},
sql: 'UPDATE
booksSETtitle=$1,titleIgnorePrefix=$2,subtitle=$3,publisher=$4,description=$5,asin=$6,language=$7,narrators=$8,coverPath=$9,tags=$10,genres=$11,updatedAt=$12 WHEREid= $13',parameters: {}
}
} ( at process. (C:\snapshot\audiobookshelf\server\Server.js))
@DirkIngo commented on GitHub (Aug 6, 2024):
Can also confirm same bug (german).
For me the bug happend after deleting / rescanning stuff.
First had "database disk image is malformed" with 2.12.1 and now this with 2.12.0:
audiobookshelf | [2024-08-06 20:11:58.817] ERROR: [Database] Failed to load extension /unicode.so [Error: SQLITE_ERROR: Error loading shared library /unicode.so.so: No such file or directory] {
audiobookshelf | errno: 1,
audiobookshelf | code: 'SQLITE_ERROR'
audiobookshelf | } (Database.js:236)
audiobookshelf | [2024-08-06 20:11:58.820] ERROR: [Database] Failed to connect to db [Error: SQLITE_ERROR: Error loading shared library /unicode.so.so: No such file or directory] {
audiobookshelf | errno: 1,
audiobookshelf | code: 'SQLITE_ERROR'
audiobookshelf | } (Database.js:214)
audiobookshelf | [2024-08-06 20:11:58.822] FATAL: [Server] Unhandled rejection: Error: Database connection failed, promise: Promise {
audiobookshelf | Error: Database connection failed
audiobookshelf | at Database.init (/server/Database.js:168:13)
audiobookshelf | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
audiobookshelf | at async Server.init (/server/Server.js:116:5)
audiobookshelf | at async Server.start (/server/Server.js:179:5)
audiobookshelf | } (Server.js:171)
I have not a lot of experience with docker but the container wont even start anymore. Doesnt matter what version (2.11, 2.12, 2.12.1)
Seems to work after deleting db and using a backup?
Update: After rescanning and removing some books the same error occured again
Update 2: Now stable in 2.11.0
@migol commented on GitHub (Aug 9, 2024):
I can confirm this issue also happened to me few hours after upgading from 2.11.0 to 2.12.2
@github-actions[bot] commented on GitHub (Aug 10, 2024):
Fixed in v2.12.3.