-
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.