8.22.6 install using PostgreSQL 11 fails upgrade tasks (bitbucket and development integration)

[Reese]

Hi.

I have a test instance on 8.22.6 using MySQL 5.7 and these tasks have been fine.

When I install on PostgreSQL 11 on the same version or on 9.4 LTS I get the following:

com.atlassian.jira.plugins.jira-bitbucket-connector-plugin build 2 and com.atlassian.jira.plugins.jira-development-integration-plugin build 3 fail to upgrade with errors like:

2023-07-09 13:08:59,521+0000 localhost-startStop-1 ERROR [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [com.atlassian.jira.plugins.jira-development-integration-plugin,buildNumber=3] failed
com.atlassian.jira.plugin.devstatus.upgrade.UpgradeFailedException: java.util.concurrent.ExecutionException: com.querydsl.core.QueryException: Caught PSQLException for insert into "AO_575BF5_DEV_SUMMARY" ("ISSUE_ID", "PROVIDER_SOURCE_ID", "JSON", "CREATED", "UPDATED")
select "entity_property"."entity_id", "entity_property"."property_key", "entity_property"."json_value", "entity_property"."created", "entity_property"."updated" from "entity_property" "entity_property" where "entity_property"."entity_name" = ? and "entity_property"."updated" < ?
at com.atlassian.jira.plugin.devstatus.upgrade.devsummary.migration.DevSummaryMigrationHandler.doOperationWithRetry(DevSummaryMigrationHandler.java:125)
at com.atlassian.jira.plugin.devstatus.upgrade.devsummary.migration.DevSummaryMigrationHandler.processRowsWithRetryingOnFail(DevSummaryMigrationHandler.java:113)
at com.atlassian.jira.plugin.devstatus.upgrade.devsummary.migration.DevSummaryMigrationHandler.beginMigration(DevSummaryMigrationHandler.java:96)
at com.atlassian.jira.plugin.devstatus.upgrade.devsummary.migration.DevSummaryMigrationHandler.startMigration(DevSummaryMigrationHandler.java:64)
at com.atlassian.jira.plugin.devstatus.upgrade.UpgradeTask_Build03.runUpgrade(UpgradeTask_Build03.java:43)
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:176)
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:503)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:488)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
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:543)
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.lambda$upgradePlugin$1(DefaultUpgradeTaskManager.java:69)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.reduce(ReferencePipeline.java:553)
at com.atlassian.upgrade.core.DefaultUpgradeTaskManager.upgradePlugin(DefaultUpgradeTaskManager.java:70)
at com.atlassian.jira.upgrade.PluginUpgradeManager.upgradePlugin(PluginUpgradeManager.java:50)
at com.atlassian.jira.upgrade.PluginUpgradeListener.onPluginInstall(PluginUpgradeListener.java:81)
at jdk.internal.reflect.GeneratedMethodAccessor190.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:42)
at com.atlassian.event.internal.ComparableListenerInvoker.invoke(ComparableListenerInvoker.java:48)
at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.lambda$null$0(AsynchronousAbleEventDispatcher.java:37)
at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:85)
at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:114)
at com.atlassian.event.internal.LockFreeEventPublisher.publish(LockFreeEventPublisher.java:40)
at com.atlassian.plugin.event.impl.DefaultPluginEventManager.broadcast(DefaultPluginEventManager.java:90)
at com.atlassian.plugin.manager.DefaultPluginManager.broadcastIgnoreError(DefaultPluginManager.java:1972)
at com.atlassian.plugin.manager.DefaultPluginManager.lambda$broadcastPluginEnabled$41(DefaultPluginManager.java:1782)
at com.atlassian.plugin.manager.PluginTransactionContext.wrap(PluginTransactionContext.java:63)
at com.atlassian.plugin.manager.DefaultPluginManager.broadcastPluginEnabled(DefaultPluginManager.java:1781)
at com.atlassian.plugin.manager.DefaultPluginManager.lambda$enableDependentPlugins$24(DefaultPluginManager.java:1260)
at com.atlassian.plugin.manager.PluginTransactionContext.wrap(PluginTransactionContext.java:63)
at com.atlassian.plugin.manager.DefaultPluginManager.enableDependentPlugins(DefaultPluginManager.java:1229)
at com.atlassian.plugin.manager.DefaultPluginManager.lambda$addPlugins$22(DefaultPluginManager.java:1214)
at com.atlassian.plugin.manager.PluginTransactionContext.wrap(PluginTransactionContext.java:63)
at com.atlassian.plugin.manager.DefaultPluginManager.addPlugins(DefaultPluginManager.java:1114)
at com.atlassian.jira.plugin.JiraPluginManager.addPlugins(JiraPluginManager.java:157)
at com.atlassian.plugin.manager.DefaultPluginManager.lambda$earlyStartup$5(DefaultPluginManager.java:593)
at com.atlassian.plugin.manager.PluginTransactionContext.wrap(PluginTransactionContext.java:63)
at com.atlassian.plugin.manager.DefaultPluginManager.earlyStartup(DefaultPluginManager.java:528)
at com.atlassian.jira.plugin.JiraPluginManager.earlyStartup(JiraPluginManager.java:119)
at com.atlassian.jira.component.pico.ComponentManager$PluginSystem.earlyStartup(ComponentManager.java:671)
at com.atlassian.jira.component.pico.ComponentManager.earlyStartPluginSystem(ComponentManager.java:239)
at com.atlassian.jira.upgrade.PluginSystemLauncher.start(PluginSystemLauncher.java:45)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:143)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:307)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:202)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:135)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:102)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:100)
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154)
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuffInBackground(LauncherContextListener.java:139)
at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:101)
... 5 filtered
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)

And:

Caused by: org.postgresql.util.PSQLException: ERROR: relation "AO_575BF5_DEV_SUMMARY" does not exist
Position: 13
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)
at com.querydsl.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:382)
... 104 more
2023-07-09 13:09:01,779+0000 localhost-startStop-1 WARN [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Failed to complete upgrade task [factory=com.atlassian.jira.plugins.jira-development-integration-plugin,buildNumber=3]

I've checked and these tables exist, the database version is supported but com.atlassian.jira.plugins.jira-development-integration-plugin (build 3) and com.atlassian.jira.plugins.jira-bitbucket-connector-plugin (build 2) don't succeed.

I have tested 9.4 LTS and it's not resolved in this version either. Anyone got any ideas how I can resolve the upgrade task for these modules?

Just tried on MySQL 8:

 [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [factory=com.atlassian.jira.plugins.jira-bitbucket-connector-plugin,buildNumber=1] completed in 760397 milliseconds
2023-07-10 12:41:34,727+0000 http-nio-8080-exec-1 INFO anonymous 739x2833x8 1iwismz 107.181.136.199,10.42.42.113 /secure/SetupDatabase!default.jspa [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [factory=com.atlassian.jira.plugins.jira-bitbucket-connector-plugin,buildNumber=2] completed in 1881 milliseconds
2023-07-10 12:41:34,735+0000 http-nio-8080-exec-1 INFO anonymous 739x2833x8 1iwismz 107.181.136.199,10.42.42.113 /secure/SetupDatabase!default.jspa [c.a.jira.upgrade.UpgradeIndexManager] Reindexing is not allowed after this upgrade and there is no immediate reindex requests
2023-07-10 12:41:53,569+0000 http-nio-8080-exec-1 INFO anonymous 739x2833x8 1iwismz 107.181.136.199,10.42.42.113 /secure/SetupDatabase!default.jspa [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [factory=com.atlassian.jira.plugins.jira-development-integration-plugin,buildNumber=1] completed in 13033 milliseconds
2023-07-10 12:41:54,145+0000 http-nio-8080-exec-1 INFO anonymous 739x2833x8 1iwismz 107.181.136.199,10.42.42.113 /secure/SetupDatabase!default.jspa [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [factory=com.atlassian.jira.plugins.jira-development-integration-plugin,buildNumber=2] completed in 493 milliseconds
2023-07-10 12:42:57,750+0000 http-nio-8080-exec-1 INFO anonymous 739x2833x8 1iwismz 107.181.136.199,10.42.42.113 /secure/SetupDatabase!default.jspa [c.a.upgrade.core.DefaultUpgradeTaskFactoryProcessor] Upgrade task [factory=com.atlassian.jira.plugins.jira-development-integration-plugin,buildNumber=3] completed in 63230 milliseconds

There's definitely issues with PostgreSQL 11. I also tried it on v14. Same issue.