Non-English Locale Causes Slow Performance Viewing Issue in JIRA IFrame

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Opening an issue in the JIRA IFrame with English locale works well. However, if using other non-English locale, it will take a long time (e.g. 20 seconds) to display the issue in the JIRA IFrame.

Cause

The performance is not related with the IFrame itself. The IFrame is just calling the standard issue view. There is no logic being processed. The root cause of the problem is the character encoding of the JIRA instance or the database itself.

Resolution

Please ensure you had done the following:-

  • Encoding setting for JVM
    Change encoding used by JVM by appending -Dfile.encoding=utf-8 to your application start up parameters. You can refer to the following documentation as a guideline: Setting Properties and Options on Startup.
  • General Configuration has been set to UTF-8.
    You can check this via Administration > Global Settings > General Configuration whether the character encoding has been set to utf8.
  • JIRA database is configured in UTF8.
    You can try using the following command to see what character encoding is set for the database:

    use jiradb;
    status;
    show variables like '%char%';
    

    If the result is not shown as UTF8, you need to reconfigure your MySQL by running the MySQL Server Instance Configuration Wizard and select utf8 as the default character set/collation. After the setting, restart MySQL and see that fixes the problem.

Last modified on Aug 26, 2013

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.