NEXTCloud - occ db:add-missing-indices 이슈 해결

Version : 26.0.3

 

업그레이드후 이슈 발생시 해결 

 

참고 메시지

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 "mounts_user_root_path_index" in table "oc_mounts". Please double check the installation guides ↗, and check for any errors or warnings in the log. Check the security of your Nextcloud over our security scan ↗.

 

docker 실행 환경 명령어

sudo docker exec --user www-data nextcloud php occ db:add-missing-indices

 

결과