You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "ckall (via GitHub)" <gi...@apache.org> on 2023/02/14 09:07:01 UTC
[GitHub] [shardingsphere] ckall opened a new issue, #24157: I reported an error using mysql cli `use database`
ckall opened a new issue, #24157:
URL: https://github.com/apache/shardingsphere/issues/24157
Version: 5.3.0
Error Message:
we find java version: java17, full_version=17.0.2, full_path=/usr/local/openjdk-17/bin/java
The port is 3308
The classpath is /opt/shardingsphere-proxy/conf:.:/opt/shardingsphere-proxy/lib/*:/opt/shardingsphere-proxy/ext-lib/*
main class org.apache.shardingsphere.proxy.Bootstrap 3308 /opt/shardingsphere-proxy/conf 0.0.0.0 false
Thanks for using Atomikos! This installation is not registered yet.
REGISTER FOR FREE at http://www.atomikos.com/Main/RegisterYourDownload and receive:
- tips & advice
- working demos
- access to the full documentation
- special exclusive bonus offers not available to others
- everything you need to get the most out of using Atomikos!
[INFO ] 2023-02-14 09:02:11.041 [main] o.a.s.p.v.ShardingSphereProxyVersion - Database name is `MySQL`, version is `8.0.28`, database name is `order`
[INFO ] 2023-02-14 09:02:11.596 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy Standalone mode started successfully
[ERROR] 2023-02-14 09:02:29.940 [ShardingSphere-Command-0] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.NullPointerException: Cannot invoke "org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.close()" because "this.databaseCommunicationEngine" is null
at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.fieldlist.MySQLComFieldListPacketExecutor.close(MySQLComFieldListPacketExecutor.java:92)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:124)
at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ckall commented on issue #24157: I reported an error using mysql cli `use database`
Posted by "ckall (via GitHub)" <gi...@apache.org>.
ckall commented on issue #24157:
URL: https://github.com/apache/shardingsphere/issues/24157#issuecomment-1444977945
Hello, have you solved 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] RaigorJiang commented on issue #24157: I reported an error using mysql cli `use database`
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24157:
URL: https://github.com/apache/shardingsphere/issues/24157#issuecomment-1449373337
@ckall In my test, this problem cannot be reproduced, can you reproduce it stably?
--
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] ckall commented on issue #24157: I reported an error using mysql cli `use database`
Posted by "ckall (via GitHub)" <gi...@apache.org>.
ckall commented on issue #24157:
URL: https://github.com/apache/shardingsphere/issues/24157#issuecomment-1430608551
`
schemaName: order
dataSources:
test_write_order_0:
url: jdbc:mysql://xxxx:32770/test_order_0?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_1:
url: jdbc:mysql://xxxx:32770/test_order_1?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_2:
url: jdbc:mysql://xxxx:32770/test_order_2?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_3:
url: jdbc:mysql://xxxx:32770/test_order_3?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_4:
url: jdbc:mysql://xxxx:32770/test_order_4?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_write_order_5:
url: jdbc:mysql://xxxx:32770/test_order_5?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_0:
url: jdbc:mysql://xxxx:32771/test_order_0?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_1:
url: jdbc:mysql://xxxx:32771/test_order_1?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_2:
url: jdbc:mysql://xxxx:32771/test_order_2?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_3:
url: jdbc:mysql://xxxx:32771/test_order_3?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_4:
url: jdbc:mysql://xxxx:32771/test_order_4?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
test_read_order_5:
url: jdbc:mysql://xxxx:32771/test_order_5?charset=utf8mb4&parseTime=True&loc=Local&collation=utf8mb4_unicode_ci
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
rules:
- !READWRITE_SPLITTING
dataSources:
test_order_0:
staticStrategy:
writeDataSourceName: test_write_order_0
readDataSourceNames:
- test_read_order_0
loadBalancerName: random
test_order_1:
staticStrategy:
writeDataSourceName: test_write_order_1
readDataSourceNames:
- test_read_order_1
loadBalancerName: random
test_order_2:
staticStrategy:
writeDataSourceName: test_write_order_2
readDataSourceNames:
- test_read_order_2
loadBalancerName: random
test_order_3:
staticStrategy:
writeDataSourceName: test_write_order_3
readDataSourceNames:
- test_read_order_3
loadBalancerName: random
test_order_4:
staticStrategy:
writeDataSourceName: test_write_order_4
readDataSourceNames:
- test_read_order_4
loadBalancerName: random
test_order_5:
staticStrategy:
writeDataSourceName: test_write_order_5
readDataSourceNames:
- test_read_order_5
loadBalancerName: random
loadBalancers:
random:
type: ROUND_ROBIN
- !SHARDING
tables:
test_order:
actualDataNodes: test_order_${0..5}.order_${0..4}
tableStrategy:
standard:
shardingColumn: user_id
shardingAlgorithmName: order_inline
databaseStrategy:
standard:
shardingColumn: agent_id
shardingAlgorithmName: database_inline
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
defaultShardingColumn: agent_id
defaultDatabaseStrategy:
standard:
shardingColumn: agent_id
shardingAlgorithmName: database_inline
defaultTableStrategy:
standard:
shardingColumn: user_id
shardingAlgorithmName: order_inline
shardingAlgorithms:
database_inline:
type: INLINE
props:
algorithm-expression: test_order_${agent_id % 6}
order_inline:
type: INLINE
props:
algorithm-expression: order_${user_id % 5}
keyGenerators:
snowflake:
type: SNOWFLAKE
`
--
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
Re: [I] I reported an error using mysql cli `use database` [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #24157: I reported an error using mysql cli `use database`
URL: https://github.com/apache/shardingsphere/issues/24157
--
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] RaigorJiang commented on issue #24157: I reported an error using mysql cli `use database`
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24157:
URL: https://github.com/apache/shardingsphere/issues/24157#issuecomment-1430647124
@ckall
Thank you for your feedback.
In addition, your markdown markup may be incorrect, and the format does not take effect.
--
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