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

[GitHub] [shardingsphere] zhaojinchao95 opened a new issue, #25576: ShardingSphere' s curator usage has event blocking risk.

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

   Hi community,
   
    Currently, ShardingSphere' s curator usage has event blocking risk. because [ZooKeeper watches are single threaded](https://cwiki.apache.org/confluence/display/CURATOR/TN1), So we can't use curator thread to do something. For example, load database metadata or persist data to governance center. 
   
   Reproduce Steps:
   
   ```
   1. CREATE DATABASE sharding_db;
   2. USE sharding_db;
   3. REGISTER STORAGE UNIT ds_0 (
       URL="jdbc:mysql://127.0.0.1:3306/yy?serverTimezone=UTC&allowPublicKeyRetrieval=true&useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000",
       USER="root",
       PASSWORD="root",
       PROPERTIES("maximumPoolSize"=20,"minimumIdle"=1,"idleTimeout"="30000")
   );
   The ds_0 data source has 1k+ tables.
   
   4. SET DIST VARIABLE sql_show = true; // sql_show is always false and need to a long time to update.
   5. SHOW DIST VARIABLES;
   ```


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


Re: [I] Curator usage has event blocking risk. [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #25576:
URL: https://github.com/apache/shardingsphere/issues/25576#issuecomment-1973838765

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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] boyjoy1127 commented on issue #25576: Curator usage has event blocking risk.

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

   Will this issue be completed before June 15 which is the final date of version 5.4.0?


-- 
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] github-actions[bot] commented on issue #25576: Curator usage has event blocking risk.

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #25576:
URL: https://github.com/apache/shardingsphere/issues/25576#issuecomment-1657254268

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


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