Project

General

Profile

Actions

Bug #4167

closed

PostgreSQL migration of 'nodes execution' table can take a long time, a warning should be displayed

Added by Vincent MEMBRÉ about 9 years ago. Updated almost 8 years ago.

Status:
Released
Priority:
3
Category:
Packaging
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Regression:

Description

When upgrading to rudder 2.8, a migration script is ran to create the new table containing all agent executions.

This script can be quite long (up to 20 minutes, but it would higher on more important installation).

During this time, no information are given to the user, making him worry for no reason.

A information should be displayed before running the migration script:

My proposition:

echo "INFO: Creating new table containing all nodes executions, this migration script can take a long time" 
Actions #1

Updated by Vincent MEMBRÉ about 9 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Vincent MEMBRÉ to Jonathan CLARKE
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/187
Actions #2

Updated by Vincent MEMBRÉ about 9 years ago

new proposition:

+  echo -n "INFO: Creating new table containing all nodes executions, this migration script can take a long time..." 
   psql -q -U rudder -h localhost -d rudder -f ${RUDDER_UPGRADE_TOOLS}/dbMigration-2.7-2.8-add-nodes-executions-storage.sql >/dev/null 2>&1
+  echo "Done." 

PR updated: https://github.com/Normation/rudder-packages/pull/187

Actions #3

Updated by Jonathan CLARKE about 9 years ago

  • Assignee changed from Jonathan CLARKE to Vincent MEMBRÉ
Actions #4

Updated by Vincent MEMBRÉ about 9 years ago

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

Applied in changeset commit:fc9a921456fa1f963a1da9b23c3de2d69fce5195.

Actions #5

Updated by Anonymous about 9 years ago

Applied in changeset commit:6aa56000c7c022b556961bf208dbe1da2e64f3da.

Actions #6

Updated by Nicolas PERRON about 9 years ago

  • Subject changed from Migration of nodes execution can take a long time, a warning should be displayed to PostgreSQL migration of 'nodes execution' table can take a long time, a warning should be displayed
Actions #7

Updated by Nicolas PERRON about 9 years ago

  • Status changed from Pending release to Released

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

Actions #8

Updated by Benoît PECCATTE almost 8 years ago

  • Project changed from 34 to Rudder
  • Category set to Packaging
Actions

Also available in: Atom PDF