"scan for new items" always scans the entire collection

[VALÍK Robert]

Hey there!

After upgrading Digikam to version 9.1, I have also noticed this weird 
behavior.

I have:

- EndeavourOS
- extra/digikam 9.1.0-4 (32.9 MiB 115.2 MiB) (Installed)
- MariaDB server as a backend

Config:

- "Scan for new items at startup" on
- "Fast Scan (...)" on

I have had this configuration for years (the Digikam DB may have worked 
and been upgraded for about 10 years). Up until upgrade - every time I 
have started Digikam, it scanned briefly (like seconds) for new items, 
if there were new items, it imported them (few seconds or minutes) and 
so.

But after upgrading, it scans and updates the entire collection every 
time. It takes more than 8hrs. Digikam rewrites all data stored in the 
database. It creates like 3GB of binlogs every time. If I log queries, 
it literally checks timestamp of a picture and than deletes and writes 
it's metadata (and thumbnails) all over again. After it finishes and I 
close it and start again, it happens again.

I have tried every DB maintenance option I have found in Digikam, still 
not working properly.

The only thing that did help - was to migrate the DB to SQLite (this is 
complicates things for me, as I synchronize images and metadata from 
Digikam to my webpage and SQLite cannot be as effectively backed up as 
MariaDB...).

It seems like Digikam may not be handling timestamps stored in MariaDB 
properly and decides that the metadata meed to be updated or something.

Robert
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0xDA8B0D6F.asc
Type: application/pgp-keys
Size: 3805 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260709/4f3eb66c/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260709/4f3eb66c/attachment.sig>