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/01/21 07:00:48 UTC
[GitHub] [shardingsphere] darkaquarius opened a new issue #14976: We have two datasources, but choose the wrong one
darkaquarius opened a new issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976
there are two datasources used in our project.
old datasource's configuration is, only shards tables, do NOT shards database:
new datasource's configuration is, we shards both databases and tables:
The datasources are:
We use the two datasources by extending spring AbstractRoutingDataSource
```
public class DynamicDataSource extends AbstractRoutingDataSource {
@Override
protected Object determineCurrentLookupKey() {
return DynamicDataSourceHolder.getDataSource();
}
}
```
DynamicDataSourceHolder uses ThreadLocal to choose either old datasource or new datasource.
We read the new datasource first and then write into new datasource by multithreading, as the following:
But sometimes, we find that it wrote to the old dataSource!
For convenience, we added some logs in InlineShardingAlgorithm:
The logs are:
First, we found the new datasource's sharding rules, but then, when we wrote, we unexpectedly found the old datasource sharding rules, so we failed to write data!
And then, we execute the code again, the we succeed!
We counted it, about 100,000 executions will report an error once, Does anyone know why?
--
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 #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976#issuecomment-1042900687
Closed because of no response for long time.
--
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] strongduanmu commented on issue #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976#issuecomment-1020692381
@darkaquarius Can you provide a demo to help reproduce this problem?
--
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] strongduanmu commented on issue #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976#issuecomment-1020692381
@darkaquarius Can you provide a demo to help reproduce this problem?
--
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] darkaquarius commented on issue #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
darkaquarius commented on issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976#issuecomment-1020069309
Although DynamicDataSource is used, we have gotten the correct shardingsphereDataSource every time, so this problem has nothing to do with DynamicDataSource, it is a problem that occurs when entering shardingsphereDataSource.
--
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 closed issue #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976
--
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] strongduanmu commented on issue #14976: We have two datasources, but choose the wrong one
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14976:
URL: https://github.com/apache/shardingsphere/issues/14976#issuecomment-1019628578
Hi @darkaquarius, thank you for your feedback. I see that you are using `DynamicDataSource` to manage multiple `ShardingDataSource`, which is beyond the scope of ShardingSphere's management, so I can't provide help, you need to investigate DynamicDataSource by yourself.
--
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