duplicate key value violates unique constraint "content_pkey" when importing data

XMLWordPrintable

    • Type: Bug
    • Resolution: Support Request
    • Priority: Medium
    • None
    • Affects Version/s: 3.0.2
    • Component/s: None
    • Environment:

      JDK 1.6.0_17
      Glassfish 2.1.1
      Postgres 8.3
      Solaris 10u8

      Hi,

      importing data from Confluence Version 2.5.4 into 3.0.2 the Importer gives me the following error:

      Import failed. Hibernate operation: could not insert: com.atlassian.confluence.pages.Page#19202739; uncategorized SQLException for SQL []; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

      and pg_log says:

      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "os_group_pkey" for table "os_group"
      NOTICE: CREATE TABLE / UNIQUE will create implicit index "os_group_groupname_key" for table "os_group"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
      NOTICE: CREATE TABLE / UNIQUE will create implicit index "users_name_key" for table "users"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "content_perm_set_pkey" for table "content_perm_set"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "indexqueueentries_pkey" for table "indexqueueentries"
      ERROR: duplicate key value violates unique constraint "content_pkey"
      STATEMENT: insert into CONTENT (DRAFTPAGEID, DRAFTSPACEKEY, DRAFTTYPE, DRAFTPAGEVERSION, TITLE, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, VERSIONCOMMENT, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, 'DRAFT', $14)
      ERROR: current transaction is aborted, commands ignored until end of transaction block
      STATEMENT: insert into CONTENT (CHILD_POSITION, PARENTID, SPACEID, TITLE, VERSION, CREATOR, CREATIONDATE, LASTMODIFIER, LASTMODDATE, VERSIONCOMMENT, PREVVER, CONTENT_STATUS, CONTENTTYPE, CONTENTID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, 'PAGE', $13)

      The restore file is a daily backup with attachments stripped.
      Database collation is UTF-8. I got no further ideas where to look for so i reckon this a bug (maybe in some rare setups).
      An empty installation with the wizard runs fine without an error.

      Thank You.

      EDIT:
      Now I've tried several combinations. From standalone version w/ Tomcat and JDBC connection to the Postgres DB on the target remote server as well as the embedded derby database. None of them are working.

              Assignee:
              Unassigned
              Reporter:
              Oliver Böttcher
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: