Project

General

Profile

Actions

Bug #24220

closed

User session database information about tenants should not break in 8.1

Added by Clark ANDRIANASOLO 9 months ago. Updated 3 months ago.

Status:
Rejected
Priority:
N/A
Target version:
Severity:
Critical - prevents main use of Rudder | no workaround | data loss | security
UX impact:
User visibility:
Effort required:
Small
Priority:
0
Name check:
To do
Fix check:
To do
Regression:
No

Description

We added a tenants column in the usersessions table in #23440 because we plan to store tenants information each time a user logs in.
But in the 7.3 version of the table introduced in #24146, the column does not yet exist.

It breaks the database queries we currently make in 8.1 :
  • we need a migration for the tenants column with empty tenants by default.
  • we also need to change the type of stored tenants to a list of tenant ids, introduced in #24140

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 - Architecture #24146: Backport user table to Rudder 7.3ReleasedVincent MEMBRÉActions
Related to Rudder - User story #24140: Have a source of known-tenants in rudder-coreReleasedVincent MEMBRÉActions
Actions #1

Updated by Clark ANDRIANASOLO 9 months ago

Actions #2

Updated by Clark ANDRIANASOLO 9 months ago

  • Status changed from New to In progress
Actions #4

Updated by Clark ANDRIANASOLO 3 months ago

  • Status changed from In progress to Rejected

This is no longer an issue, as migration from 7.3 to 8.1 was seamless, and no longer causes database query issues : queried columns were made explicit in #24344.
Having a list of TenantId is not required and we do not need to bother for now

Actions

Also available in: Atom PDF