Skip to content

Instantly share code, notes, and snippets.

@nnako
Created March 15, 2022 11:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nnako/42e98264885f79247473b2844ad034ac to your computer and use it in GitHub Desktop.
Save nnako/42e98264885f79247473b2844ad034ac to your computer and use it in GitHub Desktop.
logfile for issue "synchronization conflicts after deactivation of Virtual Files"
...
2022-03-15 09:25:27:729 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -1345576334460704565
2022-03-15 09:25:27:729 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT path, inode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentchecksumtype.name || ':' || contentChecksum, e2eMangledName, isE2eEncrypted FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE parent_hash(path) = ?1 ORDER BY path||'/' ASC"
2022-03-15 09:25:27:729 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:362 ]: Processing "03 - BERUF/Hanno/2021_2022__Klint/Deutsch Jutta/DE_b41e14f3-1d1a-4e23-a50b-79d8e0536c20.pdf" | valid: true/true/db | mtime: 1647326973/1647326973/0 | size: 19383/19383/0 | etag: "5a48c2df2ea6b5ba7a273ba5497c0cd3"//"" | checksum: "SHA1:40f65334f837ce7f9faca8d1037766a13635026b"//"" | perm: "WDNVR"//"" | fileid: "00206943ocwn0g3teaag"//"" | inode: 1499070/1499070/ | type: CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile | e2ee: false/false | e2eeMangledName: ""/""
2022-03-15 09:25:27:729 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:1368 ]: Discovered "03 - BERUF/Hanno/2021_2022__Klint/Deutsch Jutta/DE_b41e14f3-1d1a-4e23-a50b-79d8e0536c20.pdf" CSyncEnums::CSYNC_INSTRUCTION_NONE OCC::SyncFileItem::None CSyncEnums::ItemTypeFile
...
2022-03-15 09:25:41:462 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "_TXT/_status (conflicted copy 2022-03-14 050114).ini"
2022-03-15 09:25:41:462 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT lastTryEtag, lastTryModtime, retrycount, errorstring, lastTryTime, ignoreDuration, renameTarget, errorCategory, requestId FROM blacklist WHERE path=?1 COLLATE NOCASE"
2022-03-15 09:25:41:462 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:362 ]: Processing "_TXT/_status.ini" | valid: true/true/db | mtime: 1647316859/1647316859/0 | size: 42731/42731/0 | etag: "20af29a81019a568fd378b4fd900c96b"//"" | checksum: "SHA1:5ba8c7e8e028073c5ff8a9260d6115ab83fbdd76"//"" | perm: "WDNVR"//"" | fileid: "00073151ocwn0g3teaag"//"" | inode: 514681/514681/ | type: CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile | e2ee: false/false | e2eeMangledName: ""/""
2022-03-15 09:25:41:462 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:1368 ]: Discovered "_TXT/_status.ini" CSyncEnums::CSYNC_INSTRUCTION_NONE OCC::SyncFileItem::None CSyncEnums::ItemTypeFile
2022-03-15 09:25:41:462 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:362 ]: Processing "_TXT/_sync.ini" | valid: true/true/db | mtime: 1609072739/1609072739/0 | size: 210/210/0 | etag: "7f9b1033593e77655ab85ee0954b15b2"//"" | checksum: "SHA1:77fbf616e8e138a9d0becb5dffd976d9154384ce</checksum>"//"" | perm: "WDNVR"//"" | fileid: "00073152ocwn0g3teaag"//"" | inode: 120518/120518/ | type: CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile/CSyncEnums::ItemTypeFile | e2ee: false/false | e2eeMangledName: ""/""
2022-03-15 09:25:41:463 [ info sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\discovery.cpp:1368 ]: Discovered "_TXT/_sync.ini" CSyncEnums::CSYNC_INSTRUCTION_NONE OCC::SyncFileItem::None CSyncEnums::ItemTypeFile
...
2022-03-15 09:25:42:612 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4452747264688330138
2022-03-15 09:25:42:612 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT path, inode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentchecksumtype.name || ':' || contentChecksum, e2eMangledName, isE2eEncrypted FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"
2022-03-15 09:25:42:613 [ info nextcloud.sync.engine C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\syncengine.cpp:687 ]: #### Reconcile (aboutToPropagate OK) #################################################### 16207 ms
2022-03-15 09:25:42:613 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\syncjournaldb.cpp:2439 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit "post treewalk" and starting new transaction
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT tmpfile, etag, errorcount, path FROM downloadinfo"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\syncjournaldb.cpp:1451 ] [ OCC::deleteBatch ]: Removing stale "downloadinfo" entries: "03 - BERUF/Hanno/2021_2022__Klint/Deutsch Jutta/DE_b41e14f3-1d1a-4e23-a50b-79d8e0536c20.pdf, _TXT/_status.ini"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "03 - BERUF/Hanno/2021_2022__Klint/Deutsch Jutta/DE_b41e14f3-1d1a-4e23-a50b-79d8e0536c20.pdf"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "DELETE FROM downloadinfo WHERE path=?1"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:328 ] [ OCC::SqlQuery::exec ]: Last exec affected 1 rows.
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "_TXT/_status.ini"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "DELETE FROM downloadinfo WHERE path=?1"
2022-03-15 09:25:42:614 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:328 ] [ OCC::SqlQuery::exec ]: Last exec affected 1 rows.
2022-03-15 09:25:42:614 [ info nextcloud.sync.engine C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\syncengine.cpp:226 ]: Deleting stale temporary file: "C:/Users/pkohn/_NEXTCLOUD/03 - BERUF/Hanno/2021_2022__Klint/Deutsch Jutta/.DE_b41e14f3-1d1a-4e23-a50b-79d8e0536c20.pdf.~1c02"
2022-03-15 09:25:42:614 [ info nextcloud.sync.engine C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\syncengine.cpp:226 ]: Deleting stale temporary file: "C:/Users/pkohn/_NEXTCLOUD/_TXT/._status.ini.~4b5d"
2022-03-15 09:25:42:615 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT path,transferid FROM uploadinfo"
2022-03-15 09:25:42:615 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT path FROM blacklist"
2022-03-15 09:25:42:616 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\syncjournaldb.cpp:2439 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit "post stale entry removal" and starting new transaction
2022-03-15 09:25:42:616 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -307082639377373306
2022-03-15 09:25:42:616 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec "SELECT path, inode, modtime, type, md5, fileid, remotePerm, filesize, ignoredChildrenRemote, contentchecksumtype.name || ':' || contentChecksum, e2eMangledName, isE2eEncrypted FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"
2022-03-15 09:25:42:616 [ debug nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\owncloudpropagator.cpp:892 ] [ OCC::OwncloudPropagator::removeFromBulkUploadBlackList ]: black list for bulk upload "_TOOLS/_AutoHotKey"
2022-03-15 09:25:42:617 [ info nextcloud.sync.engine C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\libsync\syncengine.cpp:741 ]: #### Post-Reconcile end #################################################### 16211 ms
2022-03-15 09:25:42:617 [ info nextcloud.gui.folder C:\Users\sysadmin\AppData\Local\Temp\2\windows-8634\client-building\desktop\src\gui\folder.cpp:957 ]: #### Propagation start ####################################################
...
@nnako
Copy link
Author

nnako commented Mar 15, 2022

please see highlighting description within issue text...

nextcloud/desktop#4350

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment