Lots of errors "File with id "XXX" has not been found." #938
Description
Just updated cloud.nextcloud.com to the stable10 branch, there are a lot of these two errors repeating:
File with id "6607" has not been found.
File with id "6607" has not been found.
In the DB:
mysql> select * from oc_filecache where fileid="6607";
+--------+---------+------------------------------------------------------------------------+----------------------------------+--------+---------------------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
| fileid | storage | path | path_hash | parent | name | mimetype | mimepart | size | mtime | storage_mtime | encrypted | unencrypted_size | etag | permissions | checksum |
+--------+---------+------------------------------------------------------------------------+----------------------------------+--------+---------------------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
| 6607 | 18 | files_trashbin/files/collabora_online_slide_deck_large.ppt.d1468937873 | 11c525a3813ef569ecfda3dd83af955d | 360 | collabora_online_slide_deck_large.ppt.d1468937873 | 7 | 3 | 2996736 | 1468918311 | 1468918311 | 0 | 0 | c1d157d0c7e87a463187652dd7b7442b | 27 | |
+--------+---------+------------------------------------------------------------------------+----------------------------------+--------+---------------------------------------------------+----------+----------+---------+------------+---------------+-----------+------------------+----------------------------------+-------------+----------+
1 row in set (0.00 sec)
mysql> mysql> select * from oc_filecache where fileid="989";
+--------+---------+-----------------------------------------+----------------------------------+--------+--------------------+----------+----------+-------+------------+---------------+-----------+------------------+---------------+-------------+----------+
| fileid | storage | path | path_hash | parent | name | mimetype | mimepart | size | mtime | storage_mtime | encrypted | unencrypted_size | etag | permissions | checksum |
+--------+---------+-----------------------------------------+----------------------------------+--------+--------------------+----------+----------+-------+------------+---------------+-----------+------------------+---------------+-------------+----------+
| 989 | 14 | files_trashbin/files/Design.d1464736340 | ed66c06cf47427dcab2ad3b4c5a4b37b | 1213 | Design.d1464736340 | 2 | 1 | 75695 | 1464736306 | 1464736306 | 0 | 0 | 574e1a321c906 | 31 | |
+--------+---------+-----------------------------------------+----------------------------------+--------+--------------------+----------+----------+-------+------------+---------------+-----------+------------------+---------------+-------------+----------+
1 row in set (0.00 sec)
A find does find those however on the FS:
root@cloud:/var/www/data# find . -iname collabora_online_slide_deck_large.ppt.d1468937873
./jos/files_trashbin/files/collabora_online_slide_deck_large.ppt.d1468937873
Also the storage exists:
mysql> select * from oc_storages where numeric_id="18";
+-----------+------------+-----------+--------------+
| id | numeric_id | available | last_checked |
+-----------+------------+-----------+--------------+
| home::jos | 18 | 1 | NULL |
+-----------+------------+-----------+--------------+
1 row in set (0.00 sec)
cc @icewind1991 @schiessle Thoughts?