missing SQL-Indexes since upgrade? Looking for a nice shirt :-)))))

[kangaroo72]

Hi,

I've upgraded from 13.0.5 to 14beta3, now I've got security warnings ...
Fehlender Index "parent_index" in der Tabelle "oc_share".
Fehlender Index "fs_mtime" in der Tabelle "oc_filecache"
Can someone confirm the missing SQL-Indexes since upgrade?

Regards

[kangaroo72]

there's a hint to fix it with
ooc db:add-missing-indices (that's misspelled)
solved with
occ db:add-missing-indices

[nextcloud-bot]

GitMate.io thinks possibly related issues are #4625 (Missed sql index), #9795 (Upgrade error), #8316 (Missing styles after 12 -> 13 upgrade), #2898 (Upgrade Issue), and #8937 (*SQL table indexes for (little) performance gains).

[kangaroo72]

hmm .... happened first time 12 > 13 was no problem. Let's monitor further comments

[rullzer]

@kangaroo72 well we only started warning about this in 14 so it makes sense you only see them now 😉 .

The reason we don't add them automatically is that we don't know the size and setup people are running. Because if your installation is big enough adding them can take a long time.

So it seems the code is actually doing what it should :)

[kangaroo72]

okay - no shirt ... time to open an accessoire-shop ... roffffl