org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_PROJECT_NAME_INDEX_1 ON PUBLIC.PROJECT(NAMESPACE, NAME) VALUES ( /* key:23 v:1 */ null, 'Project_New', null, null, null, 'HOSTNAME')"; SQL statement: update project set description=?, project_key=?, name=?, namespace=? where id=? [23505-176]

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

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via Atlassian JIRA by Dave Lahn [Atlassian], 1 year ago
Unique index or primary key violation: "UK_PROJECT_NAME_INDEX_1 ON PUBLIC.PROJECT(NAMESPACE, NAME) VALUES ( /* key:23 v:1 */ null, 'Project_New', null, null, null, 'HOSTNAME')"; SQL statement: update project set description=?, project_key=?, name=?, namespace=? where id=? [23505-176]
via Atlassian JIRA by Dave Lahn [Atlassian], 1 year ago
Unique index or primary key violation: "UK_PROJECT_NAME_INDEX_1 ON PUBLIC.PROJECT(NAMESPACE, NAME) VALUES ( /* key:23 v:1 */ null, 'Project_New', null, null, null, 'HOSTNAME')"; SQL statement: update project set description=?, project_key=?, name=?, namespace=? where id=? [23505-176]
via GitHub by c-yan
, 1 year ago
Referential integrity constraint violation: "IDX_ISSUE_ID_FK1: PUBLIC.ISSUE_ID FOREIGN KEY(USER_NAME, REPOSITORY_NAME) REFERENCES PUBLIC.REPOSITORY(USER_NAME, REPOSITORY_NAME) ('UserName', 'ProjectName')"; SQL statement: delete from "REPOSITORY" where "REPOSITORY"."USER_NAME" = ? [23503-190]
via GitHub by teaplanet
, 1 year ago
Unique index or primary key violation: "PRIMARY_KEY_8E ON PUBLIC.REPOSITORY(USER_NAME, REPOSITORY_NAME) VALUES ( /* key:459 */ 'teaplanet', 'test-repo', null, null, null, null, null, null, null, null, null, null)"; SQL statement: INSERT INTO
via GitHub by fumitoito
, 2 years ago
???????????????????????: "PRIMARY_KEY_AB ON PUBLIC.ACCOUNT(USER_NAME)" Unique index or primary key violation: "PRIMARY_KEY_AB ON PUBLIC.ACCOUNT(USER_NAME)"; SQL statement: INSERT INTO "ACCOUNT" ("USER_NAME","MAIL_ADDRESS","PASSWORD","ADMINISTRATOR","URL","REGISTERED_DATE","UPDATED_DATE","LAST_LOGIN_DATE","IMAGE","GROUP_ACCOUNT") VALUES (?,?,?,?,?,?,?,?,?,?) [23505-171]
via GitHub by sachgits
, 1 day ago
Table "SETTINGS" not found; SQL statement: select this_.id as id1_8_0_, this_.version as version2_8_0_, this_.default_value as default_3_8_0_, this_.description as descript4_8_0_, this_.name as name5_8_0_, this_.required as required6_8_0_, this_
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_PROJECT_NAME_INDEX_1 ON PUBLIC.PROJECT(NAMESPACE, NAME) VALUES ( /* key:23 v:1 */ null, 'Project_New', null, null, null, 'HOSTNAME')"; SQL statement: update project set description=?, project_key=?, name=?, namespace=? where id=? [23505-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.message.DbException.get(DbException.java:154)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:103)
at org.h2.index.PageBtree.find(PageBtree.java:121)
at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:151)
at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:104)
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:97)
at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:88)
at org.h2.index.MultiVersionIndex.add(MultiVersionIndex.java:59)
at org.h2.table.RegularTable.addRow(RegularTable.java:120)
at org.h2.table.Table.updateRows(Table.java:467)
at org.h2.command.dml.Update.update(Update.java:146)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:254)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158)
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1184)
at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:127)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:114)
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:226)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:484)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at com.sun.proxy.$Proxy258.doInTransaction(Unknown Source)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at com.sun.proxy.$Proxy330.doInTransaction(Unknown Source)
at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at com.sun.proxy.$Proxy434.doInTransaction(Unknown Source)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)
at sun.reflect.GeneratedMethodAccessor260.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at com.sun.proxy.$Proxy995.execute(Unknown Source)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper.inTransaction(DefaultMirrorSynchronizationHelper.java:520)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper.inTransactionVoid(DefaultMirrorSynchronizationHelper.java:524)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper.syncLocalRepositoriesAndFetch(DefaultMirrorSynchronizationHelper.java:648)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper.access$900(DefaultMirrorSynchronizationHelper.java:56)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper$FullSynchronizationTask.synchronizeExternalRepositories(DefaultMirrorSynchronizationHelper.java:769)
at com.atlassian.bitbucket.internal.mirroring.mirror.sync.DefaultMirrorSynchronizationHelper$FullSynchronizationTask.run(DefaultMirrorSynchronizationHelper.java:731)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at com.atlassian.stash.internal.concurrent.StateTransferringExecutor$StateTransferringRunnable.run(StateTransferringExecutor.java:70)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
2 times, 5 months ago
Once, 1 week ago
Once, 1 week ago
4 times, 1 week ago

Write tip

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