KC 26.4 mariadb version requirement #43093

gvde · 2025-09-30T17:14:45Z

gvde
Sep 30, 2025

I have been looking into the upgrade from 26.3.5 to 26.4 but it failed during start:

2025-09-30 18:54:47,979 INFO  [com.arjuna.ats.jbossatx] (main) ARJUNA032014: Stopping transaction recovery manager
ERROR: Failed to start server in (production) mode
ERROR: [PersistenceUnit: keycloak-default] Unable to build Hibernate SessionFactory
ERROR: Persistence unit 'keycloak-default' was configured to run with a database version of at least '10.6.0', but the actual version is '10.5.27'. Consider upgrading your database. Alternatively, rebuild your application with 'jakarta.persistence.database-product-version=10.5.27' (but this may disable some features and/or impact performance negatively).
For more details run the same command passing the '--verbose' option. Also you can use '--help' to see the details about the usage of the particular command.

MariaDB 10.5.27 is the version bundled with EL9. As it's a galera cluster with a couple of important databases running, I cannot upgrade the database cluster to mariadb-10.11 module at this time.

I have tried to figure out how to set the property mentioned in the error message (for instance #35279 ) but failed so far. I have created a jar file containing default-persistence.xml with the property jakarta.persistence.database-product-version set to value 10.5.27, but the jar into the providers directory and run build and start. Same error.

Can anyone explain what I need to do to let KC 26.4 run with a MariaDB 10.5 database?

shawkins · 2025-09-30T18:28:33Z

shawkins
Sep 30, 2025
Collaborator

What you are trying to do with the default-persistence.xml file is the known workaround.

However it appears that recent changes have broken that.

In KeycloakProcessor, parser.getClassLoaderService().locateResource("default-persistence.xml") is not aware of jars in the providers directory, while Thread.currentThread().getContextClassLoader().getResource("default-persistence.xml") was.

@mabartos do you recall why the context classloader isn't used anymore here - it is in the rest of the KeycloakProcessor. And/or do you consider this a bug in Quarkus?

19 replies

vmuzikar Oct 3, 2025
Collaborator

Would it be an option for you to include support for the mariadb legacy dialect in keycloak, i.e. giving the option to enable it at own risk (without hacking jar files...)?

We rarely introduce "unsupported by design" features to Keycloak. Keycloak is an enterprise grade product and try and make sure users don't need to navigate between supported and unsupported features when deploying it to production.

That said, there's the hidden db-dialect option that should allow you to use the legacy dialect, as mentioned above.

gvde Oct 3, 2025
Author

Oh, I have missed the mentioned db-dialect above. But it would still be missing the legacy dialects? Those would have to be added by me? Or did I understand it incorrectly?

But a hidden option would be enough for me at the moment. And it doesn't have to be "unsupported by design" but just support of older, deprecated thinks. RHEL is "RedHat Enterprise Linux" so I guess it's supposed to be an enterprise grade product, too, from which I don't want to navigate for the previously mentioned reasons... 😃

vmuzikar Oct 3, 2025
Collaborator

But it would still be missing the legacy dialects? Those would have to be added by me? Or did I understand it incorrectly?

The org.hibernate.orm.hibernate-community-dialects artifact is actually shipped with Keycloak. You could try setting db-dialect=org.hibernate.community.dialect.MariaDBLegacyDialect.

gvde Oct 8, 2025
Author

I have tested it today:

I have added db-dialect=org.hibernate.community.dialect.MariaDBLegacyDialect to keycloak.conf, ran build and then start:

$ /opt/keycloak/keycloak-26.4.0/bin/kc.sh start --verbose
ERROR: Failed to start server in (production) mode
Error details:
java.lang.RuntimeException: Failed to start quarkus
	at io.quarkus.runner.ApplicationImpl.<clinit>(Unknown Source)
	at java.base/jdk.internal.misc.Unsafe.allocateInstance(Native Method)
	at java.base/java.lang.invoke.DirectMethodHandle.allocateInstance(DirectMethodHandle.java:501)
	at io.quarkus.runtime.Quarkus.run(Quarkus.java:79)
	at org.keycloak.quarkus.runtime.KeycloakMain.start(KeycloakMain.java:139)
	at org.keycloak.quarkus.runtime.cli.Picocli.start(Picocli.java:910)
	at org.keycloak.quarkus.runtime.cli.command.AbstractAutoBuildCommand.runCommand(AbstractAutoBuildCommand.java:134)
	at org.keycloak.quarkus.runtime.cli.command.AbstractCommand.lambda$call$1(AbstractCommand.java:73)
	at java.base/java.util.Optional.orElseGet(Optional.java:364)
	at org.keycloak.quarkus.runtime.cli.command.AbstractCommand.call(AbstractCommand.java:72)
	at org.keycloak.quarkus.runtime.cli.command.AbstractCommand.call(AbstractCommand.java:37)
	at picocli.CommandLine.executeUserObject(CommandLine.java:2031)
	at picocli.CommandLine.access$1500(CommandLine.java:148)
	at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2469)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2461)
	at picocli.CommandLine$RunLast.handle(CommandLine.java:2423)
	at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
	at picocli.CommandLine$RunLast.execute(CommandLine.java:2425)
	at picocli.CommandLine.execute(CommandLine.java:2174)
	at org.keycloak.quarkus.runtime.cli.Picocli.parseAndRun(Picocli.java:118)
	at org.keycloak.quarkus.runtime.KeycloakMain.main(KeycloakMain.java:109)
	at org.keycloak.quarkus.runtime.KeycloakMain.main(KeycloakMain.java:83)
	at io.quarkus.bootstrap.runner.QuarkusEntryPoint.doRun(QuarkusEntryPoint.java:69)
	at io.quarkus.bootstrap.runner.QuarkusEntryPoint.main(QuarkusEntryPoint.java:37)
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] due to: Could not instantiate named strategy class [org.hibernate.community.dialect.MariaDBLegacyDialect]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214)
	at org.hibernate.boot.model.relational.Database.<init>(Database.java:44)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:255)
	at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:207)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:185)
	at io.quarkus.hibernate.orm.runtime.boot.FastBootMetadataBuilder.build(FastBootMetadataBuilder.java:417)
	at io.quarkus.hibernate.orm.runtime.PersistenceUnitsHolder.createMetadata(PersistenceUnitsHolder.java:105)
	at io.quarkus.hibernate.orm.runtime.PersistenceUnitsHolder.constructMetadataAdvance(PersistenceUnitsHolder.java:81)
	at io.quarkus.hibernate.orm.runtime.PersistenceUnitsHolder.initializeJpa(PersistenceUnitsHolder.java:39)
	at io.quarkus.hibernate.orm.runtime.HibernateOrmRecorder$1.created(HibernateOrmRecorder.java:86)
	at io.quarkus.arc.runtime.ArcRecorder.initBeanContainer(ArcRecorder.java:87)
	at io.quarkus.runner.recorded.ArcProcessor$notifyBeanContainerListeners1304312071.deploy_0(Unknown Source)
	at io.quarkus.runner.recorded.ArcProcessor$notifyBeanContainerListeners1304312071.deploy(Unknown Source)
	... 24 more
Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named strategy class [org.hibernate.community.dialect.MariaDBLegacyDialect]
	at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:170)
	at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:118)
	at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.constructDialect(DialectFactoryImpl.java:122)
	at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:87)
	at io.quarkus.hibernate.orm.runtime.service.QuarkusStaticInitDialectFactory.buildDialect(QuarkusStaticInitDialectFactory.java:25)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentWithExplicitConfiguration(JdbcEnvironmentInitiator.java:242)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironmentWithExplicitConfiguration(JdbcEnvironmentInitiator.java:233)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.getJdbcEnvironment(JdbcEnvironmentInitiator.java:161)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:127)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:82)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:133)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:262)
	... 38 more
Caused by: org.hibernate.boot.registry.selector.spi.StrategySelectionException: Could not instantiate named dialect class [org.hibernate.community.dialect.MariaDBLegacyDialect]
	at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:142)
	at org.hibernate.boot.registry.selector.internal.StrategySelectorImpl.resolveStrategy(StrategySelectorImpl.java:166)
	... 49 more
Caused by: java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:72)
	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
	at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.lambda$constructDialect$0(DialectFactoryImpl.java:130)
	... 50 more
Caused by: java.lang.NullPointerException: Cannot invoke "String.length()" because "str" is null
	at java.base/java.util.StringTokenizer.<init>(StringTokenizer.java:199)
	at org.hibernate.internal.util.StringHelper.split(StringHelper.java:330)
	at org.hibernate.internal.util.StringHelper.split(StringHelper.java:326)
	at org.hibernate.community.dialect.MySQLLegacyDialect.createVersion(MySQLLegacyDialect.java:194)
	at org.hibernate.community.dialect.MariaDBLegacyDialect.<init>(MariaDBLegacyDialect.java:70)
	at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
	... 53 more

yrodiere Oct 8, 2025

Created https://hibernate.atlassian.net/browse/HHH-19848

Navigation Menu

Repository navigation

KC 26.4 mariadb version requirement #43093

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 19 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

KC 26.4 mariadb version requirement #43093

Uh oh!

gvde Sep 30, 2025

Replies: 1 comment · 19 replies

Uh oh!

shawkins Sep 30, 2025 Collaborator

Uh oh!

vmuzikar Oct 3, 2025 Collaborator

Uh oh!

gvde Oct 3, 2025 Author

Uh oh!

vmuzikar Oct 3, 2025 Collaborator

Uh oh!

gvde Oct 8, 2025 Author

Uh oh!

yrodiere Oct 8, 2025

gvde
Sep 30, 2025

Replies: 1 comment 19 replies

shawkins
Sep 30, 2025
Collaborator

vmuzikar Oct 3, 2025
Collaborator

gvde Oct 3, 2025
Author

vmuzikar Oct 3, 2025
Collaborator

gvde Oct 8, 2025
Author