You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Raffaele Gambelli (Jira)" <ji...@apache.org> on 2024/10/10 22:46:00 UTC

[jira] [Created] (OAK-11185) RDB: MariaDB (MySQL) support

Raffaele Gambelli created OAK-11185:
---------------------------------------

             Summary: RDB: MariaDB (MySQL) support
                 Key: OAK-11185
                 URL: https://issues.apache.org/jira/browse/OAK-11185
             Project: Jackrabbit Oak
          Issue Type: Bug
          Components: rdbmk
            Reporter: Raffaele Gambelli


Oak with mariadb database doesn't work, there are errors during table creation.

As jdbc url use a typical mariadb url like _jdbc:mariadb://localhost:3306_, here it is the exception:

{noformat}
2024.09.29 17:51:35.549 - *WARN * [main] o.m.jdbc.message.server.ErrorPacket: Error: 1074-42000: Column length too big for column 'DATA' (max = 16383); use BLOB or TEXT instead (warn in Slf4JLogger.java, line 99)
2024.09.29 17:51:35.549 - *ERROR* [main] o.a.j.o.p.d.rdb.RDBDocumentStore: Failed to create table 'CLUSTERNODES' in 'MariaDB - using default settings (jdbc:mariadb://localhost/default_tenant?user=default_tenant&password=***)' (createTableFor in RDBDocumentStore.java, line 1401)
java.sql.SQLSyntaxErrorException: (conn=4) Column length too big for column 'DATA' (max = 16383); use BLOB or TEXT instead
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289)
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378)
at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:172)
at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:915)
at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:854)
at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:773)
at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:697)
at org.mariadb.jdbc.Statement.executeInternal(Statement.java:1035)
{noformat}

I've set "CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci" as suggested [here|https://jackrabbit.apache.org/oak/docs/nodestore/document/rdb-document-store.html] 

----

I gave a look to RDBDocumentStoreDB and it's quite simple find the issue, it is not recognizing MariaDb, it only knows MySql so it uses DEFAULT when it comes MariaDb from DatabaseMetaData and so it uses the default getTableCreationStatement which has varchar which cannot work in MariaDb




--
This message was sent by Atlassian Jira
(v8.20.10#820010)