mirror of
https://github.com/advplyr/audiobookshelf.git
synced 2026-05-30 23:40:40 +02:00
[Bug]: Database migration fails when upgrading docker version from 2.18.1 to any 2.19 version #2612
Closed
opened 2026-04-25 00:09:00 +02:00 by adam
·
6 comments
No Branch/Tag Specified
master
book_tags_genres_dedupe
episode_download_fallback
Issue-4540-SortBy-StartedDate-and-FinishedDate
episode_meta_tagging
fix_authorize_race_condition
redirect_transcode_requests
progress_updated_sort
fix_ereader_socket_event
fix_change_empty_root_password
fix_podcast_session_track_index
fix_set_token
session_modal_user
localize_durations
fix_oidc_create_user
jwt_auth_refactor
fix_scanner_deleting_single_file_books
fix_mediaprogress_updatedat_2
experimental_next_client
podcast_episode_duration
episode-timestamps-clickable
book_author_secondary_sort_title
podcast_useragents
pathexists_user_access
fix_pathexists_join
book_author_secondary_sort
clean_duplicate_mediaprogress
sanitize_html_description
trix_prevent_attachments
check_path_api_fix
fix_mediaprogress_updatedat
increase_express_json_limit
fix_dockerfile_nunicode
search_episodes
audiobook_tools_update
episode_secondary_sorts
hls_stream_url_update
new_session_track_endpoint
audiobook_tools_enhancements
watcher_rescans_update
player_track_tooltip
fix_exclude_prefixes_crash
socket_item_events
fix_podcast_episode_scanner_promise
new_stats_controller
count_cache_for_userpermissions
parsing-opf-v3
validate_migration_files
fix-quick-match-all-crash
fix-chapter-end-sleep-timer
stringify_sequelize_query
remove-col-ambiguity
fix_next_prev_edit_description
details_trim_whitespace
fix_content_url_basepath
fix_logger_fatal
progress_bar_visibility
batch-edit-populate-map-details
feed_generator_updates
bookmark-modal-updates
migrate-library-item-in-scanner
migrate-new-library-items
migrate-podcasts-new-library-item-2
migrate-podcasts-new-library-item
fix-remove-episode-from-playlist
playback-session-use-new-library-item
refactor-library-item
fix-heatmap-caption
feed-episodes-upsert
share-media-player-media-session-api
remove-old-playlist
remove_old_collection_object
plugin-implementation-demo
feed_migration
refactor-feeds-from-item
fix_remove_authors_no_books
v2.17.3-fk-constraints-migration
migrations-first-upgrade
sqlite_2
feature/nuxt-target-server
waveform
sqlite
playlists
video
v2.35.1
v2.35.0
v2.34.0
v2.33.2
v2.33.1
v2.33.0
v2.32.1
v2.32.0
v2.31.0
v2.30.0
v2.29.0
v2.28.0
v2.27.0
v2.26.3
v2.26.2
v2.26.1
v2.26.0
v2.25.1
v2.25.0
v2.24.0
v2.23.0
v2.22.0
v2.21.0
v2.20.0
v2.19.5
v2.19.4
v2.19.3
v2.19.2
v2.19.1
v2.19.0
v2.18.1
v2.18.0
v2.17.7
v2.17.6
v2.17.5
v2.17.4
v2.17.3
v2.17.2
v2.17.1
v2.17.0
v2.16.2
v2.16.1
v2.16.0
v2.15.1
v2.15.0
v2.14.0
v2.13.4
v2.13.3
v2.13.2
v2.13.1
v2.13.0
v2.12.3
v2.12.2
v2.12.1
v2.12.0
v2.11.0
v2.10.1
v2.10.0
v2.9.0
v2.8.1
v2.8.0
v2.7.2
v2.7.1
v2.7.0
v2.6.0
v2.5.0
v2.4.4
v2.4.3
v2.4.2
v2.4.1
v2.4.0
v2.3.5
v2.3.4
v2.3.3
v2.3.2
v2.3.1
v2.3.0
v2.2.23
v2.2.22
v2.2.21
v2.2.20
v2.2.19
v2.2.18
v2.2.17
v2.2.16
v2.2.15
v2.2.14
v2.2.13
v2.2.12
v2.2.11
v2.2.10
v2.2.9
v2.2.8
v2.2.7
v2.2.6
v2.2.5
v2.2.4
v2.2.3
v2.2.2
v2.2.1
v2.2.0
v2.1.5
v2.1.4
v2.1.3
v2.1.2
v2.1.1
v2.1.0
v2.0.24
v2.0.23
v2.0.22
v2.0.21
v2.0.20
v2.0.19
v2.0.18
v2.0.17
v2.0.16
v2.0.15
v2.0.14
v2.0.13
v2.0.12
v2.0.11
v2.0.10
v2.0.9
v2.0.8
v2.0.7
v2.0.6
v2.0.5
v2.0.4
v2.0.3
v2.0.2
v2.0.1
v1.7.2
v1.7.1
v1.7.0
v1.6.0
v1.5.5
v1.5.0
v1.4.11
v1.4.9
v1.4.7
v1.4.6
v1.4.4
v1.4.2
v1.4.0
v1.4.1
v1.3.4
v1.3.3
v1.3.1
v1.2.8
v1.2.6
v1.2.5
v1.2.4
v1.2.1
v1.1.15
v1.1.14
v1.1.13
v1.1.12
v1.1.11
v1.1.10
v1.1.9
v1.1.8
v1.0.0
0.9.61-beta.0
0.9.61-beta
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
sorting/filtering/searching
unable to reproduce
upload
users & permissions
waiting
Mirrored from GitHub Pull Request
No Label
bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
adam (Adam Melkus)
Clear assignees
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: starred/audiobookshelf#2612
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking 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 @jkrobin on GitHub (Feb 25, 2025).
What happened?
Running audiobookshelf in docker and had previous successful version upgrades. However, when attempting to upgrade from 2.18.1 to any 2.19 version, I get database migration failures in the logs and the service fails to run.
Re-pulling 2.18.1 and restarting resolves issue, but would love to be able to get on the new versions. Any help appreciated!
What did you expect to happen?
Successful upgrade to newer version (latest tried was 2.19.5).
Steps to reproduce the issue
Audiobookshelf version
Docker 2.18.1 --> 2.19.5
How are you running audiobookshelf?
Docker
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?
None
Logs
Additional Notes
No response
@mikiher commented on GitHub (Mar 6, 2025):
This is very odd.
Can you please list the contents of your docker container's
/config/migrartionsdirectory?Can you also please attach the full log lines, from server start to failure?
@jkrobin commented on GitHub (Mar 6, 2025):
Hi, @mikiher . Thanks for taking a look.
Content of /config/migrations directory is as follows:
v2.15.0-series-column-unique.js
v2.15.0-series-column-unique.js.gz
v2.15.1-reindex-nocase.js
v2.15.1-reindex-nocase.js.gz
v2.15.2-index-creation.js
v2.15.2-index-creation.js.gz
v2.17.0-uuid-replacement.js
v2.17.0-uuid-replacement.js.gz
v2.17.3-fk-constraints.js
v2.17.3-fk-constraints.js.gz
v2.17.4-use-subfolder-for-oidc-redirect-uris.js
v2.17.4-use-subfolder-for-oidc-redirect-uris.js.gz
v2.17.5-remove-host-from-feed-urls.js
v2.17.5-remove-host-from-feed-urls.js.gz
v2.17.6-share-add-isdownloadable.js
v2.17.6-share-add-isdownloadable.js.gz
v2.17.7-add-indices.js
v2.17.7-add-indices.js.gz
v2.19.1-copy-title-to-library-items.js
v2.19.4-improve-podcast-queries.js
And here is the complete log from startup through failure:
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:08.776] INFO: === Starting Server ===
[2025-03-06 16:38:08.829] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:08.829] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:08.829] INFO: [Server] Platform: linux
[2025-03-06 16:38:08.830] INFO: [Server] Arch: x64
[2025-03-06 16:38:08.841] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:08.898] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:08.902] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:08.903] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:08.903] INFO: [Database] Db connection was successful
[2025-03-06 16:38:08.924] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:08.927] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Running in production mode.
Running in production mode.
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:11.860] INFO: === Starting Server ===
[2025-03-06 16:38:11.860] INFO: === Starting Server ===
[2025-03-06 16:38:11.860] INFO: === Starting Server ===
[2025-03-06 16:38:11.877] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:11.877] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:11.877] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:11.877] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:11.877] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:11.877] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:11.878] INFO: [Server] Platform: linux
[2025-03-06 16:38:11.878] INFO: [Server] Platform: linux
[2025-03-06 16:38:11.878] INFO: [Server] Platform: linux
[2025-03-06 16:38:11.878] INFO: [Server] Arch: x64
[2025-03-06 16:38:11.878] INFO: [Server] Arch: x64
[2025-03-06 16:38:11.878] INFO: [Server] Arch: x64
[2025-03-06 16:38:11.886] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:11.886] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:11.886] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:11.924] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.924] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.924] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.925] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.926] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:11.925] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.926] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:11.925] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:11.926] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:11.927] INFO: [Database] Db connection was successful
[2025-03-06 16:38:11.945] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
[2025-03-06 16:38:11.927] INFO: [Database] Db connection was successful
[2025-03-06 16:38:11.945] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
[2025-03-06 16:38:11.927] INFO: [Database] Db connection was successful
���g
���g
[2025-03-06 16:38:11.945] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
^
^
SyntaxError: Invalid or unexpected token
SyntaxError: Invalid or unexpected token
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at resolve (/server/managers/MigrationManager.js:147:18)
at resolve (/server/managers/MigrationManager.js:147:18)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at /server/libs/umzug/umzug.js:330:14
at /server/libs/umzug/umzug.js:330:14
at resolve (/server/managers/MigrationManager.js:147:18)
at Array.map ()
at Array.map ()
at /server/libs/umzug/umzug.js:330:14
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at Array.map ()
at migrations (/server/managers/MigrationManager.js:166:23)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:11.948] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:11.948] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
at async Server.start (/server/Server.js:227:5)
promise: Promise {
at async Database.init (/server/Database.js:184:7)
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
[2025-03-06 16:38:11.948] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at async Server.init (/server/Server.js:161:5)
at async Server.init (/server/Server.js:161:5)
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
at async Server.start (/server/Server.js:227:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
}
}
Container stopped
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:14.834] INFO: === Starting Server ===
[2025-03-06 16:38:14.848] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:14.848] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:14.849] INFO: [Server] Platform: linux
[2025-03-06 16:38:14.849] INFO: [Server] Arch: x64
[2025-03-06 16:38:14.860] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:14.900] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:14.901] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:14.901] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:14.902] INFO: [Database] Db connection was successful
[2025-03-06 16:38:14.921] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:14.924] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:17.180] INFO: === Starting Server ===
[2025-03-06 16:38:17.202] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:17.202] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:17.202] INFO: [Server] Platform: linux
[2025-03-06 16:38:17.203] INFO: [Server] Arch: x64
[2025-03-06 16:38:17.214] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:17.254] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:17.255] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:17.255] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:17.256] INFO: [Database] Db connection was successful
[2025-03-06 16:38:17.274] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:17.277] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:19.515] INFO: === Starting Server ===
[2025-03-06 16:38:19.529] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:19.529] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:19.530] INFO: [Server] Platform: linux
[2025-03-06 16:38:19.530] INFO: [Server] Arch: x64
[2025-03-06 16:38:19.540] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:19.580] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:19.581] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:19.581] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:19.582] INFO: [Database] Db connection was successful
[2025-03-06 16:38:19.600] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:19.603] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:22.752] INFO: === Starting Server ===
[2025-03-06 16:38:22.766] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:22.767] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:22.767] INFO: [Server] Platform: linux
[2025-03-06 16:38:22.767] INFO: [Server] Arch: x64
[2025-03-06 16:38:22.776] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:22.819] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:22.820] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:22.821] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:22.821] INFO: [Database] Db connection was successful
[2025-03-06 16:38:22.837] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:22.840] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:27.799] INFO: === Starting Server ===
[2025-03-06 16:38:27.816] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:27.817] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:27.817] INFO: [Server] Platform: linux
[2025-03-06 16:38:27.818] INFO: [Server] Arch: x64
[2025-03-06 16:38:27.825] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:27.867] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:27.868] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:27.868] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:27.869] INFO: [Database] Db connection was successful
[2025-03-06 16:38:27.887] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:27.890] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:36.001] INFO: === Starting Server ===
[2025-03-06 16:38:36.018] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:36.019] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:36.019] INFO: [Server] Platform: linux
[2025-03-06 16:38:36.019] INFO: [Server] Arch: x64
[2025-03-06 16:38:36.026] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:36.064] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:36.065] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:36.065] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:36.066] INFO: [Database] Db connection was successful
[2025-03-06 16:38:36.087] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:36.090] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:38:50.298] INFO: === Starting Server ===
[2025-03-06 16:38:50.311] INFO: [Server] Init v2.19.5
[2025-03-06 16:38:50.312] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:38:50.312] INFO: [Server] Platform: linux
[2025-03-06 16:38:50.313] INFO: [Server] Arch: x64
[2025-03-06 16:38:50.325] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:38:50.368] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:50.369] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:38:50.369] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:38:50.369] INFO: [Database] Db connection was successful
[2025-03-06 16:38:50.388] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:38:50.390] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
Container started
Running in production mode.
Options: CONFIG_PATH=/config, METADATA_PATH=/metadata, PORT=80, HOST=undefined, SOURCE=docker, ROUTER_BASE_PATH=/audiobookshelf
[2025-03-06 16:39:18.427] INFO: === Starting Server ===
[2025-03-06 16:39:18.448] INFO: [Server] Init v2.19.5
[2025-03-06 16:39:18.448] INFO: [Server] Node.js Version: v20.18.3
[2025-03-06 16:39:18.449] INFO: [Server] Platform: linux
[2025-03-06 16:39:18.449] INFO: [Server] Arch: x64
[2025-03-06 16:39:18.458] INFO: [Database] Initializing db at "/config/absdatabase.sqlite"
[2025-03-06 16:39:18.504] INFO: [Database] Loading extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:39:18.505] INFO: [Database] Successfully loaded extension /usr/local/lib/nusqlite3/libnusqlite3.so
[2025-03-06 16:39:18.505] INFO: [Database] Db supports unaccent and unicode foldings
[2025-03-06 16:39:18.506] INFO: [Database] Db connection was successful
[2025-03-06 16:39:18.525] ERROR: [Database] Failed to run migrations /server/migrations/v2.15.0-series-column-unique.js.gz:1
���g
^
SyntaxError: Invalid or unexpected token
at wrapSafe (node:internal/modules/cjs/loader:1378:20)
at Module._compile (node:internal/modules/cjs/loader:1428:41)
at resolve (/server/managers/MigrationManager.js:147:18)
at /server/libs/umzug/umzug.js:330:14
at Array.map ()
at Umzug.migrations (/server/libs/umzug/umzug.js:325:20)
at migrations (/server/managers/MigrationManager.js:166:23)
at Umzug.paths [as migrations] (/server/libs/umzug/umzug.js:317:32)
at MigrationManager.runMigrations (/server/managers/MigrationManager.js:82:41)
at async Database.init (/server/Database.js:184:7)
[2025-03-06 16:39:18.527] FATAL: [Server] Unhandled rejection: Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
promise: Promise {
Error: Database migration failed
at Database.init (/server/Database.js:187:13)
at async Server.init (/server/Server.js:161:5)
at async Server.start (/server/Server.js:227:5)
}
Container stopped
@mikiher commented on GitHub (Mar 6, 2025):
Ok, so all files with a .gz extension should definitely not be in that directory, and they are likely the cause for this failure.
I'm not sure, however, what caused them to be created there.
@advplyr was there any recent change that might run gzip on files in
/config/migrations?To work around this issue, can you please remove all files ending with .gz from that directory (leave only the files ending with .js), and then try to upgrade again?
@advplyr commented on GitHub (Mar 6, 2025):
Nope
@jkrobin commented on GitHub (Mar 7, 2025):
@mikiher @advplyr Thank you!
Removing the .gz files in /config/migrations did the trick and I've successfully upgraded to 2.19.5.
I definitely did not manually gzip the .js files in the directory and will keep an eye out to see if anything similar happens going forward.
Thanks again.
@advplyr commented on GitHub (Mar 7, 2025):
While it is not ideal to include non-migration files in the migrations folder, I think it is safe to ignore these, so I added a filter and validation in #4078
Including a
.jsfile that is not properly named will throw an error still.