org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#3 60475]; SQL []; integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA; nested exception is java.sql.SQLExceptio n: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Piyawoot Songsiritat [Atlassian], 1 year ago
Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#3 60475]; SQL []; integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA; nested exception is java.sql.SQLExceptio n: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
via Atlassian JIRA by Piyawoot Songsiritat [Atlassian], 1 year ago
Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#3 60475]; SQL []; integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA; nested exception is java.sql.SQLExceptio n: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
via atlassian.com by Unknown author, 6 months ago
Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#294922]; SQL []; ERROR: duplicate key value violates unique constraint "cwd_unique_user_membership" Detail: Key (parent_id, child_user_id)=(163847
via Atlassian JIRA by Joey Corea [Atlassian], 1 year ago
Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#1409029]; SQL []; Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'.; nested exception is java.sql.SQLException: Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'.
via Atlassian JIRA by Joey Corea [Atlassian], 1 year ago
Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#1409029]; SQL []; Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'.; nested exception is java.sql.SQLException: Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'.
via atlassian.com by Unknown author, 1 year ago
Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#139527563]; SQL []; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#3 60475]; SQL []; integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA; nested exception is java.sql.SQLExceptio n: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
at org.hsqldb.error.Error.error(Error.java:131)
at org.hsqldb.Constraint.getException(Constraint.java:913)
at org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:236)
at org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
at org.hsqldb.TransactionManagerMVCC.addInsertAction(TransactionManagerMVCC.java:402)
at org.hsqldb.Session.addInsertAction(Session.java:433)
at org.hsqldb.Table.insertSingleRow(Table.java:2500)
at org.hsqldb.StatementDML.insertSingleRow(StatementDML.java:820)
at org.hsqldb.StatementInsert.getResult(StatementInsert.java:131)
at org.hsqldb.StatementDMQL.execute(StatementDMQL.java:190)
at org.hsqldb.Session.executeCompiledStatement(Session.java:1300)
at org.hsqldb.Session.execute(Session.java:960)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4605)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:308)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at undefined.$Proxy24.store(Unknown Source)
at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.store(ConfluenceCachingBandanaPersister.java:130)
at com.atlassian.bandana.DefaultBandanaManager.setValue(DefaultBandanaManager.java:48)
at com.atlassian.confluence.content.render.xhtml.migration.macro.MacroMigrationService.setMigrationRequired(MacroMigrationService.java:201)
at com.atlassian.confluence.content.render.xhtml.migration.macro.RemigrationLongRunningTask.runInternal(RemigrationLongRunningTask.java:79)
at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:21)
at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
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:662)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
215 times, 1 month ago
4 times, 10 months ago
Once, 11 months ago
94 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.