pending synchonization at restart
Gilles Caulier
caulier.gilles at gmail.com
Sun Aug 30 10:42:02 BST 2026
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).
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)"
You really have a problem at this storage location, or the database
contents are not properly up-to-date corresponding to the collection
contents.
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 ???
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 ?
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/20260830/f1249767/attachment-0001.htm>
More information about the Digikam-users
mailing list