YACServer scans library but doesn't update database; app and webui shows nothing in it

[marllonsimoes]

Hello all!
I am long time user with a quite good collection as of now.
Since updating to version 10, I've been experiencing some issues.

Problem:
Newly created library; YAC starts scanning the folder; get covers and says its available but no comics are listed in the library;

Logs:

yacreader  | 2026-07-23T11:10:14.758492155Z [migrations] started
yacreader  | 2026-07-23T11:10:14.758521562Z [migrations] no migrations found
yacreader  | 2026-07-23T11:10:14.770906659Z usermod: no changes
yacreader  | 2026-07-23T11:10:14.771114436Z 
yacreader  | 2026-07-23T11:10:14.771130649Z ----------------------------------------------------------
yacreader  | 2026-07-23T11:10:14.771135349Z  __     __      _____ _____                _           
yacreader  | 2026-07-23T11:10:14.771138968Z  \ \   / //\   / ____|  __ \              | |          
yacreader  | 2026-07-23T11:10:14.771142561Z   \ \_/ //  \ | |    | |__) |___  __ _  __| | ___ _ __ 
yacreader  | 2026-07-23T11:10:14.771145877Z    \   // /\ \| |    |  _  // _ \/ _` |/ _` |/ _ \  __|
yacreader  | 2026-07-23T11:10:14.771149178Z     | |/ ____ \ |____| | \ \  __/ (_| | (_| |  __/ |   
yacreader  | 2026-07-23T11:10:14.771152294Z     |_/_/    \_\_____|_|  \_\___|\__,_|\__,_|\___|_|   
yacreader  | 2026-07-23T11:10:14.771155605Z 
yacreader  | 2026-07-23T11:10:14.771158641Z ----------------------------------------------------------
yacreader  | 2026-07-23T11:10:14.771161684Z GID/UID
yacreader  | 2026-07-23T11:10:14.771164690Z ----------------------------------------------------------
yacreader  | 2026-07-23T11:10:14.775841198Z 
yacreader  | 2026-07-23T11:10:14.775857236Z User uid:    1002
yacreader  | 2026-07-23T11:10:14.775861753Z User gid:    1002
yacreader  | 2026-07-23T11:10:14.775865310Z -------------------------------------
yacreader  | 2026-07-23T11:10:14.775868731Z 
yacreader  | 2026-07-23T11:10:15.344991005Z [custom-init] No custom files found, skipping...
yacreader  | 2026-07-23T11:10:15.368759643Z INFO  2026-07-23T13:10:15.369 YACReaderLibraryServer attempting to start 
yacreader  | 2026-07-23T11:10:15.368785211Z INFO  2026-07-23T13:10:15.369 ---------- System & configuration ---------- 
yacreader  | 2026-07-23T11:10:15.379684900Z INFO  2026-07-23T13:10:15.380 "SYSTEM INFORMATION" 
yacreader  | 2026-07-23T11:10:15.379701155Z INFO  2026-07-23T13:10:15.380 "Qt version: 6.10.2" 
yacreader  | 2026-07-23T11:10:15.379705804Z INFO  2026-07-23T13:10:15.380 "Build ABI: x86_64-little_endian-lp64" 
yacreader  | 2026-07-23T11:10:15.379709396Z INFO  2026-07-23T13:10:15.380 "build CPU architecture: x86_64" 
yacreader  | 2026-07-23T11:10:15.379712629Z INFO  2026-07-23T13:10:15.380 "CPU architecture: x86_64" 
yacreader  | 2026-07-23T11:10:15.379715891Z INFO  2026-07-23T13:10:15.380 "Kernel type: linux" 
yacreader  | 2026-07-23T11:10:15.379719126Z INFO  2026-07-23T13:10:15.380 "Kernel version: 7.1.4-200.fc44.x86_64" 
yacreader  | 2026-07-23T11:10:15.379722444Z INFO  2026-07-23T13:10:15.380 "Product info: Ubuntu 26.04 LTS" 
yacreader  | 2026-07-23T11:10:15.379725675Z INFO  2026-07-23T13:10:15.380 "" 
yacreader  | 2026-07-23T11:10:15.379728926Z INFO  2026-07-23T13:10:15.380 "APP INFORMATION" 
yacreader  | 2026-07-23T11:10:15.379732579Z INFO  2026-07-23T13:10:15.380 "Image formats supported: 3fr, ani, arw, avif, avifs, bmp, bw, cr2, cr3, crw, cur, dcr, dds, dng, eps, epsf, epsi, erf, exr, fff, gif, hdr, heic, heif, hej2, icns, ico, iff, iiq, ilbm, im1, im24, im32, im8, j2k, jfif, jp2, jpeg, jpf, jpg, jxl, k25, kdc, kra, lbm, mdc, mef, mng, mos, mrw, nef, nrw, ora, orf, pbm, pcx, pdd, pef, pfm, pgm, phm, pic, png, ppm, psb, psd, psdt, pxr, qoi, raf, ras, raw, rgb, rgba, rw2, rwl, sct, sgi, sr2, srf, srw, sti, sun, tga, tif, tiff, wbmp, webp, x3f, xbm, xcf, xpm" 
yacreader  | 2026-07-23T11:10:15.379746263Z INFO  2026-07-23T13:10:15.380 "User image plugin folder: /config/.local/share/YACReader/plugins/imageformats" 
yacreader  | 2026-07-23T11:10:15.379755853Z INFO  2026-07-23T13:10:15.380 "Compression backend: 7zip" 
yacreader  | 2026-07-23T11:10:15.379759940Z INFO  2026-07-23T13:10:15.380 "PDF support: Poppler" 
yacreader  | 2026-07-23T11:10:15.379763386Z INFO  2026-07-23T13:10:15.380 "" 
yacreader  | 2026-07-23T11:10:15.379766678Z INFO  2026-07-23T13:10:15.380 Libraries:  
yacreader  | 2026-07-23T11:10:15.379770050Z INFO  2026-07-23T13:10:15.380      "Comics [1, db7b56c6-f268-4593-a844-c45db540d435, /comics]" 
yacreader  | 2026-07-23T11:10:15.388076117Z INFO  2026-07-23T13:10:15.388      > STATUS:  "WARNING! DB read access: NO, DB write access: YES, can write to disk: YES" 
yacreader  | 2026-07-23T11:10:15.388093049Z INFO  2026-07-23T13:10:15.388 -------------------------------------------- 
yacreader  | 2026-07-23T11:10:15.388121564Z INFO  2026-07-23T13:10:15.388 YACReaderLibrary starting 
...

yacreader  | 2026-07-23T11:15:26.766982397Z INFO  2026-07-23T13:15:26.767 "updateChildrenInfo took 0ms" 
yacreader  | 2026-07-23T11:15:26.767605743Z ERROR 2026-07-23T13:15:26.767 Error getting comics to delete 
yacreader  | 2026-07-23T11:15:26.767616567Z INFO  2026-07-23T13:15:26.767 Update library END 
yacreader  | 2026-07-23T11:15:26.767620288Z INFO  2026-07-23T13:15:26.767 Done updating libraries 

After all this, the database file in the comics folder (.yacreaderlibrary/library.ydb) shows 0b.

The Error getting comics to delete is also concerning, as it's a newly created library, shouldn't be deleting anything at this point.

I've noted some "info" in the logs that are suspicious:

yacreader  | 2026-07-23T11:11:23.246272022Z INFO  2026-07-23T13:11:23.246 "Parameter count mismatch" 
yacreader  | 2026-07-23T11:11:23.246277282Z INFO  2026-07-23T13:11:23.246 "UPDATE comic_info SET title = :title,coverPage = :coverPage,numPages = :numPages,number = :number,isBis = :isBis,count = :count,volume = :volume,storyArc = :storyArc,arcNumber = :arcNumber,arcCount = :arcCount,genere = :genere,writer = :writer,penciller = :penciller,inker = :inker,colorist = :colorist,letterer = :letterer,coverArtist = :coverArtist,date = :date,publisher = :publisher,format = :format,color = :color,ageRating = :ageRating,synopsis = :synopsis,characters = :characters,notes = :notes,read = :read,edited = :edited,hasBeenOpened = :hasBeenOpened,currentPage = :currentPage,bookmark1 = :bookmark1,bookmark2 = :bookmark2,bookmark3 = :bookmark3,brightness = :brightness,contrast = :contrast, gamma = :gamma,rating = :rating,comicVineID = :comicVineID,lastTimeOpened = :lastTimeOpened,coverSizeRatio = :coverSizeRatio,originalCoverSize = :originalCoverSize,added = :added,type = :type,editor = :editor,imprint = :imprint,teams = :teams,locations = :locations,series = :series,alternateSeries = :alternateSeries,alternateNumber = :alternateNumber,alternateCount = :alternateCount,languageISO = :languageISO,seriesGroup = :seriesGroup,mainCharacterOrTeam = :mainCharacterOrTeam,review = :review,tags = :tags,imageFiltersJson = :imageFiltersJson,lastTimeImageFiltersSet = :lastTimeImageFiltersSet,lastTimeCoverSet = :lastTimeCoverSet,usesExternalCover = :usesExternalCover,lastTimeMetadataSet = :lastTimeMetadataSet WHERE id = :id" 

Screenshots:

[luisangelsm]

The logs are telling you this:

yacreader | 2026-07-23T11:10:15.388076117Z INFO 2026-07-23T13:10:15.388 > STATUS: "WARNING! DB read access: NO, DB write access: YES, can write to disk: YES"

So something seems to be off with your setup.

Where is the library stored?

[marllonsimoes]

The library is mounted in the container in the /comics folder.
(Edit) I think you mean "where" in the sense if it is local or remote - it's remote, a NAS mount in the host, then to the container. Is there any limitation using sqllite in such configuration?

I know some sqlite have issues with db remote access. Is there a way to customize the db location? Maybe keeping it in the config folder or something alike?

Here's my docker-compose.yml

services:
  yacreader:
    container_name: yacreader
    deploy:
      resources:
        limits:
          cpus: "1.0"
          memory: 512M
    environment:
      - PUID=${PUID}
      - PGID=${PGID}
      - TZ=${TZ}
    image: yacreader/yacreaderlibraryserver:10.1.0
    ports:
      - '8080:8080'
    restart: unless-stopped
    volumes:
      - /srv/yacreader/config:/config
      - /MEDIA_DIR/comics:/comics

(Edit2)
For completeness, here's my systemd mount unit:

      [Unit]
      Description=NAS share {{ item.share }} ({{ item.mount }})
      Wants=network-online.target
      After=network-online.target

      [Mount]
      What=//{{ nas_ip }}/{{ item.share }}
      Where={{ item.mount }}
      Type=cifs
      Options=credentials={{ nas_credentials_path }},uid={{ nas_uid }},gid={{ nas_gid }},rw,nofail,nobrl,iocharset=utf8,vers=3.0
      TimeoutSec={{ nas_data_mount_timeout | default(15) }}

      [Install]
      WantedBy=multi-user.target

[marllonsimoes]

It works fine after tweaking a bit with cifs. For some reason the configs were not propagated correctly, but after restarting everything and recreating the library it worked fine. Thanks for promptly answering, though :)