Indexes not working properly

Technical assistance
1

Infos:

  • Used Zammad version: 6.5
  • Used Zammad installation type: package
  • Operating system: Oracle Linux 9

Expected behavior:

  • Records of the reporting section should show all the tickets that meet the requirements

Actual behavior:

  • Tickets are missing from the records

Steps to reproduce the behavior:

  • While going through the records we realized that multiple tickets are missing.
    We manage to solve this with this command “zammad run rake zammad:searchindex:rebuild”.
    We have set up a cron to run i every night to make sure that our indexes are right but it could be a problem to people that don’t realize tickets are missing
2

That’s not a solution at all.

Why would you do that? A rebuild was required with updating to Zammad 6.5 and was pointed out in our release notes. Does the searchindex drift after every reindex?

That’s the issue you may want to check on.

3

We did rebuild after the update and we rebuilt the index multiple times since but the issue of the index not being correct kept coming.
For exemple one or two times when looking for a specific ticket in the searchbar it wouldn’t appear even though we know it existed. After rebuilding the index it came back.

We have no idea what causes this and it seems to appear more or less once a month.

4

You might want to check your production log for errors I guess. Especially if the information is not “brand new” but should be there after some hours.