Bug #3169: On a new installed server Rudder 2.5, some tables are missing, leading to numerous error messages - Rudder - Issue Tracker

Actions

Copy link

Bug #3169

closed

On a new installed server Rudder 2.5, some tables are missing, leading to numerous error messages

Added by Vincent MEMBRÉ almost 12 years ago. Updated over 9 years ago.

Status:

Released

Priority:

1 (highest)

Assignee:

Vincent MEMBRÉ

Category:

Packaging

Target version:

2.5.0~rc1

Pull Request:

Severity:

UX impact:

User visibility:

Effort required:

Priority:

Name check:

Fix check:

Regression:

Description

When installing a new rudder server 2.5 (not a migrated server), two tables are missing : gitcommit and rudderproperties.

This is due to a typo in database schema "ReportsSchema.sql", which cause the table to not be created on rudder installation

If those two tables are missing, some new features can't work (rollback, non compliant report logger).

Server Rudder runs fine, but it logs a lot of error lines in the webapp log file(linked to the fact that the table are missing)

Running a rollback don't work with an error message.

There is no stacktrace visible for the user.

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

Status changed from New to Pending technical review
Assignee changed from Vincent MEMBRÉ to François ARMAND

Pull request : https://github.com/Normation/rudder/pull/74

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

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

Applied in changeset 4226bbc505412229a9fbdb3ccbb4430e3fb6b4b6.

Actions

Copy link

Updated by Anonymous almost 12 years ago

Applied in changeset c1a3284b742e04398c863a587824bf2059f95a8d.

Actions

Copy link

Updated by Jonathan CLARKE almost 12 years ago

Status changed from Pending release to Discussion
Assignee changed from François ARMAND to Vincent MEMBRÉ

Vincent, can you please clarify this bug to explain what the impact of this problem is? The fact that tables are missing is the technical explanation causing the bug, not the bug.

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

Description updated (diff)

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

Decription updated, displaying more informations about the impact of that bug.

Actions

Copy link

Updated by Jonathan CLARKE almost 12 years ago

Vincent MEMBRÉ wrote:

Decription updated, displaying more informations about the impact of that bug.

Thanks, but we really need a usable bug title. See our changelogs for an example: http://www.rudder-project.org/foswiki/bin/view/System/Documentation:ChangeLog24.

When does this bug occur? (I think only on new installs, not for upgrades) What is the effect? (You say "some new features can't work", but how does this appear to the user? Is there an error message in the interface? Deleted data? A stacktrace in the interface? In the logs? etc)

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

Subject changed from Missing tables on new rudder server 2.5 to On a new installed server Rudder 2.5, some tables are missing, leading to numerous error messages
Description updated (diff)

Actions

Copy link

Updated by Vincent MEMBRÉ almost 12 years ago

Description updated (diff)

Actions

Copy link

#10

Updated by Vincent MEMBRÉ almost 12 years ago

I updated the title and the description:

It happens only on new installed server rudder, not migrated one.

Rudder works fine, there is a lot of error messages (both in logs (non compliant report logger) and in the webapp (rollback) complaining that databases are not working)

There is no stacktrace, only error message and Rudder doesn't stop running.

Actions

Copy link

#11