Project

General

Profile

Actions

Bug #13582

closed

Hikari pool autocomit configuration is incorrect, which can impact performance

Added by François ARMAND over 5 years ago. Updated over 5 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
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 open1 closed)

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

Updated by François ARMAND over 5 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from François ARMAND to Nicolas CHARLES
  • Pull Request set to https://github.com/Normation/rudder/pull/2041
Actions #2

Updated by Vincent MEMBRÉ over 5 years ago

  • Subject changed from Hikari pool autocomit is badly configured, which can impact performance to Hikari pool autocomit configuration is incorrect, which can impact performance
Actions #3

Updated by François ARMAND over 5 years ago

  • Status changed from Pending technical review to Pending release
Actions #4

Updated by Vincent MEMBRÉ over 5 years ago

  • Status changed from Pending release to Released
This bug has been fixed in Rudder 4.1.15, 4.3.5 and 5.0.1 which were released today.
Changelog
Changelog
Changelog
Actions #5

Updated by Nicolas CHARLES about 5 years ago

  • Related to Bug #14056: Cannot modify groups when workflow are enabled added
Actions

Also available in: Atom PDF