When running OCC (/var/www/nextcloud/occ), you must do it as the www-data user. For instance:
/var/www/nextcloud/occ
www-data
sudo -u www-data /usr/bin/php -f /var/www/nextcloud/occ db:add-missing-indices