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/08/25 02:43:05 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new issue, #20502: Got an exception but `CREATE READWRITE_SPLITTING RULE` success.

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

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   master 6cf1f1e8352d7be5c501a5626ef44e708a5b0d2b
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   `CREATE READWRITE_SPLITTING RULE` failed.
   
   ### Actual behavior
   Got an exception but `CREATE READWRITE_SPLITTING RULE` success.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   1. Create `ms_group_0`, use `resource_0`
   ```sql
   CREATE READWRITE_SPLITTING RULE ms_group_0 (
   WRITE_RESOURCE=resource_0,
   READ_RESOURCES(resource_1),TYPE(NAME=random)
   );
   ```
   2. Create `ms_group_1`, use `resource_0` too
   ```sql
   CREATE READWRITE_SPLITTING RULE ms_group_1` (
   WRITE_RESOURCE=resource_0,
   READ_RESOURCES(resource_1),TYPE(NAME=random)
   );
   ```
   ### log
   ```
   ERROR 1999 (42000): Unknown exception: Can not config duplicate write data source `resource_0` in database `test1`.
   ```
   
   But when I execute `show readwrite_splitting rules`, `ms_group_1` exists.
   


-- 
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 #20502: Got an exception but `CREATE READWRITE_SPLITTING RULE` success.

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

   Related to #19102


-- 
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 #20502: Got an exception but `CREATE READWRITE_SPLITTING RULE` success.

Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #20502: Got an exception but `CREATE READWRITE_SPLITTING RULE` success.
URL: https://github.com/apache/shardingsphere/issues/20502


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