So, now it gets stuck on ScalarInt64 and Vacuuming database… if the connection gets lost I can restart the TrayIcon and it connects, but also starts whole process again.
Now I would like to just delete the remote backup files (external HDD) and try to create the backup from scratch, because maybe it gets stuck because of lack of space?
But I can’t because Duplicati won’t respond to stop requests. (and I am afraid I would fuck up the database if I just formatted the backup disk outright)
Did anyone got through something similar?
If I look into Profiling level of log it keeps doing ExecuteScalarInt64
Mar 26, 2025 11:07 AM: Starting - ExecuteNonQuery: VACUUM
Mar 26, 2025 11:07 AM: ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("Vacuum", 1742983620); SELECT last_insert_rowid(); took 0:00:00:00.364
Mar 26, 2025 11:07 AM: Starting - ExecuteScalarInt64: INSERT INTO "Operation" ("Description", "Timestamp") VALUES ("Vacuum", 1742983620); SELECT last_insert_rowid();
Mar 26, 2025 11:07 AM: ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < 1740391620 took 0:00:00:00.000
Mar 26, 2025 11:07 AM: Starting - ExecuteNonQuery: DELETE FROM "RemoteOperation" WHERE "Timestamp" < 1740391620
Mar 26, 2025 11:07 AM: ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < 1740391620 took 0:00:00:00.000
Mar 26, 2025 11:07 AM: Starting - ExecuteNonQuery: DELETE FROM "LogData" WHERE "Timestamp" < 1740391620
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = "Blocks" AND "State" IN ("Uploaded", "Verified") took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = "Blocks" AND "State" IN ("Uploaded", "Verified")
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = "Index" AND "State" IN ("Uploaded", "Verified") took 0:00:00:00.004
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "Type" = "Index" AND "State" IN ("Uploaded", "Verified")
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "A"."VolumeID", "A"."Name", "A"."Size", "A"."Hash", "A"."VerificationCount" FROM (SELECT "ID" AS "VolumeID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "State" IN ("Uploaded", "Verified")) A, "Fileset" WHERE "A"."VolumeID" = "Fileset"."VolumeID" ORDER BY "Fileset"."Timestamp" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "A"."VolumeID", "A"."Name", "A"."Size", "A"."Hash", "A"."VerificationCount" FROM (SELECT "ID" AS "VolumeID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE "State" IN ("Uploaded", "Verified")) A, "Fileset" WHERE "A"."VolumeID" = "Fileset"."VolumeID" ORDER BY "Fileset"."Timestamp"
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT MAX("VerificationCount") FROM "RemoteVolume" took 0:00:00:00.012
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT MAX("VerificationCount") FROM "RemoteVolume"
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE ("State" = "Verified" OR "State" = "Uploaded") AND ("Hash" = '' OR "Hash" IS NULL OR "Size" <= 0) took 0:00:00:00.016
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Name", "Size", "Hash", "VerificationCount" FROM "Remotevolume" WHERE ("State" = "Verified" OR "State" = "Uploaded") AND ("Hash" = '' OR "Hash" IS NULL OR "Size" <= 0)
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
Mar 26, 2025 11:06 AM: RemoteOperationTerminate took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - RemoteOperationTerminate
Mar 26, 2025 11:06 AM: AfterBackupVerify took 0:00:00:01.231
Mar 26, 2025 11:06 AM: keeping protected incomplete remote file listed as Temporary: duplicati-20250326T100422Z.dlist.zip.aes
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ('Deleted', 'Deleting')) AND NOT "State" IN ('Deleted', 'Deleting') took 0:00:00:00.010
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ('Deleted', 'Deleting')) AND NOT "State" IN ('Deleted', 'Deleting')
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
Mar 26, 2025 11:06 AM: RemoteOperationList took 0:00:00:00.256
Mar 26, 2025 11:06 AM: Backend event: List - Completed: (74,55 KB)
Mar 26, 2025 11:06 AM: Backend event: List - Started: ()
Mar 26, 2025 11:06 AM: Starting - RemoteOperationList
Mar 26, 2025 11:06 AM: Starting - AfterBackupVerify
Mar 26, 2025 11:06 AM: CommitFinalizingBackup took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - CommitFinalizingBackup
Mar 26, 2025 11:06 AM: CommitAfterUpload took 0:00:00:00.513
Mar 26, 2025 11:06 AM: Starting - CommitAfterUpload
Mar 26, 2025 11:06 AM: VerifyConsistency took 0:00:00:12.903
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "FileLookup" WHERE "BlocksetID" != -100 AND "BlocksetID" != -200 AND NOT "BlocksetID" IN (SELECT "ID" FROM "Blockset") took 0:00:00:00.391
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "FileLookup" WHERE "BlocksetID" != -100 AND "BlocksetID" != -200 AND NOT "BlocksetID" IN (SELECT "ID" FROM "Blockset")
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Blockset" WHERE "Length" > 0 AND "ID" NOT IN (SELECT "BlocksetId" FROM "BlocksetEntry") took 0:00:00:00.977
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Blockset" WHERE "Length" > 0 AND "ID" NOT IN (SELECT "BlocksetId" FROM "BlocksetEntry")
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT * FROM (SELECT "N"."BlocksetID", (("N"."BlockCount" + 3200 - 1) / 3200) AS "BlocklistHashCountExpected", CASE WHEN "G"."BlocklistHashCount" IS NULL THEN 0 ELSE "G"."BlocklistHashCount" END AS "BlocklistHashCountActual" FROM (SELECT "BlocksetID", COUNT(*) AS "BlockCount" FROM "BlocksetEntry" GROUP BY "BlocksetID") "N" LEFT OUTER JOIN (SELECT "BlocksetID", COUNT(*) AS "BlocklistHashCount" FROM "BlocklistHash" GROUP BY "BlocksetID") "G" ON "N"."BlocksetID" = "G"."BlocksetID" WHERE "N"."BlockCount" > 1) WHERE "BlocklistHashCountExpected" != "BlocklistHashCountActual") took 0:00:00:02.530
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM (SELECT * FROM (SELECT "N"."BlocksetID", (("N"."BlockCount" + 3200 - 1) / 3200) AS "BlocklistHashCountExpected", CASE WHEN "G"."BlocklistHashCount" IS NULL THEN 0 ELSE "G"."BlocklistHashCount" END AS "BlocklistHashCountActual" FROM (SELECT "BlocksetID", COUNT(*) AS "BlockCount" FROM "BlocksetEntry" GROUP BY "BlocksetID") "N" LEFT OUTER JOIN (SELECT "BlocksetID", COUNT(*) AS "BlocklistHashCount" FROM "BlocklistHash" GROUP BY "BlocksetID") "G" ON "N"."BlocksetID" = "G"."BlocksetID" WHERE "N"."BlockCount" > 1) WHERE "BlocklistHashCountExpected" != "BlocklistHashCountActual")
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT Count(*) FROM (SELECT DISTINCT "BlocksetID", "Index" FROM "BlocklistHash") took 0:00:00:00.010
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT Count(*) FROM (SELECT DISTINCT "BlocksetID", "Index" FROM "BlocklistHash")
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT Count(*) FROM "BlocklistHash" took 0:00:00:00.002
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT Count(*) FROM "BlocklistHash"
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "CalcLen", "Length", "A"."BlocksetID", "File"."Path" FROM ( SELECT "A"."ID" AS "BlocksetID", IFNULL("B"."CalcLen", 0) AS "CalcLen", "A"."Length" FROM "Blockset" A LEFT OUTER JOIN ( SELECT "BlocksetEntry"."BlocksetID", SUM("Block"."Size") AS "CalcLen" FROM "BlocksetEntry" LEFT OUTER JOIN "Block" ON "Block"."ID" = "BlocksetEntry"."BlockID" GROUP BY "BlocksetEntry"."BlocksetID" ) B ON "A"."ID" = "B"."BlocksetID" ) A, "File" WHERE "A"."BlocksetID" = "File"."BlocksetID" AND "A"."CalcLen" != "A"."Length" took 0:00:00:08.990
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "CalcLen", "Length", "A"."BlocksetID", "File"."Path" FROM ( SELECT "A"."ID" AS "BlocksetID", IFNULL("B"."CalcLen", 0) AS "CalcLen", "A"."Length" FROM "Blockset" A LEFT OUTER JOIN ( SELECT "BlocksetEntry"."BlocksetID", SUM("Block"."Size") AS "CalcLen" FROM "BlocksetEntry" LEFT OUTER JOIN "Block" ON "Block"."ID" = "BlocksetEntry"."BlockID" GROUP BY "BlocksetEntry"."BlocksetID" ) B ON "A"."ID" = "B"."BlocksetID" ) A, "File" WHERE "A"."BlocksetID" = "File"."BlocksetID" AND "A"."CalcLen" != "A"."Length"
Mar 26, 2025 11:06 AM: Starting - VerifyConsistency
Mar 26, 2025 11:06 AM: Including source path: C:\Program Files (x86)\
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: INSERT INTO "Fileset" ("OperationID", "Timestamp", "VolumeID", "IsFullBackup") VALUES (155, 1742983462, 80397, 0); SELECT last_insert_rowid(); took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: INSERT INTO "Fileset" ("OperationID", "Timestamp", "VolumeID", "IsFullBackup") VALUES (155, 1742983462, 80397, 0); SELECT last_insert_rowid();
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: INSERT INTO "Remotevolume" ("OperationID", "Name", "Type", "State", "Size", "VerificationCount", "DeleteGraceTime") VALUES (155, "duplicati-20250326T100422Z.dlist.zip.aes", "Files", "Temporary", -1, 0, 0); SELECT last_insert_rowid(); took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: INSERT INTO "Remotevolume" ("OperationID", "Name", "Type", "State", "Size", "VerificationCount", "DeleteGraceTime") VALUES (155, "duplicati-20250326T100422Z.dlist.zip.aes", "Files", "Temporary", -1, 0, 0); SELECT last_insert_rowid();
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT "ID" FROM "Remotevolume" WHERE "Name" = "duplicati-20250326T100422Z.dlist.zip.aes" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT "ID" FROM "Remotevolume" WHERE "Name" = "duplicati-20250326T100422Z.dlist.zip.aes"
Mar 26, 2025 11:06 AM: ExecuteScalarInt64: SELECT "ID" FROM "Remotevolume" WHERE "Name" = "duplicati-20250326T100422Z.dlist.zip.aes" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteScalarInt64: SELECT "ID" FROM "Remotevolume" WHERE "Name" = "duplicati-20250326T100422Z.dlist.zip.aes"
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "Name" FROM "RemoteVolume" WHERE "Type" = "Blocks" AND NOT "ID" IN (SELECT "BlockVolumeID" FROM "IndexBlockLink") AND "State" IN ("Uploaded","Verified") took 0:00:00:00.035
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "Name" FROM "RemoteVolume" WHERE "Type" = "Blocks" AND NOT "ID" IN (SELECT "BlockVolumeID" FROM "IndexBlockLink") AND "State" IN ("Uploaded","Verified")
Mar 26, 2025 11:06 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
Mar 26, 2025 11:06 AM: PreBackupVerify took 0:00:02:22.455
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "DelMetadataFilesetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "DelMetadataFilesetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7"
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7"
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7"
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7"
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7"
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM Fileset WHERE Fileset.ID IN (SELECT DISTINCT FilesetID FROM "DelMetadataFilesetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7") AND Fileset.ID NOT IN (SELECT DISTINCT FilesetID FROM FilesetEntry) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM Fileset WHERE Fileset.ID IN (SELECT DISTINCT FilesetID FROM "DelMetadataFilesetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7") AND Fileset.ID NOT IN (SELECT DISTINCT FilesetID FROM FilesetEntry)
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM Fileset WHERE VolumeID IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM Fileset WHERE VolumeID IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM FilesetEntry WHERE FilesetID IN (SELECT ID FROM Fileset WHERE VolumeID IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM FilesetEntry WHERE FilesetID IN (SELECT ID FROM Fileset WHERE VolumeID IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ))
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "ChangeJournalData" WHERE "FilesetID" IN (SELECT "ID" FROM "Fileset" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "ChangeJournalData" WHERE "FilesetID" IN (SELECT "ID" FROM "Fileset" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ))
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "DeletedBlock" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.024
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "DeletedBlock" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "Block" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "Block" WHERE "VolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "IndexBlockLink" WHERE "BlockVolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) OR "IndexVolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.004
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "IndexBlockLink" WHERE "BlockVolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) OR "IndexVolumeID" IN (SELECT "ID" FROM "DelVolSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "BlocklistHash" WHERE "BlocklistHash"."BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "BlocklistHash" WHERE "BlocklistHash"."BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "BlocksetEntry" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "BlocksetEntry" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "Blockset" WHERE "ID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "Blockset" WHERE "ID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "FileLookup" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "FileLookup" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
Mar 26, 2025 11:06 AM: ExecuteNonQuery: DELETE FROM "Metadataset" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" ) took 0:00:00:00.000
Mar 26, 2025 11:06 AM: Starting - ExecuteNonQuery: DELETE FROM "Metadataset" WHERE "BlocksetID" IN (SELECT DISTINCT "ID" FROM "DelBlockSetIds-C24A9CE5A0EE0D4D8DD4265BFD8B8CE7" )
----The rest of the log is deleted because of post character limit----