Fatal Error after Update MariaDB

[Sascha Zänker]

Hey there,

after i update MariaDB from 10.5 to 10.6 i've got a fatal error message when i try to start confluence.

Detected tables with non-default character encoding. See https://confluence.atlassian.com/x/TABrFw

I already did the stuff atlassian tell me to do (How to Fix the Collation and Character Set of a MySQL Database manually) but it doesnt work. I've changed

character-set-server=utf8mb4
collation-server=utf8mb4_bin

in my.cnf too.

Did you just got any idea how to handle?

[Nic Brough -Adaptavist-]

As mentioned before, the fact that MariaDB is not supported really limits your options.

You've tried everything that might reasonably be assumed to fix it, so the next place to look is the software that is using it (meaning your Confluence).  As that states it does not support the use of MariaDB, you're not going to get any help with it, and I think the only thing you can do is migrate to a supported database.  If the error still occurs when you're on a supported database, you can then get support from Atlassian!

[Kishan Sharma]

Hi @Sascha Zänker the supported platforms link suggests that Confluence will not work on MySQL variants such as:

• MariaDB - see CONFSERVER-29060

You can try running the diagnostic queries to find the tables with the non-default collation: How to Fix the Collation and Character Set of a MySQL Database

[Sascha Zänker]

Hey there,

yes i tried that but it dont work as well.

I need mariadb for other applications so i used it so far and it was working well until the update

[Kishan Sharma]

Hm, then i think you are short of options here!

[Alexis Robert]

Hi @Sascha Zänker , 

at the moment MariaDB is not supported by Atlassian - this might not be at all the reason of the error you're having, but it means that Support will probably not help in this case.

For your issue, I would suggest maybe converting the existing tables to UTF8MB4, as just changing the setting will not fix the issue.

You can find more information on how to convert tables here : https://confluence.atlassian.com/kb/how-to-fix-the-collation-and-character-set-of-a-mysql-database-manually-744326173.html

Let me know if this helps, 

--Alexis

[Sascha Zänker]

Hey there,

i know that mariadb is not supported. But i works very good until now.

I already converted all table an collums but without a solution.