Project

General

Profile

Actions

User story #3945

closed

Store agent executions history in a 'lightweight' table, to speed up Rudder web interface

User story #3945: Store agent executions history in a 'lightweight' table, to speed up Rudder web interface

Added by Vincent MEMBRÉ over 12 years ago. Updated about 7 years ago.

Status:
Released
Priority:
2
Category:
Web - Compliance & node report
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

Looking for agent executions is very ressource consumming in Rudder for now (ie : opening list nodes page is very very long if you got numerous nodes, be causeit is looking for the latest reports from each node)

If we had a completely separated table only containing executions, this would really ease the process (very few lines compared to millions in rudderSysEvents)

An agent execution consists in:
- The Id of the node executing the agent
- The time when that execution was ran
- If this execution was complete or not

We should have an actor parsing reports, regularly ran(~ every ten seconds, configurable), getting new reports and determine agent executions


Subtasks 5 (0 open5 closed)

User story #3946: Add all mechanisms to store agent executionsReleasedNicolas CHARLESActions
User story #3947: Add call to execution repository when neededRejectedVincent MEMBRÉActions
User story #4059: Create migration script to create the database for node executions (rudder part)ReleasedFrançois ARMANDActions
User story #4068: Add migration script for 'execution reports' processReleasedJonathan CLARKEActions
User story #4069: Have meaningful properties name for the service that fetches agent run timesReleasedJonathan CLARKEActions

Updated by Nicolas CHARLES over 12 years ago Actions #1

Yeah \o/
Awesome

Updated by Jonathan CLARKE over 12 years ago Actions #2

  • Status changed from New to 13

Updated by Nicolas PERRON over 12 years ago Actions #3

  • Status changed from 13 to Pending release

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

  • Subject changed from Store agent executions history to Store agent executions history in a 'ligthweight' table, to speed up Rudder

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

  • Subject changed from Store agent executions history in a 'ligthweight' table, to speed up Rudder to Store agent executions history in a 'lightweight' table, to speed up Rudder web interface

Updated by Vincent MEMBRÉ over 12 years ago Actions #6

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.8.0~beta1, which was released today.
Check out:

Actions

Also available in: PDF Atom