gotson / komga

Media server for comics/mangas/BDs/magazines/eBooks with API, OPDS and Kobo Sync support
https://komga.org
MIT License
3.87k stars 233 forks source link

Update crashed database #1636

Open JamesMarcum opened 1 month ago

JamesMarcum commented 1 month ago

Steps to reproduce

Updated my docker of Komga on Unraid, restarted docker

Expected behavior

normally restarts and auto logs in

Actual behavior

after 45-60 seconds, prompted for login info. After prompting, error flashed and logged (included below). Cannot get further to see more.

Logs

2024-07-27T17:10:15.429-07:00 ERROR 1 --- [io-25600-exec-9] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.jooq.exception.DataAccessException: SQL [select LIBRARY.ID, LIBRARY.CREATED_DATE, LIBRARY.LAST_MODIFIED_DATE, LIBRARY.NAME, LIBRARY.ROOT, LIBRARY.IMPORT_COMICINFO_BOOK, LIBRARY.IMPORT_COMICINFO_SERIES, LIBRARY.IMPORT_COMICINFO_COLLECTION, LIBRARY.IMPORT_EPUB_BOOK, LIBRARY.IMPORT_EPUB_SERIES, LIBRARY.SCAN_FORCE_MODIFIED_TIME, LIBRARY.SCAN_STARTUP, LIBRARY.IMPORT_LOCAL_ARTWORK, LIBRARY.IMPORT_COMICINFO_READLIST, LIBRARY.IMPORT_BARCODE_ISBN, LIBRARY.CONVERT_TO_CBZ, LIBRARY.REPAIR_EXTENSIONS, LIBRARY.EMPTY_TRASH_AFTER_SCAN, LIBRARY.IMPORT_MYLAR_SERIES, LIBRARY.SERIES_COVER, LIBRARY.UNAVAILABLE_DATE, LIBRARY.HASH_FILES, LIBRARY.HASH_PAGES, LIBRARY.ANALYZE_DIMENSIONS, LIBRARY.IMPORT_COMICINFO_SERIES_APPEND_VOLUME, LIBRARY.ONESHOTS_DIRECTORY, LIBRARY.SCAN_CBX, LIBRARY.SCAN_PDF, LIBRARY.SCAN_EPUB, LIBRARY.SCAN_INTERVAL, LIBRARY_EXCLUSIONS.LIBRARY_ID, LIBRARY_EXCLUSIONS.EXCLUSION from LIBRARY left outer join LIBRARY_EXCLUSIONS on LIBRARY_EXCLUSIONS.LIBRARY_ID = LIBRARY.ID]; SqliteUdfPool - Connection is not available, request timed out after 30000ms.] with root cause

Komga version

14.3

Operating system

Unraid 6.12.9

Installation method

Docker

Other details

Installed via Unraid, upgraded by context menu.

Acknowledgements

gotson commented 1 month ago

a full log could help. Seems like your database file is not reachable.