Project

General

Profile

Actions
Copy link

Bug #13582

closed

Hikari pool autocomit configuration is incorrect, which can impact performance

Added by François ARMAND about 6 years ago. Updated about 6 years ago.

Status:
Released
Priority:
N/A
Assignee:
Nicolas CHARLES
Category:
Performance and scalability
Target version:
4.1.15
Pull Request:
https://github.com/Normation/rudder/p...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Fix check:
Regression:

Description

With Hicari in debug, we see a lot of:

[2018-09-26 16:58:58] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@275d4254
[2018-09-26 16:59:03] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@275d4254
[2018-09-26 16:59:03] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Reset (autoCommit) on connection org.postgresql.jdbc.PgConnection@275d4254

Which seems to mean that the pool is not correctly configured regarding autocommit, see: https://stackoverflow.com/questions/41202242/reset-autocommit-on-connection-in-hikaricp

Related issues 1 (0 open — 1 closed)

Related to Rudder - Bug #14056: Cannot modify groups when workflow are enabledReleasedVincent MEMBRÉActions
Actions
Copy link

Also available in: Atom PDF