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 2022/06/27 09:24:30 UTC

[GitHub] [shardingsphere] Bingai077 opened a new issue, #18631: hint route cache invalidation

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

   ## Question
   hint routeļ¼š
   /* ShardingSphere hint: dataSourceName= test */SELECT COUNT(*) AS total FROM account AS a
   The result varies after multiple executions.
   Found in the project.
   
   


-- 
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] terrymanu commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168799578

   This design break the ShardingSphere concept. User should not acre about the actual data source in DistSQL.
   We will remove /* ShardingSphere hint: dataSourceName= XXX */ before 5.1.3 release.


-- 
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] Bingai077 commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168135755

   ShardingSphere-Proxy 5.1.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] terrymanu closed issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #18631: hint route cache invalidation
URL: https://github.com/apache/shardingsphere/issues/18631


-- 
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] Bingai077 commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168427581

   >ShardingSphere-Proxy 5.1.0   
    Online environment (Docker environment publishing) application connection proxy will open multiple threads, resulting in inconsistent query data. Please tell me how to solve 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] Bingai077 commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168134904

   ShardingSphere-Proxy


-- 
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] zhenglu8 commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
zhenglu8 commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1167219580

   ### Which version of ShardingSphere did you use?
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?


-- 
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] Bingai077 commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168426493

   Online environment (Docker environment publishing) application connection proxy will open multiple threads, resulting in inconsistent query data. Please tell me how to solve 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] terrymanu commented on issue #18631: hint route cache invalidation

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18631:
URL: https://github.com/apache/shardingsphere/issues/18631#issuecomment-1168800400

   Please see #18620


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