Having indexing issues

  • 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 index “preferences_app_key” in table “oc_preferences”.

I’m unsure how to sudo to this on nextbox to add the missing index’s, does anyone have the code?

Sorry for anyone who doesn’t speak german, the answer was in the forum. It’s this code.

sudo - s
docker exec -it -u www-data nextbox-compose_app_1 /var/www/html/occ db:add-missing-indices

@khj where do I enter this? I have the same issue and haven’t found anything helpful to mz level of knowledge regarding console access. Do I have to ssh? Nitrokey says that then I loose the official support for my nextbox.
Perhaps someone from their team @daringer has a short hint? (I found the hint to occ in the faq, but this would mean I have to ssh on the nextbox, correct?) could I turn off ssh afterwards again (haven’t looked into setting up ssh access yet, so the question might be stupid). in general I like the idea of having Nitrokey taking care of updates etc.

Hi,
you are right, you have to ssh into the box to input the command.
As i understood, they say they can’t support you, for any things (eg mistakes) you do, when you ssh into your nextbox. But they don’t say that you loose any official support, if you have ever connected with ssh. But this is my personal interpretation, i am not related to nitrokey (only as a customer).
But i would prefer a button from the web interface to handle such things, too. Then i don’t have to ssh into the box as a user.