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/02/09 09:32:58 UTC

[GitHub] [shardingsphere] jmbkeyes opened a new issue #9404: Sharding-Proxy can't start for can't find class org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration

jmbkeyes opened a new issue #9404:
URL: https://github.com/apache/shardingsphere/issues/9404


   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   I download the Sharding-Proxy4.1.1,   and modify the config files (config/server.yaml, config-sharding.yaml). But 
   exception is thrown while running the sharding proxy, exceptions as below.
   **Exception in thread "main" Cannot create property=authentication for JavaBean=org.apache.shardingsphere.shardingproxy.config.yaml.YamlProxyServerConfiguration@52d455b8**
    in 'reader', line 60, column 1:
       authentication:
       ^
   Type org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration not present
    in 'reader', line 61, column 3:
         users:
         ^
   
           at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.constructJavaBean2ndStep(Constructor.java:312)
           at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.construct(Constructor.java:189)
           at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.construct(Constructor.java:345)
           at org.yaml.snakeyaml.constructor.BaseConstructor.constructObject(BaseConstructor.java:182)
           at org.yaml.snakeyaml.constructor.BaseConstructor.constructDocument(BaseConstructor.java:141)
           at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:127)
           at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:450)
           at org.yaml.snakeyaml.Yaml.loadAs(Yaml.java:410)
           at org.apache.shardingsphere.underlying.common.yaml.engine.YamlEngine.unmarshal(YamlEngine.java:74)
           at org.apache.shardingsphere.underlying.common.yaml.engine.YamlEngine.unmarshal(YamlEngine.java:56)
           at org.apache.shardingsphere.shardingproxy.config.ShardingConfigurationLoader.loadServerConfiguration(ShardingConfigurationLoader.java:72)
           at org.apache.shardingsphere.shardingproxy.config.ShardingConfigurationLoader.load(ShardingConfigurationLoader.java:56)
           at org.apache.shardingsphere.shardingproxy.Bootstrap.main(Bootstrap.java:82)
   Caused by: java.lang.TypeNotPresentException: Type org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration not present
           at sun.reflect.generics.factory.CoreReflectionFactory.makeNamedType(Unknown Source)
           at sun.reflect.generics.visitor.Reifier.visitClassTypeSignature(Unknown Source)
           at sun.reflect.generics.tree.ClassTypeSignature.accept(Unknown Source)
           at sun.reflect.generics.visitor.Reifier.reifyTypeArguments(Unknown Source)
           at sun.reflect.generics.visitor.Reifier.visitClassTypeSignature(Unknown Source)
           at sun.reflect.generics.tree.ClassTypeSignature.accept(Unknown Source)
           at sun.reflect.generics.repository.ConstructorRepository.getParameterTypes(Unknown Source)
           at java.lang.reflect.Executable.getGenericParameterTypes(Unknown Source)
           at java.lang.reflect.Method.getGenericParameterTypes(Unknown Source)
           at java.beans.FeatureDescriptor.getParameterTypes(Unknown Source)
           at java.beans.MethodDescriptor.setMethod(Unknown Source)
           at java.beans.MethodDescriptor.<init>(Unknown Source)
           at java.beans.MethodDescriptor.<init>(Unknown Source)
           at java.beans.Introspector.getTargetMethodInfo(Unknown Source)
           at java.beans.Introspector.getBeanInfo(Unknown Source)
           at java.beans.Introspector.getBeanInfo(Unknown Source)
           at org.yaml.snakeyaml.introspector.PropertyUtils.getPropertiesMap(PropertyUtils.java:63)
           at org.yaml.snakeyaml.introspector.PropertyUtils.getProperty(PropertyUtils.java:126)
           at org.yaml.snakeyaml.introspector.PropertyUtils.getProperty(PropertyUtils.java:121)
           at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.getProperty(Constructor.java:322)
           at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.constructJavaBean2ndStep(Constructor.java:240)
           ... 12 more
   Caused by: java.lang.ClassNotFoundException: org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration
           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)
           at java.lang.Class.forName0(Native Method)
           at java.lang.Class.forName(Unknown Source)
           ... 33 more
   The two config files as below
   ![image](https://user-images.githubusercontent.com/12583734/107343745-9cce4a00-6afc-11eb-8d9a-74c1686d5974.png)
   
   ![image](https://user-images.githubusercontent.com/12583734/107343758-a22b9480-6afc-11eb-8795-3aafb10d3972.png)
   
   authentication:
     users:
       root:
         password: root
       sharding:
         password: sharding 
         authorizedSchemas: bocai_checkin
   props:
     max.connections.size.per.query: 1
     acceptor.size: 16  # The default value is available processors count * 2.
     executor.size: 16  # Infinite by default.
     proxy.frontend.flush.threshold: 128  # The default value is 128.
       # LOCAL: Proxy will run with LOCAL transaction.
       # XA: Proxy will run with XA transaction.
       # BASE: Proxy will run with B.A.S.E transaction.
     proxy.transaction.type: LOCAL
     proxy.opentracing.enabled: false
     proxy.hint.enabled: false
     query.with.cipher.column: true
     sql.show: true
   
   **config-sharding.yaml:**
   schemaName: bocai_checkin
   
   # 分库分表的信息 
   dataSources:
     bocaicheckin2019:
       url: jdbc:mysql://10.0.0.5:3306/bocai_checkin2019?useUnicode=true&characterEncoding=utf8&autoReconnect=true
       username: root
       password: jmbkeyes
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
     bocaicheckin2020:
       url: jdbc:mysql://10.0.0.5:3306/bocai_checkin2020?useUnicode=true&characterEncoding=utf8&autoReconnect=true
       username: root
       password: jmbkeyes
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       
   # 分片规则
   shardingRule:
     tables:
       trainee_checkin_checkout:
         actualDataNodes: bocaicheckin${2019..2020}.trainee_checkin_checkout_${1..12}
         tableStrategy:
           inline:
             shardingColumn: month
             algorithmExpression: trainee_checkin_checkout_${month % 100}
     defaultDatabaseStrategy:
       inline:
         shardingColumn: month
         algorithmExpression: bocaicheckin${(month / 100) as int}
     defaultTableStrategy:
       none:
   
   According to exception detail, it should be some jar files are missing. but I don't know which jars are missing.
   Thanks in advance for your help!!!


----------------------------------------------------------------
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



[GitHub] [shardingsphere] jmbkeyes commented on issue #9404: Sharding-Proxy can't start for can't find class org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration

Posted by GitBox <gi...@apache.org>.
jmbkeyes commented on issue #9404:
URL: https://github.com/apache/shardingsphere/issues/9404#issuecomment-775801410


   close 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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] jmbkeyes closed issue #9404: Sharding-Proxy can't start for can't find class org.apache.shardingsphere.orchestration.center.yaml.config.YamlCenterRepositoryConfiguration

Posted by GitBox <gi...@apache.org>.
jmbkeyes closed issue #9404:
URL: https://github.com/apache/shardingsphere/issues/9404


   


----------------------------------------------------------------
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