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/04/01 02:59:37 UTC
[GitHub] [shardingsphere] 15898317421 opened a new issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
15898317421 opened a new issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- 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**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
sharding proxy
### Expected behavior
print shadow config and sharding config in console
### Actual behavior
shadow config does not load
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
config-shadow-sharding-demo.yaml
schemaName: demo
dataSources:
ds0:
url: jdbc:mysql://localhost:3316/demo0
username: root
password: 123456
shadow_ds0:
url: jdbc:mysql://localhost:3316/demo1
username: root
password: 123456
shadowRule:
column: shadow
shadowMappings:
ds0: shadow_ds0
shardingRule:
tables:
demo_one:
actualDataNodes: ds${0}.demo_one_${0..1}
tableStrategy:
inline:
shardingColumn: sharding_id
algorithmExpression: demo_one_${sharding_id % 2}
keyGenerator:
type: SNOWFLAKE
column: sharding_id
shadow_demo_one:
actualDataNodes: shadow_ds${0}.shadow_demo_one_${0..1}
tableStrategy:
inline:
shardingColumn: sharding_id
algorithmExpression: shadow_demo_one_${sharding_id % 2}
keyGenerator:
type: SNOWFLAKE
column: sharding_id
### 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:
users@infra.apache.org
[GitHub] [shardingsphere] soulasuna commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
soulasuna commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-927276956
@15898317421 Hi, According to the configuration file you provided, do you need to use the `shadow rule` in the case of only shard tables? If so, your configuration file is wrong.
Can you describe the scene you used? I look forward to your reply.
By the way, let's talk about the refactoring of shadow function in 5.0.0. You can follow #11661 .
--
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] 15898317421 edited a comment on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 edited a comment on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-812342731
> @15898317421 Hi, can you test it with the newest code, the `master` branch?
I try it again with version 5.0.0-alpha, but it still wrong output.
```
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
schemaName: demo
dataSourceCommon:
username: root
password: 123456
# connectionTimeoutMilliseconds: 30000
# idleTimeoutMilliseconds: 60000
# maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
# minPoolSize: 1
# maintenanceIntervalMilliseconds: 30000
dataSources:
ds0:
url: jdbc:mysql://localhost:3316/demo0?serverTimezone=UTC&useSSL=false
ds1:
url: jdbc:mysql://localhost:3316/demo1?serverTimezone=UTC&useSSL=false
rules:
- !SHARDING
tables:
demo_one:
actualDataNodes: ds${0}.demo_one_${0..1}
tableStrategy:
standard:
shardingColumn: sharding_id
shardingAlgorithmName: demo_one_inline
keyGenerateStrategy:
column: sharding_id
keyGeneratorName: snowflake
defaultTableStrategy:
none:
shardingAlgorithms:
demo_one_inline:
type: INLINE
props:
algorithm-expression: demo_one_${sharding_id % 2}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
- !SHADOW
column: shadow
sourceDataSourceNames:
- ds0
shadowDataSourceNames:
- ds1
[INFO ] 14:09:33.662 [ShardingSphere-Command-3] ShardingSphere-SQL - Logic SQL: insert into demo_one(name, age, shadow) values ("insert", 18, true)
[INFO ] 14:09:33.665 [ShardingSphere-Command-3] ShardingSphere-SQL - SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
[INFO ] 14:09:33.665 [ShardingSphere-Command-3] ShardingSphere-SQL - Actual SQL: ds0 ::: insert into demo_one_1(name, age, sharding_id) values ('insert', 18, 584745426205782017)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - Logic SQL: insert into demo_one(name, age) values ("insert", 18)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - Actual SQL: ds0 ::: insert into demo_one_0(name, age, sharding_id) values ('insert', 18, 584745299378417664)
```
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811601996
/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/bin/java -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:59422,suspend=y,server=n -javaagent:/Users/raistlin/Library/Caches/JetBrains/IntelliJIdea2020.2/captureAgent/debugger-agent.jar -Dfile.encoding=UTF-8 -classpath /Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/deploy.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/jfxrt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Li
brary/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/javaws.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/jfxswt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/plugin.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.j
dk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/ant-javafx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/javafx-mx.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/packager.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/sa-jdi.jar:/Library/Java/JavaVirtualMachines/jdk1.8.0_281.jdk/Contents/Home/lib/tools.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-bootstrap/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-database-protocol/shardingsphere-database-protocol-core/target/classes:/Users/raistlin/.m2/repository/io/netty/netty-all/4.1.42.Final/nett
y-all-4.1.42.Final.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-database-protocol/shardingsphere-database-protocol-mysql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-database-protocol/shardingsphere-database-protocol-postgresql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-common/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-pluggable/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-binder/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-route/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-common/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-rewrite/shardingspher
e-rewrite-engine/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-executor/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-underlying/shardingsphere-merge/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-center/sharding-orchestration-center-api/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-api/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/encrypt-core/encrypt-core-api/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-center/sharding-orchestration-center-configuration/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-frontend/sharding-proxy-frontend-core/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-fro
ntend/sharding-proxy-frontend-spi/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-frontend/sharding-proxy-frontend-mysql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-frontend/sharding-proxy-frontend-postgresql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-proxy/sharding-proxy-backend/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-sql92/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-engine/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-spi/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-spi/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-p
arser/shardingsphere-sql-parser-statement/target/classes:/Users/raistlin/.m2/repository/org/apache/commons/commons-collections4/4.2/commons-collections4-4.2.jar:/Users/raistlin/.m2/repository/org/antlr/antlr4-runtime/4.7.2/antlr4-runtime-4.7.2.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-sqlserver/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-route/target/classes:/U
sers/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-common/target/classes:/Users/raistlin/.m2/repository/org/codehaus/groovy/groovy/2.4.5/groovy-2.4.5-indy.jar:/Users/raistlin/.m2/repository/org/yaml/snakeyaml/1.16/snakeyaml-1.16.jar:/Users/raistlin/.m2/repository/commons-codec/commons-codec/1.10/commons-codec-1.10.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/master-slave-core/master-slave-core-route/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-rewrite/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/encrypt-core/encrypt-core-rewrite/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/shadow-core/shadow-core-rewrite/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-execute/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-core/sharding-core-merge/target/classes:/Users/raistlin/Desktop/ideaprojec
ts/shardingsphere/encrypt-core/encrypt-core-merge/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/encrypt-core/encrypt-core-common/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-core/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-spi/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-transaction/sharding-transaction-core/target/classes:/Users/raistlin/.m2/repository/javax/transaction/jta/1.1/jta-1.1.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-atomikos/sharding-transaction-xa-atomikos-manager/target/classes:/Users/raistlin/.m2/repository/com/atomikos/transactions/4.0.6/transactions-4.0.6.jar:/Users/raistlin/.m2/r
epository/com/atomikos/transactions-api/4.0.6/transactions-api-4.0.6.jar:/Users/raistlin/.m2/repository/com/atomikos/atomikos-util/4.0.6/atomikos-util-4.0.6.jar:/Users/raistlin/.m2/repository/com/atomikos/transactions-jta/4.0.6/transactions-jta-4.0.6.jar:/Users/raistlin/.m2/repository/com/atomikos/transactions-jdbc/4.0.6/transactions-jdbc-4.0.6.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-core/sharding-orchestration-core-facade/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-core/sharding-orchestration-core-configcenter/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-core/sharding-orchestration-core-common/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-core/sharding-orchestration-core-configuration/target/classes:/Users/raistlin/Deskt
op/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-core/sharding-orchestration-core-registrycenter/target/classes:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-orchestration/sharding-orchestration-center/sharding-orchestration-center-zookeeper-curator/target/classes:/Users/raistlin/.m2/repository/org/apache/curator/curator-framework/2.10.0/curator-framework-2.10.0.jar:/Users/raistlin/.m2/repository/org/apache/curator/curator-client/2.10.0/curator-client-2.10.0.jar:/Users/raistlin/.m2/repository/org/apache/zookeeper/zookeeper/3.4.6/zookeeper-3.4.6.jar:/Users/raistlin/.m2/repository/log4j/log4j/1.2.16/log4j-1.2.16.jar:/Users/raistlin/.m2/repository/jline/jline/0.9.94/jline-0.9.94.jar:/Users/raistlin/.m2/repository/org/apache/curator/curator-recipes/2.10.0/curator-recipes-2.10.0.jar:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-opentracing/target/classes:/Users/raistlin/.m2/repository/io/opentracing/opentracing-util/0.30.0/opentra
cing-util-0.30.0.jar:/Users/raistlin/.m2/repository/io/opentracing/opentracing-api/0.30.0/opentracing-api-0.30.0.jar:/Users/raistlin/.m2/repository/io/opentracing/opentracing-noop/0.30.0/opentracing-noop-0.30.0.jar:/Users/raistlin/.m2/repository/com/zaxxer/HikariCP/3.4.2/HikariCP-3.4.2.jar:/Users/raistlin/.m2/repository/org/postgresql/postgresql/42.2.5/postgresql-42.2.5.jar:/Users/raistlin/.m2/repository/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar:/Users/raistlin/.m2/repository/ch/qos/logback/logback-classic/1.2.0/logback-classic-1.2.0.jar:/Users/raistlin/.m2/repository/ch/qos/logback/logback-core/1.2.0/logback-core-1.2.0.jar:/Users/raistlin/.m2/repository/com/google/guava/guava/18.0/guava-18.0.jar:/Users/raistlin/.m2/repository/org/slf4j/slf4j-api/1.7.7/slf4j-api-1.7.7.jar:/Users/raistlin/.m2/repository/org/slf4j/jcl-over-slf4j/1.7.7/jcl-over-slf4j-1.7.7.jar:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar org.apache.shardingsphere.shardingproxy.Bootst
rap
Connected to the target VM, address: '127.0.0.1:59422', transport: 'socket'
[INFO ] 10:53:41.094 [main] o.a.s.core.log.ConfigurationLogger - ShardingRuleConfiguration:
tables:
demo_one:
actualDataNodes: ds${0}.demo_one_${0..1}
keyGenerator:
column: sharding_id
type: SNOWFLAKE
logicTable: demo_one
tableStrategy:
inline:
algorithmExpression: demo_one_${sharding_id % 2}
shardingColumn: sharding_id
shadow_demo_one:
actualDataNodes: shadow_ds${0}.shadow_demo_one_${0..1}
keyGenerator:
column: sharding_id
type: SNOWFLAKE
logicTable: shadow_demo_one
tableStrategy:
inline:
algorithmExpression: shadow_demo_one_${sharding_id % 2}
shardingColumn: sharding_id
[INFO ] 10:53:41.143 [main] o.a.s.core.log.ConfigurationLogger - Authentication:
users:
root:
authorizedSchemas: ''
password: '123456'
[INFO ] 10:53:41.145 [main] o.a.s.core.log.ConfigurationLogger - Properties:
proxy.frontend.flush.threshold: 128
executor.size: 16
proxy.transaction.type: LOCAL
max.connections.size.per.query: 1
sql.show: true
acceptor.size: 16
[INFO ] 10:54:09.987 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
Thu Apr 01 10:54:10 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[INFO ] 10:54:10.898 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
[INFO ] 10:54:10.900 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
Thu Apr 01 10:54:10 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[INFO ] 10:54:10.955 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
[INFO ] 10:54:11.032 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/Users/raistlin/.m2/repository/com/atomikos/transactions/4.0.6/transactions-4.0.6.jar!/transactions-defaults.properties
[INFO ] 10:54:11.034 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded file:/Users/raistlin/Desktop/ideaprojects/shardingsphere/sharding-transaction/sharding-transaction-2pc/sharding-transaction-xa/sharding-transaction-xa-atomikos/sharding-transaction-xa-atomikos-manager/target/classes/transactions.properties
[WARN ] 10:54:16.055 [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 ] 10:54:16.112 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.client_demarcation = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.threaded_2pc = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.rmi_export_class = none
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.trust_client_tm = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 172.20.161.24.tm
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.provider.url = rmi://localhost:1099
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 10:54:16.113 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 10:54:16.118 [main] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
Thu Apr 01 10:54:16 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[INFO ] 10:54:16.241 [main] c.a.d.xa.XATransactionalResource - resource-1-ds0: refreshed XAResource
Thu Apr 01 10:54:16 CST 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[INFO ] 10:54:16.280 [main] c.a.d.xa.XATransactionalResource - resource-2-shadow_ds0: refreshed XAResource
[INFO ] 10:54:17.217 [main] ShardingSphere-metadata - Loading 2 logic tables' meta data.
[INFO ] 10:54:22.631 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x5e33a9c1] REGISTERED
[INFO ] 10:54:22.636 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x5e33a9c1] BIND: 0.0.0.0/0.0.0.0:3307
[INFO ] 10:54:22.640 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0x5e33a9c1, L:/0:0:0:0:0:0:0:0:3307] ACTIVE
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-812342731
> @15898317421 Hi, can you test it with the newest code, the `master` branch?
I try it again with version 5.0.0-alpha, but it still wrong output.
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
schemaName: demo
dataSourceCommon:
username: root
password: 123456
# connectionTimeoutMilliseconds: 30000
# idleTimeoutMilliseconds: 60000
# maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
# minPoolSize: 1
# maintenanceIntervalMilliseconds: 30000
dataSources:
ds0:
url: jdbc:mysql://localhost:3316/demo0?serverTimezone=UTC&useSSL=false
ds1:
url: jdbc:mysql://localhost:3316/demo1?serverTimezone=UTC&useSSL=false
rules:
- !SHARDING
tables:
demo_one:
actualDataNodes: ds${0}.demo_one_${0..1}
tableStrategy:
standard:
shardingColumn: sharding_id
shardingAlgorithmName: demo_one_inline
keyGenerateStrategy:
column: sharding_id
keyGeneratorName: snowflake
defaultTableStrategy:
none:
shardingAlgorithms:
demo_one_inline:
type: INLINE
props:
algorithm-expression: demo_one_${sharding_id % 2}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
- !SHADOW
column: shadow
sourceDataSourceNames:
- ds0
shadowDataSourceNames:
- ds1
[INFO ] 14:09:33.662 [ShardingSphere-Command-3] ShardingSphere-SQL - Logic SQL: insert into demo_one(name, age, shadow) values ("insert", 18, true)
[INFO ] 14:09:33.665 [ShardingSphere-Command-3] ShardingSphere-SQL - SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
[INFO ] 14:09:33.665 [ShardingSphere-Command-3] ShardingSphere-SQL - Actual SQL: ds0 ::: insert into demo_one_1(name, age, sharding_id) values ('insert', 18, 584745426205782017)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - Logic SQL: insert into demo_one(name, age) values ("insert", 18)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
[INFO ] 14:09:03.662 [ShardingSphere-Command-5] ShardingSphere-SQL - Actual SQL: ds0 ::: insert into demo_one_0(name, age, sharding_id) values ('insert', 18, 584745299378417664)
--
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] terrymanu closed issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896
--
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] myflx commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
myflx commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-927483232
In version v4.1.1， `org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration` show that the current Datasource is `ShadowDataSource` and
`SpringBootShardingRuleConfigurationProperties` is ignored，but from actual demand shadow and prd sharding-rule can coexist，does version 5.0.0 has the related refactoring?
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811666163
2021-04-01 13:59:30 [ ERROR ] [ dynamic-datasource-sharding-spring ] [ -1 ] [ default ] [ 172.20.161.24:8080 ] [ dc:67362040931546b2af244d5c6c9dc006; ] [ http-nio-8080-exec-10 ] [ GlobalExceptionHandler.java:121 ] [ loggerError ] [ http://localhost:8080/sample/insertWithShadow ] [ 48 ] [ BadSqlGrammarException ] - GlobalExceptionHandler exception happened
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
### The error may exist in com/idanchuang/project/basic/ShardingSphereDemoMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into demo_one(name, age, shadow) values ("insert", 18, true)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy105.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
at com.sun.proxy.$Proxy106.insertWithShadow(Unknown Source)
at com.idanchuang.project.basic.controller.SampleController.insertWithShadow(SampleController.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.logback.web.filter.RequestStartTimeFilter.doFilter(RequestStartTimeFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.StandardWebFilter.doFilter(StandardWebFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.XssFilter.doFilter(XssFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:387)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy136.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.idanchuang.component.mybatis.plus.plugins.ProcessTimeInterceptor.intercept(ProcessTimeInterceptor.java:41)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy136.update(Unknown Source)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.update(MybatisCachingExecutor.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy135.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.idanchuang.support.mybatis.crypt.CryptInterceptor.intercept(CryptInterceptor.java:67)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy135.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 85 common frames omitted
--
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] dongzl commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811870895
@15898317421 Hi, can you test it with the newest code, the `master` branch?
--
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] terrymanu closed issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811766390
--
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] soulasuna commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
soulasuna commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-927493598
@myflx Thank you for your attention.
In version 5.0.0, the `shadow` function can be used with any function provided in the shardingsphere.
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811616653
2021-04-01 11:46:12 [ ERROR ] [ dynamic-datasource-sharding-spring ] [ -1 ] [ default ] [ 172.20.161.24:8080 ] [ dc:6f09af039a514b8f96e1cca5cb02d218; ] [ http-nio-8080-exec-5 ] [ GlobalExceptionHandler.java:121 ] [ loggerError ] [ http://localhost:8080/sample/insertWithShadow ] [ 49 ] [ BadSqlGrammarException ] - GlobalExceptionHandler exception happened
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
### The error may exist in com/idanchuang/project/basic/ShardingSphereDemoMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into demo_one(name, age, shadow) values ("insert", 18, true)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy105.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
at com.sun.proxy.$Proxy106.insertWithShadow(Unknown Source)
at com.idanchuang.project.basic.controller.SampleController.insertWithShadow(SampleController.java:39)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.logback.web.filter.RequestStartTimeFilter.doFilter(RequestStartTimeFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.StandardWebFilter.doFilter(StandardWebFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.XssFilter.doFilter(XssFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.idanchuang.component.just.web.filter.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:117)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:106)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'shadow' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:387)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy136.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.idanchuang.component.mybatis.plus.plugins.ProcessTimeInterceptor.intercept(ProcessTimeInterceptor.java:41)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy136.update(Unknown Source)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.update(MybatisCachingExecutor.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy135.update(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.idanchuang.support.mybatis.crypt.CryptInterceptor.intercept(CryptInterceptor.java:67)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy135.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 85 common frames omitted
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-811666069
[INFO ] 13:59:30.560 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: SELECT @@session.transaction_read_only
[INFO ] 13:59:30.560 [ShardingSphere-Command-0] ShardingSphere-SQL - SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@20a25075, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1c8ea819), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1c8ea819, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=37, distinctRow=false, projections=[ExpressionProjection(expression=@@session.transaction_read_only, alias=Optional.empty)]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@347229d9, orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@60eac2c7, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@52790757, containsSubquery=false)
[INFO ] 13:59:30.560 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: ds1 ::: SELECT @@session.transaction_read_only
[INFO ] 13:59:30.570 [ShardingSphere-Command-1] ShardingSphere-SQL - Logic SQL: insert into demo_one(name, age, shadow) values ("insert", 18, true)
[INFO ] 13:59:30.570 [ShardingSphere-Command-1] ShardingSphere-SQL - SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@46043bab, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4eb67c06), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4eb67c06, columnNames=[name, age, shadow], insertValueContexts=[InsertValueContext(parametersCount=0, valueExpressions=[CommonExpressionSegment(startIndex=48, stopIndex=55, text="insert"), LiteralExpressionSegment(startIndex=58, stopIndex=59, literals=18), LiteralExpressionSegment(startIndex=62, stopIndex=65, literals=true), DerivedLiteralExpressionSegment(super=LiteralExpressionSegment(startIndex=0, stopIndex=0, literals=584380508826238977))], parameters=[])], generatedKeyContext=Optional[GeneratedKeyContext(columnName=sharding_id, generated=true, generatedValues=[58438050
8826238977])])
[INFO ] 13:59:30.570 [ShardingSphere-Command-1] ShardingSphere-SQL - Actual SQL: ds0 ::: insert into demo_one_1(name, age, shadow, sharding_id) values ("insert", 18, true, 584380508826238977)
--
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] 15898317421 commented on issue #9896: Combine use sharding rule and shadow rule, but shadow rule config does not load.
Posted by GitBox <gi...@apache.org>.
15898317421 commented on issue #9896:
URL: https://github.com/apache/shardingsphere/issues/9896#issuecomment-812279348
> @15898317421 Hi, can you test it with the newest code, the `master` branch?
The reason why I use the version 4.1.1 because of the pro env runs this version.
And I want to know how can combine use sharding rule and shadow rule with version 4.1.1 or not.
If the properties that I config worry, I hope you can help me to correct it.
Thanks~
--
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