During update from 13.0.5 to 13.06 database error: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_filecache.fileid

Thanks.

For reference:

Before cleanup:

$ echo “.headers on
.mode csv
select name, path_hash from oc_filecache;” | sqlite3 owncloud.db | wc -l
8633

$ occ files:cleanup
15 orphaned file cache entries deleted

Files is no reduced to 8621

$ echo “.headers on      
.mode csv
select name, path_hash from oc_filecache;” | sqlite3 owncloud.db | sort | uniq -c | sort -nr | grep -v "      1" | head -10
    20 “”,d41d8cd98f00b204e9800998ecf8427e
    17 files,45b963397aa40d4a0063e0d85e4fe7a1
    17 cache,0fea6a13c52b4d4725368f24b045ca84
    10 v0.6.0,f72c70196746fc6912257146fcd84fcf
    10 lucene_index,a0c55384eae17768d8f9fe6696efed6e

Not much changed in this respect.

Will do the upgrade later this week.

Would it be possible to completely empty the file_cache table? It’s a cache after all, as such the entries will be created once accessed again, or is this not the case?