Automatically run occ db:add-missing-indices

[strugee]

Warning from the admin overview page:

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster. Missing optional index "tables_columns_t_id" in table "tables_columns". Missing optional index "tables_row_sleeves_t_id" in table "tables_row_sleeves". Missing optional index "tables_tables_ownership" in table "tables_tables".

On my personal instance, these have never taken that long (on the order of minutes, if not seconds). I have several million files.

[strugee]

Hmm. Apparently this is supposed to already work?

osl-nextcloud/resources/osl_nextcloud.rb

Line 229 in 28663f8

php occ db:add-missing-indices

[ramereth]

@strugee yeah, that should get run when an upgrade happens

[strugee]

Funky. Seems to have not worked on the last upgrade.

[ramereth]

@strugee do you recall when the last upgrade happened? I can take a look at the log and see.