apache / apache/incubator-seata

shardingsphere conflict with seata

Open
#3,103 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
26k
Forks
8.8k
Avg merge
1d 8h
Merged PRs (30d)
4

Description

When only use shardingsphere : sharding is OK (only choise one db and one table)

When only use shardingsphere with seata : sharding is ERROR(Scan all db and table) like
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_0 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_1 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_2 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_3 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_4 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_5 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_6 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_7 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_8 LIMIT 1
15:16:15.370 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_9 LIMIT 1
15:16:15.371 INFO [main] ShardingSphere-SQL - Actual SQL: bookshelf_0 ::: SELECT * FROM shelf_book_key_10 LIMIT 1
......
sharding-transaction-base-seata-at It doesn't help.


org.apache.shardingsphere
sharding-jdbc-spring-boot-starter
4.1.1


org.apache.shardingsphere
sharding-jdbc-spring-namespace
4.1.1


org.apache.shardingsphere
sharding-transaction-base-seata-at
4.1.2

notice :4.1.2 is my version be used for fix SeataATShardingTransactionManager can't read seata.conf


io.seata
seata-spring-boot-starter
1.3.0

Contributor guide

Open the contributing guide

Research direction

Reproduce the reported behavior with the listed ShardingSphere 4.1.1, Seata AT 4.1.2, and Seata Spring Boot 1.3.0 dependencies, comparing ShardingSphere alone with the Seata integration. Trace the configuration and transaction interaction; done when a sharded query selects only its intended database and table instead of scanning all tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, spring-boot
Domain
databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.