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 2020/07/13 09:36:28 UTC
[GitHub] [shardingsphere] ericboy opened a new issue #6334: Cannot display logical table name
ericboy opened a new issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334
I have download apache-shardingsphere-4.1.1-sharding-proxy-bin.tar.gz by
```
https://www.apache.org/dyn/closer.cgi/shardingsphere/4.1.1/apache-shardingsphere-4.1.1-sharding-proxy-bin.tar.gz
```
# Version:
sharding-proxy:4.1.0
mysql:5.7
# Configure
server.yaml
```
authentication:
users:
root:
password: root
sharding:
password: sharding
authorizedSchemas: sharding_db
#
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: false
# allow.range.query.with.inline.sharding: false
```
config-sharding.yaml
```
schemaName: sharding_db
dataSources:
ds_0:
url: jdbc:mysql://192.168.50.111:3306/demo_ds_0?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url: jdbc:mysql://192.168.50.111:3306/demo_ds_1?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
t_order:
actualDataNodes: ds_${0..1}.t_order_${0..1}
tableStrategy:
inline:
shardingColumn: order_id
algorithmExpression: t_order_${order_id % 2}
keyGenerator:
type: SNOWFLAKE
column: order_id
t_order_item:
actualDataNodes: ds_${0..1}.t_order_item_${0..1}
tableStrategy:
inline:
shardingColumn: order_id
algorithmExpression: t_order_item_${order_id % 2}
keyGenerator:
type: SNOWFLAKE
column: order_item_id
bindingTables:
- t_order,t_order_item
defaultDatabaseStrategy:
inline:
shardingColumn: user_id
algorithmExpression: ds_${user_id % 2}
defaultTableStrategy:
none:
```
# Start
windows10 to start <label style="color:red">start.bat</label>
# <label style="color:red">Quetion</label>
when I connection sharding-proxy , cannot see <label style="color:red">sharding_db</label>
and demos tables has create on dataSources, and I have check the configure , do not found question ,please help,
Thank you very much!
----------------------------------------------------------------
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] ericboy commented on issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
ericboy commented on issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334#issuecomment-657491221
Navicat 12.1
# demos database images
![1594637784](https://user-images.githubusercontent.com/25583681/87297290-cad5b680-c53a-11ea-9e6b-839e977a8a66.jpg)
# shardpoxy database images
![image](https://user-images.githubusercontent.com/25583681/87297391-ed67cf80-c53a-11ea-98f4-9ceb878c5321.png)
----------------------------------------------------------------
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] ericboy commented on issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
ericboy commented on issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334#issuecomment-657494356
start successful, no error!
```
Starting the Sharding-Proxy ...
17:26:32,497 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
17:26:32,497 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
17:26:32,497 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/sharding-proxy-bootstrap-4.1.1.jar!/logback.xml]
17:26:32,497 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs multiple times on the classpath.
17:26:32,497 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/sharding-proxy-distribution-4.1.1.jar!/logback.xml]
17:26:32,497 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/sharding-proxy-bootstrap-4.1.1.jar!/logback.xml]
17:26:32,513 |-INFO in ch.qos.logback.core.joran.spi.ConfigurationWatchList@15b3e5b - URL [jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/sharding-proxy-bootstrap-4.1.1.jar!/logback.xml] is not of type file
17:26:32,545 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
17:26:32,547 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
17:26:32,552 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [console]
17:26:32,557 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
17:26:32,599 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.apache.shardingsphere] to INFO
17:26:32,599 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.shardingsphere] to false
17:26:32,599 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [console] to Logger[org.apache.shardingsphere]
17:26:32,600 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to INFO
17:26:32,600 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [console] to Logger[ROOT]
17:26:32,600 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
17:26:32,601 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@61ca2dfa - Registering current configuration as safe fallback point
[INFO ] 17:26:32.631 [main] o.a.s.core.log.ConfigurationLogger - ShardingRuleConfiguration:
bindingTables:
- t_order,t_order_item
defaultDatabaseStrategy:
inline:
algorithmExpression: ds_${user_id % 2}
shardingColumn: user_id
defaultTableStrategy:
none: ''
tables:
t_order:
actualDataNodes: ds_${0..1}.t_order_${0..1}
keyGenerator:
column: order_id
type: SNOWFLAKE
logicTable: t_order
tableStrategy:
inline:
algorithmExpression: t_order_${order_id % 2}
shardingColumn: order_id
t_order_item:
actualDataNodes: ds_${0..1}.t_order_item_${0..1}
keyGenerator:
column: order_item_id
type: SNOWFLAKE
logicTable: t_order_item
tableStrategy:
inline:
algorithmExpression: t_order_item_${order_id % 2}
shardingColumn: order_id
[INFO ] 17:26:32.660 [main] o.a.s.core.log.ConfigurationLogger - Authentication:
users:
root:
authorizedSchemas: ''
password: root
sharding:
authorizedSchemas: sharding_db
password: sharding
[INFO ] 17:26:32.661 [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: false
acceptor.size: 16
proxy.opentracing.enabled: false
[INFO ] 17:26:32.762 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
[INFO ] 17:26:32.953 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
[INFO ] 17:26:32.954 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
[INFO ] 17:26:32.962 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
[INFO ] 17:26:32.997 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/transactions-4.0.6.jar!/transactions-defaults.properties
[INFO ] 17:26:32.997 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/F:/ShardingSphere/sharding-proxy-4.1.1/lib/sharding-transaction-xa-atomikos-manager-4.1.1.jar!/transactions.properties
[WARN ] 17:26:33.012 [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:26:33.023 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 17:26:33.024 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 17:26:33.027 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 17:26:33.028 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 17:26:33.031 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 17:26:33.032 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.client_demarcation = false
[INFO ] 17:26:33.033 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.threaded_2pc = false
[INFO ] 17:26:33.033 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 17:26:33.034 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 17:26:33.034 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.rmi_export_class = none
[INFO ] 17:26:33.035 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 17:26:33.035 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 17:26:33.036 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 17:26:33.036 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 17:26:33.038 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 17:26:33.041 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.trust_client_tm = false
[INFO ] 17:26:33.042 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 17:26:33.042 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 192.168.50.104.tm
[INFO ] 17:26:33.043 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 17:26:33.043 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 17:26:33.044 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.provider.url = rmi://localhost:1099
[INFO ] 17:26:33.044 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 17:26:33.044 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 17:26:33.045 [main] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
[INFO ] 17:26:33.106 [main] c.a.d.xa.XATransactionalResource - resource-1-ds_0: refreshed XAResource
[INFO ] 17:26:33.127 [main] c.a.d.xa.XATransactionalResource - resource-2-ds_1: refreshed XAResource
[INFO ] 17:26:33.524 [main] ShardingSphere-metadata - Loading 2 logic tables' meta data.
[INFO ] 17:26:34.934 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9] REGISTERED
[INFO ] 17:26:34.942 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9] BIND: 0.0.0.0/0.0.0.0:3307
[INFO ] 17:26:34.944 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] ACTIVE
[INFO ] 17:26:46.000 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0xdb9d31b6, L:/127.0.0.1:3307 - R:/127.0.0.1:55582]
[INFO ] 17:26:46.002 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 17:27:26.559 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x184c095d, L:/127.0.0.1:3307 - R:/127.0.0.1:55583]
[INFO ] 17:27:26.560 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
[INFO ] 17:27:30.610 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ: [id: 0x60e9f1e4, L:/127.0.0.1:3307 - R:/127.0.0.1:55584]
[INFO ] 17:27:30.611 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd3c84ad9, L:/0:0:0:0:0:0:0:0:3307] READ COMPLETE
```
----------------------------------------------------------------
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] ericboy commented on issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
ericboy commented on issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334#issuecomment-657499761
I tried it with my colleague,ok,his is navicat 11.0
thank you very much
----------------------------------------------------------------
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] menghaoranss commented on issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334#issuecomment-658046229
Thanks for your feedback, could you please close the issue now?
----------------------------------------------------------------
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] menghaoranss commented on issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334#issuecomment-657479057
What client do you use to connect to mysql, any error logs ?
----------------------------------------------------------------
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] ericboy closed issue #6334: Cannot display logical table name
Posted by GitBox <gi...@apache.org>.
ericboy closed issue #6334:
URL: https://github.com/apache/shardingsphere/issues/6334
----------------------------------------------------------------
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