I’m seeing the same thing on 1.25.4.xxxx versions. I haven’t yet upgraded libraries, not sure I wanna do that either to end up in a point of no return at the moment. Downgrading to 1.25.3 makes all library scans finish in a matter of seconds, but on 1.25.4 it tends to get stuck on certain particular entries (that has previously been indexed). However, according to the logs, the entry that it is reporting is logged as it would be skipped, so it might be the “next” file in the list that is the actual culprit, but there is no indication of which one that is.
According to the logs, it just seems to stall. The only thing standing out is this:
Jan 28, 2022 13:55:28.837 [0x7f449ada6b38] WARN - SLOW QUERY: It took 370.000000 ms to retrieve 50 items.
Jan 28, 2022 13:55:28.876 [0x7f4499b8db38] WARN - SLOW QUERY: It took 300.000000 ms to retrieve 50 items.
I recall seeing some errors a few days ago when investigating this as well, about the database being locked, but not sure if related:
Jan 25, 2022 21:51:52.729 [0x7fbba7b34b38] ERROR - Soci Exception handled: Cannot begin transaction. database is locked
Jan 25, 2022 21:51:54.775 [0x7fbba166cb38] ERROR - Failed to begin transaction (/data/jenkins/server/3533770972/Library/MediaStreamSetting.cpp:24) (tries=1): Cannot begin transaction. database is locked
Jan 25, 2022 21:51:57.075 [0x7fbba166cb38] ERROR - Failed to begin transaction (/data/jenkins/server/3533770972/Library/MediaStreamSetting.cpp:24) (tries=2): Cannot begin transaction. database is locked
Jan 25, 2022 21:51:59.374 [0x7fbba166cb38] ERROR - Failed to begin transaction (/data/jenkins/server/3533770972/Library/MediaStreamSetting.cpp:24) (tries=3): Cannot begin transaction. database is locked
Could there be some problematic db-migration, missing indexes or such that was introduced in 1.25.4? The changelog claims that major database migrations were applied, so doesn’t seem to farfetched.
