Project

General

Profile

Actions
Copy link

Bug #2672

closed

Duplicate index name in PSQL initiation script

Added by Jonathan CLARKE over 12 years ago. Updated over 9 years ago.

Status:
Released
Priority:
1 (highest)
Assignee:
Nicolas CHARLES
Category:
Packaging
Target version:
2.4.0~beta3
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);
Actions
Copy link

Also available in: Atom PDF