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 2020/08/19 03:58:00 UTC

[GitHub] [shardingsphere] yxb-git opened a new issue #6924: The same transaction, the data is inconsistent

yxb-git opened a new issue #6924:
URL: https://github.com/apache/shardingsphere/issues/6924


   Hello, 
   I use sharding-proxy to directly link proxy database. 
   In the same transaction, query and update access different databases. 
   Example: 
           tx := apiDB.Begin()
   	var user TabUser
   	tx.Where("id = ?", 1).First(&user)
   	tx.Model(&user).Where("id = ?", 1).Updates(map[string]interface{}{"age": 0})
   	tx.Commit()
   Is there any problem with my approach, 
   Thanks


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] wcsoft commented on issue #6924: The same transaction, the data is inconsistent

Posted by GitBox <gi...@apache.org>.
wcsoft commented on issue #6924:
URL: https://github.com/apache/shardingsphere/issues/6924#issuecomment-675893316


   @yxb-git 
   We feel sorry that it's hardly to find any clue about ShardingSphere from the code you provide. Could you provide more details such as yaml configuraion, version of ShardingProxy etc.
   
   It's pleasure you can type more information in format like this:
   
   - What's the issue?
   - How to reproduce it?
   - What's the actural result?
   - What's your expectation?
   -  What's the version of ShardingSphere
   -  Provide the configuration about ShardingSphere if you have.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu closed issue #6924: The same transaction, the data is inconsistent

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #6924:
URL: https://github.com/apache/shardingsphere/issues/6924


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #6924: The same transaction, the data is inconsistent

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6924:
URL: https://github.com/apache/shardingsphere/issues/6924#issuecomment-675888738


   Hi @yxb-git 
   Your comment is insufficient. Please set `sql.show` = true to get the log and configuration.
   
   Thanks,
   Trista


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] terrymanu commented on issue #6924: The same transaction, the data is inconsistent

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #6924:
URL: https://github.com/apache/shardingsphere/issues/6924#issuecomment-680619216


   Closed because of no response anymore


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org