Desktop client 3.4.0 destroys local time stamp and keeps uploading data to server

Hello
the method I have used is far from perfect.
I did query the database to get all files with invalid dates.

mysql <database name>
select path from oc_filecache where mtime <= 0;

from this I generated a script to put valid dates (but not from backup due to me wanting to be quick)

touch -c <filename reported by the query>

the hard thing is that path returned by the first query is missing the path to storage and I do not have an easy way to solve that
at the end I just trigger a scan of the files to update again the database

sudo -u www-data php <path to nextcloud>/occ files:scan
2 Likes

thank you @mgallien for this starting point. As long I understand right you reset the invalid time stamp of the the file to now… I was looking for more complex approach like restoring versions and recover the original file date

I would try to script something over the weekend - could you help me and explain where in the DB the information about file versions is stored and how the original file and it’s versions are linked together? Is there some docs about database schema available, I didn’t found anything…

Regarding the storage path, in oc_filecache there is a column storage which shows the numeric_id from oc_strorages table - both pieces allow can be combined to build full path

I didn’t have serious disruption on 3.4.0, but I did have several folders resync, when they were already up to date. This has not recurred on 3.4.1RC1, for either of the two builds posted. All run on Win10 Enterprise 2004.

I did not have any issues on 3.4.0 with server 21.0.7 without virtual files, and i do not have any with … Nextcloud-bugfix-3.4.1RC1-build-8524-unbranded.AppImage

1 Like

Can confirm this was effecting me on server 22.2.0

I tryed hard to find a universal solution to link the file damaged by the sync with valid versions and allow subsequent recovery… at the moment my sql skills only allow this summary of intermediate steps which hopefully helps others. for some really strange reason there is no clear relation (in terms of unique ID) between the files and their versions… both are listed in the oc_filecache table… the only difference is

  • real files have prefix files/
  • while versions have files_versions/ prefix and .v<unixepoch> suffix in the path column

so in my eyes the only way to detect a file and it’s version belong together is to strip files/ prefix and search for records with prefix files_versions/ and same value at the end (and strip the suffix after .v).

here I explain the procedure with one file I found with the search term @mgallien provided:

image

# relevant data from oc_filecache for files with invalid mtime
select storage,fileid,trim(LEADING 'files/' FROM path) as path,size,mtime,from_unixtime(mtime) as mtime from oc_filecache WHERE path like 'files/%' and mtime=0 and fileid=308330 \G;

this query shows one file with the id 308330 - skip the and fileid.. to see all files with invalid mtime and skip \G to see the results as table… some hints:

  • trim(LEADING ‘files/’ FROM path)
    shows the path of the original file without files/ prefix
  • from_unixtime(mtime) as mtime
    converts unix epoch to human readable time
  • path like ‘files/%’ and mtime=0
    lists regular files with invalid change time
  • and fileid=308330
    limits results to one specific file
  • \G
    makes results appear as list rather than table
# file version for specific file path collectected from above query
select storage,fileid,SUBSTRING_INDEX(trim(LEADING 'files_versions/' FROM path),'.v',1) as original_path,path,size,mtime as change_mtime,from_unixtime(mtime) as change_time,from_unixtime(SUBSTRING_INDEX(name,'.v',-1)) as original_mtime FROM oc_filecache WHERE path like CONCAT('files_versions/','Documents/PowerShell/PowerShell_Advanced_Kurs_2019/...eRequired/--Switch.txt','.v%') \G;
  • SUBSTRING_INDEX(trim(LEADING ‘files_versions/’ FROM path),’.v’,1) as original_path
    shows the raw value of path (exactly the same as path in the above query
  • from_unixtime(SUBSTRING_INDEX(name,’.v’,-1)) as original_mtime
    the suffix of the path value shows when this file version was created (mtime of the original file)
  • WHERE path like CONCAT(‘files_versions/’,‘Documents/PowerShell/PowerShell_Advanced_Kurs_2019/…eRequired/–Switch.txt’,’.v%’)
    filters the table for filename from the above query but prepernds the files_versions/ prefix and .v... suffix - in my case there is only one version but depending on how long desktop client 3.4.0 was syncing you might have multiple. I used CONCAT so you can directly feed path from the above query as middle parameter

At the moment my SQL skills are not enough to construct recovery action from this findings which is valid for different architectures but with this starting point it’s not hard script something using your preferred scripting/programming tool something which

  • builds the list of affected files using the first query
  • repeats the second query using the file paths from the first result as input and
    – collects a list of existing file versions
  • depending on your approach and skills
    – either extract correct modification dates from the versions and change the creation/modification date on the files
    – or move the version you like to the original location and recover by rinning occ files:scan
1 Like

I’m not sure if I should report results from 3.4.1 RC here on in the Github issue? (3.4.0 keep synchronizing files after upgrade · Issue #4016 · nextcloud/desktop · GitHub)

I’m using 3.4.1 RC for a few days, and I meet a problem today. I see a lot of these error messages:

XXXXXX\file.xlsx has invalid modified time reported by server. Do not save it.

Testing related problems are best to be reported directly to the bug tracker.

Installed 3.4.1 from github and run into the issue. Unfortunately, the files were deleted from Nextcloud. No data loss, since backup was available.

image

Hi, macOS user here (12.1) and nextcloud 3.4.1

I get errors like:

xxx has invalid modified time reported by server. Do not save it.

On the server, all the affected files are shown as created Jan 1 1970

me too…
Get Nexcloud client 3.4.1 and that is what i get:
image

1 Like

@jospoortvliet it’s a shame 20d after the issue was identified there is no guidance from Nextcloud GmbH how to recover from the issue… it might be no small issue to restore a private instance, but what is about small business? with 10 users, 2-3 of them affected by the issue? how should they respond to the problem?

I feel really bad customers left alone with the problem… and the only official person participating this thread is a marketing guy… kudos for @jospoortvliet and really bad mood against tech personnel who prefer to keep hidden behind the “forum firewall”

1 Like

For a possible fix take a look at the following wiki page:

2 Likes

Hi Mathieu,

I tried your shell script and I got a lot of errors from mysql query. Because some directories have single quote in name.

Moreover, the script only browses some files of the first user, it doesn’t go to the second one nor to the groupfolders.

Output error:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘écran/iOS-14.2-wallpaper-LAke-The-Cliff-Light-Mode.jpg’’ at line 2

I am also getting this “…has invalid time reported by server. Do not save it” warning for multiple files, every time I sync. That is based off a clean install of 3.4.1 (done yesterday), on a clean install of Windows 11 (done the day before).

The frustrating thing is that Nextcloud is giving me no information or guidance on what to do next. How can I save it or not save it? The error shows but I can have no further interaction with it.

2 Likes

Hi!
I’m also facing this huge issue. For me, this is a big issue, because we are now slowly implementing this in our company and I’m responsible for the project. So I really really hope this can be tackled soon!
If we can’t use the nextcloud client on windows, then we can’t use nextcloud at all!
Also the bash script didn’t give me any output at all, neither with list nor with fix argument!
Thanks!
Best regards!
Stefan

nextcloud-error
This is the error in my client. It keeps saying “invalid modification date don’t save”
Please provide a fix soon!
Thanks
Best regards!
Stefan

@stefanp2021 as you have commercial interest to fix the issue it would be great you spend little resources to help out people still affected by this issue. I think nice script could be written within 4-8 working hours…

Starting with SQL queries in my post #54 it’s possible to

  • build a list of files with invalid time stamp
  • find versions of this times with correct time stamp
  • build (a list) a command to copy/move the last valid version

running occ:filescan can remain manual task.

Hi,

@stefanp2021 if your nextlcoud setup isn’t on the same server where mysql is on. You must install a mysql client in first.

@mgallien for the single quote issues, here’s a solution:

relative_filepath_without_username="$(echo ${relative_filepath/\/$username\//} | sed "s/'/\\\'/g")"

Hi!

Nextcloud and SQL are on the same server!