DB maintance unable to clear some missing roll and image

Is there an existing issue for this?

• I checked and did not find my issue in the already reported ones

Describe the bug

I removed a large number of images from the disk and moved them to long-term storage.

I then used the DB maintenance lua script to remove them from the database. It worked for most of them, but I still have "skull" images and film rolls that won't go away.

Steps to reproduce

DB maintenance -> scan for -> images (nothing is shown, see the screenshot, but there are phantom skulls around).

The same happens for scab for -> film roll (ee the second screenshot); the rolls come out in the list, but choosing "remove" does nothing.

Expected behavior

remove all "strokeout" film roll and "skull" images

Logfile | Screenshot | Screencast

First screenshot, missing image not found

Second screenshot, film roll found but not removed

Commit

No response

Where did you obtain darktable from?

distro packaging

darktable version

darktable 5.4.1

What OS are you using?

Linux

What is the version of your OS?

Manjaro Linux, stable version, up-to-date 2026-03-22

Describe your system

> inxi
CPU: 8-core AMD Ryzen 9 5900HX with Radeon Graphics (-MT MCP-)
speed/min/max: 1100/423/4683 MHz Kernel: 6.18.12-1-MANJARO x86_64 Up: 5h 51m
Mem: 6.68/30.77 GiB (21.7%) Storage: 3.64 TiB (48.2% used) Procs: 449
Shell: Zsh inxi: 3.3.40
> inxi -G      
Graphics:
  Device-1: Advanced Micro Devices [AMD/ATI] Cezanne [Radeon Vega Series /
    Radeon Mobile Series] driver: amdgpu v: kernel
  Device-2: Creative Live! Cam Sync 1080p V2 driver: snd-usb-audio,uvcvideo
    type: USB
  Display: wayland server: X.org v: 1.21.1.21 with: Xwayland v: 24.1.9
    compositor: gnome-shell v: 49.4 driver: X: loaded: amdgpu
    unloaded: modesetting,radeon dri: radeonsi gpu: amdgpu resolution:
    1: 2560x1440~60Hz 2: 1920x1080~60Hz
  API: EGL v: 1.5 drivers: kms_swrast,radeonsi,swrast
    platforms: gbm,wayland,x11,surfaceless,device
  API: OpenGL v: 4.6 compat-v: 4.5 vendor: amd mesa v: 25.3.5-arch1.1
    renderer: AMD Radeon Graphics (radeonsi renoir ACO DRM 3.64
    6.18.12-1-MANJARO)
  Info: Tools: api: clinfo, eglinfo, glxinfo gpu: amd-smi x11: xprop,xrandr

Are you using OpenCL GPU in darktable?

yes

If yes, what is the GPU card and driver?

See inxi output above

Please provide additional context if applicable. You can attach files too, but might need to rename to .txt or .zip

This is a very old installation of darktable, kept up to date. I am available to give detail, I can run a mysql inspector on the database, no problem (if I am pointed to what to do 😉)

Thanks to all developers of Darktable!