041tjpu commented on issue #27346:
URL:
https://github.com/apache/shardingsphere/issues/27346#issuecomment-1647110380
> Can you try it with `5.4.0`?
I have just upgraded from version 5.3.2 to 5.4.0, and the previous problem
has been solved. There is a new problem, the table without sharding Settings
cannot be found. (door_record is my sharding table, and notice is the table
without setting. The error is "Table 'notice' doesn't exist") My configuration
is:
mode:
type: Standalone
repository:
type: JDBC
dataSources:
ds_0:
connectionProperties: druid.stat.mergeSql=true; druid.stat.slowSqlMillis=5000
minIdle: 5
validationQuery: SELECT 1 FROM sys_user
initialSize: 5
maxWait: 60000
# filters: stat,wall,log4j
poolPreparedStatements: true
dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
maxPoolPreparedStatementPerConnectionSize: 20
testOnBorrow: true
testWhileIdle: true
minEvictableIdleTimeMillis: 300000
timeBetweenEvictionRunsMillis: 60000
testOnReturn: false
maxActive: 20
driverClassName: com.mysql.jdbc.Driver
username: root
Url: JDBC: mysql: / / 127.0.0.1:3306 / screen111?
useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
password: root
rules:
-! SHARDING
tables:
door_record:
actualDataNodes: ds_0.door_record_$->{202305.. 202307}
tableStrategy:
standard:
shardingColumn: addtime
shardingAlgorithmName: door_interval
keyGenerateStrategy:
column: guid
keyGeneratorName: snowflake
bindingTables:
- door_record
defaultTableStrategy:
none:
shardingAlgorithms:
door_interval:
type: INTERVAL
props:
datetime-pattern: 'yyyy-MM-dd HH:mm:ss'
datetime-lower: '2023-05-01 00:00:00'
datetime-upper: '2023-08-01 00:00:00'
sharding-suffix-pattern: 'yyyyMM'
datetime-interval-amount: 1
datetime-interval-unit: 'MONTHS'
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
sql-show: false @
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
