Unique Content Analytics view is empty when using MySQL as DB repository for Confluence
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When attempting to view the Unique Content Analytics of any Space, the graph shows no values or is an empty graph.
Environment
Confluence 7.19.x, 8.5.x
Database MySQL 8
Diagnosis
The Analytics graph will be shown as the one below, instead of being populated with data:
There are no errors in the Confluence logs or in the HAR files collected. However, if you run the following SQL statement in MySQL is returned a null value.
1
select convert_tz('2022-06-20 00:03:08.5220', 'SYSTEM', 'UTC');⚠️ If the query returns null, you may be impacted by this issue.
Cause
The output of the SQL statements executed against the MySQL database when retrieving the Unique values, return null.
This may be caused by an empty or missing record from mysql.time_zone table.
Solution
Check with your MySQL DBA to review the following functions used in the query:
Double check that your mysql.time_zone is loaded as it is used for the convert_tz function as outlined in the MySQL official docs to Load the Time Zone tables.
If the issue perists, reach out to Atlassian Support and generate and upload a Support Zip.
Was this helpful?