I am trying to perform a migration of our JIRA 6.3.4 installation on a LINUX machine to another LINUX machine.
By using mysqldump, I created a dump of the JIRA DB and I am importing the mysqldump file into the mysql JIRA DB on the destination machine.
I am copying the JIRA program directory and the JIRA home directory to the destination machine by using rsync using the --delete switch to exactly receive the source version of the file/directory structure.
Afterwards I am doing a reindex on the destination JIRA.
I realized, that the Base URL is still the original value but I suppose, that it should have been set to the value of the source machine ? Using mysql command line on the destination DB, I can see that the source machine BASE URL is present in the propertystring and changeitem tables, but not in the JIRA System GUI.
The issues of the source machine are visible, but when I try to update an issue I am receiving the following error:
"org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:ChangeGroup][id,453410][author,sfe_admin][created,2015-03-18 15:15:08.288][issue,66821] (SQL Exception while executing the following:INSERT INTO changegroup (ID, issueid, AUTHOR, CREATED) VALUES (?, ?, ?, ?) (Duplicate entry '453410' for key 'PRIMARY'))
It seems that you have tried to perform an illegal workflow operation.
If you think this message is wrong, please contact your JIRA administrators."
Any help with what is going wrong or missing would be greatly appreciated!
Thanx in advance!
I believe you've severely messed up the counter in your DB.
Disclaimer & Note: I am not responsible for anything that happens after this
Thank You for Your reply!
Why would the counter get messed up by doing a mysqldump export and an mysql import ?
Nevertheless I found this article which describes an operation to repair a situation like this:
And also why is the Base Url still the original one ?
It is recommended to NOT use the XML backup but instead the native DB tools to do exports/imports but somehow this doesnt seem to work...
Any hints are very much appreciated!
bq. Why would the counter get messed up by doing a mysqldump export and an mysql import ? No answer for that bq. And also why is the Base Url still the original one ? What you are doing is a copy and paste of the database. You will have to change the Base URL yourself.
The Base URL already shows the (old) destination address and not the one of the source machine which it should. Therefore I dont have to change it, like I have to when I use XML Backup. For me this implies, that something didnt get updated correctly, during the import... Regards, Hans
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs