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)