shardingsphere偶尔出现错误Cannot support database type ‘MySQL‘

weixin_45644548

于 2024-08-20 10:28:54 发布

阅读量147

点赞数 3

文章标签： java

本文链接：https://blog.csdn.net/weixin_45644548/article/details/141351057

版权

springboot项目，使用了shardingsphere做分表，maven如下

<dependency>
	<groupId>org.apache.shardingsphere</groupId>
	<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
	<version>4.1.1</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>8.0.32</version>
</dependency>

项目迭代了功能，发现uat环境正常，prd却一直报错Cannot support database type ‘MySQL’，详细错误如下：

[2024-08-19 13:43:04.521][WARN][main o.s.b.w.s.c.AnnotationConfigServletWebServerApplicationContext.refresh:591] - [Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'xxxServiceImpl': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.UnsupportedOperationException: Cannot support database type 'MySQL'
### The error may exist in URL [jar:file:/apps/xxx/xxx-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/mapper/xxxMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM xxx  WHERE is_delete = 0 AND material_type = ?
### Cause: java.lang.UnsupportedOperationException: Cannot support database type 'MySQL']
[2024-08-19 13:43:04.551][INFO][main com.alibaba.druid.pool.DruidDataSource.close:2032] - [{dataSource-1} closing ...]
[2024-08-19 13:43:04.560][INFO][main com.alibaba.druid.pool.DruidDataSource.close:2104] - [{dataSource-1} closed]
[2024-08-19 13:43:04.561][INFO][main com.alibaba.druid.pool.DruidDataSource.close:2032] - [{dataSource-2} closing ...]
[2024-08-19 13:43:04.562][INFO][main com.alibaba.druid.pool.DruidDataSource.close:2104] - [{dataSource-2} closed]
[2024-08-19 13:43:04.598][INFO][main o.s.b.a.logging.ConditionEvaluationReportLoggingListener.logMessage:136] - [

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.]
[2024-08-19 13:43:04.627][ERROR][main org.springframework.boot.SpringApplication.reportFailure:824] - [Application run failed]
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'xxxServiceImpl': Invocation of init method failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.UnsupportedOperationException: Cannot support database type 'MySQL'
### The error may exist in URL [jar:file:/apps/qualityMonitor/xxx-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/mapper/xxxlMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM ai_material WHERE is_delete = 0 AND material_type = ?
### Cause: java.lang.UnsupportedOperationException: Cannot support database type 'MySQL'
        at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:440)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147)
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:734)

当初以为是shardingsphere版本问题，修改版本仍然未能解决，偶尔发现地址：https://github.com/apache/shardingsphere/issues/7947

项目启动过程中，启动了多线程去查数据库引发上面的错误，搜索资料后，在启动前加入NewInstanceServiceLoader.register(SQLParserConfiguration.class)即可，启动完整代码如下：

import org.apache.shardingsphere.spi.NewInstanceServiceLoader;
import org.apache.shardingsphere.sql.parser.spi.SQLParserConfiguration;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.scheduling.annotation.EnableScheduling;
import springfox.documentation.oas.annotations.EnableOpenApi;
@SpringBootApplication
@EnableOpenApi
@EnableScheduling
@MapperScan({"xxx.xxx.xxx.xxxx"})
public class StartApplication {
    public static void main(String[] args) {
        NewInstanceServiceLoader.register(SQLParserConfiguration.class);
        SpringApplication.run(StartApplication .class, args);
    }
}