The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Getting Below error in catalina.out however till yesterday JIRA properly working with en_US.UTF-8.
Upon login to JIRA and selecting project, no issues related to the project getting displayed in JIRA
2019-05-01 08:48:05,585 JIRA-Bootstrap WARN [c.a.jira.health.HealthChecks] Your database is using an unsupported collation
2019-05-01 08:48:05,585 JIRA-Bootstrap WARN [c.a.jira.health.HealthChecks] Your postgres72 database is currently using an unsupported collation: en_US.UTF-8. You should change this to a supported collation: - POSIX.UTF-8
- C.UTF-8
- C
- POSIX
Hello,
The error you noted "An unknown error occurred while trying to perform a search" could be caused by a varying number of sources, and there is a possibility that this could be related to the database collation warning you are receiving but might be something else entirely. The collation may be contributing to issue.
However in combination with the issues not displaying at all it sounds like there is more than likely an indexing issue is occuring, or a lesser chance of an issue with project permissions, particularly browse project permission is missing.
I would first recommend double checking the project permissions on the project just to make sure that you do have the "browse project" permission for the project, its more than likely not this causing the issue but its a quick check to rule this out.
Then I would suggest triggering a full lock and re-index on the application that should clear out any indexing issues unless there is index corruption so also make sure to watch the logging to see if you trigger any errors related to index corruption described HERE that would require a manual flush as described in the KB.
As for the collation warnings on the database check out the KB "How to fix the collation of a Postgres JIRA database" for the steps to take to correct the mismatch.
Regards,
Earl
Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.