an error occurred while performing jira upgrade from 5.1 to 6.4.12

[pawan moolrajani]

2015-12-10 08:18:06,271 localhost-startStop-1 INFO      [atlassian.jira.upgrade.UpgradeManagerImpl] ___ Performing Upgrade ____________________ 2015-12-10 08:18:06,470 localhost-startStop-1 INFO      [atlassian.jira.upgrade.UpgradeManagerImpl] Performing Upgrade Task: Converting default Custom field values for User and MultiUser types to store the key of the user rather than the username. 2015-12-10 08:18:06,866 localhost-startStop-1 INFO      [jira.upgrade.tasks.UpgradeTask_Build6045] Updating custom field 'Approver List', 1 of 14 2015-12-10 08:18:06,871 localhost-startStop-1 ERROR      [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: java.lang.NullPointerException com.atlassian.cache.CacheException: java.lang.NullPointerException         at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:330)         at com.atlassian.jira.issue.fields.config.persistence.CachedFieldConfigSchemePersister.getConfigSchemesForCustomField(CachedFieldConfigSchemePersister.java:109)         at com.atlassian.jira.issue.fields.config.manager.FieldConfigSchemeManagerImpl.getConfigSchemesForField(FieldConfigSchemeManagerImpl.java:81)         at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6045.processCustomFieldDefaults(UpgradeTask_Build6045.java:76)         at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6045.doUpgrade(UpgradeTask_Build6045.java:69)         at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:814)         at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:681)         at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:540)         at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:475)         at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:410)         at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:107)         at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:55)         at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:49)         at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:140)         at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:345)         at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:215)         at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:124)         at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:33)         at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:86)         at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)         at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:81)         at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:72)  <+5> (StandardContext.java:4992) (StandardContext.java:5490) (LifecycleBase.java:150) (ContainerBase.java:1575) (ContainerBase.java:1565)         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)         at java.util.concurrent.FutureTask.run(FutureTask.java:166)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)         at java.lang.Thread.run(Thread.java:722) Caused by: java.lang.NullPointerException         at com.atlassian.jira.issue.fields.config.persistence.FieldConfigSchemePersisterImpl$1.apply(FieldConfigSchemePersisterImpl.java:233)         at com.atlassian.jira.issue.fields.config.persistence.FieldConfigSchemePersisterImpl$1.apply(FieldConfigSchemePersisterImpl.java:229)         at com.google.common.collect.Iterators$7.computeNext(Iterators.java:649)         at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143)         at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138)         at com.google.common.collect.Lists.newArrayList(Lists.java:119)         at com.atlassian.jira.issue.fields.config.persistence.FieldConfigSchemePersisterImpl.getConfigSchemesForCustomField(FieldConfigSchemePersisterImpl.java:228)         at com.atlassian.jira.issue.fields.config.persistence.CachedFieldConfigSchemePersister.access$401(CachedFieldConfigSchemePersister.java:42)         at com.atlassian.jira.issue.fields.config.persistence.CachedFieldConfigSchemePersister$FieldConfigSchemeByFieldCacheLoader.load(CachedFieldConfigSchemePersister.java:215)         at com.atlassian.jira.issue.fields.config.persistence.CachedFieldConfigSchemePersister$FieldConfigSchemeByFieldCacheLoader.load(CachedFieldConfigSchemePersister.java:209)         at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:132)         at com.atlassian.cache.memory.BlockingCacheLoader.load(BlockingCacheLoader.java:51)         at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3573)         at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2350)         at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2313)         at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2228)         at com.google.common.cache.LocalCache.get(LocalCache.java:3970)         at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)         at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4834)         at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:324)         ... 31 more 2015-12-10 08:18:06,916 localhost-startStop-1 INFO      [ext.bamboo.service.PlanStatusUpdateServiceImpl] Job 'com.atlassian.jira.plugin.ext.bamboo.service.PlanStatusUpdateServiceImpl:job' scheduled to run every 60000ms 2015-12-10 08:18:06,941 localhost-startStop-1 INFO      [plugins.hipchat.service.HipChatPluginLauncher] HipChat Plugin launched successfully 2015-12-10 08:18:06,951 localhost-startStop-1 INFO      [plugins.dvcs.scheduler.DvcsScheduler] DvcsScheduler job handler registered

[Vasiliy Zverev]

Try to create bug reques on JIRA tracer: https://jira.atlassian.com/secure/Dashboard.jspa

[pawan moolrajani]

So when I check the list for approver list (ID is 20503) by the provided query. Got the following columns with null (defaultvalue, fieldtype, project, issuetype, parentkey, numbervalue, textvalue, datevalue, valuetype) and following columns with not null value (ID, customfieldtypekey,CUSTOMFIELDSEARCHERKEY,cfname, description, id, issue, customfield, stringvalue) .
I think if STRINGVALUE is there it should not cry !

[Vasiliy Zverev]

I could suggest that trouble is related to custom field "Approver List". Try to check values for this field. I usually use this SQL query:

Select
	customfield.*
	, customfieldvalue.*
from
	customfield
	join customfieldvalue	
		join jiraissue	
		on	customfieldvalue.ISSUE = jiraissue.ID
	on	customfield.ID = customfieldvalue.CUSTOMFIELD
where
	customfield.ID = 11900

Try to find any nulls for this field values (table customfieldvalue)