Project

General

Profile

Actions
Copy link

Bug #4871

closed

Bug #4831: Reports cannot be inserted into postgresql due to a limit on ids

Migration SQL script to change the format of the ids from integer to bigint

Added by Nicolas CHARLES over 10 years ago. Updated over 10 years ago.

Status:
Released
Priority:
1 (highest)
Assignee:
François ARMAND
Category:
Web - Compliance & node report
Target version:
2.10.1
Pull Request:
https://github.com/Normation/rudder/p...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

This ticket is to create the SQL migration script to :
- rename the tables ruddersysevent to ruddersysevents_old, and create a new ruddersysevetns with bigint ids
- rename the tables archivedruddersysevent to archivedruddersysevents_old, and create a new archivedruddersysevetns with bigint ids

And another script to copy a specific number of reports from a node from the ruddersysevents_old to ruddersysevent

Actions
Copy link

Also available in: Atom PDF