Quantcast

Delete project by hand with purging stuff

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Delete project by hand with purging stuff

kontomen

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build 12-Sep-2012 01:50:37 Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build 12-Sep-2012 01:50:37 at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build 12-Sep-2012 01:50:37 at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build 12-Sep-2012 01:50:37 at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build 12-Sep-2012 01:50:37 at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build 12-Sep-2012 01:50:37 at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build 12-Sep-2012 01:50:37 at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build 12-Sep-2012 01:50:37 at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build 12-Sep-2012 01:50:37 ... 23 more
build 12-Sep-2012 01:50:37 Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build 12-Sep-2012 01:50:37 at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build 12-Sep-2012 01:50:37 at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build 12-Sep-2012 01:50:37 at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build 12-Sep-2012 01:50:37 at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build 12-Sep-2012 01:50:37 at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build 12-Sep-2012 01:50:37 at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build 12-Sep-2012 01:50:37 at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build 12-Sep-2012 01:50:37 at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build 12-Sep-2012 01:50:37 at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build 12-Sep-2012 01:50:37 ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Delete project by hand with purging stuff

Freddy Mallet
Hello, 

Which version of Sonar are you using ?

At the beginning of the day, do you launch all Sonar analysis at the same time ?

Kind regards,
-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 11:39 AM, kontomen <[hidden email]> wrote:

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build   12-Sep-2012 01:50:37    Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build   12-Sep-2012 01:50:37            at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build   12-Sep-2012 01:50:37            at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build   12-Sep-2012 01:50:37            ... 23 more
build   12-Sep-2012 01:50:37    Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build   12-Sep-2012 01:50:37            at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build   12-Sep-2012 01:50:37            at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build   12-Sep-2012 01:50:37            ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email



Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Delete project by hand with purging stuff

kontomen
Hello,

It's the newest Sonar 3.2. It is the same time actually, but I've already made some experiment and disable night build, then run it manually few hours later and it was the same thing. It's just the first run of a day.

BR,
kontomen



Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 12 wrz 2012, o godz. 20:44:

Hello, 

Which version of Sonar are you using ?

At the beginning of the day, do you launch all Sonar analysis at the same time ?

Kind regards,
-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 11:39 AM, kontomen <[hidden email]> wrote:

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build   12-Sep-2012 01:50:37    Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build   12-Sep-2012 01:50:37            at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build   12-Sep-2012 01:50:37            at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build   12-Sep-2012 01:50:37            ... 23 more
build   12-Sep-2012 01:50:37    Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build   12-Sep-2012 01:50:37            at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build   12-Sep-2012 01:50:37            at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build   12-Sep-2012 01:50:37            ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email




Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Delete project by hand with purging stuff

Freddy Mallet
Hello, 

I'm sorry, your Sonar DB seems indeed corrupted but I don't know how to fix it easily. 

Is starting from scratch (by dropping all tables in the Sonar DB) is a possible option ? 

Kind regards,
Freddy

-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 9:10 PM, kontomen <[hidden email]> wrote:
Hello,

It's the newest Sonar 3.2. It is the same time actually, but I've already made some experiment and disable night build, then run it manually few hours later and it was the same thing. It's just the first run of a day.

BR,
kontomen



Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 12 wrz 2012, o godz. 20:44:

Hello, 

Which version of Sonar are you using ?

At the beginning of the day, do you launch all Sonar analysis at the same time ?

Kind regards,
-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 11:39 AM, kontomen <[hidden email]> wrote:

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build   12-Sep-2012 01:50:37    Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build   12-Sep-2012 01:50:37            at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build   12-Sep-2012 01:50:37            at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build   12-Sep-2012 01:50:37            ... 23 more
build   12-Sep-2012 01:50:37    Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build   12-Sep-2012 01:50:37            at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build   12-Sep-2012 01:50:37            at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build   12-Sep-2012 01:50:37            ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email





Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Delete project by hand with purging stuff

kontomen
Unfortunately, it's not. I need this historical data. Maybe you know Sonar source code quite better than me and know what exactly he is looking for, according to stacktrace I've pasted.

Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 14 wrz 2012, o godz. 14:38:

Hello, 

I'm sorry, your Sonar DB seems indeed corrupted but I don't know how to fix it easily. 

Is starting from scratch (by dropping all tables in the Sonar DB) is a possible option ? 

Kind regards,
Freddy

-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 9:10 PM, kontomen <[hidden email]> wrote:
Hello,

It's the newest Sonar 3.2. It is the same time actually, but I've already made some experiment and disable night build, then run it manually few hours later and it was the same thing. It's just the first run of a day.

BR,
kontomen



Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 12 wrz 2012, o godz. 20:44:

Hello, 

Which version of Sonar are you using ?

At the beginning of the day, do you launch all Sonar analysis at the same time ?

Kind regards,
-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 11:39 AM, kontomen <[hidden email]> wrote:

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build   12-Sep-2012 01:50:37    Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build   12-Sep-2012 01:50:37            at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build   12-Sep-2012 01:50:37            at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build   12-Sep-2012 01:50:37            ... 23 more
build   12-Sep-2012 01:50:37    Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build   12-Sep-2012 01:50:37            at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build   12-Sep-2012 01:50:37            at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build   12-Sep-2012 01:50:37            ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email






Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Delete project by hand with purging stuff

Freddy Mallet
Hello, 

Could you just check that you don't have the maven key (groupid/artifactid) : "com.example.store:store-shard-ear" used in two different modules ?

And do you confirm that on your 3 projects, you get the same exception each morning : "Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id XXX " ? 

Thanks
freddy
-----
Sonar for Continuous Inspection



On Fri, Sep 14, 2012 at 11:17 PM, kontomen <[hidden email]> wrote:
Unfortunately, it's not. I need this historical data. Maybe you know Sonar source code quite better than me and know what exactly he is looking for, according to stacktrace I've pasted.

Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 14 wrz 2012, o godz. 14:38:

Hello, 

I'm sorry, your Sonar DB seems indeed corrupted but I don't know how to fix it easily. 

Is starting from scratch (by dropping all tables in the Sonar DB) is a possible option ? 

Kind regards,
Freddy

-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 9:10 PM, kontomen <[hidden email]> wrote:
Hello,

It's the newest Sonar 3.2. It is the same time actually, but I've already made some experiment and disable night build, then run it manually few hours later and it was the same thing. It's just the first run of a day.

BR,
kontomen



Wiadomość napisana przez Freddy Mallet <[hidden email]> w dniu 12 wrz 2012, o godz. 20:44:

Hello, 

Which version of Sonar are you using ?

At the beginning of the day, do you launch all Sonar analysis at the same time ?

Kind regards,
-----
Sonar for Continuous Inspection



On Wed, Sep 12, 2012 at 11:39 AM, kontomen <[hidden email]> wrote:

Hi, everyone! Some time ago I was trying to delete one of our projects in Sonar since we don't need its reports anymore. For some reason, Sonar was unable to do so itself. So I removed the projects in the DB and all its entities (snapshots, measure_data) guesing actually what to remove since there is no foreign keys in the schema. Probably I removed a little bit too much because since then I have in 3 our projects exceptions like this while doing FIRST report every day:

build   12-Sep-2012 01:50:37    Caused by: org.sonar.api.utils.SonarException: Fail to decorate 'org.sonar.api.resources.Project@4a03e0b5[id=21669,key=com.example.store:store-shard-ear:trunk,qualifier=BRC]'
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:84)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.decorateResource(DecoratorsExecutor.java:70)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.execute(DecoratorsExecutor.java:55)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.Phases.execute(Phases.java:94)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.ProjectModule.doStart(ProjectModule.java:139)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:131)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.analyze(BatchModule.java:126)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BatchModule.doStart(BatchModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.BootstrapModule.doStart(BootstrapModule.java:121)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrap.Module.start(Module.java:83)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.startBatch(Batch.java:73)
build   12-Sep-2012 01:50:37            at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:60)
build   12-Sep-2012 01:50:37            at org.sonar.maven3.SonarMojo.execute(SonarMojo.java:142)
build   12-Sep-2012 01:50:37            at org.codehaus.mojo.sonar.Bootstraper.executeMojo(Bootstraper.java:113)
build   12-Sep-2012 01:50:37            ... 23 more
build   12-Sep-2012 01:50:37    Caused by: javax.persistence.EntityNotFoundException: Unable to find org.sonar.api.database.model.Snapshot with id 786957
build   12-Sep-2012 01:50:37            at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:113)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
build   12-Sep-2012 01:50:37            at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
build   12-Sep-2012 01:50:37            at org.sonar.api.database.model.Snapshot_$$_javassist_11.setPeriodMode(Snapshot_$$_javassist_11.java)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.persistConfiguration(TimeMachineConfigurationPersister.java:58)
build   12-Sep-2012 01:50:37            at org.sonar.plugins.core.timemachine.TimeMachineConfigurationPersister.decorate(TimeMachineConfigurationPersister.java:50)
build   12-Sep-2012 01:50:37            at org.sonar.batch.phases.DecoratorsExecutor.executeDecorator(DecoratorsExecutor.java:79)
build   12-Sep-2012 01:50:37            ... 38 more

If I rerun such build on CI server it's OK then until first build next day. I tried few time to remove rows in other tables that reference to such unexistent Snapshots but it doesn't help. There are new such rows next day. Can you help me with this?

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email







Loading...