Startup error: Caused by: org.apache.ibatis.binding.BindingException summary solution

报错

Springboot启动时从nacos拉取配置.启动报错：

Caused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): xxx
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:49)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy143.selectConfigList(Unknown Source)
	at com.mmoa.system.service.impl.SysConfigServiceImpl.init(SysConfigServiceImpl.java:37)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389)
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333)
	at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157)
	... 32 common frames omitted

报错分析

Usually there is an errorCaused by: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found),There are following reasons

1.mapper.xmlScan register

 # mybatis配置
mybatis:
    # 搜索指定包别名
    typeAliasesPackage: com.xx.xx
    # 配置mapper的扫描,找到所有的mapper.xml映射文件
    mapperLocations: classpath:mapper/**/*.xml

2.mapper接口与mapper.xml不在同一个包（package)The inconsistent or file name


3.mapper.xml的命名空间（namespace）与mapperThe package name of the interface does not agree


4. 接口的方法名,与xml中的sql标签的id不一致


5.接口中的返回值与xml方法配置esultMap或resultType不一致

通过,Screening for several possible situation,All are found the problem,由于是通过nacosPull configuration can be configured not pull to.
Take a closer look at startup information.

15:43:15.030 [main] WARN  c.a.c.n.c.NacosPropertySourceBuilder - [loadNacosData,87] - Ignore the empty nacos configuration and get it based on dataId[application-master.yml] & group[DEFAULT_GROUP]
15:43:15.037 [main] WARN  c.a.c.n.c.NacosPropertySourceBuilder - [loadNacosData,87] - Ignore the empty nacos configuration and get it based on dataId[test] & group[DEFAULT_GROUP]
15:43:15.043 [main] WARN  c.a.c.n.c.NacosPropertySourceBuilder - [loadNacosData,87] - Ignore the empty nacos configuration and get it based on dataId[test.yml] & group[DEFAULT_GROUP]
15:43:15.047 [main] WARN  c.a.c.n.c.NacosPropertySourceBuilder - [loadNacosData,87] - Ignore the empty nacos configuration and get it based on dataId[test-master.yml] & group[DEFAULT_GROUP]
15:43:15.052 [main] INFO  c.m.s.MmoaSystemApplication - [logStartupProfileInfo,674] - The following profiles are active: master

发现nacosTraining in rotation three configuration, did not get to,猜测正确

注：
拉取Nacos的配置文件时会轮训三个dataID：

格式一：name

文件名：xxx_config;

格式二：name.yaml
文件名+yaml后缀;

格式三：name-master.yaml
文件名+profile + 后缀.中间用“-”分割.

解决

环境配置错误,Modify environment restart service success.

# Spring
spring: 
  application:
    # 应用名称
    name: test
  profiles:
    # 环境配置
    active: dev

小结

If not change the code,启动报错,Check the configuration environment is correct or try to clear the cache, etc.

我与春风皆过客,你携秋水揽星河.