As part of JIRA Service Desk now, JIRA is storing the incoming mails in the database (done by the JEPP). Those are stored inside the AO_2C4E5C_MAILITEMCHUNK table.
JIRA is, sometimes, silently failing to import or export the active objects part of the backup.
- Install JIRA;
- Import the backup linked on the private comments.
- JIRA will stop importing once it reaches 90%. Restart JIRA.
- Navigate to Administration » System » Plugin Data Storage and verify what has been imported.
All entries in the active objects table would have been imported/exported.
- Exporting: JIRA creates the backup normally, but upon inspecting the activeobjects.xml file (using the grep below) not all entries are in the file.
- Importing: JIRA fails to import the data once it reaches 90%, but after restarting JIRA it seems to have imported correctly. Inspecting the Plugin Data Storage shows most tables as empty, and inspecting the activeobjects file shows all data.
The following errors might be found in the Jira logs:
The following errors might be seen in the logs:
This seems to be happening because JIRA runs out of memory due to import, but fails to log any errors or warnings.
To verify the data inside the activeobjects.xml backup, run:
This will show how many rows were exported for each table. For example, when JIRA failed to export correctly, this was shown:
It is possible to see what tables were (supposed to be) exported to the backup with:
Follow our Increasing JIRA Memory guide to increase the memory available to JIRA, restart JIRA and try to import/export the backup again. If this doesn't work, please follow the instructions below:
It is possible to remove the affected lines from the backup with:
This will return two numbers.
- use vim to open the activeobjects.xml and run:
Where num1 and num2 are the numbers returned in the first step. e.g.:
- save and exit vim;
- zip the backup again and import.
This will return the body of the emails that are stored.
- Turn off the Email Puller so that no new mail will be added to the database
- JIRA Administration > System > Global Mail Settings
- Wait at least 5 minutes so that the mail processor is able to process mail that is already in the database
- Stop JIRA;
- Run the following update in the database to delete the mail items:
- Optional: backup this table using your database's native tools before running the update
- Restart JIRA;
- Export the data again.
- Turn the Email Puller back on