I can't migration database from MySQL to PostgreSQL

[Konstantin Lugovskoy]

I can't migration database from MySQL to PostgreSQL.  In the middle of the export process, the start-up setting comes out.

[Andy_Heinzer · Accepted solution]

Hi Konstantin,

That log file shows a stuck thread, but that appears to clear and does not clearly show a problem to me.   I would like to gather a more complete set of logs from your environment so we can better understand this problem.  To do that I have created a support case on your behalf in https://getsupport.atlassian.com/servicedesk/customer/portal/20/GHS-165434

Please see the instructions there so we can try to help troubleshoot this further.

Thanks

Andy

[Andy_Heinzer]

Hi Konstantin,

I understand you are trying to migrate databases between MySQL and PostgreSQL, but I am unclear as to exactly what steps you are following to attempt to do this.  In regards to a Jira database, I would suggest trying to follow the steps in Switching databases. 

This process has you creating an XML backup .zip file in Jira and then creating a new blank database for Jira to use.  This way you can then import that data using Jira's setup wizard to import that backup into this new empty database.  

While it might be possible to use some kind of native database tool to try to convert this data, I don't have any experience in getting this part to work.  I would though recommend checking to make sure that your version of Jira is listed as a supported platform with the specific version of Postgres that you are trying to migrate to.  You can do this by checking against the appropriate Jira Supported Platforms page. 

Please let me know if this helps.

Andy

[Konstantin Lugovskoy]

Hi Andy,

Yes, I created an XML backup .zip file. Then I created a new database on PostgreSQL.

But I had a issue then I tried exporting .zip file to new database. 

Export window goes to installation window.

[Andy_Heinzer]

Hi Konstantin,

I'm not sure I follow what you mean.  Specifically the line:

Export window goes to installation window.

I don't know what you mean by this.   Do you mean that in the middle of trying to create the XML backup file that Jira takes you to the installation view?  Or that there are startup logs being generated in the backup itself?

• Would it be possible for us to take a closer look at the $JIRAHOME/log/altassian-jira.log file at the time this backup is being created?
• What version of Jira are you using here?

Unfortunately, our community site will not allow you to attach a file here.  So you would need to upload this file first to another service like Google Drive or Dropbox and then share a link to that file here.  I'd be happy to take a closer look at that log to see if we can learn more about the problem here.

Andy

[Konstantin Lugovskoy]

Hi Andy,

I mean that in the middle of importing XML backup file to new database Jira take me to the installation view.

My version of Jira is Atlassian Jira (v8.4.0#804001-sha1:a071452)

Thanks.

[Andy_Heinzer]

I would really like to take a closer look at the $JIRAHOME/log/altassian-jira.log OR the $JIRAINSTALL/logs/catalina.out file at the time of this import.

I'm thinking that something has gone horribly wrong on a SQL level or something else within Jira.  You should not be taken back to the installation wizard page during this import.  Instead when the import is complete, Jira should restart and take you to the login page.   If you are not getting that far, then there is most likely something wrong with the database, or Jira's ability to use that database as expected.

[Konstantin Lugovskoy]

Hi Andy,

https://drive.google.com/file/d/161RS31yMdO4wesF3yxCfFGk_Z1grvu9a/view?usp=sharing 

This is log from $JIRAHOME/logs/catalina.out