I can't import my confluence xml export due the the following errors:
postgres_confluence | 2020-05-11 03:46:57.299 UTC  ERROR: duplicate key value violates unique constraint "unq_lwr_username"
postgres_confluence | 2020-05-11 03:46:57.299 UTC  DETAIL: Key (lower_username)=() already exists.
postgres_confluence | 2020-05-11 03:46:57.299 UTC  STATEMENT: insert into user_mapping (username, lower_username, user_key) values ($1, $2, $3)
postgres_confluence | 2020-05-11 03:46:57.300 UTC  ERROR: current transaction is aborted, commands ignored until end of transaction block
postgres_confluence | 2020-05-11 03:46:57.300 UTC  STATEMENT: select 1
I have tried updating to v7 release and I still get the error. I found a bug report with a workaround, but I can't find any of the classes in my entities.xml. The bug-reporter is using cloud verison where I use the server version, perhaps that is why?> Can anybody help me workaround this issue, I have been struggling for days to fix it to no avail.
"Workaround" says to find
<object class="HibernateMembership" package="com.atlassian.crowd.embedded.hibernate2">
But of course, that doesn't exist in my export, but I get the same error.
I was able to get past this by basically deleting all users, clearing almost everything from `user_mapping` manually via sql and using the "recovery_admin" user to export/import and create a new user. Simple right?
Ran into this issue, but same resolution (I think?)
It seems you have a user with the same lower user name as one that currently exists in your backup file.
This means you may need to first verify this conflict and resolve it before proceeding any further.
Let us know how this goes.
Sorry, not that simple as I have done lots of troubleshooting. I have only two users and I am importing into a brand new setup with only one user which is a different username. This is related to the XML export bug I linked which said I had to move the declarations around in entities.xml somehow, but I can't figure out how.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
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