pending synchonization at restart
frederic chaume
frederic.chaume at gmail.com
Tue Sep 1 11:32:49 BST 2026
Gilles
Just rerun maintenance tools again but with debug view
Found following messages, see below
This confirm the DB corruption. , right?
so next step is to restart with a fresh DB, right ? Can you precise how
to proceed , thinking to stop DK, remove Db and restart DK. Is that enough ?
regards
Frederic
"DELETE FROM Thumbnails WHERE id=:0;"
Error messages: "Impossible de récupérer la ligne" "database disk
image is malformed" "11" 1
Bound values: QList(QVariant(int, 226891))
digikam.dbengine: Failure executing query:
"DELETE FROM Thumbnails WHERE id=:0;"
Error messages: "Impossible de récupérer la ligne" "database disk
image is malformed" "11" 1
Bound values: QList(QVariant(int, 516784))
digikam.thumbsdb: Could not start the removal of "" due to error
digikam.general: One job is done Digikam::DatabaseTask(0x2a303943000)
time: 1400524
digikam.dbengine: WARNING !!! Transaction count is 1 when destroying
database!!!
digikam.maintenance: List of Pending Jobs is empty
digikam.maintenance: Faces DB is clean.
digikam.maintenance: Found 59575 image ids that are referenced in
similarity db but not used.
digikam.maintenance: Creating a database task for removing stale image
id entries from similarity db.
digikam.general: Action Thread run 1 new jobs
digikam.general: One job is done Digikam::DatabaseTask(0x2a30721f3e0)
time: 2331
digikam.maintenance: List of Pending Jobs is empty
digikam.general: Action Thread run 1 new jobs
digikam.maintenance: Shrinking databases
digikam.database: Failed integrity check for SQLite core database:
"wrong # of entries in index image_status_index"
digikam.maintenance: Integrity check for core DB failed. Will not vacuum.
digikam.database: Failed integrity check for SQLite thumbnail database:
"*** in database main ***\nTree 2 page 4087277 cell 0: invalid page
number 4245518588\nTree 2 page 4087214 cell 0: invalid page number
2543449262\nTree 2 page 4087192 cell 1: invalid page number
1989601594\nTree 2 page 4087168 cell 2: invalid page number
2282729473\nTree 2 page 4087168 cell 0: invalid page number
3079188245\nTree 2 page 4087155 cell 0: invalid page number
1367568241\nTree 2 page 4087139 cell 0: invalid page number
1619541267\nTree 2 page 4087108 cell 0: invalid page number
2484542021\nTree 2 page 4087080 cell 0: invalid page number
3050765754\nTree 2 page 4087074 cell 1: invalid page number
425636694\nTree 2 page 4087066 cell 0: invalid page number
2720391427\nTree 2 page 4087038 cell 0: invalid page number
1294591941\nTree 2 page 4087023 cell 0: invalid page number
2364799556\nTree 2 page 4087004 cell 1: invalid page number
2916350661\nTree 2 page 4086970 cell 0: invalid page number
2816116134\nTree 2 page 4086960 cell 0: invalid page number
2329730588\nTree 2 page 4086945 cell 0: invalid page number
1705933643\nTree 2 page 4086927 cell 0: invalid page number
990215723\nTree 2 page 4086911 cell 0: invalid page number
3081192065\nTree 2 page 4086893 cell 0: invalid page number
2565581624\nPage 5357198: never used\nPage 5357199: never used\nPage
5357200: never used\nPage 5357201: never used\nPage 5357202: never
used\nPage 5357204: never used\nPage 5357205: never used\nPage 5357206:
never used\nPage 5357207: never used\nPage 5357208: never used\nPage
5357209: never used\nPage 5357210: never used\nPage 5357211: never
used\nPage 5357212: never used\nPage 5357213: never used\nPage 5357214:
never used\nPage 5357215: never used\nPage 5357216: never used\nPage
5357217: never used\nPage 5357218: never used\nPage 5357219: never
used\nPage 5357220: never used\nPage 5357221: never used\nPage 5357222:
never used\nPage 5357223: never used\nPage 5357224: never used\nPage
5357225: never used\nPage 5357226: never used\nPage 5357227: never
used\nPage 5357228: never used\nPage 5357229: never used\nPage 5357230:
never used\nPage 5357231: never used\nPage 5357232: never used\nPage
5357233: never used\nPage 5357234: never used\nPage 5357236: never
used\nPage 5357237: never used\nPage 5357238: never used\nPage 5357239:
never used\nPage 5357240: never used\nPage 5357241: never used\nPage
5357243: never used\nPage 5357244: never used\nPage 5357245: never
used\nPage 5357246: never used\nPage 5357247: never used\nPage 5357248:
never used\nPage 5357249: never used\nPage 5357250: never used\nPage
5357251: never used\nPage 5357252: never used\nPage 5357253: never
used\nPage 5357254: never used\nPage 5357255: never used\nPage 5357257:
never used\nPage 5357258: never used\nPage 5357259: never used\nPage
5357260: never used\nPage 5357261: never used\nPage 5357262: never
used\nPage 5357263: never used\nPage 5357264: never used\nPage 5357265:
never used\nPage 5357266: never used\nPage 5357267: never used\nPage
5357268: never used\nPage 5357269: never used\nPage 5357270: never
used\nPage 5357271: never used\nPage 5357272: never used\nPage 5357273:
never used\nPage 5357274: never used\nPage 5357275: never used\nPage
5357276: never used\nPage 5357277: never used\nPage 5357278: never
used\nPage 5357279: never used\nPage 5357280: never used\nPage 5357281:
never used"
digikam.maintenance: Integrity check for thumbnails DB failed. Will not
vacuum.
digikam.maintenance: Finished vacuuming of recognition DB. Integrity
check after vacuuming was positive.
digikam.maintenance: Finished vacuuming of similarity DB. Integrity
check after vacuuming was positive.
digikam.general: One job is done Digikam::DatabaseTask(0x2a30721ea80)
time: 223314
digikam.maintenance: List of Pending Jobs is empty
digikam.maintenance: stage3
digikam.maintenance: stage4
digikam.maintenance: stage5
digikam.maintenance: stage6
digikam.maintenance: stage7
digikam.maintenance: stage8
digikam.maintenance: stage9
digikam.general: Event is dispatched using KDE desktop notifier
kf.notifications: No event config could be found for event id "digiKam
Maintenance" under notifyrc file for app "digikam"
digikam.general: Finish Main Thread
digikam.general: Finish Main Thread
Le 01/09/2026 à 11:29, frederic chaume a écrit :
> Bonjour Gilles
>
> After a backup , I have executed "Tools/Database maintenance : perform
> database cleaning" with all options set.
> It tooks some minutes to execute, but when I compare the backup and
> the active database, I notice that:
> - digikam4.db and thumbnails-digikam.db files are exactly same size
> (backup and active)
> - all db files in active directory (the one configured in DK settings)
> have the date of November 2024
>
> is that normal ?
>
> regards
> frederic
>
>
>
>
>
> Le 31/08/2026 à 18:07, frederic chaume a écrit :
>> Thanks Gilles for your advice.
>>
>> Will proceed following steos:
>> - backup DB (already doing it from time to time, but keeping only the
>> last version, cannot store an history for a 500M DB file, don't have
>> enough disk space)
>> - run the Tools/Database maintenance : perform database cleaning
>> - run the Tools/Database maintenance : perform sync metadata and
>> database (from file to DB)
>>
>> and will see if it is better. (filter debugview on "database disk
>> image is malformed" )
>> I will also see to run a cleaning of windows registry
>>
>> Note that for "jpg is written to XMP sidecar". My settings is "write
>> to XMP for read-only items only"
>>
>> regards
>> Frederic
>>
>>
>>
>> Le 31/08/2026 à 16:51, Gilles Caulier a écrit :
>>>
>>>
>>> Le lun. 31 août 2026 à 09:21, frederic chaume
>>> <frederic.chaume at gmail.com> a écrit :
>>>
>>> Hi Gilles
>>>
>>> thanks for your analysis.
>>> Answers/questions in blue inline
>>>
>>> regards
>>> Frederic
>>>
>>>
>>>
>>>
>>>
>>> Le 30/08/2026 à 11:42, Gilles Caulier a écrit :
>>>> Just at start of the application, when the icon view is
>>>> populated from the database we can read :
>>>>
>>>> 00000506 59.79187012 11348 digikam.dbengine: Failure executing
>>>> query:
>>>> 00000507 59.79187012 11348 "REPLACE INTO Images ( album, name,
>>>> status, category, modificationDate, fileSize, uniqueHash )
>>>> VALUES (:0,:1,:2,:3,:4,:5,:6);"
>>>> 00000508 59.79187012 11348 Error messages: "Impossible de
>>>> récupérer la ligne" "database disk image is malformed" "779" 1
>>>> 00000509 59.79187012 11348 Bound values: QList(QVariant(int,
>>>> 1053), QVariant(QString, "20181016_121649.jpg"), QVariant(int,
>>>> 1), QVariant(int, 1), QVariant(QDateTime, QDateTime(2021-04-10
>>>> 17:14:42.190 UTC+2 Qt::LocalTime)), QVariant(qlonglong,
>>>> 2821819), QVariant(QString, "61b16a737e8f3d7b4f104998ab36650d"))
>>>> 00000510 59.79508972 11348 digikam.database: Finishing took 4 ms
>>>>
>>>> It's clear the database file is corrupted. Why ? I don't know.
>>>> We already see more and more sqlite database corruption under
>>>> Windows, perhaps due to the anti-virus running in the
>>>> background, i don't know yet. From my side I use digiKam in my
>>>> office under Windows 11 controlled by my company (to reference
>>>> all photo taken in my office aka device, hardware, room,
>>>> working place, laboratory, experiment, etc), with Norton AV in
>>>> the background where is set an exception to l'ets run digiKam
>>>> properly and this lets all collection and database files live
>>>> alone without constraint. I never saw the sqlite database
>>>> corrupted (all running on my Dell Laptop with large NVME storages).
>>> Is there something I can do regarding DB corrupted? clean?
>>> rebuild (but how long it will take ?) ?
>>> I never run the database cleaning from maintenance. Can it help ?
>>>
>>>
>>> First backup the database files. This is the priority. In second
>>> stage, run the Tools/Database maintenance to see if it can help.
>>> After that close digiKam and restart. Check if the latency problem
>>> are solved...
>>>
>>>>
>>>> For this kind of error message:
>>>>
>>>> 00000506 59.79187012 11348 digikam.dbengine: Failure executing
>>>> query:
>>>> 00000507 59.79187012 11348 "REPLACE INTO Images ( album, name,
>>>> status, category, modificationDate, fileSize, uniqueHash )
>>>> VALUES (:0,:1,:2,:3,:4,:5,:6);"
>>>> 00000508 59.79187012 11348 Error messages: "Impossible de
>>>> récupérer la ligne" "database disk image is malformed" "779" 1
>>>> 00000509 59.79187012 11348 Bound values: QList(QVariant(int,
>>>> 1053), QVariant(QString, "20181016_121649.jpg"), QVariant(int,
>>>> 1), QVariant(int, 1), QVariant(QDateTime, QDateTime(2021-04-10
>>>> 17:14:42.190 UTC+2 Qt::LocalTime)), QVariant(qlonglong,
>>>> 2821819), QVariant(QString, "61b16a737e8f3d7b4f104998ab36650d"))
>>>> 00000510 59.79508972 11348 digikam.database: Finishing took 4 ms
>>>>
>>>> This is a native Windows desktop notifier failure. Nothing
>>>> important as it's not database related. This is strange because
>>>> later a similar notification is pushed successfully. Windows
>>>> environnement looks ugly.
>>>>
>>>> This one is important as file cannot be found. Why?
>>>>
>>>> 00001862 42845.85546875 11348 digikam.general: Action Thread
>>>> run 12 new jobs
>>>> 00001863 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a66a30) time: 4
>>>> 00001864 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a66da0) time: 6
>>>> 00001865 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67200) time: 3
>>>> 00001866 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67890) time: 8
>>>> 00001867 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a66a80) time: 5
>>>> 00001868 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67c00) time: 1
>>>> 00001869 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a671b0) time: 2
>>>> 00001870 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67110) time: 7
>>>> 00001871 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67480) time: 3
>>>> 00001872 42845.86328125 11348 digikam.general: One job is done
>>>> Digikam::MetadataSyncTask(0x20706a67660) time: 1
>>>> 00001873 42845.87500000 11348 digikam.metaengine: Cannot load
>>>> metadata from file with Exiv2 backend:
>>>> D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg (Error # 10 :
>>>> "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg: Failed to open the
>>>> data source: No such file or directory (errno = 2)"
>>>>
>>>> Here it's the metadata synchronizer working in the background.
>>>> So Exiv2 generates exceptions which can introduce time latency.
>>>>
>>>> Looks also another one :
>>>>
>>>> 00001897 42846.00781250 11348 <tel:+7%20812%20501-13-48>
>>>> digikam.general: Detected change, triggering rescan of
>>>> "D:/images/Pellicules/Pellicule 2026/2026-08/2026-08-25/"
>>>> 00001898 42846.03906250 11348 digikam.metaengine: Metadata for
>>>> file "P1003747_Dx90.jpg" written to XMP sidecar.
>>>> 00001899 42846.11328125 11348 digikam.general: Detected change,
>>>> triggering rescan of "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/"
>>>> 00001900 42846.11718750 11348 digikam.metaengine: wroteComment:
>>>> false
>>>> 00001901 42846.12109375 11348 digikam.metaengine: wroteEXIF: true
>>>> 00001902 42846.12109375 11348 digikam.metaengine: wroteIPTC: true
>>>> 00001903 42846.12109375 11348 digikam.metaengine: wroteXMP: true
>>>> 00001904 42846.12109375 11348 digikam.general: Detected change,
>>>> triggering rescan of "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/"
>>>> 00001905 42846.12109375 11348 digikam.metaengine: Metadata for
>>>> file "P1003747.RW2" written to XMP sidecar.
>>>> 00001906 42846.12500000 11348 digikam.metaengine: Cannot load
>>>> metadata from file with Exiv2 backend:
>>>> D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg (Error # 10 :
>>>> "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg: Failed to open the
>>>> data source: No such file or directory (errno = 2)"
>>>
>>> Such kind of file, once generated , is intented to be moved to
>>> another Album
>>> Is this can happen if the file is moved between setting the
>>> metadata and before launching synchronization ? If yes, that
>>> mean that metadata for this file will never be updated in the DB?
>>>
>>>
>>> I don't know. But in all cases this kind of error does not load the
>>> file metadata at all, and yes the database contents can be not
>>> homogeneous.
>>>
>>>
>>> Also wondering why "Metadata for file "P1003747_Dx90.jpg" is
>>> written to XMP sidecar." shouldn't use XMP for Jpeg, no?
>>>
>>>
>>> This depends on your needs. If you want the original files
>>> untouched, yes. Also consider ExifTool backend where the IO
>>> operations are processed to play metadata (it's more powerful than
>>> Exiv2, but not faster...
>>>
>>>
>>>
>>>>
>>>> You really have a problem at this storage location, or the
>>>> database contents are not properly up-to-date corresponding to
>>>> the collection contents.
>>> How to update the DB ? in maintenance menu, I see a "sync
>>> metadata and database", can it be run to solve it , using the
>>> read from file direction ?
>>>
>>>
>>> If the DB files are corrupted, no way. I hope that all digiKam
>>> properties are stored in files metadata (or xmp sidecar). Creating a
>>> new DB sounds like the more safe way to go. But this will not solve
>>> the base of the problem. Why have the DB files been corrupted one
>>> time ? This can happen one more time...
>>>
>>>>
>>>> This one is related to the thumbnails processing:
>>>>
>>>> 00001922 42846.17187500 11348 digikam.general: Generating
>>>> thumbnail for: "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>> 00001923 42846.17187500 11348 digikam.general: Failed to
>>>> generate thumbnail for: "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>> 00001924 42846.17187500 11348 digikam.general: Thumbnail is
>>>> null for "D:/images/Pellicules/Pellicule
>>>> 2026/2026-08/2026-08-25/P1003747_Dx90.jpg"
>>>>
>>>> It's always relevant of the same album.
>>>>
>>>> These errors are not relevant of digiKam. It's the
>>>> chrome install failure :
>>>>
>>>> 00002015 42950.33984375 13912 [0827/080238
>>>> <tel:0%20827%2008%2002%2038>.667:ERROR:third_party\crashpad\crashpad\util\file\filesystem_win.cc:128]
>>>> GetFileAttributes
>>>> C:\Users\famil\AppData\Local\Google\Chrome\User
>>>> Data\Crashpad\attachments\484eb780-549b-4714-9168-1b249d8237a1:
>>>> Le fichier spécifié est introuvable. (0x2)
>>>> 00002016 42950.33984375 13912 [0827/080238
>>>> <tel:0%20827%2008%2002%2038>.668:ERROR:third_party\crashpad\crashpad\util\file\filesystem_win.cc:128]
>>>> GetFileAttributes
>>>> C:\Users\famil\AppData\Local\Google\Chrome\User
>>>> Data\Crashpad\attachments\847eff80-ab44-430d-9695-a18c08e984df:
>>>> Le fichier spécifié est introuvable. (0x2)
>>>>
>>>> Something crashes in the background and can introduce more time
>>>> latency in your system.
>>>>
>>>> For this one, what's that ? It's an internal sqlite session
>>>> from the system or another application running in the
>>>> background? You have plenty of this kind of traces:
>>>>
>>>> 00004987 46830.67578125 11436 [2026-08-27 09:07:18.9897317]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00004988 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>> 00004989 46830.67578125 11436 FROM ( SELECT
>>>> 00004990 46830.67578125 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00004991 46830.67578125 11436 FROM ( SELECT
>>>> 00004992 46830.67578125 11436 1 AS [A1]
>>>> 00004993 46830.67578125 11436 FROM [Items] AS [Extent1]
>>>> 00004994 46830.67578125 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00004995 46830.67578125 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00004996 46830.67578125 11436 1 AS [C1]
>>>> 00004997 46830.67578125 11436 FROM [Sources] AS [Extent3]
>>>> 00004998 46830.67578125 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00004999 46830.67578125 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005000 46830.67578125 11436 [2026-08-27 09:07:18.9897317]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00005001 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005002 46830.67578125 11436 FROM ( SELECT
>>>> 00005003 46830.67578125 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00005004 46830.67578125 11436 FROM ( SELECT
>>>> 00005005 46830.67578125 11436 1 AS [A1]
>>>> 00005006 46830.67578125 11436 FROM [Items] AS [Extent1]
>>>> 00005007 46830.67578125 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00005008 46830.67578125 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00005009 46830.67578125 11436 1 AS [C1]
>>>> 00005010 46830.67578125 11436 FROM [Sources] AS [Extent3]
>>>> 00005011 46830.67578125 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00005012 46830.67578125 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005013 46830.67578125 11436 [2026-08-27 09:07:18.9897317]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00005014 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005015 46830.67578125 11436 FROM ( SELECT
>>>> 00005016 46830.67578125 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00005017 46830.67578125 11436 FROM ( SELECT
>>>> 00005018 46830.67578125 11436 1 AS [A1]
>>>> 00005019 46830.67578125 11436 FROM [Items] AS [Extent1]
>>>> 00005020 46830.67578125 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00005021 46830.67578125 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00005022 46830.67578125 11436 1 AS [C1]
>>>> 00005023 46830.67578125 11436 FROM [Sources] AS [Extent3]
>>>> 00005024 46830.67578125 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00005025 46830.67578125 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005026 46830.67578125 11436 [2026-08-27 09:07:18.9897317]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00005027 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005028 46830.67578125 11436 FROM ( SELECT
>>>> 00005029 46830.67578125 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00005030 46830.67578125 11436 FROM ( SELECT
>>>> 00005031 46830.67578125 11436 1 AS [A1]
>>>> 00005032 46830.67578125 11436 FROM [Items] AS [Extent1]
>>>> 00005033 46830.67578125 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00005034 46830.67578125 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00005035 46830.67578125 11436 1 AS [C1]
>>>> 00005036 46830.67578125 11436 FROM [Sources] AS [Extent3]
>>>> 00005037 46830.67578125 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00005038 46830.67578125 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005039 46830.67578125 11436 [2026-08-27 09:07:18.9897317]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00005040 46830.67578125 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005041 46830.67578125 11436 FROM ( SELECT
>>>> 00005042 46830.67578125 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00005043 46830.67578125 11436 FROM ( SELECT
>>>> 00005044 46830.67578125 11436 1 AS [A1]
>>>> 00005045 46830.67578125 11436 FROM [Items] AS [Extent1]
>>>> 00005046 46830.67578125 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00005047 46830.67578125 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00005048 46830.67578125 11436 1 AS [C1]
>>>> 00005049 46830.67578125 11436 FROM [Sources] AS [Extent3]
>>>> 00005050 46830.67578125 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00005051 46830.67578125 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005052 46831.84375000 11436 [2026-08-27 09:07:20.1733485]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 42: interrupted; [SELECT
>>>> 00005053 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005054 46831.84375000 11436 FROM ( SELECT
>>>> 00005055 46831.84375000 11436 Count([Filter4].[A1]) AS [A1]
>>>> 00005056 46831.84375000 11436 FROM ( SELECT
>>>> 00005057 46831.84375000 11436 1 AS [A1]
>>>> 00005058 46831.84375000 11436 FROM ( SELECT [Extent1].[Id] AS
>>>> [Id1], [Extent1].[CreationDate] AS [CreationDate],
>>>> [Extent1].[ModificationDate] AS [ModificationDate],
>>>> [Extent1].[Name] AS [Name1], [Extent1].[StoreRating] AS
>>>> [StoreRating], [Extent1].[StoreSettings] AS [StoreSettings],
>>>> [Extent1].[StoreProcessingStatus] AS [StoreProcessingStatus],
>>>> [Extent1].[Uuid] AS [Uuid1], [Extent1].[StoreOrientation] AS
>>>> [StoreOrientation], [Extent1].[StorePickOrReject] AS
>>>> [StorePickOrReject], [Extent1].[StoreMetadataVersion] AS
>>>> [StoreMetadataVersion], [Extent1].[StoreFormat] AS [StoreForma
>>>> 00005059 46831.84375000 11436 [2026-08-27 09:07:20.1733485]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 59: interrupted; [SELECT
>>>> 00005060 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005061 46831.84375000 11436 FROM ( SELECT
>>>> 00005062 46831.84375000 11436 Count([Filter2].[A1]) AS [A1]
>>>> 00005063 46831.84375000 11436 FROM ( SELECT
>>>> 00005064 46831.84375000 11436 1 AS [A1]
>>>> 00005065 46831.84375000 11436 FROM [Items] AS [Extent1]
>>>> 00005066 46831.84375000 11436 LEFT OUTER JOIN [Sources] AS
>>>> [Extent2] ON ([Extent1].[SourceId] = [Extent2].[Id]) AND
>>>> ([Extent2].[SourceTypeDiscriminator] = 'EFDOPFileSource')
>>>> 00005067 46831.84375000 11436 WHERE
>>>> (([Extent1].[ItemTypeDiscriminator] = 'EFDOPInputItem') AND
>>>> (CASE WHEN ([Extent2].[Id] IS NULL) THEN NULL ELSE '2X0X0X' END
>>>> LIKE '2X0X%')) AND (( EXISTS (SELECT
>>>> 00005068 46831.84375000 11436 1 AS [C1]
>>>> 00005069 46831.84375000 11436 FROM [Sources] AS [Extent3]
>>>> 00005070 46831.84375000 11436 INNER JOIN [Metadatas] AS
>>>> [Extent4] ON [Extent3].[Id] = [Extent4].[SourceId]
>>>> 00005071 46831.84375000 11436 WHERE
>>>> (([Extent3].[SourceTypeDiscriminator] = 'EFDOPFileSource') AND (
>>>> 00005072 46831.84375000 11436 [2026-08-27 09:07:20.1733485]
>>>> System.Data.SQLite (Log): SQLite error (9): statement aborts at
>>>> 71: interrupted; [SELECT
>>>> 00005073 46831.84375000 11436 [GroupBy1].[A1] AS [C1]
>>>> 00005074 46831.84375000 11436 FROM ( SELECT
>>>> 00005075 46831.84375000 11436 Count([Filter3].[A1]) AS [A1]
>>>> 00005076 46831.84375000 11436 FROM ( SELECT
>>>> 00005077 46831.84375000 11436 1 AS [A1]
>>>> 00005078 46831.84375000 11436 FROM (SELECT [Extent1].[Id] AS
>>>> [Id1], [Extent1].[CreationDate] AS [CreationDate],
>>>> [Extent1].[ModificationDate] AS [ModificationDate],
>>>> [Extent1].[Name] AS [Name1], [Extent1].[StoreRating] AS
>>>> [StoreRating], [Extent1].[StoreSettings] AS [StoreSettings],
>>>> [Extent1].[StoreProcessingStatus] AS [StoreProcessingStatus],
>>>> [Extent1].[Uuid] AS [Uuid1], [Extent1].[StoreOrientation] AS
>>>> [StoreOrientation], [Extent1].[StorePickOrReject] AS
>>>> [StorePickOrReject], [Extent1].[StoreMetadataVersion] AS
>>>> [StoreMetadataVersion], [Extent1].[StoreFormat] AS [StoreForm
>>>>
>>>> ... Perhaps something comming another 3rdparty application
>>>> installled on your system (:=))):
>>>>
>>>> 00005190 46887.89062500 11348 digikam.general: Resolved file
>>>> path: "E:\\Applications\\DxO\\DxO PhotoLab 8\\DxO.PhotoLab.exe"
>>>> 00005191 46887.89843750 11348 digikam.general: Resolved file
>>>> path: "E:\\Applications\\GIMP 3\\bin\\gimp-3.exe"
>>>> 00005192 46887.90625000 11348 digikam.general: Resolved file
>>>> path: "E:\\Applications\\ON1\\ON1\\ON1 Effects 2025\\ON1
>>>> Effects 2025.exe"
>>>> 00005193 46887.94921875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\DxO\\DxO PhotoLab 6\\DxO.PhotoLab.exe"
>>>> 00005194 46887.94921875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\DxO\\DxO PhotoLab 6\\DxO.PhotoLab.exe"
>>>> 00005195 46887.94921875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\DxO\\DxO PhotoLab 7\\DxO.PhotoLab.exe"
>>>> 00005196 46887.94921875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\DxO\\DxO PhotoLab 7\\DxO.PhotoLab.exe"
>>>> 00005197 46887.95703125 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\GIMP 2\\bin\\gimp-2.10.exe"
>>>> 00005198 46887.95703125 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\GIMP 2\\bin\\gimp-2.10.exe"
>>>> 00005199 46887.96093750 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\IrfanView\\i_view32.exe"
>>>> 00005200 46887.96093750 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\IrfanView\\i_view32.exe"
>>>> 00005201 46887.96093750 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\IrfanView\\i_view32.exe"
>>>> 00005202 46887.96093750 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\IrfanView\\i_view64.exe"
>>>> 00005203 46887.96093750 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\IrfanView\\i_view64.exe"
>>>> 00005204 46887.96484375 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\IrfanView\\i_view64.exe"
>>>> 00005205 46887.96875000 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\Corel\\Corel PaintShop Pro 2023
>>>> (64-bit)\\Corel PaintShop Pro.exe"
>>>> 00005206 46887.96875000 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\Corel\\Corel PaintShop Pro 2023
>>>> (64-bit)\\Corel PaintShop Pro.exe"
>>>> 00005207 46887.96875000 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\Corel\\Corel PaintShop Pro 2023
>>>> (64-bit)\\Corel PaintShop Pro.exe"
>>>> 00005208 46887.97656250 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\digiKam\\showfoto.exe"
>>>> 00005209 46887.98046875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\digiKam\\showfoto.exe"
>>>> 00005210 46887.98046875 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\digiKam\\showfoto.exe"
>>>> 00005211 46887.98437500 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\XnView\\xnview.exe"
>>>> 00005212 46887.98437500 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\XnView\\xnview.exe"
>>>> 00005213 46887.98437500 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files (x86)\\XnView\\xnview.exe"
>>>> 00005214 46887.98828125 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\XnViewMP\\xnviewmp.exe"
>>>> 00005215 46887.98828125 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\XnViewMP\\xnviewmp.exe"
>>>> 00005216 46887.98828125 11348 digikam.general: Resolved file
>>>> path: "C:\\Program Files\\XnViewMP\\xnviewmp.exe"
>>>> 00005217 46887.98828125 11348 digikam.general: Resolved file
>>>> path: "E:\\Applications\\DxO\\DxO PhotoLab 8\\DxO.PhotoLab.exe"
>>>> 00005218 46887.98828125 11348 digikam.general: Resolved file
>>>> path: "E:\\Applications\\GIMP 3\\bin\\gimp-3.exe"
>>>>
>>>> As DXO, Corel, or ON1 ???
>>> but where DK is finding those path? every applications shown int
>>> path "C:\\Program Files\" doesn't exist anymore
>>>
>>>
>>> It's the information reported by the Window API, typically stored in
>>> the registration database. Sounds like the uninstallation of these
>>> applications has been dirty done.
>>>
>>>>
>>>> And finally:
>>>>
>>>> 00082665 305921.93750000 11348 digikam.dbengine: Detected
>>>> locked database file. There is an active transaction. Waited
>>>> but giving up now.
>>>> 00082666 305921.93750000 11348 digikam.dbengine: Failure
>>>> executing query:
>>>> 00082667 305921.93750000 11348 "INSERT OR IGNORE INTO
>>>> ImageInformation ( imageid, rating, creationDate,
>>>> digitizationDate, orientation, width, height, format,
>>>> colorDepth, colorModel ) VALUES ( :0, :1, :2, :3, :4, :5, :6,
>>>> :7, :8, :9 );"
>>>> 00082668 305921.93750000 11348 Error messages: "Impossible de
>>>> récupérer la ligne" "database is locked" "5" 1
>>>> 00082669 305921.93750000 11348 Bound values:
>>>> QList(QVariant(qlonglong, 128219), QVariant(int, 1),
>>>> QVariant(QDateTime, QDateTime(2020-09-08 19:12:00.000 UTC+2
>>>> Qt::LocalTime)), QVariant(QDateTime, QDateTime(2020-09-08
>>>> 19:12:00.000 UTC+2 Qt::LocalTime)), QVariant(int, 1),
>>>> QVariant(int, 4608), QVariant(int, 3456), QVariant(QString,
>>>> "JPG"), QVariant(int, 8), QVariant(int, 5))
>>>> 00082670 305921.93750000 11348 digikam.dbengine: Error while
>>>> executing DBAction [ "changeItemInformation" ] Statement [
>>>> "INSERT OR IGNORE INTO ImageInformation ( imageid, :fieldList )
>>>> VALUES ( :id, :valueList );" ]
>>>> 00082671 305921.93750000 11348 digikam.dbengine: Database is
>>>> locked. Waited 0
>>>> 00082672 305922.03125000 11348 digikam.geoiface: ----
>>>> 00082673 305922.03125000 11348 digikam.geoiface: ----
>>>> 00082674 305922.03125000 11348 digikam.dbengine: Database is
>>>> locked. Waited 9750
>>>> 00082675 305922.06250000 11348 digikam.geoiface: ----
>>>> 00082676 305922.06250000 11348 digikam.geoiface: ----
>>>> 00082677 305922.18750000 11348 digikam.geoiface: ----
>>>> 00082678 305922.18750000 11348 digikam.geoiface: ----
>>>> 00082679 305922.21875000 11348 digikam.dbengine: Database is
>>>> locked. Waited 250
>>>> 00082680 305922.21875000 11348 digikam.dbengine: Database is
>>>> locked. Waited 250
>>>> 00082681 305922.28125000 11348 digikam.geoiface: ----
>>>> 00082682 305922.28125000 11348 digikam.geoiface: ----
>>>> 00082683 305922.34375000 11348 digikam.dbengine: Database is
>>>> locked. Waited 250
>>>> 00082684 305922.43750000 11348 digikam.geoiface: ----
>>>> 00082685 305922.46875000 11348 digikam.geoiface: ----
>>>> 00082686 305922.46875000 11348 digikam.dbengine: Database is
>>>> locked. Waited 250
>>>> 00082687 305922.71875000 11348 digikam.geoiface: ----
>>>> 00082688 305922.71875000 11348 digikam.geoiface: ----
>>>> 00082689 305922.78125000 11348 digikam.geoiface: ----
>>>> 00082690 305922.78125000 11348 digikam.geoiface: ----
>>>> 00082691 305922.90625000 11348 digikam.geoiface: ----
>>>> 00082692 305922.90625000 11348 digikam.geoiface: ----
>>>> 00082693 305922.93750000 11348 digikam.dbengine: Database is
>>>> locked. Waited 500
>>>> 00082694 305923.06250000 11348 digikam.geoiface: ----
>>>> 00082695 305923.06250000 11348 digikam.geoiface: ----
>>>> 00082696 305923.06250000 11348 digikam.dbengine: Database is
>>>> locked. Waited 750
>>>> 00082697 305923.18750000 11348 digikam.geoiface: ----
>>>> 00082698 305923.18750000 11348 digikam.geoiface: ----
>>>> 00082699 305923.18750000 11348 digikam.dbengine: Database is
>>>> locked. Waited 10000
>>>> 00082700 305923.21875000 11348 digikam.dbengine: Detected
>>>> locked database file. There is an active transaction. Waited
>>>> but giving up now.
>>>> 00082701 305923.21875000 11348 digikam.dbengine: Failure
>>>> executing query:
>>>> 00082702 305923.21875000 11348 "INSERT OR IGNORE INTO
>>>> ImageInformation ( imageid, rating, creationDate,
>>>> digitizationDate, orientation, width, height, format,
>>>> colorDepth, colorModel ) VALUES ( :0, :1, :2, :3, :4, :5, :6,
>>>> :7, :8, :9 );"
>>>> 00082703 305923.21875000 11348 Error messages: "Impossible de
>>>> récupérer la ligne" "database is locked" "5" 1
>>>> 00082704 305923.21875000 11348 Bound values:
>>>> QList(QVariant(qlonglong, 349804), QVariant(int, 1),
>>>> QVariant(QDateTime, QDateTime(2024-04-25 19:13:18.000 UTC+2
>>>> Qt::LocalTime)), QVariant(QDateTime, QDateTime(2024-04-25
>>>> 19:13:18.000 UTC+2 Qt::LocalTime)), QVariant(int, 1),
>>>> QVariant(int, 5464), QVariant(int, 3640), QVariant(QString,
>>>> "JPG"), QVariant(int, 8), QVariant(int, 5))
>>>> 00082705 305923.21875000 11348 digikam.dbengine: Error while
>>>> executing DBAction [ "changeItemInformation" ] Statement [
>>>> "INSERT OR IGNORE INTO ImageInformation ( imageid, :fieldList )
>>>> VALUES ( :id, :valueList );" ]
>>>> 00082706 305923.21875000 11348 digikam.dbengine: Database is
>>>> locked. Waited 0
>>>> 00082707 305923.25000000 11348 digikam.dbengine: Database is
>>>> locked. Waited 500
>>>> 00082708 305923.37500000 11348 digikam.dbengine: Database is
>>>> locked. Waited 250
>>>> 00082709 305923.46875000 11348 digikam.dbengine: Database is
>>>> locked. Waited 10000
>>>> 00082710 305923.50000000 11348 digikam.dbengine: Detected
>>>> locked database file. There is an active transaction. Waited
>>>> but giving up now.
>>>> 00082711 305923.50000000 11348 digikam.dbengine: Failure
>>>> executing query:
>>>> 00082712 305923.50000000 11348 "DELETE FROM ImagePositions
>>>> WHERE imageid=:0;"
>>>> 00082713 305923.50000000 11348 Error messages: "Impossible de
>>>> récupérer la ligne" "database is locked" "5" 1
>>>> 00082714 305923.50000000 11348 Bound values:
>>>> QList(QVariant(qlonglong, 149838))
>>>> 00082715 305923.50000000 11348 digikam.dbengine: Database is
>>>> locked. Waited 0
>>>> 00082716 305923.53125000 11348 digikam.dbengine: Database is
>>>> locked. Waited 500
>>>> 00082717 305923.56250000 11348 digikam.dbengine: Database is
>>>> locked. Waited 500
>>>> 00082718 305923.59375000 11348 digikam.dbengine: Database is
>>>> locked. Waited 500
>>>>
>>>> Why is the database locked here? Perhaps a file descriptor open
>>>> take rights on the sqlite files and block access to digiKam, or
>>>> something like that. The AV ?
>>> seems the reason of freezing, as this never end.
>>> Using Defender
>>>
>>>
>>> Defender is a pain on Windows. I remember the VLC team's post one
>>> week ago about the time latency to open MP3 files for playing, due
>>> to the AV lock.
>>>
>>> https://pcmasterinsider.com/vlc-windows-11-microsoft-defender-startup-delay/
>>>
>>> Windows is definitely so far to be used safety for a production
>>> usages (this is my viewpoint, i'm using Linux and macOS)
>>>
>>> Best regards
>>>
>>> Gilles Caulier
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260901/ce4f481b/attachment-0001.htm>
More information about the Digikam-users
mailing list