Issues while importing XML backup in JIRA 7.12.3

[Ash]

Hi Everyone,

We are seeing below issue while importing Mysql 5.6 XML backup to Postgres 9.6. in JIRA 7.12.3. We are using AWS RDS instances. Already used XML cleaner to clean backups before import.

---------------------------------------------------------------------------------------------

com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:9.6.9
- minor version:6
- major version:9
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.4.1212

org.postgresql.util.PSQLException: ERROR: relation "public.AO_455C86_PASS_POLICY_PROP" does not exist
Position: 32
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:9.6.9
- minor version:6
- major version:9
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.4.1212

org.postgresql.util.PSQLException: ERROR: relation "public.AO_455C86_PASS_POLICY_PROP" does not exist
Position: 32

TIA!!

[Thomas Deiler]

Dear @Ash,

is the XML backup of a lower version of Jira Software than 7.12.3?

So long

Thomas

[Ash]

@Thomas Deiler Thanks for your reply XML back is on JIRA 7.12.3.

we are switching database in the new instance.

Since MySQL RDS is not supported by Atlassian.

[Thomas Deiler]

Ok, then something went wrong when exporting the data. The XML dump is free of any DB flavour. It would make no sense to export DB details in an XML file. Otherwise you could just dump the DB without Jira.

Just to double check - when you reimport into the same DB type, does the error occure, too?

Another source of the error: Have you set up postgresql like recommended by Atlassian?

Why does the  driver say its version 9.4.1212 and not 9.6.9? Are there parallel DB versions installed?

So long

Thomas

[Ash]

Just to double check - when you reimport into the same DB type, does the error occure, too?

Re-Importing to the same XML to the same DB worked fine.

Another source of the error: Have you set up PostgreSQL like recommended by Atlassian?

We are using RDS Postgres and DB has been created instruction given by atlassian.

Why does the driver say its version 9.4.1212 and not 9.6.9? Are there parallel DB versions installed?

Using 9.4 JDBC is atlassian recommendation. 

"Jira is tested and bundled with the 9.4 JDBC driver. You can also use the latest JDBC driver for your PostgreSQL version, though we can't guarantee it will work with your version of Jira."

Can you be more specific on this question,

"Are there parallel DB versions installed?"

TIA!!

[Thomas Deiler]

Dear @Ash,

it's possible to manually install more than one DB of the same type on one system. My thought was, that there are two different versions installed. But you exclueded this.

Then lets check your process for the migration (my assumtion):

1. Backup data to XML
2. Stop old instance to prevent data modification
3. Setup new server, modify configs
4. Setup JIRA_HOME
   1. copy attachments from former JIRA_HOME
   2. copy all 3rd party plugins with the right version to plugins/installed-plugins
   3. copy XML dump to import folder
   4. copy avatars
5. Start new Jira Server
6. Open browser and configure new DB
7. Restore XML dump with license

So long

Thomas

[Ash]

@Thomas Deiler Thank you so much for your responses.

Yes, we followed the same exact steps.

[Thomas Deiler]

Did you use the same JIRA_HOME as with the old DB?

[Ash]

we copied these two folders to our new server.

/var/atlassian/application-data/jira/data 

/var/atlassian/application-data/jira/plugins

[Thomas Deiler]

Try this:

• Stop you new Jira
• Empty the JIRA_HOME directory completely
• clean the DB (drop all tables)
• Start Jira and configure the new DB (no XML restore)
• Stop Jira
• copy only the 3rd party plugins into /var/atlassian/application-data/jira/plugins/installed-plugins and not those jars, that came with Jira
• copy from data only attachments and avatras
• Start Jira (and check the log if the plugins where loaded
• Restore XML dump

so long

Thomas

[Ash]

@Thomas Deiler  Thank you.Will try this.

[Contact IT]

Hello @Ash

Did the steps provided by @Thomas Deiler work for you?

I am facing almost the same issue as you, although with the relation "public.AO_7DEABF_EXEC_CLUSTER_MESSAGE".

Thanks

[Ash]

Hi @Contact IT  did you try these steps ??

https://confluence.atlassian.com/jirakb/how-to-handle-4-byte-characters-in-xml-backup-899181755.html

There is an issue with xml cleaner.