Project

General

Profile

Bug #4167

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

Added by Vincent MEMBRÉ over 6 years ago. Updated about 5 years ago.

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

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" 
#1

Updated by Vincent MEMBRÉ over 6 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
#2

Updated by Vincent MEMBRÉ over 6 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

#3

Updated by Jonathan CLARKE over 6 years ago

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

Updated by Vincent MEMBRÉ over 6 years ago

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

Applied in changeset commit:fc9a921456fa1f963a1da9b23c3de2d69fce5195.

#5

Updated by Anonymous over 6 years ago

Applied in changeset commit:6aa56000c7c022b556961bf208dbe1da2e64f3da.

#6

Updated by Nicolas PERRON over 6 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
#7

Updated by Nicolas PERRON over 6 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:

#8

Updated by Benoît PECCATTE about 5 years ago

  • Project changed from packages to Rudder
  • Category set to Packaging

Also available in: Atom PDF