RaigorJiang opened a new issue #13426: URL: https://github.com/apache/shardingsphere/issues/13426
### Background DistSQL is a new feature of version 5.0. Users may encounter some error prompts when using it, but do not understand how to deal with these situations. ### Aim Add FAQ, point out the cause of the error message, and provide solutions. ### How to 1. Understand the error message in the task description, investigate and confirm the cause. (Of course you can also ask for help) 2. Edit the [FAQ](https://github.com/apache/shardingsphere/tree/master/docs/document/content/reference/faq) files to add related questions and answers. 3. If you are not good at Chinese, you can also submit an English FAQ independently. ### Task - DROP RESOURCE ```sql mysql> ADD RESOURCE ds_0 ( -> HOST=127.0.0.1, -> PORT=3306, -> DB=demo_ds_0, -> USER=root, -> PASSWORD=123456, -> PROPERTIES("maximumPoolSize"=10) -> ); Query OK, 0 rows affected (0.68 sec) mysql> show schema resources; +------+-------+-----------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | name | type | host | port | db | attribute | +------+-------+-----------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ds_0 | MySQL | 127.0.0.1 | 3306 | demo_ds_0 | {"maxLifetimeMilliseconds":1800000,"readOnly":false,"customPoolProps":{"maximumPoolSize":"10"},"minPoolSize":1,"idleTimeoutMilliseconds":60000,"maxPoolSize":50,"connectionTimeoutMilliseconds":30000} | +------+-------+-----------+------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.05 sec) mysql> drop resource ds_0; ERROR 1101 (C1101): Resource [ds_0] is still used by [SingleTableRule]. ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
