Getting "javax.persistence.NonUniqueResultException": Expected single result, but got...

Details

Type: Bug
Status: Closed
Priority: Critical
Resolution: Duplicate
Affects Version/s: 2.8, 2.9
Fix Version/s: None
Component/s: None
Labels:
None
Environment:
Happens on either our Linux or Solaris 10 build servers, Maven 3.0.2, Java 1.6.0_23

Number of attachments :
0

Description

We're getting an error that's causing all projects updating to our Sonar server to throw an error. For one project, Sonar refuses to run at all; for the rest of the projects, Sonar runs but before it exits it throws this error. The error is exactly the same in both cases. We originally encountered this error while running Sonar 2.8; I upgraded to 2.9 to see if it was solved.

Full maven output:

> /tools/maven/3.0.2/bin/mvn -e -B sonar:sonar -Dmaven.repo.local=/tmp/dshea/localrepo -DbuildLifeId=304153
[INFO] Error stacktraces are turned on.
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building voice-common 01.07.01-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- sonar-maven-plugin:2.0-beta-2:sonar (default-cli) @ voice-common ---
[INFO] Sonar version: 2.9
[INFO]  Database dialect class org.sonar.jpa.dialect.Oracle
[INFO]  Initializing Hibernate
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 38.014s
[INFO] Finished at: Thu Jul 28 11:36:23 CDT 2011
[INFO] Final Memory: 14M/482M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:217)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)
        at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)
        at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)
        at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)
        at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:319)
        at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)
        at org.apache.maven.cli.MavenCli.execute(MavenCli.java:534)
        at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)
        at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)
        at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)
        at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)
        at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)
Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar
        at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:118)
        at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65)
        at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:90)
        at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:107)
        at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)
        ... 19 more
Caused by: org.picocontainer.PicoLifecycleException: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]]
        at org.picocontainer.monitors.NullComponentMonitor.lifecycleInvocationFailed(NullComponentMonitor.java:77)
        at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.monitorAndThrowReflectionLifecycleException(ReflectionLifecycleStrategy.java:132)
        at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:115)
        at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)
        at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
        at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
        at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
        at org.picocontainer.behaviors.Stored.start(Stored.java:110)
        at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:996)
        at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:989)
        at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:746)
        at org.sonar.batch.bootstrap.Module.start(Module.java:88)
        at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:96)
        at org.sonar.batch.bootstrap.Module.start(Module.java:89)
        at org.sonar.batch.Batch.execute(Batch.java:74)
        at org.sonar.maven3.SonarMojo.executeBatch(SonarMojo.java:147)
        at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:136)
        at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
        ... 23 more
Caused by: javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]]
        at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:194)
        at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:212)
        at org.sonar.batch.ProjectConfigurator.isLatestAnalysis(ProjectConfigurator.java:106)
        at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:83)
        at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:78)
        at org.sonar.batch.ProjectTree.doStart(ProjectTree.java:81)
        at org.sonar.batch.ProjectTree.start(ProjectTree.java:58)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)
        ... 38 more
[ERROR]
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]

Issue Links

duplicates

SONAR-2329 NonUniqueResultException occurs when analyzing both a maven module and its parent

Activity

Ascending order - Click to sort in descending order

Evgeny Mandrikov made changes - 28/Jul/11 12:08 PM

Field	Original Value	New Value
Description	We're getting an error that's causing all projects updating to our Sonar server to throw an error. For one project, Sonar refuses to run at all; for the rest of the projects, Sonar runs but before it exits it throws this error. The error is exactly the same in both cases. We originally encountered this error while running Sonar 2.8; I upgraded to 2.9 to see if it was solved. Full maven output: > /tools/maven/3.0.2/bin/mvn -e -B sonar:sonar -Dmaven.repo.local=/tmp/dshea/localrepo -DbuildLifeId=304153 [INFO] Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building voice-common 01.07.01-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- sonar-maven-plugin:2.0-beta-2:sonar (default-cli) @ voice-common --- [INFO] Sonar version: 2.9 [INFO] Database dialect class org.sonar.jpa.dialect.Oracle [INFO] Initializing Hibernate [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 38.014s [INFO] Finished at: Thu Jul 28 11:36:23 CDT 2011 [INFO] Final Memory: 14M/482M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] -> [Help 1] org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:217) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:319) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:534) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:118) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:90) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:107) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) ... 19 more Caused by: org.picocontainer.PicoLifecycleException: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] at org.picocontainer.monitors.NullComponentMonitor.lifecycleInvocationFailed(NullComponentMonitor.java:77) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.monitorAndThrowReflectionLifecycleException(ReflectionLifecycleStrategy.java:132) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:115) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84) at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169) at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132) at org.picocontainer.behaviors.Stored.start(Stored.java:110) at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:996) at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:989) at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:746) at org.sonar.batch.bootstrap.Module.start(Module.java:88) at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:96) at org.sonar.batch.bootstrap.Module.start(Module.java:89) at org.sonar.batch.Batch.execute(Batch.java:74) at org.sonar.maven3.SonarMojo.executeBatch(SonarMojo.java:147) at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:136) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113) ... 23 more Caused by: javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:194) at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:212) at org.sonar.batch.ProjectConfigurator.isLatestAnalysis(ProjectConfigurator.java:106) at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:83) at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:78) at org.sonar.batch.ProjectTree.doStart(ProjectTree.java:81) at org.sonar.batch.ProjectTree.start(ProjectTree.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) ... 38 more [ERROR] [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR]	We're getting an error that's causing all projects updating to our Sonar server to throw an error. For one project, Sonar refuses to run at all; for the rest of the projects, Sonar runs but before it exits it throws this error. The error is exactly the same in both cases. We originally encountered this error while running Sonar 2.8; I upgraded to 2.9 to see if it was solved. Full maven output: {noformat} > /tools/maven/3.0.2/bin/mvn -e -B sonar:sonar -Dmaven.repo.local=/tmp/dshea/localrepo -DbuildLifeId=304153 [INFO] Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building voice-common 01.07.01-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- sonar-maven-plugin:2.0-beta-2:sonar (default-cli) @ voice-common --- [INFO] Sonar version: 2.9 [INFO] Database dialect class org.sonar.jpa.dialect.Oracle [INFO] Initializing Hibernate [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 38.014s [INFO] Finished at: Thu Jul 28 11:36:23 CDT 2011 [INFO] Final Memory: 14M/482M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] -> [Help 1] org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.0-beta-2:sonar (default-cli) on project voice-common: Can not execute Sonar at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:217) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:319) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) at org.apache.maven.cli.MavenCli.execute(MavenCli.java:534) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) Caused by: org.apache.maven.plugin.MojoExecutionException: Can not execute Sonar at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:118) at org.codehaus.mojo.sonar.Bootstraper.start(Bootstraper.java:65) at org.codehaus.mojo.sonar.SonarMojo.execute(SonarMojo.java:90) at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:107) at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) ... 19 more Caused by: org.picocontainer.PicoLifecycleException: PicoLifecycleException: method 'public void org.sonar.batch.ProjectTree.start() throws java.io.IOException', instance 'org.sonar.batch.ProjectTree@3a0fbd45, javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] at org.picocontainer.monitors.NullComponentMonitor.lifecycleInvocationFailed(NullComponentMonitor.java:77) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.monitorAndThrowReflectionLifecycleException(ReflectionLifecycleStrategy.java:132) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:115) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84) at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169) at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132) at org.picocontainer.behaviors.Stored.start(Stored.java:110) at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:996) at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:989) at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:746) at org.sonar.batch.bootstrap.Module.start(Module.java:88) at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:96) at org.sonar.batch.bootstrap.Module.start(Module.java:89) at org.sonar.batch.Batch.execute(Batch.java:74) at org.sonar.maven3.SonarMojo.executeBatch(SonarMojo.java:147) at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:136) at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113) ... 23 more Caused by: javax.persistence.NonUniqueResultException: Expected single result, but got : [Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.03,version=01.08.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.03,period3Date=2011-06-27 04:03:05.03,period4Date=<null>,period5Date=<null>,id=8074478], Snapshot[resourceId=33525,createdAt=2011-07-27 04:03:05.033,version=01.07.01-SNAPSHOT,last=true,status=P,scope=PRJ,path=<null>,depth=0,qualifier=TRK,rootId=<null>,parentId=<null>,rootProjectId=33525,period1Mode=previous_analysis,period2Mode=days,period3Mode=days,period4Mode=<null>,period5Mode=<null>,period1Param=2011-07-26,period2Param=5,period3Param=30,period4Param=<null>,period5Param=<null>,period1Date=2011-07-26 04:03:54.693,period2Date=2011-07-22 04:03:05.033,period3Date=2011-06-27 04:03:05.033,period4Date=<null>,period5Date=<null>,id=8074479]] at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:194) at org.sonar.jpa.session.JpaDatabaseSession.getSingleResult(JpaDatabaseSession.java:212) at org.sonar.batch.ProjectConfigurator.isLatestAnalysis(ProjectConfigurator.java:106) at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:83) at org.sonar.batch.ProjectConfigurator.configure(ProjectConfigurator.java:78) at org.sonar.batch.ProjectTree.doStart(ProjectTree.java:81) at org.sonar.batch.ProjectTree.start(ProjectTree.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) ... 38 more [ERROR] [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] {noformat}

Hide

Permalink

Douglas Shea added a comment - 28/Jul/11 12:14 PM

Thanks for the clean-up, Evgeny.

Show

Douglas Shea added a comment - 28/Jul/11 12:14 PM Thanks for the clean-up, Evgeny.

Hide

Permalink

Freddy Mallet added a comment - 29/Jul/11 1:59 AM

Hello, you're facing issue ~~SONAR-2329~~ which should have happened during an analysis with Sonar 2.7. You must manually execute an SQL request (see comments in ~~SONAR-2329~~) to fix corrupted data in your DB.

Show

Freddy Mallet added a comment - 29/Jul/11 1:59 AM Hello, you're facing issue SONAR-2329 which should have happened during an analysis with Sonar 2.7. You must manually execute an SQL request (see comments in SONAR-2329 ) to fix corrupted data in your DB.

Freddy Mallet made changes - 29/Jul/11 1:59 AM

Link

This issue duplicates ~~SONAR-2329~~ [ ~~SONAR-2329~~ ]

Freddy Mallet made changes - 29/Jul/11 2:00 AM

Status	Open [ 1 ]	Closed [ 6 ]
Resolution		Duplicate [ 3 ]

People

Assignee:

Unassigned

Reporter:

Douglas Shea

Vote (0)

Watch (0)

Dates

Created:

28/Jul/11 11:41 AM

Updated:

29/Jul/11 2:00 AM

Resolved:

29/Jul/11 2:00 AM