You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "liuxiaocs7 (via GitHub)" <gi...@apache.org> on 2023/03/31 05:43:03 UTC

[GitHub] [shardingsphere] liuxiaocs7 opened a new issue, #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

liuxiaocs7 opened a new issue, #24919:
URL: https://github.com/apache/shardingsphere/issues/24919

   ## Question
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   ---
   
   Hi, community,  i start `org.apache.shardingsphere.proxy.Bootstrap` by IDEA (set argument `3307` as port)
   
   `server.yaml` conf:
   
   ```yaml
   mode:
     type: Cluster
     repository:
       type: ZooKeeper
       props:
         namespace: governance_ds
         server-lists: localhost:2181
         retryIntervalMilliseconds: 500
         timeToLiveSeconds: 60
         maxRetries: 3
         operationTimeoutMilliseconds: 500
   
   authority:
     users:
       - user: root@%
         password: root
       - user: sharding
         password: sharding
     privilege:
       type: ALL_PERMITTED
   ```
   
   ```
   [INFO ] 2023-03-31 13:39:53.048 [Pipeline-EventListener-2] o.a.s.d.p.c.m.n.e.h.i.ConfigMetaDataChangedEventHandler - ADDED job configuration: /pipeline/jobs/j0302p0000fb15926d7953f53bdad7b0763b42ac91/config, disabled=false
   [INFO ] 2023-03-31 13:39:53.505 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy Cluster mode started successfully
   ```
   
   But when I try to connect to the proxy using the mysql client, it seems to be stuck.
   
   ![image](https://user-images.githubusercontent.com/42756849/229032907-c5c58123-df6b-4f8a-9112-bd960e4ecaef.png)
   
   So how to use DistSQL in native ShardingSphere-Proxy or only support configuration by yaml now  in local mode?
   
   


-- 
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] RaigorJiang commented on issue #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1498430815

   Hi @liuxiaocs7 
   Sorry, I can't reproduce your problem. Please help with a few questions:
   1. When you use standalone mode, can the mysql client connect to the Proxy normally?
   2. In your zookeeper namespace (governance_ds), do you have historical data?
   3. If there is a historical data, whether it contains `proxy-frontend-database-protocol-type` in props?


-- 
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 #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1515627218

   OK, thanks for the feedback.
   
   Now the ShardingSphere source code needs to be compiled with JDK 11 or above, but the binary file supports running on JDK 8.
   
   This issue you found is very interesting. Anyway, congratulations on solving the problem.


-- 
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 #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1515629886

   My JDK version:
   
   <img width="559" alt="image" src="https://user-images.githubusercontent.com/5668787/233243701-c2ad3330-5042-40a2-af3f-bea8c6f3d3de.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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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


[GitHub] [shardingsphere] liuxiaocs7 commented on issue #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "liuxiaocs7 (via GitHub)" <gi...@apache.org>.
liuxiaocs7 commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1492223392

   > Proxy is indeed used as such, both in binary and in IDEs. Did you get any exception messages?
   
   Hi, @RaigorJiang, I added some notes to make the problem description clearer, and there is no exception message in IDEA's console.


-- 
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 #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1492178337

   Proxy is indeed used as such, both in binary and in IDEs.
   Did you get any exception messages?


-- 
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] liuxiaocs7 commented on issue #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "liuxiaocs7 (via GitHub)" <gi...@apache.org>.
liuxiaocs7 commented on issue #24919:
URL: https://github.com/apache/shardingsphere/issues/24919#issuecomment-1515222615

   Hi, @RaigorJiang, Sorry for late.
   
   1.  when I use standalone mode, mysql client can connect to the Proxy normally.
   2.  I deleted default zookeeper namespace (governance_ds) and tried, but failed too.
   3. `proxy-frontend-database-protocol-type` is not included in props, `server.yaml` as conf as shown above, no other configuration
   
   ---
   
   I found that it may be a problem with the JDK version. After switching to JDK17, I can log in successfully.
   
   Before:
   <img width="483" alt="Snipaste_2023-04-20_02-54-13" src="https://user-images.githubusercontent.com/42756849/233173485-eed5f1eb-6c95-426d-b8f1-10e06d055123.png">
   After:
   <img width="455" alt="Snipaste_2023-04-20_02-56-45" src="https://user-images.githubusercontent.com/42756849/233173511-c592749b-03e8-4658-97f8-5e6f16995097.png">
   
   Result:
   ![image](https://user-images.githubusercontent.com/42756849/233173627-431921c7-f411-42c5-8194-7c144841ff09.png)
   
   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.

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 closed issue #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #24919: [Question] How to use DistSQL in native ShardingSphere-Proxy
URL: https://github.com/apache/shardingsphere/issues/24919


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