Skip to content

Incompatibility with audiobookshelf #638

Open
@cyclingwithelephants

Description

@cyclingwithelephants

I've just attempted to integrate litestream with audiobookshelf v2.21.0 and receive the following error logs.

It appears that audiobookshelf uses a custom installation of sqlite which uses nunicode, I'm not sure if that's what's causing this?

time=2025-05-04T17:28:49.611Z level=INFO msg=litestream version=v0.3.13
time=2025-05-04T17:28:49.611Z level=INFO msg="initialized db" path=/sqlite/absdatabase.sqlite
time=2025-05-04T17:28:49.611Z level=INFO msg="replicating to" name=b2 type=s3 sync-interval=1s bucket=adamrummer-database-dumps path=audiobookshelf region=us-west-004 endpoint=s3.us-west-004.backblazeb2.com
time=2025-05-04T17:28:50.614Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:51.614Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:52.614Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:53.615Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:54.613Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:55.615Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"
time=2025-05-04T17:28:56.615Z level=ERROR msg="sync error" db=/sqlite/absdatabase.sqlite error="malformed database schema (update_library_items_author_names_on_book_authors_insert) - near \"ORDER\": syntax error"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions