Actions
Bug #2672
closed
Duplicate index name in PSQL initiation script
Status:
Released
Priority:
1 (highest)
Assignee:
Category:
Packaging
Target version:
Pull Request:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:
Description
While installing Rudder in 2.4, we see this error:
psql:/opt/rudder/etc/postgresql/reportsSchema.sql:114: ERROR: relation "executiontimestamp_idx" already exists
Indeed, if we look at the reportsSchema.sql we can see this index is defined twice, for two different things:
93:CREATE INDEX executionTimeStamp_idx on RudderSysEvents (executionTimeStamp); -- 114:create index executionTimeStamp_idx on ArchivedRudderSysEvents (executionTimeStamp);
Updated by Nicolas CHARLES over 12 years ago
- Status changed from 2 to Pending technical review
- % Done changed from 0 to 100
Applied in changeset 61f9a6afe2cc1149e6a34dff536d4672c4e04603.
Updated by Jonathan CLARKE over 12 years ago
- Status changed from Pending technical review to In progress
This is not functional, the file rudder-core/src/main/resources/Migration/dbMigration-2.3-2.4-index-archive.sql is missing from the repo. Nicolas, please add it ASAP.
Updated by Nicolas CHARLES over 12 years ago
- Status changed from In progress to Pending technical review
Applied in changeset bcaa64360aa79af56996650426ef3a344decd3e7.
Updated by Jonathan CLARKE over 12 years ago
- Status changed from Pending technical review to Released
Thanks Nicolas, this looks good now.
Updated by Nicolas PERRON almost 12 years ago
- Project changed from Rudder to 34
- Category deleted (
11)
Updated by Benoît PECCATTE over 9 years ago
- Project changed from 34 to Rudder
- Category set to Packaging
Actions