pending synchonization at restart
frederic chaume
frederic.chaume at gmail.com
Mon Aug 31 08:20:26 BST 2026
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 ?
>
> 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 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?
Also wondering why "Metadata for file "P1003747_Dx90.jpg" is written to
XMP sidecar." shouldn't use XMP for Jpeg, no?
>
> 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 ?
>
> 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.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.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
>
> 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
>
> That's all for my analysis.
>
> Best regards
>
> Gilles Caulier
>
>
> Le dim. 30 août 2026 à 09:29, frederic chaume
> <frederic.chaume at gmail.com> a écrit :
>
> Bonjour Gilles
>
> Je viens de tomber dans un cas de blocage. Voici le log associé
> (un peut gros, ca tourne depuis plusieurs jour):
> https://www.swisstransfer.com/dl/01a0518d-013a-73ca-988a-f2a3ed36b1d8
>
> Je venais de lancer une synchro sur 50 fichiers et l'avancement
> est bloqué à 96%, sans avoir le message "ne répond pas", et en
> regardant debugview, j'ai vu des error , failures, et des database
> lock.
> Du coup j'ai récupérer le log et je vais redemarrer DK
> Dans le gestionnaire de tache, DK utilise ~3% du CPU et ~700M de RAM
>
> PS: Au moment de finir le mail, le process vient de finir, mais
> j'avais déjà arreté debugview, du coup je n'ai pas la fin
>
>
> Merci et Bonne journée
> Frederic
>
>
>
>
> Le 27/08/2026 à 15:46, frederic chaume a écrit :
>> Answers inline
>>
>> Le 27/08/2026 à 14:41, Gilles Caulier a écrit :
>>>
>>>
>>> Le mer. 26 août 2026 à 19:05, frederic chaume
>>> <frederic.chaume at gmail.com> a écrit :
>>>
>>> Answers inline
>>>
>>> Le 26/08/2026 à 13:11, Gilles Caulier a écrit :
>>>>
>>>>
>>>> Le mer. 26 août 2026 à 12:55, frederic chaume
>>>> <frederic.chaume at gmail.com> a écrit :
>>>>
>>>> Thanks Gilles for your feedback.
>>>>
>>>> In the recent freezing behavior, I don't remember to
>>>> have run large batches may be up to 50 files in a
>>>> batch, but run it multiple times and I notice that
>>>> problem occurs after running more and more
>>>> synchronization. I didn't record the qty of
>>>> synchronization ran begore freezing
>>>> Not network issue as using local SSD drive , but may be
>>>> limitation with the RAM 16G which became a problem
>>>> after migration to Win11
>>>>
>>>> I didn't find where to reduce the number of album to
>>>> process, In metadata settings , I only have the flag to
>>>> set Lazy synchronization
>>>>
>>>>
>>>> Right. The lazy synchronization is a background task, using
>>>> common code from the maintenance "sync Metadata" tool
>>>> (where you can tune the album selection to process and
>>>> where you can turn on/off the multithreading).
>>> Ok, got it: multithreading is unset and album selection is
>>> set to all (4K albums), I reduced to 1K which are the most
>>> used albums. For example , currently I'm trying to update
>>> tags which where missing or inconsitent, and then I don't
>>> know what wold be consequence if I launch a synchronization
>>> involving elements not included in the selected albums?
>>>
>>>
>>> From the Maintenance tool, only the items included in the
>>> selected physical albums or virtual tags will be processed.
>> Hum, seems not easy to manage, If I correctly understand, I
>> should ensure that files I'm working on (updating tags,
>> caption,...) should be in the albums list, and also not forget to
>> add new added albums. At least the way I'm organized today
>> doesn't allow me to manage such settings.
>> nevertheless, debugview is running and will share logs if failing
>> in freeze again
>>
>>>
>>> Best regards
>>>
>>> Gilles Caulier
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260831/69b90c62/attachment-0001.htm>
More information about the Digikam-users
mailing list