Bamboo does not start when connecting to Azure Database for MySQL

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

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.

*Fisheye および Crucible は除く

要約

When connecting Bamboo to Azure Database for MySQL the start up process will fail with error "Bamboo doesn't support MySQL version 5.6.47.0" regardless of using a newer version of Azure MySQL.

環境

Bamboo 8.x or newer.

MySQL 5.7 or newer.

診断

When starting Bamboo after connecting to Azure Database for MySQL the startup process will fail with the following error:

2021-11-03 09:14:10,934 INFO [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] Testing compatibility of [MySQL] 5.6.47 (5.6.47.0) using JDBC driver [MySQL Connector Java] 5.1.0 (mysql-connector-java-5.1.49 ( Revision: ad86f36e100e104cd926c6b81c8cab9565750116 )) with this version of Bamboo.
2021-11-03 09:14:10,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] Detected MYSQL version [MySQL] 5.6.47 (5.6.47.0), minimal supported version is 5.7.0
2021-11-03 09:14:10,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] Bamboo doesn't support MySQL version 5.6.47.0. Please check https://confluence.atlassian.com/display/BAMBOO/Supported+Platforms for more information.
2021-11-03 09:14:10,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [DatabaseIsSupported] For avoiding failure please set system property bamboo.upgrade.fail.if.mysql.unsupported to true
2021-11-03 09:14:10,934 ERROR [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 51111 failed
com.atlassian.upgrade.UpgradeException: Bamboo doesn't support MySQL version 5.6.47.0. Please check https://confluence.atlassian.com/display/BAMBOO/Supported+Platforms for more information.
       at com.atlassian.bamboo.upgrade.tasks.validation.DatabaseIsSupported.doUpgrade(DatabaseIsSupported.java:92)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTask(BootstrapUpgradeManagerImpl.java:131)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.lambda$runValidationTasks$0(BootstrapUpgradeManagerImpl.java:89)
       at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.forEachTask(AbstractUpgradeManager.java:195)
       at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.runValidationTasks(BootstrapUpgradeManagerImpl.java:89)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.runValidationTasks(DefaultBootstrapManager.java:492)
       at com.atlassian.bamboo.setup.DefaultBootstrapManager.postBootstrapDatabase(DefaultBootstrapManager.java:419)

原因


Azure Database for MySQL uses a gateway node in front of the database to redirect the connections to the server instance. This gateway can advertise a different version of MySQL than the actual server behind it causing Bamboo to fail the start up process as Bamboo believes that it's connecting to an old unsupported version of MySQL.

This is mentioned in the following document from Azure: Supported Azure Database for MySQL server versions.

"In the Single Server deployment option, a gateway is used to redirect the connections to server instances. After the connection is established, the MySQL client displays the version of MySQL set in the gateway, not the actual version running on your MySQL server instance."

ソリューション

1. Stop Bamboo

2. Edit the <bamboo_installation_directory>/bin/setenv.sh if on Linux or <bamboo_installation_directory>/bin/setenv.bat file if on Windows

3. Add the following property to the JVM_SUPPORT_RECOMMENDED_ARGS variable: -Dbamboo.upgrade.fail.if.mysql.unsupported=false. Your setenv file should look similar to this (the parameters are added space separated if there are more than one):

# Occasionally Atlassian Support may recommend that you set some specific JVM arguments. You can use this variable below to do that.
#
: ${JVM_SUPPORT_RECOMMENDED_ARGS:="-Dbamboo.upgrade.fail.if.mysql.unsupported=false"}

4. Start Bamboo

Note: If you are using a Windows service please follow the steps on the document below to add the property instead:

最終更新日 2021 年 11 月 5 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.