Latest Centos 8 upgrade broke both Bitbucket and Confluence

Question

Updated Centos 8 to latest packages a few days ago and suddenly both Bitbucket and Confluence stopped working.  There was an initial error that affected both products where a variable set in the config pointed to a specific version of OpenJDK that was removed with the upgrade.  I fixed that, and now the error is neither product can connect to the mysql database.  I'm using mysql 8.0 from the Centos distribution, I can connect manually using the relevant credentials, the latest connector is in place, the database is there, but it never even seems to reach the database server on the same machine with both bitbucket and Confluence.  I'm reluctant to re-install the products, since I have code in bitbucket I don't want to have to re-upload.  There are "errors" in the logs but some seem to be bogus, and I can't tell which ones are actually relevant.  Anyone have any ideas where to look?  My guess is this has to do with OpenJDK, since Jira (which has an embedded JRE) still works.

atlassian-bitbucket-7.5.0-x64.bin
atlassian-confluence-7.4.3-x64.bin

java-11-openjdk-11.0.8.10-0.el8_2.x86_64
java-1.8.0-openjdk-headless-1.8.0.265.b01-0.el8_2.x86_64
java-11-openjdk-headless-11.0.8.10-0.el8_2.x86_64

kjhall55 · Answer

Funny, I installed it a couple of times before letting it "stabilize", and it worked perfectly.  It was only the latest update from Red Hat that broke it.

I'll try pulling the latest JRE from Oracle and see if that helps, but will also try the steps above.

Question:  Which version of JRE is recommended at this poing?

Diego_88dj6o · Answer

Hello @kjhall55 !

As I understand, after updating the server’s operating system, applications that rely on external JDK libraries stopped working.

According to our Supported Platforms documentation, Confluence will run only when using AdoptOpenJDK or Oracle JDK distributions:

You can only run Confluence with AdoptOpenJDK or Oracle JRE/JDK.

The full document can be found here:

* Supported Platforms

Since MySQL 8 is indeed supported by Confluence 7.4.x, I am inclined to believe that the JDK is our main issue here.

You can try and install any of the supported JDK versions for Confluence 7.4.x. Here is a  guide on how to install it:

* [Confluence Server] Confluence 7.4 - Installing Java for Confluence

Since we did not have a look at your logs, I would like to know if it would be possible to reset the logs and then try starting Confluence again. Resetting the logs should prompt Confluence to create a new file and then populate it with entries that will give us better insight into what is happening.

For you to reset the logs:

* Make sure that Confluence is not running
* Go into <confluence_home_folder>/logs/
* Backup the Atlassian-confluence.log file
* Delete the original Atlassian-confluence.log file
* Start Confluence
* Tail the logs and check the errors (if any) that come up when Confluence tries to start

If possible, share excerpts of the errors with us here in the community. Just be careful not to disclose any sensitive data with the excerpts. Our community is an open space and everyone can see everything that is posted here.

Let us hear from you!