You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/09/22 01:31:23 UTC
[GitHub] [shardingsphere] lizhuangs opened a new issue #12609: check.table.metadata.enabled=false not work well
lizhuangs opened a new issue #12609:
URL: https://github.com/apache/shardingsphere/issues/12609
## Bug Report
I startup with springboot,it print log like fellows:
```
2021-09-17 22:06:07,801 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20088, rs-50088} query executed. 34.505012 millis. SELECT * FROM `sys_role` WHERE 1 != 1
2021-09-17 22:06:08,058 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10005, stmt-20089} created
2021-09-17 22:06:08,093 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10005, stmt-20089, rs-50089} query executed. 34.835823 millis. SELECT * FROM `site_flow_2020` WHERE 1 != 1
2021-09-17 22:06:08,129 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10005, stmt-20060} closed
2021-09-17 22:06:08,130 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10005, stmt-20062} closed
2021-09-17 22:06:08,130 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10005, stmt-20077} closed
2021-09-17 22:06:08,518 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20090, rs-50090} query executed. 34.650143 millis. SELECT * FROM `sys_site` WHERE 1 != 1
2021-09-17 22:06:08,555 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20055} closed
2021-09-17 22:06:08,555 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20070} closed
2021-09-17 22:06:08,555 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20088} closed
2021-09-18 00:08:07,797 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10003, stmt-20084} closed
creating bean with name 'transactionManager' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceTransactionManagerAutoConfiguration$JdbcTransactionManagerConfiguration.class]: Unsatisfied dependency expressed through method 'transactionManager' parameter 1; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'shardingDataSource' defined in class path resource [org/apache/shardingsphere/shardingjdbc/spring/boot/SpringBootConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'shardingDataSource' threw exception; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
```
### Which version of ShardingSphere did you use?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
startup my app work well and please not scan tables
### Actual behavior
it does not work and scan tables
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
I have set `check.table.metadata.enabled=false`
but why the logs show many `SELECT * FROM xxx WHERE 1 != 1`
the log show that it worked over 2-hour interval. one is `22:06:08`,anthoer is '00:08:07'
```
2021-09-17 22:06:08,555 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10004, stmt-20088} closed
2021-09-18 00:08:07,797 | DEBUG | filter.logging.Slf4jLogFilter | statementLog(Slf4jLogFilter.java:134) | {conn-10003, stmt-20084} closed
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #12609: check.table.metadata.enabled=false not work well
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #12609:
URL: https://github.com/apache/shardingsphere/issues/12609#issuecomment-924526342
Hi @lizhuangs, thank you for your feedback. Can you try the latest version? We have made a lot of optimizations on the metadata.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org