apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.66k stars 6.67k forks source link

When using the mariadb database in version 5.4.1, the connection prompt is Can not find builder rule: `MariaDB.shardingsphere` #31358

Closed zhengfengxu closed 1 week ago

zhengfengxu commented 2 months ago

I am using shardingsphere version 5.4.1 and the database is mariadb. Screenshot of configuration file: c3e2119724b43c9f24e81b412787866 Program specific error information: 2024-05-22 17:41:49.499 WARN 25220 --- [)-172.16.100.71] o.s.b.a.jdbc.DataSourceHealthIndicator : DataSource health check failed

com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Can not find builder rule: MariaDB.shardingsphere at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-4.0.3.jar:na] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) ~[spring-jdbc-5.3.25.jar:5.3.25] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) ~[spring-jdbc-5.3.25.jar:5.3.25] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) ~[spring-jdbc-5.3.25.jar:5.3.25] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:330) ~[spring-jdbc-5.3.25.jar:5.3.25] at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:122) ~[spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:105) ~[spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:100) ~[spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82) ~[spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.boot.actuate.health.HealthIndicator.getHealth(HealthIndicator.java:37) [spring-boot-actuator-2.7.9.jar:2.7.9] at org.springframework.boot.actuate.health.HealthEndpoint.getHealth(HealthEndpoin If the driver is changed to MySQL, it can start normally, but the inserted data will be garbled

TherChenYang commented 2 months ago

@zhengfengxu Thank you for your feedback, but I cannot find any relevant configurations about ShardingSphere in your configuration file. Please provide more detailed configurations and usage so that we can solve the problem faster.

github-actions[bot] commented 1 month ago

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

zhangxuh commented 1 month ago

I met same problem,my yaml configuration is image image

then give me an error: image

when I read the source code,I Found that the SCHEMA_PATH_SYSTEM_SCHEMA_BUILDER_RULE_MAP only support MYSQL_SHARDING_SPHERE、POSTGRESQL_SHARDING_SPHERE、OPEN_GAUSS_SHARDING_SPHERE

Did you provide support for Mariadb?

image

github-actions[bot] commented 1 week ago

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

zhangxuh commented 6 days ago

Did it close without a response?