Exception getting property 'jira.lf.date.relativize' from database. Using default
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Problem
Multiple WARN messages on this exception is showing on the logs
The following appears in the catalina.out log
2016-03-30 19:22:03,003 http-bio-8037-exec-10 WARN INTERNAL-Admin 1162x1042x1 is9j4t 127.0.0.1 /rest/activity-stream/1.0/preferences [jira.config.properties.ApplicationPropertiesImpl] Exception getting property 'jira.lf.date.relativize' from database. Using default
Diagnosis
Diagnostic Steps
Run this SQL query on the database to determine whether there is any value set for that
select * from propertyentry where property_key = 'jira.lf.date.relativize';
- If there is a value , please proceed to the resolution below :
Cause
It is unclear how this entry is populated in the database as if the user would like to disable relative dates, the only step is to add a line to the jira-config.properties file as per Disable relative dates in JIRA applications
Resolution
Run the query below to remove the entry from the database and then restart JIRA.
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
delete FROM propertyentry where property_key = 'jira.lf.date.relativize';