java.sql.BatchUpdateException: Invalid argument value, message from server: "Duplicate entry '2' for key 1"

Oracle Community | 3004 | 1 decade ago
  1. 0

    How to use a MAP whithout join table

    Oracle Community | 1 decade ago | 3004
    java.sql.BatchUpdateException: Invalid argument value, message from server: "Duplicate entry '2' for key 1"
  2. 0

    kodo3-SQLServer exception

    Oracle Community | 1 decade ago | 3004
    java.sql.BatchUpdateException: com.jnetdirect.jsql.v: sp_cursoropen/sp_cursorprepare: el par__metro de la instrucci__n s__lo puede ser una selecci__n __nica o un solo procedimiento almacenado.
  3. 0

    Install server against MySQL Import confluence.atlassian.com data Try to create a space: the space is created, but you're left with a stack-trace of a primary key conflict: java.sql.BatchUpdateException: Invalid argument value, message from server: "Duplicate entry '5' for key 1" at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1404) at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54) at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2385) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2335) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:339) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:302) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:174) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy10.savePermission(Unknown Source) at com.atlassian.confluence.spaces.DefaultSpaceManager.createSpace(DefaultSpaceManager.java:168) 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:324) at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:201) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.atlassian.confluence.util.profiling.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:17) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:135) at $Proxy12.createSpace(Unknown Source) Try to follow that with a SnipSnap import, it also fails with PK problems: org.springframework.orm.hibernate.HibernateSystemException: a different object with the same identifier value was already associated with the session: 3, of class: com.opensymphony.user.provider.hibernate.entity.HibernateUser; nested exception is net.sf.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: 3, of class: com.opensymphony.user.provider.hibernate.entity.HibernateUser net.sf.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: 3, of class: com.opensymphony.user.provider.hibernate.entity.HibernateUser at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:823) at net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:761) at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:720) at org.springframework.orm.hibernate.HibernateTemplate$7.doInHibernate(HibernateTemplate.java:299) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:149) at org.springframework.orm.hibernate.HibernateTemplate.save(HibernateTemplate.java:297) at com.atlassian.confluence.user.persistence.dao.hibernate.ConfluenceUserDAO.saveUser(ConfluenceUserDAO.java:176) at com.opensymphony.user.provider.hibernate.HibernateCredentialsProvider.create(HibernateCredentialsProvider.java:64) at com.atlassian.confluence.user.providers.ConfluenceCredentialsProvider.create(ConfluenceCredentialsProvider.java:60) at com.opensymphony.user.UserManager.createEntity(UserManager.java:370) at com.opensymphony.user.UserManager.createUser(UserManager.java:242)

    Atlassian JIRA | 1 decade ago | Charles Miller
    java.sql.BatchUpdateException: Invalid argument value, message from server: "Duplicate entry '5' for key 1"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with SQLExceptionTranslator

    springframework | 1 decade ago | lakershen
    java.sql.BatchUpdateException: Invalid argument value,  message from server: "Duplicate entry 'CAT1' for key 1"
  6. 0

    Running upgrade 0.5.3 - > 0.6.1 Ant task

    xplanner | 1 decade ago | martinsarosi
    java.sql.BatchUpdateException: Invalid argument value,  message from server: "Duplicate entry '17313-17309-0' for key 1"

    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

      Invalid argument value, message from server: "Duplicate entry '2' for key 1"

      at kodo.jdbc.sql.SQLExceptions.getFatalDataStore()
    2. kodo.jdbc.sql
      SQLExceptions.getFatalDataStore
      1. kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:42)
      2. kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:24)
      2 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager.flush
      1. kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:594)
      1 frame
    4. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.DelegatingStoreManager.flush(DelegatingStoreManager.java:152)
      2. kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:964)
      3. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:813)
      4. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      5. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:542)
      5 frames
    5. tutorial
      CreateTranslatableDescription.main
      1. tutorial.CreateTranslatableDescription.main(CreateTranslatableDescription.java:48)
      1 frame
    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:324)
      4 frames
    7. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(Unknown Source)
      1 frame