解决sharding-JDBC强制扫描表结构过程中报错问题

场景启动时报错，项目中使用了分库分表，刚开始运行的一直正常，后来启动时突然报错，于是开始排查原因。

查明项目引用的包：

<dependency>
    <groupId>io.shardingsphere</groupId>
    <artifactId>sharding-jdbc-core</artifactId>
    <version>3.0.1</version>
</dependency>
 

报错日志：

 

 Caused by: io.shardingsphere.core.exception.ShardingException: java.util.concurrent.ExecutionException: java.sql.SQLException: View 'new_db.v_tbl_record' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.loadActualTableMetaDataList(TableMetaDataLoader.java:128)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.load(TableMetaDataLoader.java:67)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.load(TableMetaDataLoader.java:63)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataInitializer.loadDefaultTables(TableMetaDataInitializer.java:81)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataInitializer.load(TableMetaDataInitializer.java:61)
    at io.shardingsphere.core.jdbc.core.datasource.ShardingDataSource.<init>(ShardingDataSource.java:73)
    at io.shardingsphere.core.api.ShardingDataSourceFactory.createDataSource(ShardingDataSourceFactory.java:51)
    at com.huobi.dbServer.config.HbDataSourceConfig.hbShardingDataSource(HbDataSourceConfig.java:75)
    at com.huobi.dbServer.config.HbDataSourceConfig$$EnhancerBySpringCGLIB$$f3883088.CGLIB$hbShardingDataSource$0(<generated>)
    at com.huobi.dbServer.config.HbDataSourceConfig$$EnhancerBySpringCGLIB$$f3883088$$FastClassBySpringCGLIB$$97ea8031.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:363)
    at com.huobi.dbServer.config.HbDataSourceConfig$$EnhancerBySpringCGLIB$$f3883088.hbShardingDataSource(<generated>)
    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.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
    ... 152 common frames omitted
Caused by: java.util.concurrent.ExecutionException: java.sql.SQLException: View 'new_db.v_tbl_record' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
    at com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
    at com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
    at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.loadActualTableMetaDataList(TableMetaDataLoader.java:126)
    ... 169 common frames omitted
Caused by: java.sql.SQLException: View 'new_db.v_tbl_record' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
    at com.mysql.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3737)
    at com.mysql.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:3727)
    at com.mysql.jdbc.IterateBlock.doForAll(IterateBlock.java:50)
    at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3725)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.getPrimaryKeys(TableMetaDataLoader.java:106)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.getColumnMetaDataList(TableMetaDataLoader.java:93)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.load(TableMetaDataLoader.java:82)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.load(TableMetaDataLoader.java:75)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader.access$000(TableMetaDataLoader.java:49)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader$1.call(TableMetaDataLoader.java:121)
    at io.shardingsphere.core.metadata.table.executor.TableMetaDataLoader$1.call(TableMetaDataLoader.java:117)
    at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
    at java.util.concurrent.FutureTask.run(FutureTask.java)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Disconnected from the target VM, address: '127.0.0.1:58269', transport: 'socket'

报错原因：sharding-sphere 3.0版本强制扫描表结构

在sharding-sphere3.0.0的版本发布之后会强制校验分库分表的表结构的结构是否一致，
如果不一致会报错

解决方案：三种方案

1、升级jar包，比如：

<dependency>
    <groupId>io.shardingsphere</groupId>
    <artifactId>sharding-jdbc-core</artifactId>
    <version>3.3.0</version>
</dependency>
 

2、把分的表结构重新改成一致：

3、源码里注释调强制验证的代码（下篇分享）

很简单吧，下篇我们从源码的角度分析，为啥会报错，敬请期待！