[Bug]: VirtualFiles move image file from one folder to another does not work

seymourwang commented 1 week ago

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

[X] This is a bug, not a question or a configuration issue.
[X] This issue is not already reported on Github (I've searched it).
[X] Nextcloud Server and Desktop Client are up to date. See Server Maintenance and Release Schedule and Desktop Releases for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct

Bug description

On windows 10 connecting to the server using virtual files, move an image file from one folder to another won't work before the file is downloaded since the last modified time is missing. The file will have an invalidate date after the move. Interestingly marking the source and destination directories as alwayse available on this device does not work either. When the file is made available locally, the move is not syncronized to the server. Other devices will not see the move.

Steps to reproduce

On windows 10 connecting to the server using virtual files, put some image files (.JPG in my case) in a source folder, create a second folder. One is not able to move the files from the source folder to the destination folder (both on the server) properly regardless if the files for made available locally or not. Please check the move on the web interface or from a different device.

Expected behavior

The move should be syncronized to the server.

Which files are affected by this bug

all .JPG files

Operating system

Windows

Which version of the operating system you are running.

windows 10

Package

Distro package manager

Nextcloud Server version

29.0.2 or 28.0.6

Nextcloud Desktop Client version

3.13.0

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

Updated from a minor version (ex. 3.4.2 to 3.4.4)

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

{"reqId":"JUOoPn9pXrEi7LcWnYuz","level":0,"time":"2024-06-16T13:39:17+00:00","remoteAddr":"10.4.105.180","user":"--","app":"no app in context","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=XIR5xdYaC%2BVCw1wXsWrdWzAVk8V3nrbTWrkaEB43hgc%3D%3AC%2B4VqpV4JLUX9Tp%2F4BirGQNnwrYutd%2B%2BP%2FpsQm9i8jc%3D","message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0","version":"28.0.6.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":348,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":293,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":1244,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":458,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":431,"function":"getTypedValue","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/IntegrityCheck/Checker.php","line":415,"function":"getValueArray","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/IntegrityCheck/Checker.php","line":425,"function":"getResults","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/var/www/nextcloud/lib/private/IntegrityCheck/Checker.php","line":545,"function":"storeResults","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/var/www/nextcloud/lib/private/IntegrityCheck/Checker.php","line":556,"function":"verifyCoreSignature","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":299,"function":"runInstanceVerification","class":"OC\\IntegrityCheck\\Checker","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":129,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/core/ajax/update.php","line":193,"function":"upgrade","class":"OC\\Updater","type":"->"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":316,"message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","tables":["oc_jobs","oc_appconfig","oc_preferences","oc_addressbookchanges","oc_calendarchanges","oc_calendars","oc_properties","oc_filecache","oc_mimetypes","oc_oauth2_access_tokens","oc_oauth2_clients","oc_filecache_extended","oc_files_metadata","oc_files_metadata_index"],"reads":["oc_appconfig"],"exception":{},"CustomMessage":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1"}}
{"reqId":"JUOoPn9pXrEi7LcWnYuz","level":1,"time":"2024-06-16T13:39:19+00:00","remoteAddr":"10.4.105.180","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=XIR5xdYaC%2BVCw1wXsWrdWzAVk8V3nrbTWrkaEB43hgc%3D%3AC%2B4VqpV4JLUX9Tp%2F4BirGQNnwrYutd%2B%2BP%2FpsQm9i8jc%3D","message":"\\OC\\Updater::finishedCheckCodeIntegrity: Finished code integrity check","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0","version":"28.0.6.1","data":{"app":"updater"}}
{"reqId":"JUOoPn9pXrEi7LcWnYuz","level":1,"time":"2024-06-16T13:39:19+00:00","remoteAddr":"10.4.105.180","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=XIR5xdYaC%2BVCw1wXsWrdWzAVk8V3nrbTWrkaEB43hgc%3D%3AC%2B4VqpV4JLUX9Tp%2F4BirGQNnwrYutd%2B%2BP%2FpsQm9i8jc%3D","message":"\\OC\\Updater::updateEnd: Update successful","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0","version":"29.0.2.2","data":{"app":"updater"}}
{"reqId":"JUOoPn9pXrEi7LcWnYuz","level":1,"time":"2024-06-16T13:39:19+00:00","remoteAddr":"10.4.105.180","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=XIR5xdYaC%2BVCw1wXsWrdWzAVk8V3nrbTWrkaEB43hgc%3D%3AC%2B4VqpV4JLUX9Tp%2F4BirGQNnwrYutd%2B%2BP%2FpsQm9i8jc%3D","message":"\\OC\\Updater::maintenanceDisabled: Turned off maintenance mode","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0","version":"29.0.2.2","data":{"app":"updater"}}
{"reqId":"JUOoPn9pXrEi7LcWnYuz","level":1,"time":"2024-06-16T13:39:19+00:00","remoteAddr":"10.4.105.180","user":"--","app":"updater","method":"GET","url":"/nextcloud/core/ajax/update.php?requesttoken=XIR5xdYaC%2BVCw1wXsWrdWzAVk8V3nrbTWrkaEB43hgc%3D%3AC%2B4VqpV4JLUX9Tp%2F4BirGQNnwrYutd%2B%2BP%2FpsQm9i8jc%3D","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36 Edg/126.0.0.0","version":"29.0.2.2","data":{"app":"updater"}}
{"reqId":"ZinK7TkZuRvX3GkAJgYT","level":3,"time":"2024-06-16T13:49:19+00:00","remoteAddr":"10.4.105.180","user":"fengwang","app":"PHP","method":"POST","url":"/nextcloud/remote.php/dav/bulk","message":"Unknown: POST Content-Length of 75650416 bytes exceeds the limit of 8388608 bytes at Unknown#0","userAgent":"Mozilla/5.0 (Windows) mirall/3.13.0stable-Win64 (build 20240423) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"PHP"}}
{"reqId":"e1HOyqiMkhdbqBoPlxvw","level":3,"time":"2024-06-16T13:51:48+00:00","remoteAddr":"10.4.105.180","user":"fengwang","app":"PHP","method":"POST","url":"/nextcloud/remote.php/dav/bulk","message":"Unknown: POST Content-Length of 75650278 bytes exceeds the limit of 8388608 bytes at Unknown#0","userAgent":"Mozilla/5.0 (Windows) mirall/3.13.0stable-Win64 (build 20240423) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"29.0.2.2","data":{"app":"PHP"}}
{"reqId":"rfqHRT2u75EfigsgASjj","level":3,"time":"2024-06-16T14:31:48+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"imagecreatefromgif(): \"/storage/nextcloud/data/fengwang/files/UArk/httproot/water/enztech/images/equili8.gif\" is not a valid GIF file at /var/www/nextcloud/lib/private/legacy/OC_Image.php#680","userAgent":"--","version":"29.0.2.2","data":{"app":"PHP"}}
{"reqId":"rfqHRT2u75EfigsgASjj","level":3,"time":"2024-06-16T14:32:09+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"imagecreatefromgif(): \"/storage/nextcloud/data/fengwang/files/UArk/httproot/water/enztech/images/kineti1.gif\" is not a valid GIF file at /var/www/nextcloud/lib/private/legacy/OC_Image.php#680","userAgent":"--","version":"29.0.2.2","data":{"app":"PHP"}}
{"reqId":"rfqHRT2u75EfigsgASjj","level":2,"time":"2024-06-16T14:45:24+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Used memory grew by more than 10 MB when executing job OC\\Core\\BackgroundJobs\\GenerateMetadataJob (id: 1763477, arguments: null): 47.3 MB (before: 34.6 MB)","userAgent":"--","version":"29.0.2.2","data":{"app":"cron"}}

Additional info

the issue affects older versions of the client too. Note that debug archive too large and has to be truncated. debug.zip

PhilippSchlesinger commented 1 week ago

This is probably a duplicate of https://github.com/nextcloud/desktop/issues/6721

seymourwang commented 1 week ago

This looks similiar. However, in my case restarting the client still does not cause the moved files to be updated on the server. I have to move them out of a nextcloud folder and move them back in for them to actually sync.

PhilippSchlesinger commented 1 week ago

This looks similiar. However, in my case restarting the client still does not cause the moved files to be updated on the server. I have to move them out of a nextcloud folder and move them back in for them to actually sync.

So you might want to add that additional information to the other issue and close this one.

seymourwang commented 1 week ago

Merging this to #6721 and close this for now.

nextcloud / desktop