Actions
Architecture #16051
open
Re-authentication error in postgres doesn't kill existing pool
Added by Elaad FURREEDAN over 4 years ago. Updated 4 days ago.
Pull Request:
Effort required:
Name check:
To do
Fix check:
To do
Regression:
Files
| thread_jvm.log (125 KB) thread_jvm.log | Elaad FURREEDAN, 2019-10-24 14:30 |
Updated by
Updated by François ARMAND over 4 years ago
- Related to Bug #16055: java.lang.Error null in PooledConnectionProvider added
Updated by François ARMAND over 4 years ago
- Subject changed from Rudder is very slow to Authentication error to postgres cause major slowdown
- Category set to System integration
- Target version changed from 6.0.0~beta1 to 6.0.0
The problem is linked to Postgres DB connexion dying and the pool does not seems to notice. We can see it very clearly in the log here: https://issues.rudder.io/attachments/1549
So we have the connexion starting to fails around 2019-10-24 12:35:38+0200 - most likely rudder agent is running and reconfigured something on pg, restarting the db after that.
Then, at 2019-10-24 14:16:20+0200 we finaly have:
ERROR com.normation.rudder.rest.v1.RestTechniqueReload - Root exception cause was:
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "rudder"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:520)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
And then, everything related to PG fails. It's as if PG was restarted to take care of new auth info, but the connexion didn't noticed the pb. Moreover, Rudder should have been restarted to get the new info, but wasn't.
Updated by Elaad FURREEDAN over 4 years ago
- Related to Bug #12489: Cannot login into 2 different Rudder with the same URL - apocalypse ensues added
Updated by Elaad FURREEDAN over 4 years ago
When I have two Rudder's env running, after ~10mins the bug occurs
Updated by Elaad FURREEDAN over 4 years ago
- Category changed from System integration to Web - Technique editor
Updated by Alexis Mousset over 4 years ago
- Target version changed from 6.0.0 to 6.0.1
Updated by Vincent MEMBRÉ over 4 years ago
- Target version changed from 6.0.1 to 6.0.2
Updated by Vincent MEMBRÉ over 4 years ago
- Target version changed from 6.0.2 to 6.0.3
Updated by Vincent MEMBRÉ about 4 years ago
- Target version changed from 6.0.3 to 6.0.4
Updated by Vincent MEMBRÉ about 4 years ago
- Target version changed from 6.0.4 to 6.0.5
Updated by Vincent MEMBRÉ about 4 years ago
- Target version changed from 6.0.5 to 6.0.6
Updated by Vincent MEMBRÉ almost 4 years ago
- Target version changed from 6.0.6 to 6.0.7
Updated by Vincent MEMBRÉ almost 4 years ago
- Target version changed from 6.0.7 to 6.0.8
Updated by François ARMAND almost 4 years ago
- Subject changed from Authentication error to postgres cause major slowdown to Re-authentication error in postgres doesn't kill existing pool
- Severity set to Major - prevents use of part of Rudder | no simple workaround
- User visibility set to Operational - other Techniques | Rudder settings | Plugins
- Priority changed from 0 to 46
Updated by Vincent MEMBRÉ almost 4 years ago
- Target version changed from 6.0.8 to 6.0.9
- Priority changed from 46 to 45
Updated by Vincent MEMBRÉ over 3 years ago
- Target version changed from 6.0.9 to 6.0.10
- Priority changed from 45 to 44
Updated by Vincent MEMBRÉ over 3 years ago
- Target version changed from 6.0.10 to 798
- Priority changed from 44 to 43
Updated by Benoît PECCATTE almost 3 years ago
- Target version changed from 798 to 6.1.14
Updated by Vincent MEMBRÉ almost 3 years ago
- Target version changed from 6.1.14 to 6.1.15
Updated by Vincent MEMBRÉ almost 3 years ago
- Target version changed from 6.1.15 to 6.1.16
Updated by Vincent MEMBRÉ over 2 years ago
- Target version changed from 6.1.16 to 6.1.17
Updated by Vincent MEMBRÉ over 2 years ago
- Target version changed from 6.1.17 to 6.1.18
Updated by Vincent MEMBRÉ over 2 years ago
- Target version changed from 6.1.18 to 6.1.19
Updated by Alexis Mousset over 2 years ago
- Category changed from Web - Technique editor to Server components
Updated by François ARMAND over 2 years ago
- Tracker changed from Bug to Architecture
- Severity deleted (
Major - prevents use of part of Rudder | no simple workaround) - User visibility deleted (
Operational - other Techniques | Rudder settings | Plugins) - Priority deleted (
43)
Updated by Vincent MEMBRÉ about 2 years ago
- Target version changed from 6.1.19 to 6.1.20
Updated by Vincent MEMBRÉ almost 2 years ago
- Target version changed from 6.1.20 to 6.1.21
Updated by Vincent MEMBRÉ almost 2 years ago
- Target version changed from 6.1.21 to old 6.1 issues to relocate
Updated by Alexis Mousset about 1 year ago
- Target version changed from old 6.1 issues to relocate to 8.0.0~alpha1
Updated by Vincent MEMBRÉ 10 months ago
- Target version changed from 8.0.0~alpha1 to 8.0.0~beta1
Updated by Alexis Mousset 9 months ago
- Target version changed from 8.0.0~beta1 to 8.1.0~alpha1
Updated by Vincent MEMBRÉ 4 months ago
- Target version changed from 8.1.0~alpha1 to 8.1.0~beta1
Updated by Vincent MEMBRÉ 2 months ago
- Target version changed from 8.1.0~beta1 to 8.1.0~beta2
Updated by Vincent MEMBRÉ about 1 month ago
- Target version changed from 8.1.0~beta2 to 8.1.0~rc1
Updated by Vincent MEMBRÉ 28 days ago
- Target version changed from 8.1.0~rc1 to 8.1.0
Updated by Vincent MEMBRÉ 22 days ago
- Target version changed from 8.1.0 to 8.1.1
Updated by Vincent MEMBRÉ 9 days ago
- Target version changed from 8.1.1 to 8.1.2
Updated by Vincent MEMBRÉ 4 days ago
- Target version changed from 8.1.2 to 8.1.3
Actions