Exceptions thrown by Insight when starting tc Server

[Dalla]

For some reason, Insight keeps throwing exceptions everytime I startup my tc Server. Looks like it´s trying to purge old data or something, but without succeding.
I´m using STS
Version: 2.7.0.RELEASE
Build Id: 201107041000

tc Server is Developer Edition 2.5

Any ideas? Please ask if you want me to provide additional info.

Here´s the exception:

2011-jul-12 10:25:09 com.springsource.insight.tcserver.WeavingHelper findRepositoriesForClassPath
INFO: file:/C:/Program/springsource/vfabric-tc-server-developer-2.5.0.RELEASE/spring-insight-instance/insight/collection-plugins/insight-collection-1.5.0.RELEASE.jar: aspects will be woven into the main Tomcat classloader
2011-jul-12 10:25:09 com.springsource.insight.tcserver.WeavingHelper findRepositoriesForClassPath
INFO: file:/C:/Program/springsource/vfabric-tc-server-developer-2.5.0.RELEASE/spring-insight-instance/insight/collection-plugins/insight-plugin-jdbc-1.5.0.RELEASE.jar: aspects will be woven into the main Tomcat classloader
2011-jul-12 10:25:09 com.springsource.insight.tcserver.WeavingHelper findRepositoriesForClassPath
INFO: file:/C:/Program/springsource/vfabric-tc-server-developer-2.5.0.RELEASE/spring-insight-instance/insight/collection-plugins/insight-plugin-tomcat-1.5.0.RELEASE.jar: aspects will be woven into the main Tomcat classloader
ASPECTJ: aspectj.overweaving=true: overweaving switched ON
2011-jul-12 10:25:10 com.springsource.tcserver.security.PropertyDecoder <init>
INFO: tc Runtime property decoder using memory-based key
2011-jul-12 10:25:10 com.springsource.tcserver.security.PropertyDecoder <init>
INFO: tcServer Runtime property decoder has been initialized in 213 ms
2011-jul-12 10:25:22 org.apache.coyote.AbstractProtocolHandler init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
2011-jul-12 10:25:23 com.springsource.tcserver.serviceability.rmi.JmxSocketListener init
INFO: Started up JMX registry on 127.0.0.1:6969 in 130 ms
2011-jul-12 10:25:23 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 12960 ms
2011-jul-12 10:25:23 org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
2011-jul-12 10:25:23 org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: SpringSource tc Runtime 2.5.0.RELEASE/7.0.12.A.RELEASE
2011-jul-12 10:25:23 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor insight.xml from C:\Program\springsource\vfabric-tc-server-developer-2.5.0.RELEASE\spring-insight-instance\conf\Catalina\localhost
2011-jul-12 10:25:23 com.springsource.insight.collection.tcserver.ltw.TomcatWeavingInsightClassLoader start
INFO: Context [localhost|insight] will not be woven
2011-jul-12 10:25:23 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2011-jul-12 10:25:34 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'Spring MVC Dispatcher Servlet'
Exception in thread "purgeThread" org.springframework.dao.DataIntegrityViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#193]; SQL [delete from resources where id=? and version=?]; constraint ["FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#193]
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:102)
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:471)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy51.purgeResources(Unknown Source)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeResources(PurgeServiceImpl.java:145)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeData(PurgeServiceImpl.java:121)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeExpiredData(PurgeServiceImpl.java:87)
	at com.springsource.insight.repo.purge.PurgeServiceImpl$2.run(PurgeServiceImpl.java:177)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
	at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.ConstraintViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#193]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2710)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2893)
	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467)
	... 14 more
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
	at org.h2.message.DbException.get(DbException.java:167)
	at org.h2.message.DbException.get(DbException.java:144)
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:382)
	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:399)
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
	at org.h2.table.Table.fireConstraints(Table.java:812)
	at org.h2.table.Table.fireAfterRow(Table.java:829)
	at org.h2.command.dml.Delete.update(Delete.java:80)
	at org.h2.command.CommandContainer.update(CommandContainer.java:69)
	at org.h2.command.Command.executeUpdate(Command.java:201)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2692)
	... 26 more

[Gr3y]

Have the same problem, and I'm a newbie, so I'm not sure how to fix it.
How to recreate:
- Installed a fresh copy of the latest STS.
- New Spring Template Project.
- Choose MVC.
- Drag project to tc server.
- Run project (say yes to server "insights").

Error occours.

[mj85910101]

Hi

Does this forum monitored by any admins? Anyone found the fix, please post it here.

I am getting the same errors. Using the followings:

sts-2.7.1.RELEASE
vfabric-tc-server-developer-2.5.0.RELEASE
MS SQL Server 2008 Express Server
sqljdbc4.jar


Jul 24, 2011 10:34:44 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Exception in thread "purgeThread" org.springframework.dao.DataIntegrityViolationExce ption: could not delete: [com.springsource.insight.repo.resource.persist.Per sistedApplicationResource#69]; SQL [delete from resources where id=? and version=?]; constraint ["FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]]; nested exception is org.hibernate.exception.ConstraintViolationExcepti on: could not delete: [com.springsource.insight.repo.resource.persist.Per sistedApplicationResource#69]
at org.springframework.orm.hibernate3.SessionFactoryU tils.convertHibernateAccessException(SessionFactor yUtils.java:637)
at org.springframework.orm.jpa.vendor.HibernateJpaDia lect.translateExceptionIfPossible(HibernateJpaDial ect.java:102)
at org.springframework.orm.jpa.JpaTransactionManager. doCommit(JpaTransactionManager.java:471)
at org.springframework.transaction.support.AbstractPl atformTransactionManager.processCommit(AbstractPla tformTransactionManager.java:754)
at org.springframework.transaction.support.AbstractPl atformTransactionManager.commit(AbstractPlatformTr ansactionManager.java:723)
at org.springframework.transaction.interceptor.Transa ctionAspectSupport.commitTransactionAfterReturning (TransactionAspectSupport.java:393)
at org.springframework.transaction.interceptor.Transa ctionInterceptor.invoke(TransactionInterceptor.jav a:120)
at org.springframework.aop.framework.ReflectiveMethod Invocation.proceed(ReflectiveMethodInvocation.java :172)
at org.springframework.aop.framework.JdkDynamicAopPro xy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy75.purgeResources(Unknown Source)
at com.springsource.insight.repo.purge.PurgeServiceIm pl.purgeResources(PurgeServiceImpl.java:145)
at com.springsource.insight.repo.purge.PurgeServiceIm pl.purgeData(PurgeServiceImpl.java:121)
at com.springsource.insight.repo.purge.PurgeServiceIm pl.purgeExpiredData(PurgeServiceImpl.java:87)
at com.springsource.insight.repo.purge.PurgeServiceIm pl$2.run(PurgeServiceImpl.java:177)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not delete: [com.springsource.insight.repo.resource.persist.Per sistedApplicationResource#69]
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersi ster.delete(AbstractEntityPersister.java:2710)
at org.hibernate.persister.entity.AbstractEntityPersi ster.delete(AbstractEntityPersister.java:2893)
at org.hibernate.action.EntityDeleteAction.execute(En tityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQue ue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:189)
at org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:321)
at org.hibernate.event.def.DefaultFlushEventListener. onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.j ava:1216)
at org.hibernate.impl.SessionImpl.managedFlush(Sessio nImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(J DBCTransaction.java:133)
at org.hibernate.ejb.TransactionImpl.commit(Transacti onImpl.java:76)
at org.springframework.orm.jpa.JpaTransactionManager. doCommit(JpaTransactionManager.java:467)
... 14 more
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]
at org.h2.message.DbException.getJdbcSQLException(DbE xception.java:327)
at org.h2.message.DbException.get(DbException.java:16 7)
at org.h2.message.DbException.get(DbException.java:14 4)
at org.h2.constraint.ConstraintReferential.checkRow(C onstraintReferential.java:382)
at org.h2.constraint.ConstraintReferential.checkRowRe fTable(ConstraintReferential.java:399)
at org.h2.constraint.ConstraintReferential.checkRow(C onstraintReferential.java:275)
at org.h2.table.Table.fireConstraints(Table.java:812)
at org.h2.table.Table.fireAfterRow(Table.java:829)
at org.h2.command.dml.Delete.update(Delete.java:80)
at org.h2.command.CommandContainer.update(CommandCont ainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java: 201)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInt ernal(JdbcPreparedStatement.java:143)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(Jd bcPreparedStatement.java:129)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 02)
at org.hibernate.persister.entity.AbstractEntityPersi ster.delete(AbstractEntityPersister.java:2692)

Thanks,
MJ

[Gr3y]

Found a fix here:
http://forum.springsource.org/showth...rtup-exception

Hope it works for you as well.

[mj85910101]

@Gr3y: It worked. Thanks.

[jbbarquero]

I have the same error, and the FIX only worked because I obviate the spring-insight when creating the new template (I used only base and bio)

Is there any solution for this issue?

In the meantime, is there any way to see the embedded H2 database?

Thanks in advance.

[jtravis]

Strange.

Insight has not used H2 for storing Resources for quite some time. Can you check the page served up by localhost:8080/insight and tell me the version on the footer?

[jbbarquero]

Hello,

Thank you very much for your help. As requested:

"Spring Insight 1.5.0.RELEASE (20110415) | Copyright © 2009-2011 SpringSource, a division of VMware, Inc. | All Rights Reserved."

Further information: I'm using a custom Server Runtime Environment, using as installation directory [STS_HOME]\springsource-2.7.1\vfabric-tc-server-developer-2.5.0.RELEASE and as JRE an IBM RAD 7 (it's a Java SE 5) for a tomcat 6.

Here it's the stack trace:

INFORMACIàN: Initializing Spring root WebApplicationContext
Exception in thread "purgeThread" org.springframework.dao.DataIntegrityViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#7]; SQL [delete from resources where id=? and version=?]; constraint ["FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#7]
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:102)
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:471)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy50.purgeResources(Unknown Source)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeResources(PurgeServiceImpl.java:145)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeData(PurgeServiceImpl.java:121)
	at com.springsource.insight.repo.purge.PurgeServiceImpl.purgeExpiredData(PurgeServiceImpl.java:87)
	at com.springsource.insight.repo.purge.PurgeServiceImpl$2.run(PurgeServiceImpl.java:177)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
	at java.lang.Thread.run(Thread.java:810)
Caused by: org.hibernate.exception.ConstraintViolationException: could not delete: [com.springsource.insight.repo.resource.persist.PersistedApplicationResource#7]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2710)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2893)
	at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:189)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467)
	... 14 more
Caused by: org.h2.jdbc.JdbcSQLException: Violación de una restricción de Integridad Referencial: "FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"
Referential integrity constraint violation: "FK_RESOURCES_APPLICATION: PUBLIC.RESOURCES FOREIGN KEY(APPLICATION) REFERENCES PUBLIC.RESOURCES(ID)"; SQL statement:
delete from resources where id=? and version=? [23003-147]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
	at org.h2.message.DbException.get(DbException.java:167)
	at org.h2.message.DbException.get(DbException.java:144)
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:382)
	at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:399)
	at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:275)
	at org.h2.table.Table.fireConstraints(Table.java:812)
	at org.h2.table.Table.fireAfterRow(Table.java:829)
	at org.h2.command.dml.Delete.update(Delete.java:80)
	at org.h2.command.CommandContainer.update(CommandContainer.java:69)
	at org.h2.command.Command.executeUpdate(Command.java:201)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
	at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
	at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2692)
	... 26 more
08-sep-2011 11:36:04 org.apache.catalina.core.ApplicationContext log

[jtravis]

This is fixed in Insight 1.5.1 (which is available probably next week with the big vFabric release). Resources are no longer stored in H2, but are stored in Gemfire.

Expect an announcement regarding the new tc Server Developer Edition next week or so.

[jbbarquero]

Thank you very much for your help.

Will the version 2.8.0 of STS include this new release of Insight?

Regards.