Sonar

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

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical 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

Bug - A problem which impairs or prevents the functions of the product. SONAR-2329 NonUniqueResultException occurs when analyzing both a maven module and its parent

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Douglas Shea added a comment -

Thanks for the clean-up, Evgeny.

Show
Douglas Shea added a comment - Thanks for the clean-up, Evgeny.
Hide
Permalink
Freddy Mallet added a comment -

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 - 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.

People

  • Assignee:
    Unassigned
    Reporter:
    Douglas Shea
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: