[CONJ-978] useBatchMultiSend setting as jdbc param is not honored since 2.7.5 Created: 2022-05-31  Updated: 2022-08-16  Resolved: 2022-08-16

Status: Closed
Project: MariaDB Connector/J
Component/s: aurora
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Tomas Assignee: Diego Dupin
Resolution: Incomplete Votes: 0
Labels: None

Issue Links:
Relates
relates to CONJ-948 Under certain circumstances, Connecto... Closed

 Description   

Hello, in CONJ-895 usage of useBatchMultiSend (another param was also changed). This was merged into 2.7.5. When using this driver we explicitly now set useBatchMultiSend to false.

However, it does not seem to work correctly. Actually, when our app sends multiple inserts into a single table, the communication hangs in the middle and we are left with a connection leak.
Downgrading to 2.7.4 fixes the issue for us.

 Comments   
Comment by Diego Dupin [ 2022-06-22 ]

Is this an Aurora server ? This kind of server has issue with pipeline that can lead to this kind of result.

CONJ-895 correct some issue that was disabling pipelining for RDS instance without reason.
Driver now only check for aurora "jdbc:mariadb:aurora://" pattern.

In case of using an aurora server without setting aurora configuration, pipelining option (useBatchMultiSend and usePipelineAuth) must explicitly be disabled.

Comment by Diego Dupin [ 2022-08-16 ]

closing since no answer

Generated at Thu Feb 08 03:19:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.