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/15 09:10:19 UTC
[GitHub] [incubator-shardingsphere] cws1981 opened a new issue #5198: Why is
there a delay of about 5 seconds when changing the rules of the
registration center?
cws1981 opened a new issue #5198: Why is there a delay of about 5 seconds when changing the rules of the registration center?
URL: https://github.com/apache/incubator-shardingsphere/issues/5198
Why is there a delay of about 5 seconds when changing the rules of the registration center? I use version 4.0.1 and zk registration center.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] cws1981 edited a comment on issue #5198:
Why is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
cws1981 edited a comment 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 table 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
[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 ?
Posted by GitBox <gi...@apache.org>.
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
[GitHub] [incubator-shardingsphere] kimmking closed issue #5198: Why is
there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
kimmking closed 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
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5198: Why
is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
kimmking 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-615206541
You should open a new issue for the latest one.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5198: Why
is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
kimmking 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-614463782
@cws1981 any more details for profiling? logs, configs ?
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5198: Why
is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
kimmking 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-613991048
It's due with your config details.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] menghaoranss commented on issue #5198:
Why is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
menghaoranss 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-613961894
@cws1981 ,hi, could you describe your specific steps ?
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] cws1981 edited a comment on issue #5198:
Why is there a delay of about 5 seconds service takes effect,
when changing the rules of the registration center ?
Posted by GitBox <gi...@apache.org>.
cws1981 edited a comment 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 table at 15:47:56;
However, I think it is reasonable, switching requires a smooth transition period
----------------------------------------------------------------
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