MariaDB incompatibility?

[dgm...@gmail.com]

Dear all,

I am using MariaDB with Ubuntu 18.

mysql  Ver 15.1 Distrib 10.3.22-MariaDB

When following the installation instructions, at some point I have to create a database using the following command:

sudo mysql -h localhost -u root -p -e "CREATE DATABASE atomtest CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;"

I get the following error:

ERROR 1273 (HY000) at line 1: Unknown collation: 'utf8mb4_0900_ai_ci'

I think this might be a compatibility issue with Maria DB.

if I change the end of the string to this: "utf8 COLLATE utf8_unicode_ci;"

Then, i can create the database the problem is that I am not sue if this will cause other compatibility issues.

Is this workaround OK or should we have to switch over from MariaDB to MySQL?

Thanks!

Daniel

[raddao...@gmail.com]

Hi Daniel,

It looks like you're using a version of MariaDB representative of MySQL 5.7. AtoM 2.6 requires MySQL 8.0 and, while it's not officially supported it could work with MariaDB, but you'll need to use version 10.5 or 10.4.

https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/

Best regards. 

[dgm...@gmail.com]

Thanks, Rad,

You are right, of course! I thought Maria DB was updated to the latest version but I just I found out that MariaDB is not updated automaticall. It seems that the upgrade is a bit cumbersome...

I will look into it. Thanks again.

Daniel

[dgm...@gmail.com]

Hi, Rad,

Just to metion that I haveupgraded my MariaDB installation and I have the same error when I try to create a new database:

sudo mysql -h localhost -u root -p -e "CREATE DATABASE atomtest CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;"

This line resulst in this error.

ERROR 1273 (HY000) at line 1: Unknown collation: 'utf8mb4_0900_ai_ci'

I can use a different collation just to have the database created but then when I run the upgrade command:

php -d memory_limit=-1 symfony tools:upgrade-sql

The upgrade tool closes with the following error:

SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_0900_ai_ci"

I have seem some reports about the latest releases of MariaDB not being 100% compatible with mySQL8.

Could it be that AtoM is cannot work anymore with MariaDB?  Has anybody been able to use AtoM 2.6 with MariaDB?

I realise it is not officially supported by until now it was working fine.

Daniel

[José Raddaoui]

Hi Daniel,

I'm sorry to say that you're right. It looks like MariaDB has not included the Unicode 9 collations (yet?):

https://mariadb.com/docs/reference/cs10.5/collations/ 

Therefore, AtoM 2.6 won't work in the available MariaDB releases at the moment without code changes. If MySQL is the problem, you could try Percona 8, it's not officially supported either but we've been using it in development.

Best regards,

Radda.

[dgm...@gmail.com]

Thanks, for confirming, Radda! At least I know I am not doing anything wrong!

You might want to modify the 2.6 documentation and remove your reference MariaDB ("Also, we’ve experienced very good results using forks like Percona Server or MariaDB, so don’t be afraid and use them if you want!") because it reads as if you had installed Atom 2.6 with MariaDB, which is not the case.

https://www.accesstomemory.org/es/docs/2.6/admin-manual/installation/linux/ubuntu-bionic/

Thanks for pointer about Percona! I will have a look at it.

Daniel

[José Raddaoui]

No problem Daniel,

Thank you for being an early adopter and for finding and reporting the incompatibility. We're working on the documentation:

https://github.com/artefactual/atom-docs/pull/160

Bests,

Radda.