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 2020/04/17 07:58:13 UTC

[GitHub] [incubator-shardingsphere] cws1981 commented on issue #5198: Why is there a delay of about 5 seconds service takes effect, when changing the rules of the registration center ?

cws1981 commented on issue #5198: Why is there a delay of about 5 seconds service takes effect, when changing the rules of the registration center ?
URL: https://github.com/apache/incubator-shardingsphere/issues/5198#issuecomment-615103194
 
 
   > @cws1981 any more details for profiling? logs, configs ?
   
   ```
   20/04/17 15:47:29 INFO Curator-TreeCache-0 org.apache.shardingsphere.core.config.log.ConfigurationLogger: ShardingRuleConfiguration
   tables:
     log_process:
       actualDataNodes: dataSource.log_process,dataSource.log_process_2020_$->{4..12}
       keyGenerator:
         column: id
         type: SNOWFLAKE_SIMPLE
       logicTable: log_process
       tableStrategy:
         standard:
           preciseAlgorithmClassName: com.bolome.base.shardingjdbc.shardingAlgorithm.IDPrecise
           shardingColumn: id
   
   20/04/17 15:47:29 INFO Curator-TreeCache-0 org.apache.shardingsphere.core.config.log.ConfigurationLogger: Properties
   sql.show: 'false'
   
   
   20/04/17 15:47:56 ERROR http-bio-8080-exec-1 com.bolome.pms.advisor.ExceptionControllerAdvice: 
   ### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'pms_stage.log_process_2020_1' doesn't exist
   ### The error may exist in class path resource [com/bolome/pms/shardingMappers/log/LogProcessMapper.xml]
   ### The error may involve com.bolome.pms.shardingDao.log.LogProcessMapper.selectByExample-Inline
   
   ```
   
   Time to see the log I modified the configuration at 15:47:29, but the report does not exist at 15:47:56

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services