javax.jdo.JDODataStoreException

Insert of object "org.apache.hadoop.hive.metastore.model.MTable@259d0986" using statement "INSERT INTO TBLS *(TBL_ID,RETENTION,DB_ID,LAST_ACCESS_TIME,OWNER,TBL_TYPE,VIEW_ORIGINAL_TEXT,VIEW_EXPANDED_TEXT,TBL_NAME,SD_ID,CREATE_TIME) VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUETABLE' defined on 'TBLS'.*

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web56

  • via Google Groups by santlal gupta, 9 months ago
    (?,?,?,?,?,?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUETABLE' defined on 'TBLS'.*
  • via Google Groups by Chris K Wensel, 7 months ago
    (?,?,?,?,?,?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUETABLE' defined on 'TBLS'.
  • via Stack Overflow by user3318618
    , 1 year ago
    Insert of object "B@95973d" using statement "INSERT INTO `B` (`ID`,`IDR`) VALUES (?,?)" failed : Duplicate entry '4' for key 'PRIMARY'
  • Stack trace

    • javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MTable@259d0986" using statement "INSERT INTO TBLS *(TBL_ID,RETENTION,DB_ID,LAST_ACCESS_TIME,OWNER,TBL_TYPE,VIEW_ORIGINAL_TEXT,VIEW_EXPANDED_TEXT,TBL_NAME,SD_ID,CREATE_TIME) VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUETABLE' defined on 'TBLS'.* at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago