cherrylzhao commented on issue #3015: URL: https://github.com/apache/shardingsphere/issues/3015#issuecomment-645725136
There are 2 transaction exception when `max.connections.size.per.query > 1` 1. `write-write` transaction exception (#3015) If write-operation-1 hold 4 connections of database1, then write-operation-2 may use a cached connection which lack of privilege to access the record and then dead lock exception happed. 2. `write-query` transaction exception (#3732) If write-operation-1 only hold 1 connection of database1, but query-operation-2 may get another connections from datasources which lack of privilege to access the write-operation-1 record, and then uncommitted records will not be visible. ---------------------------------------------------------------- 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: [email protected]
