org.springframework.dao.DataIntegrityViolationException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> org.apache.openjpa.persistence.EntityExistsException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]

syncope-user | ernst Developer | 4 years ago
  1. 0

    Error while starting Syncope with an empty database

    syncope-user | 4 years ago | ernst Developer
    org.springframework.dao.DataIntegrityViolationException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> org.apache.openjpa.persistence.EntityExistsException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]
  2. 0

    usage-session: 08ed2676-af7f-4e32-80c7-6b17c216dc41 stack-trace-digest: BE2B7EF071D48BEEB167A2BC08A162B7FEC0FE0F sakai-version: 2.4 service-version: [r32731-r3583] app-server: vula2b user-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5 browser-id: Win-Mozilla IP: 41.240.23.187 request-path: /portal/tool/ae65ba26-0b66-4a89-80f2-9b16350f41f0/assignmentDetails time: 22-Jul-2007 14:21:35 stack trace: org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:63) caused by: org.sakaiproject.tool.api.ToolException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1099) caused by: javax.servlet.ServletException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) caused by: javax.faces.el.EvaluationException: Exception while invoking expression #{assignmentDetailsBean.processUpdateScores} at javax.faces.component.UICommand.broadcast(UICommand.java:89) caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.sakaiproject.tool.gradebook.AssignmentGradeRecord]; SQL [insert into GB_GRADE_RECORD_T (VERSION, GRADABLE_OBJECT_ID, STUDENT_ID, GRADER_ID, DATE_RECORDED, POINTS_EARNED, OBJECT_TYPE_ID) values (?, ?, ?, ?, ?, ?, 1)]; Duplicate entry '1910-40c3ad2c-28aa-4d2a-8063-3d903518857d' for key 2; nested exception is java.sql.SQLException: Duplicate entry '1910-40c3ad2c-28aa-4d2a-8063-3d903518857d' for key 2 at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) caused by: java.sql.SQLException: Duplicate entry '1910-40c3ad2c-28aa-4d2a-8063-3d903518857d' for key 2 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:3026) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1968) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:502) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:494) at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:490) at sun.reflect.GeneratedMethodAccessor437.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1205) at $Proxy1.saveOrUpdate(null:-1) at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl$6.doInHibernate(GradebookManagerHibernateImpl.java:614) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334) at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.updateAssignmentGradeRecords(GradebookManagerHibernateImpl.java:641) at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.updateAssignmentGradeRecords(GradebookManagerHibernateImpl.java:1790) at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.updateAssignmentGradesAndComments(GradebookManagerHibernateImpl.java:710) at sun.reflect.GeneratedMethodAccessor7487.invoke(null:-1) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy71.updateAssignmentGradesAndComments(null:-1) at org.sakaiproject.tool.gradebook.ui.AssignmentDetailsBean.saveScores(AssignmentDetailsBean.java:366) at org.sakaiproject.tool.gradebook.ui.AssignmentDetailsBean.processUpdateScores(AssignmentDetailsBean.java:357) 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:585) at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132) at javax.faces.component.UICommand.broadcast(UICommand.java:89) at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32) at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:555) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.tool.gradebook.ui.RoleFilter.doFilter(RoleFilter.java:139) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.sakaiproject.jsf.util.JsfTool.dispatch(JsfTool.java:221) at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:441) at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1099) at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:163) at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:86) at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:63) at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:942) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:592) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:595)

    Sakai JIRA | 9 years ago | Stephen Marquard
    org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.sakaiproject.tool.gradebook.AssignmentGradeRecord]; SQL [insert into GB_GRADE_RECORD_T (VERSION, GRADABLE_OBJECT_ID, STUDENT_ID, GRADER_ID, DATE_RECORDED, POINTS_EARNED, OBJECT_TYPE_ID) values (?, ?, ?, ?, ?, ?, 1)]; Duplicate entry '1910-40c3ad2c-28aa-4d2a-8063-3d903518857d' for key 2; nested exception is java.sql.SQLException: Duplicate entry '1910-40c3ad2c-28aa-4d2a-8063-3d903518857d' for key 2
  3. 0

    I've followed all the instructions to the letter on http://confluence.atlassian.com/display/CONFEXT/Scripting+and+External+Content+Macros, including installing every single jar plugin and option idenfied in the instructions. However, starting confluence shows the scripting plugin to be disabled, with the following errors: There were errors loading this plugin. There is more information in the logs. groovy Macro to execute a groovy script into a Confluence page Error: There was a problem loading the descriptor for module 'macro' in plugin 'Scripting Plugin' jython Macro to execute a Jython script into a Confluence page xslt Macro to transfer a Xml into confluence page by XSLT sql Macro to execute Sql Statements producing a table. I have the following java errors in my catalina.out file: 2006-05-02 14:03:41,336 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] createModuleDescriptor There were problems loading the module 'macro'. The module and its plugin have been disabled. 2006-05-02 14:03:41,339 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] createModuleDescriptor There was a problem loading the descriptor for module 'macro' in plugin 'Scripting Plugin' com.atlassian.plugin.PluginParseException: Error retrieving dependency of class: com.TAP.confluence.macros.script.GroovyMacro. Missing class: groovy/lang/Binding 2006-05-02 14:03:41,920 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] configurePlugin There were errors loading the plugin 'Scripting Plugin'. The plugin has been disabled. 2006-05-02 14:03:43,862 FATAL [atlassian.confluence.plugin.ConfluencePluginManager] onApplicationEvent Error initialising plugin manager: Duplicate plugin key found: 'com.TAP.confluence.macros.SHAI' com.atlassian.plugin.PluginParseException: Duplicate plugin key found: 'com.TAP.confluence.macros.SHAI' at com.atlassian.plugin.DefaultPluginManager.addPlugin(DefaultPluginManager.java:118) at com.atlassian.confluence.plugin.ConfluencePluginManager.addPlugin(ConfluencePluginManager.java:115) at com.atlassian.plugin.DefaultPluginManager.init(DefaultPluginManager.java:49) at com.atlassian.confluence.plugin.ConfluencePluginManager.onApplicationEvent(ConfluencePluginManager.java:62) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:68) etc... and 2006-05-02 14:07:23,424 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,424 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,429 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,429 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,431 ERROR [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2006-05-02 14:07:23,431 ERROR [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2006-05-02 14:07:23,434 ERROR [atlassian.confluence.util.XWorkTransactionInterceptor] onThrowable Invoking rollback for transaction on action '/admin/users/docreateuser.action (CreateUserAction.execute())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) etc.... and 2006-05-02 14:07:23,442 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] serviceAction Could not execute action org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) etc... Any help would be appreciated, as my team really wants the excel plugin :)

    JIRA | 5 years ago | Tom Moore
    org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I've followed all the instructions to the letter on http://confluence.atlassian.com/display/CONFEXT/Scripting+and+External+Content+Macros, including installing every single jar plugin and option idenfied in the instructions. However, starting confluence shows the scripting plugin to be disabled, with the following errors: There were errors loading this plugin. There is more information in the logs. groovy Macro to execute a groovy script into a Confluence page Error: There was a problem loading the descriptor for module 'macro' in plugin 'Scripting Plugin' jython Macro to execute a Jython script into a Confluence page xslt Macro to transfer a Xml into confluence page by XSLT sql Macro to execute Sql Statements producing a table. I have the following java errors in my catalina.out file: 2006-05-02 14:03:41,336 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] createModuleDescriptor There were problems loading the module 'macro'. The module and its plugin have been disabled. 2006-05-02 14:03:41,339 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] createModuleDescriptor There was a problem loading the descriptor for module 'macro' in plugin 'Scripting Plugin' com.atlassian.plugin.PluginParseException: Error retrieving dependency of class: com.TAP.confluence.macros.script.GroovyMacro. Missing class: groovy/lang/Binding 2006-05-02 14:03:41,920 ERROR [atlassian.plugin.loaders.AbstractXmlPluginLoader] configurePlugin There were errors loading the plugin 'Scripting Plugin'. The plugin has been disabled. 2006-05-02 14:03:43,862 FATAL [atlassian.confluence.plugin.ConfluencePluginManager] onApplicationEvent Error initialising plugin manager: Duplicate plugin key found: 'com.TAP.confluence.macros.SHAI' com.atlassian.plugin.PluginParseException: Duplicate plugin key found: 'com.TAP.confluence.macros.SHAI' at com.atlassian.plugin.DefaultPluginManager.addPlugin(DefaultPluginManager.java:118) at com.atlassian.confluence.plugin.ConfluencePluginManager.addPlugin(ConfluencePluginManager.java:115) at com.atlassian.plugin.DefaultPluginManager.init(DefaultPluginManager.java:49) at com.atlassian.confluence.plugin.ConfluencePluginManager.onApplicationEvent(ConfluencePluginManager.java:62) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:68) etc... and 2006-05-02 14:07:23,424 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,424 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,429 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,429 ERROR [sf.hibernate.util.JDBCExceptionReporter] logExceptions Duplicate entry '32769' for key 1 2006-05-02 14:07:23,431 ERROR [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2006-05-02 14:07:23,431 ERROR [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2006-05-02 14:07:23,434 ERROR [atlassian.confluence.util.XWorkTransactionInterceptor] onThrowable Invoking rollback for transaction on action '/admin/users/docreateuser.action (CreateUserAction.execute())' due to throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) etc.... and 2006-05-02 14:07:23,442 ERROR [opensymphony.webwork.dispatcher.ServletDispatcher] serviceAction Could not execute action org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) etc... Any help would be appreciated, as my team really wants the excel plugin :)

    JIRA | 5 years ago | Tom Moore
    org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '32769' for key 1 java.sql.BatchUpdateException: Duplicate entry '32769' for key 1
  6. 0

    Lets say you have a group called "Group" in confluence. Then you add a page permission via soap-api with deviating case in the group name, for example "GROUP". The page permission will be set and work correctly in that only members of "Group" can edit or view the page. However, you will not be able to make any changes to the pages permissions from the "normal" web interface. The dialog stays open and confluence log shows the following error: {code} 2014-02-10 16:21:39,738 ERROR [http-8443-120] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action -- url: /pages/setpagepermissions.action | userName: tobias.kloht | referer: https://wiki.intact-is.com/display/talent/Private+Address+Claire+TestTwo_3 org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#60851953]; SQL []; Duplicate entry '60818021-View-Uk HR' for key 'cp_unique_group'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '60818021-View-Uk HR' for key 'cp_unique_group' at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:619) at org.springframework.orm.hibernate.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:605) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:518) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) at com.atlassian.xwork.interceptors.TransactionalInvocation.commitOrRollbackTransaction(TransactionalInvocation.java:107) ... {code} In this case the Group is called "Uk HR" (lowercase k), the permission was added via soap for "UK HR" (uppercase k). As described above the error occurs when adding or removing another user or group to/from the page permissions. The database entry for GROUPNAME in CONTENT_PERM reads "UK HR" when added via soap api whereas it is "Uk HR" when added via web interface. So to summarize it seems like when adding a new entry you search for all new entries and try to add them. If the casing doesn't match exactly you think the existing entry is new. Adding this group again fails obviously because it would be a duplicate entry.

    Atlassian JIRA | 3 years ago | Tobias Kloht
    org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#60851953]; SQL []; Duplicate entry '60818021-View-Uk HR' for key 'cp_unique_group'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '60818021-View-Uk HR' for key 'cp_unique_group'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.springframework.dao.DataIntegrityViolationException

      Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]; nested exception is <openjpa-2.2.1-r422266:1396819 fatal store error> org.apache.openjpa.persistence.EntityExistsException: Duplicate entry 'schema.version' for key 1 {prepstmnt 319187494 INSERT INTO ACT_GE_PROPERTY(NAME_,VALUE_,REV_) VALUES (?,?,?)} [code=1062, state=23000]

      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean()
    2. Spring Beans
      DefaultListableBeanFactory.preInstantiateSingletons
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
      4. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
      5. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
      6. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
      7. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
      8. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:605)
      8 frames
    3. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:925)
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:472)
      2 frames
    4. Spring
      ContextLoaderListener.contextInitialized
      1. org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
      2. org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
      3. org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
      3 frames
    5. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
      2. org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
      3. org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
      4. org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
      5. org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
      6. org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
      7. org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
      8. org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
      9. org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
      10. org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
      11. org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
      12. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
      13. org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      14. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      15. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      16. org.apache.catalina.core.StandardService.start(StandardService.java:525)
      17. org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      18. org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      18 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      2 frames