Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
5 of 8 tasks
geeklihui opened this issue Mar 31, 2022 · 22 comments
Open
5 of 8 tasks

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

geeklihui opened this issue Mar 31, 2022 · 22 comments

Comments

@geeklihui
Copy link

geeklihui commented Mar 31, 2022

⚠️ 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?

  • Default internal user-backend
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

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

This comment was marked as off-topic.

@rajendradewani
Copy link

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
Copy link

jvalskis commented Jul 7, 2022

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
Copy link

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
Copy link

rajendradewani commented Sep 16, 2022

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
Copy link

D1StrX commented Oct 5, 2022

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
Copy link
Member

Do you still have this issue with 3.8.1?

@GAPPSRefusenik
Copy link

GAPPSRefusenik commented May 20, 2023

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
Copy link

D1StrX commented Jun 8, 2023

Can confirm, the issue still exists in 3.8.2

image

@HEtchevers
Copy link

HEtchevers commented Aug 3, 2023

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

This comment was marked as duplicate.

@Ed1ks
Copy link

Ed1ks commented Sep 21, 2023

Same error after updating to 3.10

@koelle25
Copy link

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
Copy link

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
Copy link

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
Copy link

paramazo commented Mar 11, 2024

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
Copy link

aiso-net commented Apr 9, 2024

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

This comment was marked as duplicate.

@bMorgan01

This comment was marked as duplicate.

@paddelboot
Copy link

This issue has suddenly appeared for me too,

image

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

@Medius7
Copy link

Medius7 commented Oct 24, 2024

I activated the virtual file support; then, I got these messages. From the windows notification i knew, that over 20,000 files are affected.
Image

Has anyone an idea, how to fix it?

@mmitech
Copy link

mmitech commented Oct 30, 2024

Having the same issue here as well

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

No branches or pull requests