Latest issues only appear by searching on exact issue number after importing mysql dump

I'm migrating our Jira instance to a new server, I've copied the program and home directories to the new server and set up all the prerequisites. After importing the mysql dump the most recent tickets are not appearing when queried, but when I enter the exact issue number they show up. For instance I search by the project key db it will list all the db tickets, showing the latest first. That latest ticket being DB-1456 for instance, then I search by for DB-1457 and that ticket will come up, only it does not come up in the first query. I hope this makes sense. Any ideas? Thanks for your hlep.

4 answers

1 accepted

0 votes
Accepted answer

I suspect my problem all along was not dumping the mysql database with a user with lock table privileges, I can't garauntee this was the cause but all is working now and and that's the only thing I can think of. Thanks for any help though, it was much appreciated.

0 votes
Joseph Pitt Community Champion May 29, 2014

The preferred method of moving a JIRA instance is the built in export/import. Have you tried running an reindex? Is the old instance of JIRA up? If so, and the reindex doesn't work you can use the built in functions still

0 votes

A MySQL move you've described should actually be fine. However, I'm completely unclear on your problems here.

Are you saying that everything you brought in via the MySQL dump is working ok? But any new issues you add can't be searched for? Or are you saying that most of the MySQL dump is ok, barring a few of the latest issues that were in it? (And again, in the second case, what do new issues do?)

Either way, it's definitely your index. But we need to know exactly what the symptoms are. And if a full re-index fixes it completely or changes the symptoms?

It is the second case. The issues do not show up in queries, or when I just list all issues, however they do show when I search by their exact issue number.

Ok, I'd expect a full reindex to fix the issues that are missing. Question again though - what happens with new issues in the new system?

When I create new issues on the new system they behave just like they should, it's only the newer issues imported that are not appearing properly.

Ok. Could you read the logs from when you did a full re-index? Any errors?

I have run a reindex a number of times, strangley with no effect, and yes the old instance is still up, it's still our production Jira. When you say export/import are you referring to the xml backup tool in Jira? I was under the impression our database was too big for that, not sure about that though. We're on Jira 6.05 running on Fedora 14 and migrating to CentOS 6.5 Mysql version on the production box is 14.14 Distrib 5.1.55, for redhat-linux-gnu (x86_64) using readline 5.1 and on the new CentOS box it's Mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

The problem is the latest tickets entered on the old system that are included in the dump are not appearing when queried unless you search for them by their exact issue number. And yes the migrated jira works perfectly except for this issue. Feel free to ask me for more clarification of the issue if I'm not being clear. Thanks again.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,949 views 19 22
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you