Receiving errors during xml import (from MYSQL -> PostGres)

Rahul Aich [Nagra]

Hi All

I am trying to migrate my JIRA (7.2) database from MYSQL to PostGres. I am doing it via xml export/import.

I am receiving this error during the import. JIRA Application is fine though despite this error.

My questions are

- Is this a harmless error and can i safely ignore it?

- Is there a way we can fix this error?

Error:

atlassian-jira.log.1:2018-07-11 06:40:44,432 active-objects-init-JiraTenantImpl{id='system'}-0 ERROR anonymous 366x362x1 l1slwv 10.8.8.79 /secure/admin/XmlRestore.jspa [n.java.ao.sql] Exception executing SQL update <CREATE INDEX "index_ao_8b1069_act1994704914" ON public."AO_8B1069_ACTIVITY_ENTRY"("TEST_RUN_ID")>

Brant Schroeder

Rahul the error is letting you know that an index failed to create on a table in the DB.  I am not familiar with the table listed.  I would find out if it is a JIRA or a plugin table and then contact support to find out what the index should be and apply it.  If the DB is not properly indexed you will run into performance issues at some point.