Project

General

Profile

Actions

Bug #24017

closed

Webapp can fail to start with null sessionid error

Bug #24017: Webapp can fail to start with null sessionid error

Added by Clark ANDRIANASOLO over 2 years ago. Updated about 2 years ago.

Status:
Released
Priority:
N/A
Category:
Web - Maintenance
Target version:
Severity:
Minor - inconvenience | misleading | easy workaround
UX impact:
User visibility:
Getting started - demo | first install | Technique editor and level 1 Techniques
Effort required:
Medium
Priority:
0
Name check:
To do
Fix check:
Checked
Regression:
No

Description

When restarting the webapp it could occur that it fails to boot with a an error
zio.FiberFailure: SystemError(Error when saving session 'null' info for user 'username', org.postgresql.util.PSQLException: ERROR: null value in column "sessionid" of relation "usersessions" violates not-null constraint
Detail: Failing row contains (username, null, 2024-01-12 11:35:00.413+01, file, {administrator}, all, null, null).)

Restarting again the webapp seems to fix the issue so it appears like a synchronization problem regarding user and session variables.


Subtasks 1 (0 open1 closed)

Bug #24755: In case a NULL was introduced earlier in sessionid, login is impossibleResolvedClark ANDRIANASOLOActions

Related issues 3 (0 open3 closed)

Related to Rudder - User story #23440: Add users table to better track user and sessionsReleasedVincent MEMBRÉActions
Related to Rudder - Bug #23920: Lift Async system is not able to find spring SecurityContextHolderReleasedVincent MEMBRÉActions
Related to Rudder - Bug #25123: Authentication happens twice with same session idReleasedFrançois ARMANDActions

Updated by Clark ANDRIANASOLO over 2 years ago Actions #1

  • Related to User story #23440: Add users table to better track user and sessions added

Updated by François ARMAND over 2 years ago Actions #2

  • Related to Bug #23920: Lift Async system is not able to find spring SecurityContextHolder added

Updated by François ARMAND over 2 years ago Actions #3

It might be a user/session problem, but since it happens at reboot, on a time when no user are trying to log, it's more likely the cleaning of open sessions that is failing.
When we reboot, for each session that was open when rudder was stopped (and so, are still open in base but clearly are not really open at an http level), we add a "close" date at reboot time. But perhaps something is broken in that closing logic.

See: bootstrap.liftweb.checks.consistency.CloseOpenUserSessions

Updated by Vincent MEMBRÉ over 2 years ago Actions #4

  • Target version changed from 8.1.0~alpha1 to 8.1.0~beta1

Updated by Vincent MEMBRÉ over 2 years ago Actions #5

  • Target version changed from 8.1.0~beta1 to 8.1.0~beta2

Updated by Vincent MEMBRÉ about 2 years ago Actions #6

  • Target version changed from 8.1.0~beta2 to 8.1.0~rc1

Updated by Vincent MEMBRÉ about 2 years ago Actions #7

  • Target version changed from 8.1.0~rc1 to 8.1.0

Updated by Clark ANDRIANASOLO about 2 years ago Actions #8

  • Assignee changed from François ARMAND to Clark ANDRIANASOLO
  • Target version changed from 8.1.0 to 7.3.14

Updated by Clark ANDRIANASOLO about 2 years ago Actions #9

  • Status changed from New to In progress

Updated by Clark ANDRIANASOLO about 2 years ago Actions #10

  • Status changed from In progress to Pending technical review
  • Assignee changed from Clark ANDRIANASOLO to François ARMAND
  • Pull Request set to https://github.com/Normation/rudder/pull/5593

Updated by Clark ANDRIANASOLO about 2 years ago Actions #11

  • Status changed from Pending technical review to Pending release

Updated by François ARMAND about 2 years ago Actions #12

  • Subtask #24755 added

Updated by François ARMAND about 2 years ago Actions #13

  • Fix check changed from To do to Checked

This can't be validated easily, so we will need to see if the problem occures again with the correction.

Updated by Vincent MEMBRÉ about 2 years ago Actions #14

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 7.3.14, 8.0.8 and 8.1.1 which were released today.

Updated by Clark ANDRIANASOLO almost 2 years ago Actions #15

  • Related to Bug #25123: Authentication happens twice with same session id added
Actions

Also available in: PDF Atom