Crash at creating new group

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 1.1.1
    • Affects Version/s: 1.1
    • Component/s: None
    • Environment:

      We use the standalone version.

      Cause:
      org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Violation of unique index: SYS_PK_OS_GROUP in statement [insert into os_group (groupname, id) values ('marvin development', 4)]

      Stack Trace: [hide]

      org.springframework.dao.DataIntegrityViolationException: (HibernateAccessor): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Violation of unique index: SYS_PK_OS_GROUP in statement [insert into os_group (groupname, id) values ('marvin development', 4)]
      java.sql.SQLException: Violation of unique index: SYS_PK_OS_GROUP in statement [insert into os_group (groupname, id) values ('marvin development', 4)]
      at org.hsqldb.Trace.getError(Unknown Source)
      at org.hsqldb.jdbcResultSet.(Unknown Source)
      at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      at org.hsqldb.jdbcConnection.execute(Unknown Source)
      at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source)
      at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      at com.mchange.v2.sql.filter.FilterCallableStatement.executeUpdate(FilterCallableStatement.java:309)
      at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)
      at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382)
      at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335)
      at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1775)
      at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1536)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1501)
      at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
      at org.springframework.orm.hibernate.HibernateTemplate$19.doInHibernate(HibernateTemplate.java:352)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150)
      at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:170)
      at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:348)
      at bucket.user.persistence.dao.hibernate.BucketGroupDAO.findGroupByGroupname(BucketGroupDAO.java:40)
      at sun.reflect.GeneratedMethodAccessor315.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)
      at $Proxy2.findGroupByGroupname(Unknown Source)
      at com.opensymphony.user.provider.hibernate.HibernateAccessProvider.handles(HibernateAccessProvider.java:72)
      at bucket.user.providers.ChainedUserProvider.handles(ChainedUserProvider.java:125)
      at bucket.user.providers.CachingAccessProvider.handles(CachingAccessProvider.java:52)
      at com.opensymphony.user.UserManager.getProvider(UserManager.java:310)
      at com.opensymphony.user.UserManager.access$100(UserManager.java:33)
      at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:390)
      at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100)
      at com.opensymphony.user.Group.(Group.java:35)
      at com.opensymphony.user.UserManager.buildEntity(UserManager.java:339)
      at com.opensymphony.user.UserManager.createEntity(UserManager.java:371)
      at com.opensymphony.user.UserManager.createGroup(UserManager.java:228)
      at bucket.user.DefaultUserAccessor.addGroup(DefaultUserAccessor.java:91)
      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:324)
      at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:149)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:118)
      at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:191)
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:148)
      at $Proxy8.addGroup(Unknown Source)
      at com.atlassian.confluence.user.actions.BrowseGroupsAction.doAdd(BrowseGroupsAction.java:27)
      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:324)
      at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:301)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
      at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:73)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:124)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278)
      at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145)
      at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:146)
      at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:165)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117)
      at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30)
      at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:38)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
      at java.lang.Thread.run(Thread.java:534)

      Referer URL: http://192.168.10.50:8080/admin/users/browsegroups.action

      Build Information:
      Uptime: 4 hours, 9 minutes, 53 seconds
      Version: 1.1
      Build Number: 53

      Server Information:
      Application Server: Apache Tomcat/4.1.29
      Servlet Version: 2.3
      Database Dialect: net.sf.hibernate.dialect.HSQLDialect

      Memory Information:
      Total Memory: 127 MB
      Free Memory: 45 MB
      Used Memory: 82 MB

      System Information:
      System Date: Monday, 14 Jun 2004
      System Time: 14:40:07
      System Favourite Colour: Almond
      Java Version: 1.4.2_04
      Java Vendor: Sun Microsystems Inc.
      JVM Version: 1.0
      JVM Vendor: Sun Microsystems Inc.
      JVM Implementation Version: 1.4.2_04-b04
      Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
      Java VM: Java HotSpot(TM) Client VM
      User Name: root
      User Timezone: GMT+1
      Operating System: SunOS 5.9
      OS Architecture: sparc

      Request Logging:
      0 log statements generated by this request:

              Assignee:
              Unassigned
              Reporter:
              Marco Hermans
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: