Project

General

Profile

Actions

Bug #2672

closed

Duplicate index name in PSQL initiation script

Added by Jonathan CLARKE almost 12 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

Also available in: Atom PDF