Project

General

Profile

Actions

Bug #2672

closed

Duplicate index name in PSQL initiation script

Added by Jonathan CLARKE over 11 years ago. Updated about 9 years ago.

Status:
Released
Priority:
1
Category:
Packaging
Target version:
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);
Actions #1

Updated by Nicolas CHARLES over 11 years ago

  • Status changed from 2 to Pending technical review
  • % Done changed from 0 to 100
Actions #2

Updated by Jonathan CLARKE over 11 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.

Actions #3

Updated by Nicolas CHARLES over 11 years ago

  • Status changed from In progress to Pending technical review
Actions #4

Updated by Jonathan CLARKE over 11 years ago

  • Status changed from Pending technical review to Released

Thanks Nicolas, this looks good now.

Actions #5

Updated by Nicolas PERRON about 11 years ago

  • Project changed from Rudder to 34
  • Category deleted (11)
Actions #6

Updated by Benoît PECCATTE about 9 years ago

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

Also available in: Atom PDF