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

JIRA | Tom Moore | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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

    Root Cause Analysis

    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()
    2. MySQL jdbc
      ServerPreparedStatement.executeBatch
      1. com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)
      1 frame
    3. c3p0:JDBC DataSources/Resource Pools
      NewProxyPreparedStatement.executeBatch
      1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1722)
      1 frame
    4. net.sf.hibernate
      SessionImpl.executeAll
      1. net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
      2. net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
      3. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2438)
      3 frames