Issue Summary
Jira Data Center fails to start after upgrading due to InvalidPropertyTypeException. This could be due to corrupt data existing in the property tables.
Steps to Reproduce
- Stop Jira.
- Insert corrupt synthetic data:
INSERT INTO propertyentry (id, entity_name, entity_id, property_key, propertytype) SELECT svi.seq_id, 'jira.properties', 1, 'sample.property.key', 5 FROM sequence_value_item svi WHERE svi.seq_name = 'OSPropertyEntry'; INSERT INTO propertynumber (id, propertyvalue) SELECT pe.id, 123 FROM propertyentry pe WHERE property_key = 'sample.property.key'; UPDATE sequence_value_item SET seq_id = seq_id + 100 WHERE seq_name = 'OSPropertyEntry';
3. Start Jira.
Expected Results
Jira should start up successfully.
Actual Results
The below exception is thrown in the atlassian-jira.log file:
2025-02-04 18:25:36,752+0000 JIRA-Bootstrap ERROR [c.a.j.component.pico.ComponentManager] Error occurred while initializing component 'com.atlassian.jira.plugin.JiraPluginPersistentStateStore'. Caused by: com.atlassian.cache.CacheException: com.opensymphony.module.propertyset.InvalidPropertyTypeException at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:214) at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:165) at com.atlassian.cache.impl.metrics.InstrumentedCache.get(InstrumentedCache.java:72) at com.atlassian.jira.cache.stats.CacheWithStats.get(CacheWithStats.java:46) at com.atlassian.jira.config.properties.v2.DefaultCachingApplicationPropertiesManager.getAllKeysInternal(DefaultCachingApplicationPropertiesManager.java:155) at com.atlassian.jira.config.properties.v2.DefaultCachingApplicationPropertiesManager.getAllKeys(DefaultCachingApplicationPropertiesManager.java:124) at com.atlassian.jira.config.properties.v2.ApplicationPropertiesBackedPropertySet.getKeys(ApplicationPropertiesBackedPropertySet.java:74)
Workaround
Detailed workaround is mentioned in the following article: Jira Data Center fails to start after upgrade due to InvalidPropertyTypeException