nextcloud / desktop

💻 Desktop sync client for Nextcloud
https://nextcloud.com/install/#install-clients
GNU General Public License v2.0
2.99k stars 788 forks source link

[Bug]: Couldn't convert to placeholder #4401

Open geeklihui opened 2 years ago

geeklihui commented 2 years ago

⚠️ Before submitting, please verify the following: ⚠️

Bug description

I added some files on 2022-03-25 and most of them are working fine, but 564 of them have been synced repeatedly by the client over and over again.

By comparing the SHA-1 checksum with webUI and local files, I can confirm that the files have actually been synced successfully.

The process of synchronizing these files by the client is: syncing in progress, syncing error, syncing successful. Then after a while it starts syncing again: syncing in progress, syncing error, syncing successful. As shown in the figure below.

19fd3ae2341fbcb35d5ea23fa254f53 341187361649932a34c626ec0390892 4a8022da76741a233ddd56cbee2dd43

When I open the settings during the sync, I can see two prompts: one says "downloading files" and the other says "unable to upload files".

1a3e6520c49a2d0c64b93622b0ae389

In Windows Explorer, the status of these files is "Synchronization is pending". image

I have exported the logs and the database to a zip file via https://docs.nextcloud.com/desktop/3.4/troubleshooting.html#create-debug-archive. Considering privacy, please give me an email address to send logs and affected file list.

Steps to reproduce

Just open the desktop client.

Expected behavior

  1. The 564 files should not be transferred any more.
  2. The files status in Windows Explorer should be "OK" rather than "Synchronization is pending".

Which files are affected by this bug

Considering privacy, I'll provide file list and logs via email, please give me an address.

Operating system

Windows

Which version of the operating system you are running.

Windows 10

Package

Official SNAP package

Nextcloud Server version

23.0.3

Is this bug present after an update or on a fresh install?

Fresh desktop client install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

Are you using an external user-backend?

Nextcloud Server logs

Nothing special in data/nextcloud.log. I met this issue just from 2022-03-25, but the latest log is on 2022-03-06.
Nothing special in /settings/admin/logging either. Today I met this issues many times, but the latest log is on 2022-03-29.

Additional info

No response

geeklihui commented 2 years ago

Can anyone help me? It really annoyed me.

rajendradewani commented 2 years ago

We are also facing the same issue. Removing files, force sync and re-adding files did not help.

Any suggestion or workaround is appreciated.

jvalskis commented 2 years ago

Having the same issue. In my case, I added a symbolic link to sync an additional folder that is outside of /Nextcloud.

VFS is turned on. Tried turning it off like it was suggested in #3198, but then the linked folder was not synced at all.

rajendradewani commented 2 years ago

We are also facing this issue. We do not have the symbolic link. Yes, VFS is turned on.

Any suggestion or workaround is appreciated.

rajendradewani commented 2 years ago

Errors: retrieved resulted in "Can't update non existing placeholder info"

retrieved resulted in error "Can't update non existing placeholder info"

OCC::PropagateDownloadFile(0x12df66a3b50) with status OCC::SyncFileItem::NormalError and error: "Can't update non existing placeholder info"

Let us know how I can submit full logs. We have been facing these issues for months. Any help from the Nextcloud developer or community is appreciated.

2022-09-15 21:45:27:117 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -5240875010407873644

2022-09-15 21:45:27:117 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:117 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:117 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:118 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:672 ]: Item "mybackpc/video/SampleVideo001.mkv" retrieved resulted in "Can't update non existing placeholder info"

2022-09-15 21:45:27:118 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:647 ]: Item "mybackpc/video/SampleVideo001.mkv" retrieved resulted in error "Can't update non existing placeholder info"

2022-09-15 21:45:27:118 [ info nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\activitylistmodel.cpp:551 ]: Error successfully added to the notification list: "Can't update non existing placeholder info"

2022-09-15 21:45:27:149 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280

2022-09-15 21:45:27:149 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:150 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280

2022-09-15 21:45:27:151 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:153 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280 . . .

2022-09-15 21:45:27:206 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:220 [ info nextcloud.sync.propagator.root.directory C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:1282 ]: scheduleSelfOrChild OCC::PropagatorJob::Running pending uploads 0 subjobs state OCC::PropagatorJob::Running

2022-09-15 21:45:27:221 [ info nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.h:212 ]: Starting CSyncEnums::CSYNC_INSTRUCTION_SYNC propagation of "mybackpc/video/SampleVideo002.mp4" by OCC::PropagateDownloadFile(0x12df66a3b50)

2022-09-15 21:45:27:221 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:455 ] [ OCC::PropagateDownloadFile::start ]: "mybackpc/video/SampleVideo002.mp4" 0

2022-09-15 21:45:27:221 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:221 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:222 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:499 ] [ OCC::PropagateDownloadFile::startAfterIsEncryptedIsChecked ]: dehydrating file "mybackpc/video/SampleVideo002.mp4"

2022-09-15 21:45:27:222 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "mybackpc/video/SampleVideo002.mp4"

2022-09-15 21:45:27:222 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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-09-15 21:45:27:222 [ warning nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:281 ]: Could not complete propagation of "mybackpc/video/SampleVideo002.mp4" by OCC::PropagateDownloadFile(0x12df66a3b50) with status OCC::SyncFileItem::NormalError and error: "Can't update non existing placeholder info"

2022-09-15 21:45:27:223 [ debug nextcloud.sync.statustracker C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\syncfilestatustracker.cpp:274 ] [ OCC::SyncFileStatusTracker::slotItemCompleted ]: Item completed "mybackpc/video/SampleVideo002.mp4" OCC::SyncFileItem::NormalError CSyncEnums::CSYNC_INSTRUCTION_SYNC

2022-09-15 21:45:27:224 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 3721629113043059593

2022-09-15 21:45:27:224 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:224 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -5240875010407873644

2022-09-15 21:45:27:224 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:224 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:225 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:225 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:672 ]: Item "mybackpc/video/SampleVideo002.mp4" retrieved resulted in "Can't update non existing placeholder info"

2022-09-15 21:45:27:225 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:647 ]: Item "mybackpc/video/SampleVideo002.mp4" retrieved resulted in error "Can't update non existing placeholder info"

2022-09-15 21:45:27:225 [ info nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\activitylistmodel.cpp:551 ]: Error successfully added to the notification list: "Can't update non existing placeholder info"

2022-09-15 21:45:27:257 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:257 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:259 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:259 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:262 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:262 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:268 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280 . . .

2022-09-15 21:45:27:309 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -7771364040584252954

2022-09-15 21:45:27:309 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:311 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -7771364040584252954

2022-09-15 21:45:27:311 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:314 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -7771364040584252954

2022-09-15 21:45:27:314 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:361 [ info nextcloud.sync.propagator.root.directory C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:1282 ]: scheduleSelfOrChild OCC::PropagatorJob::Running pending uploads 0 subjobs state OCC::PropagatorJob::Running

2022-09-15 21:45:27:361 [ info nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.h:212 ]: Starting CSyncEnums::CSYNC_INSTRUCTION_SYNC propagation of "mybackpc/video/SampleVideo003.mp4" by OCC::PropagateDownloadFile(0x12df65f43c0)

2022-09-15 21:45:27:361 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:455 ] [ OCC::PropagateDownloadFile::start ]: "mybackpc/video/SampleVideo003.mp4" 0

2022-09-15 21:45:27:361 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:361 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:362 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:499 ] [ OCC::PropagateDownloadFile::startAfterIsEncryptedIsChecked ]: dehydrating file "mybackpc/video/SampleVideo003.mp4"

2022-09-15 21:45:27:363 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "mybackpc/video/SampleVideo003.mp4"

2022-09-15 21:45:27:363 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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-09-15 21:45:27:363 [ warning nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:281 ]: Could not complete propagation of "mybackpc/video/SampleVideo003.mp4" by OCC::PropagateDownloadFile(0x12df65f43c0) with status OCC::SyncFileItem::NormalError and error: "Can't update non existing placeholder info"

2022-09-15 21:45:27:364 [ debug nextcloud.sync.statustracker C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\syncfilestatustracker.cpp:274 ] [ OCC::SyncFileStatusTracker::slotItemCompleted ]: Item completed "mybackpc/video/SampleVideo003.mp4" OCC::SyncFileItem::NormalError CSyncEnums::CSYNC_INSTRUCTION_SYNC

2022-09-15 21:45:27:364 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 3721629113043059593

2022-09-15 21:45:27:364 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:365 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -5240875010407873644

2022-09-15 21:45:27:365 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:365 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:365 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:366 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -9075527568022715586

2022-09-15 21:45:27:366 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:366 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:672 ]: Item "mybackpc/video/SampleVideo003.mp4" retrieved resulted in "Can't update non existing placeholder info"

2022-09-15 21:45:27:366 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:647 ]: Item "mybackpc/video/SampleVideo003.mp4" retrieved resulted in error "Can't update non existing placeholder info"

2022-09-15 21:45:27:366 [ info nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\activitylistmodel.cpp:551 ]: Error successfully added to the notification list: "Can't update non existing placeholder info"

2022-09-15 21:45:27:398 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 6096808492014427509

2022-09-15 21:45:27:398 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:399 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 6096808492014427509

2022-09-15 21:45:27:399 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:401 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 6096808492014427509

2022-09-15 21:45:27:402 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:408 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:408 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:414 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:415 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:417 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 4010088648941826446

2022-09-15 21:45:27:417 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:423 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280

2022-09-15 21:45:27:423 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:425 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280

2022-09-15 21:45:27:425 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:45:27:427 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 2632796835425864280

2022-09-15 21:45:27:427 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1" ... ... ...

022-09-15 21:46:19:835 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:840 [ info nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:1229 ]: PropagateDirectory::slotSubJobsFinished emit finished OCC::SyncFileItem::NormalError

2022-09-15 21:46:19:840 [ info nextcloud.gui.folderwatcher C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\folderwatcher.cpp:187 ]: Detected changes in paths: QSet("F:/NextCloud/mybackpc/video/baskets/SamplePath001/SampleVideo004.nfo")

2022-09-15 21:46:19:840 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 7671636374960942277

2022-09-15 21:46:19:840 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:841 [ info nextcloud.gui.folder C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\folder.cpp:605 ]: Ignoring spurious notification for file "mybackpc/video/baskets/SamplePath001/SampleVideo004.nfo"

2022-09-15 21:46:19:851 [ info nextcloud.sync.propagator.root.directory C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:1282 ]: scheduleSelfOrChild OCC::PropagatorJob::Running pending uploads 0 subjobs state OCC::PropagatorJob::Running

2022-09-15 21:46:19:851 [ info nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.h:212 ]: Starting CSyncEnums::CSYNC_INSTRUCTION_SYNC propagation of "mybackpc/video archive/SampleVideo005.avi" by OCC::PropagateDownloadFile(0x12df66a3150)

2022-09-15 21:46:19:851 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:455 ] [ OCC::PropagateDownloadFile::start ]: "mybackpc/video archive/SampleVideo005.avi" 0

2022-09-15 21:46:19:851 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -4535926512151646577

2022-09-15 21:46:19:852 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:852 [ debug nextcloud.sync.propagator.download C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\propagatedownload.cpp:499 ] [ OCC::PropagateDownloadFile::startAfterIsEncryptedIsChecked ]: dehydrating file "mybackpc/video archive/SampleVideo005.avi"

2022-09-15 21:46:19:853 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 "mybackpc/video archive/SampleVideo005.avi"

2022-09-15 21:46:19:853 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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-09-15 21:46:19:883 [ warning nextcloud.sync.propagator C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\owncloudpropagator.cpp:281 ]: Could not complete propagation of "mybackpc/video archive/SampleVideo005.avi" by OCC::PropagateDownloadFile(0x12df66a3150) with status OCC::SyncFileItem::NormalError and error: "Can't update non existing placeholder info"

2022-09-15 21:46:19:884 [ debug nextcloud.sync.statustracker C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\syncfilestatustracker.cpp:274 ] [ OCC::SyncFileStatusTracker::slotItemCompleted ]: Item completed "mybackpc/video archive/SampleVideo005.avi" OCC::SyncFileItem::NormalError CSyncEnums::CSYNC_INSTRUCTION_SYNC

2022-09-15 21:46:19:884 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 3721629113043059593

2022-09-15 21:46:19:884 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:885 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -6231748910558631324

2022-09-15 21:46:19:885 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:885 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 6502369186450216133

2022-09-15 21:46:19:885 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:885 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -4535926512151646577

2022-09-15 21:46:19:886 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:886 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 -4535926512151646577

2022-09-15 21:46:19:886 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:886 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:672 ]: Item "mybackpc/video archive/SampleVideo005.avi" retrieved resulted in "Can't update non existing placeholder info"

2022-09-15 21:46:19:887 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:647 ]: Item "mybackpc/video archive/SampleVideo005.avi" retrieved resulted in error "Can't update non existing placeholder info"

2022-09-15 21:46:19:887 [ info nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\activitylistmodel.cpp:551 ]: Error successfully added to the notification list: "Can't update non existing placeholder info"

2022-09-15 21:46:19:920 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 1646002028873493648

2022-09-15 21:46:19:920 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:921 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 1646002028873493648

2022-09-15 21:46:19:921 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\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, lock, lockOwnerDisplayName, lockOwnerId, lockType, lockOwnerEditor, lockTime, lockTimeout FROM metadata LEFT JOIN checksumtype as contentchecksumtype ON metadata.contentChecksumTypeId == contentchecksumtype.id WHERE phash=?1"

2022-09-15 21:46:19:924 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 1646002028873493648 2022 2022-09- Nextcloud-2022-09-16-client Error log.txt

D1StrX commented 2 years ago

There is an additional issue with the cannot replace non-existing placeholder error. When replacing all files in a folder, when not all files are downloaded and locally available, it cannot upload/overwrite the files in the cloud. Thus not sync.

Expected behavior is to overwrite everything in the cloud that has been overwritten locally. Windows 10 - NC Dekstop client v3.6.0

camilasan commented 1 year ago

Do you still have this issue with 3.8.1?

GAPPSRefusenik commented 1 year ago

Do you still have this issue with 3.8.1?

Indeed I have. Just updated to 3.8.1. in hopes that this would have gotten resolved by now. Before this update, I reverted to 3.3.6 after a more recent version had caused the deletion of the affected 'non-placeholder' file and its parent folder. At least with 3.3.6, and now 3.8.1 no files have been deleted anymore, although I did spot the affected folder in the Nextcloud recycle bin the other day. The folder and all of its contents however remain intact on my client machines, so at the moment I can cope with the situation.

It might be of notice that the affected file is a KeePass database that is kept open for most of the time, and changed on several clients that are running simultaneously. This seems to cause irritation on the sync process. My approach to temporarily resolve the issue is to manually sync KeePass database files on all machines, and then transfer one of them to the server, overwriting the previous file.

I just noticed, on the Desktop client (Win10) it says that the affected parent folder was deleted 11 hours ago. When I go to 'Deleted Files' on Nextcloud, it does show the folder, with a time stamp 12 hours ago. Fortunately, all the files however remain intact, on the server and all client machines. With a previous version of Nextcloud, in between 3.3.6 and 3.8.1, the folder got deleted several times, until I reverted to the older version. This is very strange behavior, but at least my files won't get deleted anymore, and except this one database file everything is synced without issues.

D1StrX commented 1 year ago

Can confirm, the issue still exists in 3.8.2

image

HEtchevers commented 1 year ago

This issue STILL exists with a slightly different error message in version 3.9.1: Couldn't update placeholder info. It has happened for (nearly) all of my nearly 6000 files and they all try to synchronize constantly and fruitlessly. They seem to be present on the server though.

image

--

Follow-up: in the "activity" bar online, it lists that I have either "changed" or "created" the individual files. I have been able to upload and sync new files since, though. In refusing the client update on my office desktop so far, I do not have any of these error messages and all appears to be normally sync'd.

alexx-ftw commented 1 year ago

Having this same error

Ed1ks commented 1 year ago

Same error after updating to 3.10

koelle25 commented 10 months ago

The problem still seems to exist in Nextcloud Desktop 3.10.1 (Windows 10). I had one file where there was the error "Couldn't convert to placeholder". As a workaround I simply deleted it (it was just a software installer download) and now everything is fine again so far, but I will keep an eye on it.

MartinDerHettich commented 8 months ago

A User of my NextCloud is affected since 2023-11. No synchronisation of her local files (see screenshot), the error message 'Couldn't convert to placeholder' on the client, no error message on the server, current version Nextcloud Desktop-Client 3.11.0. Yes, we tried every obvious instance of "Have you tried turning it off and on again?".

NextCloudBug#4401_NewUserSJ2023-11_2024-01

MartinDerHettich commented 8 months ago

A remark to OP and Admins:

"5 of 8 tasks" is misleading, because checking a box right there is obviously optional:

Are you using an external user-backend?
[x] Default internal user-backend
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Answering this question should be 1 (One) task, not 4.

paramazo commented 6 months ago

Same happens here on Windows. When create a new folder in nextcloud in home and sync that folder, everything is fine. When try to sync to a local available network drive, the error Couldn't convert to placeholder is thrown.

Configure disable virtual files in nextcloud app for the synced folder fixed it for me.

aiso-net commented 5 months ago

Same issue here, but need VFS ability since the desktop doent have the needed free space, so need it to be all virtual, need this fixed ASAP.

FloTheSysadmin commented 5 months ago

Same issue here

bMorgan01 commented 3 months ago

+1 to @aiso-net. Please fix asap.

paddelboot commented 2 days ago

This issue has suddenly appeared for me too,

image

Nextcloud Desktop-Client 3.14.1 Microsoft Windows 11 Pro 10.0.22631 Build 22631