It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error Message during XML Import

Confluence Server Version: 7.2.1

Operating System: Ubuntu 18.04.3

Database System PostgreSQL 10.12

 

Hey Guys,

Trying to migrate a Confluence Instance from MySQL to PostgreSQL using the xml dump. When i'm importing the xml dump, after about 10 minutes i receive the following error message:

 

com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: null value in column "username" violates not-null
constraint
Detail: Failing row contains (2719745, 0, 2, 2020-01-26 19:03:06, 2017-09-14 12:39:51, 2013-02-06 22:20:09, null).

 

Can somebody help?

 

Regards,

 

Dominic

1 answer

1 accepted

0 votes
Answer accepted

Hi,

same Confluence version on both systems? If they are not the same, there will be no help/support.

Assuming they are the same:

The error message is pretty good: On the PostgreSQL side there is a constrain on a table not allowing the username column to be null. The data to be inserted contains a null value in the latest column.

This might be a bug / difference between MySQL & PSQL. It might be a bug in your database table. A solution is not that easy:

1. Ask Atlassian support

2. Try relaxing the constrain in PostgreSQL

3. Fix the null value in the exported data

#2 & #3 are a sort of last resort.

Best

JP

Of course both systems have the same Version of Confluence.

Can i find the table which produces the error?

 

How do i relax the constraint in PostgreSQL?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

7,070 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you