-
Type:
Bug
-
Resolution: Cannot Reproduce
-
Priority:
Low
-
None
-
Affects Version/s: 10.3.6
-
Component/s: Upgrade
-
None
-
10.03
-
1
-
Severity 3 - Minor
Issue Summary
Upgrading Jira from 9.12.23 to 10.3.6 creates database errors in the upgrade log which removes the color theme from Jira once the upgrade is complete.
Database is MySQL version 8.0.15

Steps to Reproduce
- Set up a Jira instance environment 9.12.23 and use a MySQL 8.0.15 version
- Upgrade from Jira 9.12.23 to 10.3.6
- Navigate to profile menu and see that the colour theme option is missing
Expected Results
Color theme menu from the profile menu should be available
Actual Results
Colour selection theme is missing

Error log showing when upgrade is complete
025-07-03 02:23:01,929+0200 Caesium-1-1 ERROR [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [host,buildNumber=9150000] failed java.lang.RuntimeException: Error running original upgrade task at com.atlassian.jira.upgrade.AbstractUpgradeTask.runUpgrade(AbstractUpgradeTask.java:63) at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.runOneUpgradeTask(DefaultUpgradeTaskFactoryProcessor.java:109) at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.lambda$performUpgradesUnsafe$13(DefaultUpgradeTaskFactoryProcessor.java:80) at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:178) at java.base/java.util.stream.SortedOps$RefSortingSink.end(SortedOps.java:400) at java.base/java.util.stream.Sink$ChainedReference.end(Sink.java:258) at java.base/java.util.stream.AbstractPipeline.copyIntoWithCancel(AbstractPipeline.java:528) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:513) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.FindOps$FindOp.evaluateSequential(FindOps.java:150) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.ReferencePipeline.findFirst(ReferencePipeline.java:647) at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.performUpgradesUnsafe(DefaultUpgradeTaskFactoryProcessor.java:81) at com.atlassian.upgrade.core.DefaultUpgradeTaskFactoryProcessor.performUpgrades(DefaultUpgradeTaskFactoryProcessor.java:46) at com.atlassian.upgrade.core.DefaultUpgradeTaskManager.upgradeHostApp(DefaultUpgradeTaskManager.java:41) at com.atlassian.jira.upgrade.LicenseCheckingUpgradeService.executeUpgrades(LicenseCheckingUpgradeService.java:134) at com.atlassian.jira.upgrade.LicenseCheckingUpgradeService.runUpgrades(LicenseCheckingUpgradeService.java:97) at com.atlassian.jira.upgrade.ClusterLockingUpgradeService.runUpgrades(ClusterLockingUpgradeService.java:35) at com.atlassian.jira.upgrade.LoggingUpgradeService.lambda$runUpgradesWithLogging$0(LoggingUpgradeService.java:28) at com.atlassian.jira.upgrade.LoggingUpgradeService.runWithTaskLogging(LoggingUpgradeService.java:43) at com.atlassian.jira.upgrade.LoggingUpgradeService.runUpgradesWithLogging(LoggingUpgradeService.java:28) at com.atlassian.jira.upgrade.IndexingUpgradeService.runUpgrades(IndexingUpgradeService.java:19) Caused by: com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for delete from propertyentry where propertyentry.id in (with preload as (select propertyentry.id, propertyentry.entity_name, propertyentry.entity_id, propertyentry.property_key from propertyentry propertyentry) select preload.id from preload preload inner join (select max(propertyentry.id) as latest_id, propertyentry.entity_name, propertyentry.entity_id, propertyentry.property_key from propertyentry propertyentry group by propertyentry.entity_name, propertyentry.entity_id, propertyentry.property_key having count(propertyentry.id) > ?) as latest_property_having_duplicates on latest_property_having_duplicates.entity_name = propertyentry.entity_name and latest_property_having_duplicates.entity_id = propertyentry.entity_id and latest_property_having_duplicates.property_key = propertyentry.property_key where propertyentry.id != latest_id) at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) at com.querydsl.sql.Configuration.translate(Configuration.java:507) at com.querydsl.sql.dml.AbstractSQLDeleteClause.execute(AbstractSQLDeleteClause.java:215) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build9150000.lambda$doUpgrade$1(UpgradeTask_Build9150000.java:80) at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$execute$1(DefaultQueryDslAccessor.java:86) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:77) at com.atlassian.jira.database.DefaultQueryDslAccessor$1.execute(DefaultQueryDslAccessor.java:85) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build9150000.doUpgrade(UpgradeTask_Build9150000.java:74) at com.atlassian.jira.upgrade.AbstractUpgradeTask.runUpgrade(AbstractUpgradeTask.java:61) ... 34 more Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'propertyentry.entity_name' in 'on clause' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) 2025-07-03 02:23:01,951+0200 Caesium-1-1 WARN [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Failed to complete upgrade task [factory=host,buildNumber=9150000] 2025-07-03 02:23:01,953+0200 Caesium-1-1 INFO [c.a.j.upgrade.util.BuildNumberDao] Setting current build number to 960000 2025-07-03 02:23:01,953+0200 Caesium-1-1 ERROR [c.a.jira.upgrade.LicenseCheckingUpgradeService] There was an error running the upgrades 2025-07-03 02:23:01,953+0200 Caesium-1-1 INFO [c.a.j.upgrade.util.BuildNumberDao] Setting current version to 10.3.6 2025-07-03 02:23:01,954+0200 Caesium-1-1 INFO [c.a.j.upgrade.util.BuildNumberDao] Setting downgrade version to 7.1.2 2025-07-03 02:23:01,958+0200 Caesium-1-1 INFO [c.a.jira.upgrade.LoggingUpgradeService] run upgrades has finished unsuccessfully, and took 1295 milliseconds to process. 2025-07-03 02:23:01,958+0200 Caesium-1-1 ERROR [c.a.jira.upgrade.UpgradeScheduler] Error occurred during execution of upgrades com.atlassian.jira.upgrade.UpgradeException * The upgrade task manager has returned a non-successful result from running the upgrades at com.atlassian.jira.upgrade.UpgradeScheduler.runHostUpgrades(UpgradeScheduler.java:103) at com.atlassian.jira.upgrade.UpgradeScheduler.runUpgrades(UpgradeScheduler.java:80) at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134) at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106) at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:500) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:495) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:519) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:415) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35) at java.base/java.lang.Thread.run(Thread.java:840) 2025-07-03 02:23:03,673+0200 Caesium-1-3 DEBUG U80854893 [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.jira.jira-email-processor-plugin] 2025-07-03 02:23:06,253+0200 Caesium-1-4 DEBUG ServiceRunner [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.jira.plugins.inform.event-plugin] 2025-07-03 02:23:12,715+0200 ForkJoinPool.commonPool-worker-1 ERROR [c.a.j.migration.httpclient.BackOffHttpRequestRetryHandler] Will not retry. Exceeds maximum retry count of 5 of org.apache.http.conn.ConnectTimeoutException 2025-07-03 02:23:12,718+0200 ForkJoinPool.commonPool-worker-1 ERROR [c.atlassian.fx3.Fx3Client] Unexpected error occurs fetching launch darkly feature flags: An error occurred when requesting against HTTP POST https://api.atlassian.com/flags/api/v2/frontend/featureFlagValues: Connect to api.atlassian.com:443 [api.atlassian.com/13.227.180.4] failed: Connect timed out com.atlassian.jira.migration.httpclient.exceptions.HttpCommunicationException: An error occurred when requesting against HTTP POST https://api.atlassian.com/flags/api/v2/frontend/featureFlagValues: Connect to api.atlassian.com:443 [api.atlassian.com/13.227.180.4] failed: Connect timed out at com.atlassian.jira.migration.httpclient.exceptions.ExceptionsKt.communicationError(Exceptions.kt:15) at com.atlassian.jira.migration.httpclient.AbstractPluginHttpClient.handleHttpCommunicationError(AbstractPluginHttpClient.kt:97) at com.atlassian.jira.migration.httpclient.AbstractPluginHttpClient.getResponse(AbstractPluginHttpClient.kt:199) at com.atlassian.jira.migration.fx3.Fx3ObjectMapperFactory$createFx3HttpCallback$1.post(Fx3ObjectMapperFactory.kt:100) at com.atlassian.fx3.Fx3Client.fetch(Fx3Client.kt:188) at com.atlassian.fx3.Fx3Client.fetchFlags(Fx3Client.kt:165) at com.atlassian.fx3.Fx3Client.access$fetchFlags(Fx3Client.kt:41) at com.atlassian.fx3.Fx3Client$Companion.init(Fx3Client.kt:67) at com.atlassian.jira.migration.fx3.Fx3PluginClientImpl$1.invoke(Fx3PluginClientImpl.kt:60) at com.atlassian.jira.migration.fx3.Fx3PluginClientImpl$1.invoke(Fx3PluginClientImpl.kt:59) at com.atlassian.jira.migration.fx3.Fx3PluginClientImpl.tryGetFx3Client$lambda$13$lambda$12(Fx3PluginClie
Workaround
No workaround yet