Insight throwing errors in STS

[matsientst]

I'm getting this error when my app runs for a few minutes.
Insight bascially starts failing left and right. Here are a few stacktraces.
Any ideas would be greatly appreciated.

org.hibernate.AssertionFailure: null id in com.springsource.insight.repo.resource.persist.PersistedApplicationEndPointResource entry (don't flush the Session after an exception occurs)
	at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:82)
	at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:190)
	at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:147)
	at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219)
	at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99)
	at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:58)
	at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1175)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1251)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)


2011-04-12 08:49:14,194 ERROR [com.springsource.insight.command.CommandServiceImpl][traceCreatingExecutor-1] - Unknown command, Increment[key=insight:Application="localhost|ThisOrThat",Server="dashboard",name="com.tot.web.controller.AbstractViewTotController#show(HttpServletRequest,Integer,Integer,String,User,CookieIdentifier,LinkedList,Integer,HttpSession,LinkedList,HttpServletResponse,Model)",type=Application.Server.EndPoint:tag:satisfied, val=range=[Tue Apr 12 08:49:13 MDT 2011 -> Tue Apr 12 08:49:14 MDT 2011], count=1.0]
2011-04-12 08:49:14,195 WARN  [com.springsource.insight.dashboard.ExecutorTraceCreator][traceCreatingExecutor-1] - Unable to create trace
org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction marked as rollbackOnly
	at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:476)
	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:374)
	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)

[jtravis]

Interesting. Is that the first error you get?

[matsientst]

Actually I left it running overnight and here is a more robust message:

Apr 12, 2011 3:27:01 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 52710 ms
 INFO [2011-04-12 15:27:04,111] [TP-Processor3] (BlockedIpInterceptor.java:26) - Requesting:/pt/404 from IP:127.0.0.1
2011-04-12 15:27:04,216 WARN  [org.hibernate.util.JDBCExceptionReporter][traceCreatingExecutor-1] - SQL Error: 90005, SQLState: 90005
2011-04-12 15:27:04,216 ERROR [org.hibernate.util.JDBCExceptionReporter][traceCreatingExecutor-1] - Value too long for column "KEY VARCHAR(255)": "'insight:Application=""localhost|ThisOrThat"",name=""com.tot.web.controller.AbstractViewTotController#show(HttpServletRequest,Integ... (262)"; SQL statement:
insert into resources (id, key, label, version, application, dtype) values (null, ?, ?, ?, ?, 5) [90005-136]
2011-04-12 15:27:04,229 ERROR [com.springsource.insight.command.CommandServiceImpl][traceCreatingExecutor-1] - Unable to execute command normally, unable to retry command:SyncResource[ApplicationEndPointResource[key=insight:Application="localhost|ThisOrThat",name="com.tot.web.controller.AbstractViewTotController#show(HttpServletRequest,Integer,Integer,String,User,CookieIdentifier,LinkedList,Integer,HttpSession,LinkedList,HttpServletResponse,Model)",type=Application.EndPoint,  lbl=AbstractViewTotController#show]]
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.GenericJDBCException: could not insert: [com.springsource.insight.repo.resource.persist.PersistedApplicationEndPointResource]; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [com.springsource.insight.repo.resource.persist.PersistedApplicationEndPointResource]
	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:311)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:369)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy39.storeResource(Unknown Source)
	at com.springsource.insight.repo.resource.persist.PersistedResourceRepo.syncResource(PersistedResourceRepo.java:154)
	at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy40.syncResource(Unknown Source)
	at com.springsource.insight.repo.resource.command.SyncResourceProcessor.executeCommand(SyncResourceProcessor.java:37)
	at com.springsource.insight.repo.resource.command.SyncResourceProcessor.executeCommand(SyncResourceProcessor.java:23)
	at com.springsource.insight.command.AbstractProcessor.execute(AbstractProcessor.java:23)
	at com.springsource.insight.command.CommandServiceImpl.processCommand(CommandServiceImpl.java:91)
	at com.springsource.insight.command.CommandServiceImpl.processCommand(CommandServiceImpl.java:47)
	at com.springsource.insight.repo.trace.TraceReportServiceImpl.processCommands(TraceReportServiceImpl.java:61)
	at com.springsource.insight.repo.trace.TraceReportServiceImpl.processReport(TraceReportServiceImpl.java:50)
	at sun.reflect.GeneratedMethodAccessor99.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy47.processReport(Unknown Source)
	at com.springsource.insight.dashboard.ExecutorTraceCreator$CreateTraceCommand.run(ExecutorTraceCreator.java:147)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:619)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [com.springsource.insight.repo.resource.persist.PersistedApplicationEndPointResource]
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1235)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1168)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1174)
	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:674)
	at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
	at $Proxy32.persist(Unknown Source)
	at com.springsource.insight.repo.resource.persist.JpaResourceDAO.storeResource(JpaResourceDAO.java:75)
	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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
	... 37 more

Here is what I would assume is the culprit:

Value too long for column "KEY VARCHAR(255)": "'insight:Application=""localhost|ThisOrThat"",name=""com.tot.web.controller.AbstractViewTotController#show(HttpServletRequest,Integ... (262)"

Need to change that to a different data type in your db. Not sure what you're using as a datastore for insight.

[jonico]

We run into the same issue and filed https://issuetracker.springsource.com/browse/INSIGHT-38 for it.

Best, Johannes