Confluence Server Version: 7.2.1
Operating System: Ubuntu 18.04.3
Database System PostgreSQL 10.12
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
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?
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.
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...
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