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 2021/12/21 05:02:54 UTC
[GitHub] [shardingsphere] xue2lang opened a new issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
xue2lang opened a new issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
**sharding-proxy when execute connection.setReadOnly(true) ,all datasource in proxy will execute "set session transaction read only"**
when one connection (for datasource a)execute connection.setReadOnly(true),other datasource b c d will change to read only,why this occur??
- 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**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.0.0-beat
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
only one datasource change to read only
### Actual behavior
all datasource change to read only
### Reason analyze (If you can)

this ShardingDatabaseBroadcastRoutingEngine route all datasources
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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] xue2lang edited a comment on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
xue2lang edited a comment on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-998553637
@jingshanglu hi, i add example code ,you can see 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] xue2lang commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-999310030
my question is,why one dal command will effect all schema,i think one tcp session will only effect its schema
--
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] xue2lang commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-998503242
@menghaoranss have any suggest
--
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] jingshanglu commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-999477405
@xue2lang Maybe it is a bug.
--
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] xue2lang commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
xue2lang commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-998553637
@jingshanglu your can see test code
--
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] jingshanglu commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-1006300798
@xue2lang Very in-depth analysis. For this situation, it may be necessary to design database metadata management to be compatible with MySQL behavior. We should sort out the states that need to be managed, and then manage them through zk.
--
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] chengh1 commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
chengh1 commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-1003321510
The sql like `session transaction read only` will execute on all schema, When routing later, it will also route to all datasourcec under the current schema.
--
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] userkdg commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
userkdg commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-1002407993
What's wrong with this problem?
i met 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] jingshanglu commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-998529040
@xue2lang Is it unreasonable that all datasources are set to `session transaction read only`? What is your use case?
--
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] jingshanglu commented on issue #14187: sharding-proxy when execute connection.setReadOnly(true) all datasource in proxy will execute "set session transaction read only"
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #14187:
URL: https://github.com/apache/shardingsphere/issues/14187#issuecomment-1001287229
@xue2lang Are you interested in fixing this problem?we can fully discuss it first, and then fix 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