We recently migrated our enterprise sonarqube app to AWS, After the migration of DB , we started our application, but re-indexing haven’t started immediately, We have to stop the sonar , delete es7 folder and restart sonar, then it started re-indexing for DB.
1- How can we make sure indexing is start after application is deployed ? We first migrated Db then stated the app.
2- Also my Db guy requested me to use currentSchema to point to public , jdbc_url: “jdbc:postgresql://.amazonaws.com:5432/sonar?currentSchema=public” , we use public as our schema, does this fix the re-indexing ?
3- How can I automate Re-Indexing , should I add “deleting es7 folder” task in ansible playbook to automate this or there is any api call to do this ?