[GitHub] [shardingsphere] mbql commented on issue #24042: sharding-jdbc integration seata Java.sqlexception: Failed to fetch schema of stock

["mbql (via GitHub)" <gi...@apache.org>]

mbql commented on issue #24042:
URL: https://github.com/apache/shardingsphere/issues/24042#issuecomment-1423815371

   > Looks like a complicated scenario, can you provide a demo to reproduce this problem?
   
   Yes, first of all, this scenario is based on the micro-service architecture. Each service is divided into database and table and read-write separation. Components: seata version 1.6.1, shardingsphere version 5.2.1, dubbo version 3.2.0-beta.3, mybatis-plus version 3.5.3.1. I made a common e-shopping scene here. Three services, commodity service, inventory service and order service, were started, and the remote call was made through remote dubbo rpc. When the order was requested, the error mentioned above occurred when the inventory service was called to deduct the inventory, that is, the logical database did not exist, because the sharding was done here, the logical library should be resolved into the real library. This does not result in an error for the underlying jdbc operations. However, this is not the case. See the previous description for the debugging results. Repeat scenario: This problem may occur when both the caller and the called party divide libraries and tables. Demo
  is also provided here for testing.
   The Demo is reproduced as follows:
   [sueno-shop.zip](https://github.com/apache/shardingsphere/files/10694802/sueno-shop.zip)
   


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