How to Debug "Analysis report XXXXX is missing in databse"?

Version info:
Sonarqube Version 7.9.2
Postgresql cluster Version 10.11
Scanner Version Maven-sonar-Plugin 3.6.0

Problem:
I tried to scan my project and it successfully committed task to my sonarqube server.
But the task failed after 188ms,and,i can only get error messeage “Analysis report XXXXX is missing in database”.

Try:
I try to find some information from my database,and i get some information in table ce_activity,but i cant get something useful.
So,What can i do if i want to find out what’s wrong with my server? I have no idea how to debug that.Please give me some help

Some information about my database:
i have a pgsql cluster with 3 nodes on 3 different servers.And,I use pgpool-II to achieve load balance. Pgsql cluser is running in replication mode and pgpool-II is running in master-slave mode.I only turn on the native replication.

Looks like you might have several SonarQube instances connected to the same DB.

Thanks for your reply.
I try to change my pg cluster from asynchronous to synchronous,and this problem was solved.
But,i have another problem.

Here is log information by sonar server:

Log Infomation:

org.sonar.ce.task.projectanalysis.component.VisitException: Visit of Component {key=NRCS_nrcs-busi-cps_feature_58646,uuid=AWzxB8c2yZooBLmDKKro,type=PROJECT} failed
at org.sonar.ce.task.projectanalysis.component.VisitException.rethrowOrWrap(VisitException.java:44)
at org.sonar.ce.task.projectanalysis.component.DepthTraversalTypeAwareCrawler.visit(DepthTraversalTypeAwareCrawler.java:41)
at org.sonar.ce.task.projectanalysis.step.PersistAnalysisStep.execute(PersistAnalysisStep.java:63)
at org.sonar.ce.task.step.ComputationStepExecutor.executeStep(ComputationStepExecutor.java:81)
at org.sonar.ce.task.step.ComputationStepExecutor.executeSteps(ComputationStepExecutor.java:72)
at org.sonar.ce.task.step.ComputationStepExecutor.execute(ComputationStepExecutor.java:59)
at org.sonar.ce.task.projectanalysis.taskprocessor.ReportTaskProcessor.process(ReportTaskProcessor.java:81)
at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.executeTask(CeWorkerImpl.java:209)
at org.sonar.ce.taskprocessor.CeWorkerImpl$ExecuteTask.run(CeWorkerImpl.java:191)
at org.sonar.ce.taskprocessor.CeWorkerImpl.findAndProcessTask(CeWorkerImpl.java:158)
at org.sonar.ce.taskprocessor.CeWorkerImpl$TrackRunningState.get(CeWorkerImpl.java:133)
at org.sonar.ce.taskprocessor.CeWorkerImpl.call(CeWorkerImpl.java:85)
at org.sonar.ce.taskprocessor.CeWorkerImpl.call(CeWorkerImpl.java:53)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error updatin

Some try:

I dont know how to fix it.It occurs sometimes.I try to use single database,not cluster.But the problem is still there.Any ideas?

Hi,

For a new question, please open a new thread. And please include the entire stacktrace.

 
Ann

Hi,Ann
Thanks for you reply.I will follow your advise.Thank you again.