You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/07/17 04:39:17 UTC
[GitHub] [shardingsphere] lyf200581105 opened a new issue, #19278: Sharding-jdbc Can't findById after insert the data
lyf200581105 opened a new issue, #19278:
URL: https://github.com/apache/shardingsphere/issues/19278
Using sharding-jdbc-core 4.1.1， only sharding tables
DB : AWS Aurora
Both read and write operations are using master endpoint
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.1.1</version>
</dependency>
Using Jmeter to do some performance test
step 1: call create API to insert data to DB and return id
step 2: call get API with ID returned by step1 to query the data by Id, about 70% results showed data not found
But if pause about 30ms between step1 and step2, then all queries of step2 return successfully
And I did a similar test for no sharding tables, and all works fine.
I saw there is a statement for LOCAL Transaction as below
"There is no loss in performance, but strong consistency and final consistency cannot be guaranteed."
So is the insert delay I met caused by the strong consistency issue of local consistency? or did someone encounter a similar issue before?
--
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] terrymanu closed issue #19278: Sharding-jdbc Can't findById after insert the data
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #19278: Sharding-jdbc Can't findById after insert the data
URL: https://github.com/apache/shardingsphere/issues/19278
--
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] terrymanu commented on issue #19278: Sharding-jdbc Can't findById after insert the data
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19278:
URL: https://github.com/apache/shardingsphere/issues/19278#issuecomment-1186419190
The version 4.x is out of service, please try to version 5.x
--
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] lyf200581105 commented on issue #19278: Sharding-jdbc Can't findById after insert the data
Posted by GitBox <gi...@apache.org>.
lyf200581105 commented on issue #19278:
URL: https://github.com/apache/shardingsphere/issues/19278#issuecomment-1186960517
hi @terrymanu
I had update to version 5.1.1., issue still exist
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core</artifactId>
<version>5.1.1</version>
</dependency>
below is part of the log:
--
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