-
Bug
-
Resolution: Fixed
-
Low
-
10.2.0, 9.6.9
-
None
-
1
-
Severity 2 - Major
-
Issue Summary
Bamboo 9.5 or later accepts any product SEMVER returned by the MySQL-like server if it is >= 5.7
As per the Bamboo 9.5 Supported Platforms page, only MySQL 8 should be supported.
This is reproducible on Data Center: 
NOTE: The issue also manifests in other database types such as PostgreSQL, Oracle and MSSQL, where Bamboo only enforces the minimum version and doesn't validate the maximum version, even if it goes beyond what's listed on the Supported Platforms page
Steps to Reproduce
- Install MariaDB 10.3 (equivalent to MySQL 5.7)
- Install Bamboo 9.5 or later
- Configure Bamboo to point to the MariaDB 10.3 DB
- Continue the setup
Expected Results
- Bamboo should not accept the MariaDB 10.3 version as that's not MySQL and its SEMVER is > 8
Actual Results
- Bamboo accepts 10.3 as a valid MySQL version
- Accepting any database version raises concerns. For example, MariaDB 10.3 is equivalent to MySQL 5.7, which is not compatible with Bamboo versions 9.5 and later. Using this version of MariaDB/MySQL may lead to failures in Bamboo upgrade tasks and regular database operations, resulting in unexpected errors. This happens because the expected DDL used by modern versions of Bamboo can't be implemented in these older database versions.
Workaround
Currently, there is no known workaround for this behavior. A workaround will be added here when available
- mentioned in
-
Page Loading...
[BAM-25997] Bamboo will accept MySQL forks (Percona/Aurora/MariaDB/etc) when using the MySQL connector even if only MySQL is officially supported
| Fix Version/s | New: 11.0.0 [ 110791 ] |
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
| Remote Link | New: This issue links to "Page (Confluence)" [ 980096 ] |
| Support reference count | New: 1 |
| Component/s | New: Database (Postgresql) [ 12170 ] | |
| Component/s | New: Database (Oracle) [ 12661 ] | |
| Component/s | New: Database (MS SQL) [ 12660 ] |
| Fix Version/s | New: 10.2.1 [ 110796 ] |
| Status | Original: In Review [ 10051 ] | New: Waiting for Release [ 12075 ] |
| Description |
Original:
h3. Issue Summary
Bamboo 9.5 or later accepts any product SEMVER returned by the MySQL-like server if it is >= 5.7 As per the [Bamboo 9.5 Supported Platforms page|https://confluence.atlassian.com/bamboo0905/supported-platforms-1345817907.html], *only MySQL 8 should be supported*. This is reproducible on Data Center: (/) h3. Steps to Reproduce # Install MariaDB 10.3 (equivalent to MySQL 5.7) # Install Bamboo 9.5 or later # Configure Bamboo to point to the MariaDB 10.3 DB # Continue the setup h3. Expected Results # Bamboo should not accept the MariaDB 10.3 version as that's not MySQL and its SEMVER is > 8 h3. Actual Results # Bamboo accepts 10.3 as a valid MySQL version # Accepting any database version raises concerns. For example, MariaDB 10.3 is equivalent to MySQL 5.7, which is not compatible with Bamboo versions 9.5 and later. Using this version of MariaDB/MySQL may lead to failures in Bamboo upgrade tasks and regular database operations, resulting in unexpected errors. This happens because the expected DDL used by modern versions of Bamboo can't be implemented in these older database versions. h3. Workaround Currently there is no known workaround for this behavior. A workaround will be added here when available |
New:
h3. Issue Summary
Bamboo 9.5 or later accepts any product SEMVER returned by the MySQL-like server if it is >= 5.7 As per the [Bamboo 9.5 Supported Platforms page|https://confluence.atlassian.com/bamboo0905/supported-platforms-1345817907.html], {*}only MySQL 8 should be supported{*}. This is reproducible on Data Center: (/) {panel:bgColor=#ffebe6} *NOTE:* The issue also manifests in other database types such as PostgreSQL, Oracle and MSSQL, where Bamboo only enforces the minimum version and doesn't validate the maximum version, even if it goes beyond what's listed on the [Supported Platforms|https://confluence.atlassian.com/display/BAMBOO/Supported+platforms] page {panel} h3. Steps to Reproduce # Install MariaDB 10.3 (equivalent to MySQL 5.7) # Install Bamboo 9.5 or later # Configure Bamboo to point to the MariaDB 10.3 DB # Continue the setup h3. Expected Results # Bamboo should not accept the MariaDB 10.3 version as that's not MySQL and its SEMVER is > 8 h3. Actual Results # Bamboo accepts 10.3 as a valid MySQL version # Accepting any database version raises concerns. For example, MariaDB 10.3 is equivalent to MySQL 5.7, which is not compatible with Bamboo versions 9.5 and later. Using this version of MariaDB/MySQL may lead to failures in Bamboo upgrade tasks and regular database operations, resulting in unexpected errors. This happens because the expected DDL used by modern versions of Bamboo can't be implemented in these older database versions. h3. Workaround Currently, there is no known workaround for this behavior. A workaround will be added here when available |
| Status | Original: In Progress [ 3 ] | New: In Review [ 10051 ] |
From Bamboo 10.2.1 and later, the following message will be thrown during startup in case its version is not listed as compatible in the equivalent Supported platforms page.
If you are presented with such a message, please adjust the database version to a supported one or contact Atlassian Support to discuss further options.