net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

Atlassian JIRA | Saleh Parsa [Atlassian] | 2 years ago
  1. 0

    h6. Steps to Reproduce: # Install Confluence 5.7 with any databases _(e.g. Postgres, HSQL)_ # Create a space. # Export the Space. # Install another Confluence 5.7 with *Oracle* database. # Import the space. h6. Expected Behavior: Should be able to import the Space Backup. h6. Actual Behavior: !SpaceBug.png|width=512! {code} Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated {code} Following appears in the log: {code} 2015-02-19 13:21:15,725 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://10.60.4.82:8090/admin/backup.action | url: /admin/restore.action | userName: admin | action: restore com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:430) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:388) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:150) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:259) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:50) at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:211) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:77) ... at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:73) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420) ... 30 more Caused by: org.xml.sax.SAXException: Error while importing backup: Could not execute JDBC batch update net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:110) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61) ... 31 more Caused by: net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2465) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2419) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2288) at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.flushIfNeeded(ImportProcessorContext.java:246) at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.objectImported(ImportProcessorContext.java:81) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:50) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:37) at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:51) ... 43 more Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) ... 51 more caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10298) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10404) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) .... {code} *Workaround* # Delete any previously failed, half-imported space. # Shut down Confluence. # Run the following query in database: {code} alter table CONTENT_PERM DISABLE constraint CP_UNIQUE_USER_GROUPS; {code} # Start Confluence. # Import Space. # Shut down Confluence again. # Run the following query in database: {code} alter table CONTENT_PERM ENABLE constraint CP_UNIQUE_USER_GROUPS; {code} (!) *Please backup your database before running the above query.*

    Atlassian JIRA | 2 years ago | Saleh Parsa
    net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  2. 0

    h6. Steps to Reproduce: # Install Confluence 5.7 with any databases _(e.g. Postgres, HSQL)_ # Create a space. # Export the Space. # Install another Confluence 5.7 with *Oracle* database. # Import the space. h6. Expected Behavior: Should be able to import the Space Backup. h6. Actual Behavior: !SpaceBug.png|width=512! {code} Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated {code} Following appears in the log: {code} 2015-02-19 13:21:15,725 ERROR [Long running task: Importing data] [confluence.importexport.actions.ImportLongRunningTask] runInternal Failure during import -- referer: http://10.60.4.82:8090/admin/backup.action | url: /admin/restore.action | userName: admin | action: restore com.atlassian.confluence.importexport.ImportExportException: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:430) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:388) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:150) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:259) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:50) at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:211) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:77) ... at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:73) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420) ... 30 more Caused by: org.xml.sax.SAXException: Error while importing backup: Could not execute JDBC batch update net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:110) at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61) ... 31 more Caused by: net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2465) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2419) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2288) at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.flushIfNeeded(ImportProcessorContext.java:246) at com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.objectImported(ImportProcessorContext.java:81) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:50) at com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:37) at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:51) ... 43 more Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128) ... 51 more caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10298) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10404) at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) .... {code} *Workaround* # Delete any previously failed, half-imported space. # Shut down Confluence. # Run the following query in database: {code} alter table CONTENT_PERM DISABLE constraint CP_UNIQUE_USER_GROUPS; {code} # Start Confluence. # Import Space. # Shut down Confluence again. # Run the following query in database: {code} alter table CONTENT_PERM ENABLE constraint CP_UNIQUE_USER_GROUPS; {code} (!) *Please backup your database before running the above query.*

    Atlassian JIRA | 2 years ago | Saleh Parsa [Atlassian]
    net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  3. 0

    Update non-existent table - crash ORA-00942

    Stack Overflow | 6 years ago | Ten_of_a_Kind
    java.sql.BatchUpdateException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    @OneToOne + Table-per-Concrete-Class = exception?

    Stack Overflow | 6 years ago | Ten_of_a_Kind
    java.sql.BatchUpdateException: ORA-02291: integrity constraint (NDP.FK9619CF1CAD47EF0F) violated - parent key not found
  6. 0

    Hibernate, Hibernate Spatial, Oracle, existing table(s)

    Google Groups | 5 years ago | Pedro Mendes
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

  1. r1chjames 10 times, last 6 months ago
12 unregistered visitors
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. java.sql.BatchUpdateException

    ORA-00001: unique constraint (CONF57.CP_UNIQUE_USER_GROUPS) violated

    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch()
  2. Oracle jdbc
    OracleStatementWrapper.executeBatch
    1. oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)
    2. oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    2 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeBatch
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
    1 frame
  4. net.sf.hibernate
    SessionImpl.flush
    1. net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
    2. net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
    3. net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73)
    4. net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
    5. net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:328)
    6. net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:135)
    7. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2465)
    8. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2419)
    9. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2288)
    9 frames
  5. com.atlassian.confluence
    BackupParser.endElement
    1. com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.flushIfNeeded(ImportProcessorContext.java:246)
    2. com.atlassian.confluence.importexport.xmlimport.ImportProcessorContext.objectImported(ImportProcessorContext.java:81)
    3. com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.persist(DefaultImportProcessor.java:50)
    4. com.atlassian.confluence.importexport.xmlimport.DefaultImportProcessor.processObject(DefaultImportProcessor.java:37)
    5. com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:51)
    6. com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55)
    6 frames
  6. Xerces2-j
    SAXParserImpl$JAXPSAXParser.parse
    1. org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
    2. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
    3. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
    4. org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
    5. org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    6. org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    7. org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    8. org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    9. org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
    9 frames
  7. com.atlassian.security
    RestrictedXMLReader.parse
    1. com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103)
    1 frame
  8. com.atlassian.confluence
    DefaultXmlImporter.doImport
    1. com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:110)
    2. com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:61)
    2 frames