You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "RaigorJiang (via GitHub)" <gi...@apache.org> on 2023/02/02 04:29:57 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new issue, #23919: DROP SHARDING TABLE RULE execution failed

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

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   master 87f4f45d
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   DROP SHARDING TABLE RULE executed successfully
   
   ### Actual behavior
   ```sql
   Cannot invoke "org.apache.shardingsphere.sharding.api.config.strategy.audit.ShardingAuditStrategyConfiguration.getAuditorNames()" because the return value of "org.apache.shardingsphere.sharding.api.config.rule.ShardingAutoTableRuleConfiguration.getAuditStrategy()" is null
   ```
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   - DistSQL
   ```sql
   REGISTER STORAGE UNIT ds_0 (
       HOST="127.0.0.1",
       PORT=3306,
       DB="demo_ds_0",
       USER="root",
       PASSWORD="xxx"
   ),ds_1 (
       HOST="127.0.0.1",
       PORT=3306,
       DB="demo_ds_1",
       USER="root",
       PASSWORD="xxx"
   );
   
   CREATE SHARDING TABLE RULE t_order(
   STORAGE_UNITS(ds_0,ds_1),
   SHARDING_COLUMN=order_id,
   TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="4")),
   KEY_GENERATE_STRATEGY(COLUMN=order_id,TYPE(NAME="snowflake"))
   );
   
   CREATE SHARDING TABLE RULE t_order_item(
   STORAGE_UNITS(ds_0,ds_1),
   SHARDING_COLUMN=order_id,
   TYPE(NAME="hash_mod",PROPERTIES("sharding-count"="4")),
   KEY_GENERATE_STRATEGY(COLUMN=order_item_id,TYPE(NAME="snowflake"))
   );
   
   DROP SHARDING TABLE RULE t_order_item;
   ```
   


-- 
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 #23919: DROP SHARDING TABLE RULE execution failed

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #23919:
URL: https://github.com/apache/shardingsphere/issues/23919#issuecomment-1414751167

   Thank you! @Pace2Car 


-- 
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 #23919: DROP SHARDING TABLE RULE execution failed

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #23919: DROP SHARDING TABLE RULE execution failed
URL: https://github.com/apache/shardingsphere/issues/23919


-- 
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 #23919: DROP SHARDING TABLE RULE execution failed

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #23919:
URL: https://github.com/apache/shardingsphere/issues/23919#issuecomment-1413137604

   Related to #22361, @Pace2Car Could you have a check?


-- 
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] Pace2Car commented on issue #23919: DROP SHARDING TABLE RULE execution failed

Posted by "Pace2Car (via GitHub)" <gi...@apache.org>.
Pace2Car commented on issue #23919:
URL: https://github.com/apache/shardingsphere/issues/23919#issuecomment-1413139012

   I will try to 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