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 2022/01/05 09:39:23 UTC
[GitHub] [shardingsphere] xcmonline opened a new issue #14543: shardingsphere-proxy start fail
xcmonline opened a new issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543
Starting the ShardingSphere-Proxy ...
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/shardingsphere/mode/repository/cluster/ClusterPersistRepositoryConfiguration
at org.apache.shardingsphere.mode.manager.cluster.yaml.ClusterPersistRepositoryConfigurationYamlSwapper.swapToObject(ClusterPersistRepositoryConfigurationYamlSwapper.java:41)
at org.apache.shardingsphere.mode.manager.cluster.yaml.ClusterPersistRepositoryConfigurationYamlSwapper.swapToObject(ClusterPersistRepositoryConfigurationYamlSwapper.java:27)
at org.apache.shardingsphere.infra.yaml.config.swapper.mode.PersistRepositoryConfigurationYamlSwapperEngine.swapToObject(PersistRepositoryConfigurationYamlSwapperEngine.java:57)
at org.apache.shardingsphere.infra.yaml.config.swapper.mode.ModeConfigurationYamlSwapper.swapToObject(ModeConfigurationYamlSwapper.java:44)
at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:67)
at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:47)
Caused by: java.lang.ClassNotFoundException: org.apache.shardingsphere.mode.repository.cluster.ClusterPersistRepositoryConfiguration
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
server.ymal
`
scaling:
blockQueueSize: 10000
workerThread: 40
clusterAutoSwitchAlgorithm:
type: IDLE
props:
incremental-task-idle-minute-threshold: 30
dataConsistencyCheckAlgorithm:
type: DEFAULT
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: localhost:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
overwrite: true
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
- !TRANSACTION
defaultType: XA
providerType: Atomikos
props:
max-connections-size-per-query: 1
kernel-executor-size: 16
proxy-frontend-flush-threshold: 128
proxy-opentracing-enabled: false
proxy-hint-enabled: false
sql-show: false
check-table-metadata-enabled: false
show-process-list-enabled: false
proxy-backend-query-fetch-size: -1
check-duplicate-table-enabled: false
sql-comment-parse-enabled: false
proxy-frontend-executor-size: 0
proxy-backend-executor-suitable: OLAP
proxy-frontend-max-connections: 0
sql-federation-enabled: false
`
config-sharding.ymal
`
schemaName: sharding_db
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
obs_aws_data_min:
actualDataNodes: ds_0.obs_aws_data_min_${0..1}
tableStrategy:
standard:
shardingColumn: observ_time
shardingAlgorithmName: sharding_by_time
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
shardingAlgorithms:
sharding_by_time:
type: auto_interval
props:
datetime-lower: "2021-10-01 00:00:00"
sharding-seconds: "86400"
datetime-upper: "2021-11-05 00:00:00"
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
`
--
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] zjcnb commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1005545218
@xcmonline Hello, Can you tell me your ShardingSphere-Proxy version?
--
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] xcmonline edited a comment on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline edited a comment on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1007106240
only setting.
server.ymal
```
mode:
type: Cluster
repository:
type: Zookeeper
props:
namespace: qiyun_db1
server-lists: localhost:2181
overwrite: true
rules:
- !AUTHORITY
users:
- root@%:123456
provider:
type: ALL_PRIVILEGES_PERMITTED
props:
max-connections-size-per-query: 1
kernel-executor-size: 16
proxy-frontend-flush-threshold: 128
proxy-opentracing-enabled: false
proxy-hint-enabled: false
sql-show: false
check-table-metadata-enabled: false
```
and
config-sharding.yaml
```
schemaName: testdb
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useSSL=false
username: root
password: xxxxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
obs_aws_data_min:
actualDataNodes: ds_0.obs_aws_data_min_${0..1}
tableStrategy:
standard:
shardingColumn: observ_time
shardingAlgorithmName: sharding_by_time
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
shardingAlgorithms:
sharding_by_time:
type: auto_interval
props:
datetime-lower: "2020-10-01 00:00:00"
sharding-seconds: "86400"
datetime-upper: "2020-10-05 00:00:00"
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
```
--
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] zjcnb commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1007115208
@xcmonline Can you check your ${shardingsphere-proxy}/lib directory. Are `shardingsphere-cluster-mode-repository-zookeeper-curator.5.0.0.jar` in it?
--
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] terrymanu commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1043017839
The Github IT is run every pull request, please check your environment.
--
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] xcmonline edited a comment on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline edited a comment on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1006195112
> @xcmonline
apache-shardingsphere-5.0.0-shardingsphere-proxy
windows 10
--
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] xcmonline commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1006195112
> @xcmonline你好,你能告诉我你的ShardingSphere-Proxy版本吗?
apache-shardingsphere-5.0.0-shardingsphere-proxy
--
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] terrymanu closed issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543
--
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] xcmonline commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1007106240
only setting.
server.ymal
`mode:
type: Cluster
repository:
type: Zookeeper
props:
namespace: qiyun_db1
server-lists: localhost:2181
overwrite: true
rules:
- !AUTHORITY
users:
- root@%:123456
provider:
type: ALL_PRIVILEGES_PERMITTED
props:
max-connections-size-per-query: 1
kernel-executor-size: 16
proxy-frontend-flush-threshold: 128
proxy-opentracing-enabled: false
proxy-hint-enabled: false
sql-show: false
check-table-metadata-enabled: false`
and
config-sharding.yaml
`schemaName: testdb
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useSSL=false
username: root
password: xxxxxx
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
obs_aws_data_min:
actualDataNodes: ds_0.obs_aws_data_min_${0..1}
tableStrategy:
standard:
shardingColumn: observ_time
shardingAlgorithmName: sharding_by_time
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
shardingAlgorithms:
sharding_by_time:
type: auto_interval
props:
datetime-lower: "2020-10-01 00:00:00"
sharding-seconds: "86400"
datetime-upper: "2020-10-05 00:00:00"
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
`
--
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] xcmonline edited a comment on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline edited a comment on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1006195112
> @xcmonline你好,你能告诉我你的ShardingSphere-Proxy版本吗?
apache-shardingsphere-5.0.0-shardingsphere-proxy
windows 10
--
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] xcmonline commented on issue #14543: shardingsphere-proxy start fail
Posted by GitBox <gi...@apache.org>.
xcmonline commented on issue #14543:
URL: https://github.com/apache/shardingsphere/issues/14543#issuecomment-1007152854
> @xcmonline Can you check your ${shardingsphere-proxy}/lib directory. Are `shardingsphere-cluster-mode-repository-zookeeper-curator.5.0.0.jar` in it?
zookeeper-3.6.0.jar and zookeeper-jute-3.6.0.jar .
shardingsphere-cluster-mode-repository-zookeeper-curator.5.0.0.jar not found, where can I download it.
--
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