Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After performing an insert operation within a transaction,the data cannot be queried subsequently #34468

Closed
mlmw92 opened this issue Jan 24, 2025 · 4 comments

Comments

@mlmw92
Copy link

mlmw92 commented Jan 24, 2025

Which version of ShardingSphere did you use?

shardingjdbc 5.5.1

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-JDBC

Expected behavior

If you perform an insert operation within a transaction and then query the data again, you should be able to retrieve it.

Actual behavior

After performing an insert operation within a transaction,the data cannot be queried subsequently

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).

@linghengqian
Copy link
Member

How do you come to this conclusion? This requires a git with minimal reproducible unit tests, and the database can be created with testcontainers or h2database.

Copy link

github-actions bot commented Feb 3, 2025

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.

@github-actions github-actions bot added the stale label Feb 3, 2025
@linghengqian
Copy link
Member

Closed because the current issue is meaningless.

@linghengqian linghengqian closed this as not planned Won't fix, can't repro, duplicate, stale Feb 4, 2025
@mlmw92
Copy link
Author

mlmw92 commented Feb 5, 2025

I have already solved this problem. The reason is that the transactionalReadQueryStrategy property was set to DYNAMIC by default, and I changed it to PRIMARY.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants