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 2026/04/20 07:12:03 UTC

[I] IllegalStateException when import database configuration in Proxy [shardingsphere]

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

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   5.5.4-SNAPSHOT 1358c7bfc8e573534cc61e061b95b2fd8705a71e
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   Import database success
   
   ### Actual behavior
   Exception occurs
   
   ### Reason analyze (If you can)
   No
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   1. Create logic database
   ```sql
   create database sharding_db;
   
   use sharding_db;
   ```
   
   2. Register storage unit
   ```sql
   REGISTER STORAGE UNIT ds_0 (
       URL="jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true",
       USER="root",
       PASSWORD="123456",
       PROPERTIES("maximumPoolSize"=10)
   );
   ```
   
   3. Load single table
   ```sql
   show unloaded single tables;
   
   load single table *.*;
   
   show single tables;
   ```
   
   4. Export database configuration
   ```sql
   export database configuration to file '/tmp/database-sharding-db.yaml';
   ```
   
   5. Import database configuration
   - Drop database first
   ```sql
   use mysql;
   drop database sharding_db;
   ```
   
   - Import
   ```sql
   import database configuration from file '/tmp/database-sharding-db.yaml';
   ```
   
   <img width="738" height="296" alt="Image" src="https://github.com/user-attachments/assets/e767ca1b-cfda-4087-a91d-d5fa4901a40b" />
   
   
   - Error log in Proxy
   
   <img width="1277" height="302" alt="Image" src="https://github.com/user-attachments/assets/dffb9815-c3c7-4a38-b83d-ad047d706915" />
   


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


Re: [I] IllegalStateException when import database configuration in Proxy [shardingsphere]

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #38640: IllegalStateException when import database configuration in Proxy
URL: https://github.com/apache/shardingsphere/issues/38640


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