Project

General

Profile

Actions

Bug #5125

closed

Migration script 'rudder-upgrade-database' displays unwanted logs

Added by Nicolas PERRON almost 10 years ago. Updated over 9 years ago.

Status:
Released
Priority:
N/A
Category:
System integration
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

The use of the script will display these lines, containing unwanted messages from psql:

server:/var/rudder/configuration-repository # /opt/rudder/bin/rudder-upgrade-database
Upgrade script for Rudder database.

This script updates the format of all the id used, from Integer to BigInt
Please note that it will stop the Rudder web interface temporarily at the beginning of the migration, for a few seconds
Checking the database...The ruddersysevents IDs need migrating. Let's go!
   77723 lines used, approximately 0% of total available, you may migrate later.
Please note that this script will stop the Rudder Web Interface for several seconds during the first part of the migration
Do you want to migrate now? (y/n)y
Stopping the Rudder web interface... Done.
Renaming the old tables, and recreating new ones with proper id format...psql:/opt/rudder/share/upgrade-tools/dbMigration-change-ids-in-tables.sql:67: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ruddersysevents_pkey1" for table "ruddersysevents" 
psql:/opt/rudder/share/upgrade-tools/dbMigration-change-ids-in-tables.sql:99: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "archivedruddersysevents_pkey1" for table "archivedruddersysevents" 
 Done
Restarting the Rudder web interface...2014-06-24 17:55:24.735:INFO::Redirecting stderr/stdout to /var/log/rudder/webapp/2014_06_24.stderrout.log
 Done.
Checking the number of entries to migrate... Done
[...]


Related issues 1 (0 open1 closed)

Related to Rudder - Bug #4831: Reports cannot be inserted into postgresql due to a limit on idsReleasedFrançois ARMAND2014-05-07Actions
Actions #1

Updated by Jonathan CLARKE almost 10 years ago

  • Status changed from New to Pending technical review
  • Pull Request set to https://github.com/Normation/rudder-packages/pull/418
Actions #2

Updated by Jonathan CLARKE almost 10 years ago

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

Applied in changeset packages:commit:15df59ef091ba7c52f92ade254576a72ed6c6462.

Actions #3

Updated by Matthieu CERDA almost 10 years ago

Applied in changeset packages:commit:fb7c988808f6c43e3743689de7eb8eb682699d87.

Actions #4

Updated by Vincent MEMBRÉ over 9 years ago

  • Subject changed from The use of migration script 'rudder-upgrade-database' has some unwanted display to Migration script 'rudder-upgrade-database' display uwanted logs
Actions #5

Updated by Vincent MEMBRÉ over 9 years ago

  • Subject changed from Migration script 'rudder-upgrade-database' display uwanted logs to Migration script 'rudder-upgrade-database' display unwanted logs
Actions #6

Updated by Vincent MEMBRÉ over 9 years ago

  • Subject changed from Migration script 'rudder-upgrade-database' display unwanted logs to Migration script 'rudder-upgrade-database' displays unwanted logs
Actions #7

Updated by Vincent MEMBRÉ over 9 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.10.3 (announcement , changelog) and 2.11.0~beta2 (announcement , changelog), which were released today.

Actions

Also available in: Atom PDF