After an update to version 19.0.4 some data is missing in the web UI.
There are missing around 400GB of data if I look into the users dataspace.
If I take a look into the folders there is data without any calculated space on the disk.
All this files take over 2GB discspace each. So I think it’s a problem with big files.
Accessing the files via SMB still work. But via the web UI or webdav the files seem to be corrupted.
After the update to 19.0.4 NC asked to refresh some database tables… so I did.
Any ideas how to get them back or repair the database?
What exactly did NC ask and what action did you take?
What was NC version before updating?
If you used nc-update-nextcloud to upgrade to 19.0.4 there will be a backup created in same dir ncdata is stored, /ncp-update-backups/ from which you can restore to a previous database and NC.
Output of ncp-report could possibly be useful.
It asked for:
sudo -u www-data php occ db:add-missing-columns
and
sudo -u www-data php occ db:add-missing-indices
the report seems to be too long to post here… what could be useful of it so I can post those parts.
Can use pastebin.com or similar and just post link here.
You did not say what was NC version before updating?
This is the report: https://pastebin.com/XKjMedN2
I came from version 18…? I don’t know exactly.
I had to perform two updates in a row to get to 19.0.4.
For testing I uploaded a new file vie SMB with about 3GB of size.
The upload worked and it showes up in the web UI.
But the file’s size has also been not calculated.