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/09/30 02:53:05 UTC
[GitHub] [shardingsphere] RaigorJiang opened a new issue #11013: Drop resource error with DistSQL
RaigorJiang opened a new issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013
## Bug Report
### Which version of ShardingSphere did you use?
ShardingSphere-Proxy 5.0.0-beta
### Expected behavior
Use distSQL, add a resource:
```sql
ADD RESOURCE resource_0 (
HOST=127.0.0.1,
PORT=3306,
DB=db0,
USER=root,
PASSWORD=root
);
```
and then drop the resource immediately (did not config any other rule):
```sql
DROP RESOURCE resource_0
```
Expect the `resource_0` was deleted.
### Actual behavior
Got error:
` Error Code: 1101. Resources [resource_0] in the rule are still in used.`
### Reason analyze
After the resource added, proxy refresh `ShardingRule` at the backend. `resource_0` may be relted to a `SingleTableRule` in class `SingleTableRuleLoader`.
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013#issuecomment-883035449
It was fixed by https://github.com/apache/shardingsphere/pull/11324
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013
--
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] tristaZero closed issue #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013#issuecomment-930707816
Currently, if there is a singletableRule uses the resource, `drop` still cannot be successful.
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013#issuecomment-883035449
It was fixed by https://github.com/apache/shardingsphere/pull/11324
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013#issuecomment-868399925
refer to #9204
My case is not readwrite-splitting, but each database has the same table, and the table is not in any rule.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013
--
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 #11013: Drop resource error with DistSQL
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11013:
URL: https://github.com/apache/shardingsphere/issues/11013#issuecomment-883035449
It was fixed by https://github.com/apache/shardingsphere/pull/11324
--
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