<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<ul dir="auto">
<li>shardingsphere-jdbc-core-spring-boot-starter：5.0.0-beta</li>
<li>mybatis-plus-boot-starter：3.4.3.1</li>
</ul>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">only use ShardingSphere-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">The SQL exception information can be obtained.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Failed to obtain the SQL exception information.</p>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<ol dir="auto">
<li>The database field 'status' set to mandatory.</li>
<li>use mybatis-plus provide the save function to save the entity not set status value.</li>
<li>can print insert log without exception，but don't success to save the data.</li>
</ol>
<h2 dir="auto">Bug Report</h2>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.1.0</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">transaction rollback(proxy-db) when connection ( application-proxy) is closed</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">transaction no rollback(proxy-db) when connection ( application-proxy) is closed</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/20919316/176368125-9b7c3595-f0f1-4534-bdcb-ff44acbcc4de.png"><img src="https://user-images.githubusercontent.com/20919316/176368125-9b7c3595-f0f1-4534-bdcb-ff44acbcc4de.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">When the above figure is executed to step 4-6, the disconnection of the upstream connection triggers the channelInactive method of Netty. At this time, the resources in the JDBCBackendConnection are still empty. Because step 7 has not been started, the subsequent step 7 is executed after the resources are cleaned up, and the subsequent connection will remain there.</p>
<p dir="auto">JDBCBackendConnection Whether to add a new status to control the addition of connections？</p>