mingqing6364 opened a new issue #9509:
URL: https://github.com/apache/shardingsphere/issues/9509
**Which version of ShardingSphere did you use?**
shardingsphere-4.1.0-sharding-proxy
**Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?**
ShardingSphere-Proxy
**Expected behavior**
Load masterSlaveRule and encryptRule configuration.
**Actual behavior**
Just load masterSlaveRule configuration.
**Reason analyze (If you can)**
**Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.**
```
[root@localhost apache-shardingsphere-4.1.0-sharding-proxy-bin]# cat
conf/config-test.yaml
schemaName: test_db
dataSources:
master_ds:
url: jdbc:mysql://192.168.72.1:3308/test?serverTimezone=UTC&useSSL=false
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
slave_ds_0:
url: jdbc:mysql://192.168.72.1:3308/test?serverTimezone=UTC&useSSL=false
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
masterSlaveRule:
name: ms_ds
masterDataSourceName: master_ds
slaveDataSourceNames:
- slave_ds_0
encryptRule:
encryptors:
encryptor_aes:
type: aes
props:
aes.key.value: 123456abc
encryptor_md5:
type: md5
tables:
t_test:
columns:
user_id:
plainColumn: user_plain
cipherColumn: user_cipher
encryptor: encryptor_aes
order_id:
cipherColumn: order_cipher
encryptor: encryptor_md5
```
```
[root@localhost apache-shardingsphere-4.1.0-sharding-proxy-bin]#
bin/start.sh
Starting the Sharding-Proxy ...
The classpath is
.:..:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/*:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/*:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/ext-lib/*
Please check the STDOUT file:
/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/logs/stdout.log
[root@localhost apache-shardingsphere-4.1.0-sharding-proxy-bin]# tail -n200
-f /root/apache-shardingsphere-4.1.0-sharding-proxy-bin/logs/stdout.log
17:30:35,067 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback-test.xml]
17:30:35,067 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback.groovy]
17:30:35,067 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found
resource [logback.xml] at
[jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-proxy-bootstrap-4.1.0.jar!/logback.xml]
17:30:35,068 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs multiple times on the classpath.
17:30:35,068 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs at
[jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-proxy-distribution-4.1.0.jar!/logback.xml]
17:30:35,068 |-WARN in ch.qos.logback.classic.LoggerContext[default] -
Resource [logback.xml] occurs at
[jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-proxy-bootstrap-4.1.0.jar!/logback.xml]
17:30:35,092 |-INFO in
ch.qos.logback.core.joran.spi.ConfigurationWatchList@8e24743 - URL
[jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-proxy-bootstrap-4.1.0.jar!/logback.xml]
is not of type file
17:30:35,787 |-INFO in
ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not
set
17:30:35,794 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
17:30:35,800 |-INFO in ch.qos.logback.core.joran.action.AppenderAction -
Naming appender as [console]
17:30:35,829 |-INFO in
ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default
type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder]
property
17:30:35,914 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting level of logger [org.apache.shardingsphere] to INFO
17:30:35,914 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting additivity of logger [org.apache.shardingsphere] to false
17:30:35,914 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [console] to Logger[org.apache.shardingsphere]
17:30:35,915 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
ROOT level set to INFO
17:30:35,915 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [console] to Logger[ROOT]
17:30:35,915 |-INFO in
ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
17:30:35,915 |-INFO in
ch.qos.logback.classic.joran.JoranConfigurator@74a10858 - Registering current
configuration as safe fallback point
[INFO ] 17:30:35.946 [main] o.a.s.core.log.ConfigurationLogger -
MasterSlaveRuleConfiguration:
masterDataSourceName: master_ds
name: ms_ds
slaveDataSourceNames:
- slave_ds_0
[INFO ] 17:30:35.996 [main] o.a.s.core.log.ConfigurationLogger -
Authentication:
users:
root:
authorizedSchemas: ''
password: root
[INFO ] 17:30:35.996 [main] o.a.s.core.log.ConfigurationLogger - Properties:
sql.show: true
[INFO ] 17:30:36.680 [main] com.zaxxer.hikari.HikariDataSource -
HikariPool-1 - Starting...
[INFO ] 17:30:55.478 [main] com.zaxxer.hikari.HikariDataSource -
HikariPool-1 - Start completed.
[INFO ] 17:30:55.478 [main] com.zaxxer.hikari.HikariDataSource -
HikariPool-2 - Starting...
[INFO ] 17:30:55.488 [main] com.zaxxer.hikari.HikariDataSource -
HikariPool-2 - Start completed.
[INFO ] 17:30:55.574 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded
jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/transactions-4.0.6.jar!/transactions-defaults.properties
[INFO ] 17:30:55.584 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded
jar:file:/root/apache-shardingsphere-4.1.0-sharding-proxy-bin/lib/sharding-transaction-xa-atomikos-manager-4.1.0.jar!/transactions.properties
[WARN ] 17:30:55.596 [main] c.a.icatch.provider.imp.AssemblerImp - Thanks
for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions
for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable
this message and receive FREE tips & advice
Thanks for using Atomikos! Evaluate
http://www.atomikos.com/Main/ExtremeTransactions for advanced features and
professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable
this message and receive FREE tips & advice
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.allow_subtransactions = true
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.recovery_delay = 300000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.client_demarcation = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.threaded_2pc = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.rmi_export_class = none
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_actives = 10000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.enable_logging = true
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_timeout = 300000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.trust_client_tm = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.tm_unique_name = 127.0.0.1.tm
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.provider.url = rmi://localhost:1099
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 17:30:55.621 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 17:30:55.623 [main] c.a.icatch.provider.imp.AssemblerImp - Using
default (local) logging and recovery...
[INFO ] 17:30:55.693 [main] c.a.d.xa.XATransactionalResource -
resource-1-master_ds: refreshed XAResource
[INFO ] 17:30:55.712 [main] c.a.d.xa.XATransactionalResource -
resource-2-slave_ds_0: refreshed XAResource
[INFO ] 17:30:55.782 [main] ShardingSphere-metadata - Loading 31 tables'
meta data.
[INFO ] 17:30:57.013 [epollEventLoopGroup-2-1]
i.n.handler.logging.LoggingHandler - [id: 0x9276b6ca] REGISTERED
[INFO ] 17:30:57.033 [epollEventLoopGroup-2-1]
i.n.handler.logging.LoggingHandler - [id: 0x9276b6ca] BIND: 0.0.0.0/0.0.0.0:3307
[INFO ] 17:30:57.037 [epollEventLoopGroup-2-1]
i.n.handler.logging.LoggingHandler - [id: 0x9276b6ca, L:/0.0.0.0:3307] ACTIVE
```
**Example codes for reproduce this issue (such as a github link).**
----------------------------------------------------------------
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:
[email protected]
