Project

General

Profile

Actions
Copy link

Architecture #3918

closed

Architecture #3988: Change rudder sysevents indexes on PostgreSQL

Migration script to change indexes on rudder sys events

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

Status:
Released
Priority:
1
Assignee:
Jonathan CLARKE
Category:
Web - Compliance & node report
Target version:
2.6.6
Pull Request:
https://github.com/Normation/rudder-p...
Effort required:
Name check:
Fix check:
Regression:

Description

Following 3674, we need to have a migration script for existing installation

Related issues 1 (0 open — 1 closed)

Related to Rudder - Bug #3674: Missing index on DB for "reports by nodes" leads to timeout for node list pageReleasedFrançois ARMANDActions
Actions
Copy link
 #1

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Jonathan CLARKE
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/117
Actions
Copy link
 #2

Updated by Jonathan CLARKE over 10 years ago

  • Status changed from Pending technical review to Discussion
  • Assignee changed from Jonathan CLARKE to Nicolas CHARLES

See comments in PR.

Actions
Copy link
 #3

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Discussion to Pending technical review
  • Assignee changed from Nicolas CHARLES to Jonathan CLARKE

PR updated !

Actions
Copy link
 #4

Updated by Nicolas CHARLES over 10 years ago

Pr Updated again !

Actions
Copy link
 #5

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to In progress
  • Assignee changed from Jonathan CLARKE to Nicolas CHARLES

Ha, there's something to correct there probably, removing the index on executionTimeStamp only did break stuff for one user

Actions
Copy link
 #6

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to Jonathan CLARKE

Ok, this PR doesn't need modification, as the scripts only have been changed

Actions
Copy link
 #7

Updated by Nicolas CHARLES over 10 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100

Applied in changeset packages:commit:4539b32f1df71f992ac1c9b2d6d4275e97557432.

Actions
Copy link
 #8

Updated by Jonathan CLARKE over 10 years ago

Applied in changeset packages:commit:d0293b0a70e403a23bec213f452f0348ca8ae5eb.

Actions
Copy link
 #9

Updated by Nicolas PERRON over 10 years ago

  • Tracker changed from Bug to 6
  • Parent task deleted (#3674)

This is not a bug but an implementation ticket. And it could not be a sub-ticket of a bug.

Actions
Copy link
 #10

Updated by Nicolas PERRON over 10 years ago

  • Parent task set to #3988
Actions
Copy link
 #11

Updated by Nicolas PERRON over 10 years ago

  • Status changed from Pending release to Released
Actions
Copy link
 #12

Updated by Benoît PECCATTE about 9 years ago

  • Tracker changed from 6 to Architecture
Actions
Copy link

Also available in: Atom PDF