Jira trouble after system upgrade

[wortmanb]

We just patched our Jira server to bring it up to the latest version of CentOS 7, but when I started Jira it failed due to a problem cleaning a cache directory.

I deleted that directory using the directions here, and when we started it again it came up (with multiple errors which, at the time, we attributed to the cache rebuild). But now the most recent activity in our instance dates to July, and there are no tickets in the instance at all.

Before I make things worse (I did take a mysqldump of the database while the instance was down prior to the cache directory purge above, so I'm hopeful we've got a good copy of everything), I figured I should ask for some advice. The instance is currently shut down while we try to figure out how to move forward.

---Update---

I checked the jiraissue table in mysql and found some very recent issues, so the data is in the db, it's just not being read correctly.

Thanks!

[wortmanb · Accepted solution]

It just needed a lock-and-reindex to sort itself out. All good now.

[Nic Brough -Adaptavist-]

What do the log files say the problem is?  (Check Jira-home/logs/atlassian-jira.log as a starter)

[wortmanb]

More detail: Tickets aren't showing up under their projects, or under the properly-assigned users.

[wortmanb]

When the instance did come up it has a health check error for a missing attachment and the logs complain about not being able to connect to our mail server...