confluence setup makes problems

[Marco Bierbach]

Hello Everyone,

in the past year i was using Bitbucket mostly without jira and confluence. but as everything, stuff grows over the past and my team is in need of jira and confluence now.

So i was setting up Jira finally 100%, was updating it to the newest Version and also decided to finally install confluence. Why not using it if i pay for it ^^

I did the same steps as for jira, downloaded the server package, installed it over sudo ./package_name.bin with the same user as bitbucket and jira.

It installed fine, and i was also able to enter the installation page.

i was able to go till the point where i have to setup the database.

i was creating a database for confluence with utf8_bin 

i adjusted the jdbc string to also 

jdbc:mysql://127.0.0.1:3306/<my_dbname>?sessionVariables=tx_isolation='READ-COMMITTED'

was adding the username and password who also handles my bitbucket and jira just fine.

on pushing Testing Connection, it was everything okay and so i tapped next.

But then problems begann to spread.

first i got a 503 Gateway error from my nginx after some loading time.

when i reloaded the page, the stylesheet was gone, everything looked wird and it told me that the database already exists and if i wanna overwrite all the infos 

(this was the first point where i was like 'wft', because i had to create the db before, otherwise he would not have let me pass on the db linking process)

i tapped on overwrite as i do not care, the db is empty, so why not.

but then i got a big error showing me 

Unable to register MBean [com.atlassian.confluence.jmx.TaskQueueWrapper@7e3f04e2] with key 'Confluence:name=MailTaskQueue'; nested exception is javax.management.InstanceAlreadyExistsException: Confluence:name=MailTaskQueue

so i restarted confluence over

sudo /etc/init.d/confluence stop
sudo /etc/init.d/confluence start

and then i reload the page.

and got this

com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.IllegalStateException: Spring Application context has not been set
    at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)

caused by: java.lang.IllegalStateException: Spring Application context has not been set
    at com.atlassian.spring.container.SpringContainerContext.getComponent(SpringContainerContext.java:48)

I am honestly super confused as i just followed the guide on the atlassian page. and for jira and bitbucket they worked super fine. but now confluence is bringing me headache.

i hope someone can help me.

Kind regards

[Marco Bierbach · Accepted solution]

So problem has been solved for me.

I was checking some more documentations about mysql and mariadb and noticed that the version i used was to old in order to work with confluence.

i updated now to mariadb 10.2.13 and it works like a charm now.

[Marco Bierbach · Accepted solution]

So after searching the rest of the time now for possible reasons, i had to see that confluence other than jira and bitbucket, does not support mariadb until today.

this is pretty sad, but at least i know now what's wrong....

[Shannon S]

Hi Marco,

That is correct, many of our products do not support MariaDB.

If you want your voice heard, we do have a few feature requests for it where you can vote and comment with your use case.

• JRASERVER-32347 JIRA should support MariaDB
• CONFSERVER-29060 Support for MariaDB

Thank you for your understanding!

Regards,

Shannon

[Marco Bierbach]

Hello @Shannon S

thanks for getting back to me about this, i have already seen those tickets.

But as i said below, after i upgraded to the newest version of MariaDB 10.2.13 everything works now out of the box.

Jira also works with MariaDB 10.0.x same as Bitbucket does.

Confluence works witouth any issue with 10.2.13.

I think someone could mention this on your pages somewhere that MariaDB is inofficially supported with those versions.

Kind regards

Marco

[Shannon S]

Hi Marco,

Officially, MariaDB is not supported, thus the reason it is mentioned in our documentation.

• Is MariaDB supported by Confluence?

Is MariaDB Supported by Confluence?

MariaDB is not supported by Confluence. Confluence's internal code, as well as third-party plugins, assume you are using a supported database.

The reason that we do not support MariaDB is because we did not test our product with this type of database. Because of this, there might be several compatibility issues within the usage of Confluence and MariaDB. A number of problems can occur when using MariaDB.

The term "unsupported" means that we may not be able to help you in troubleshooting issues within your instance should it presents any problem.

I hope this is clear, but do let me know if you have any questions!

Regards,

Shannon

[digitalunityapps]

I have the same problem with but with MySql version: 

14.14 Distrib 5.7.23.How  i could fix it?