- Notifications
You must be signed in to change notification settings - Fork197
Open
Description
Bug description
[1] query failed: CREATE TABLE "journey_location" ("journey_id" uuid NOT NULL, "customer_id" bigint NOT NULL, "stepEntry" bigint NOT NULL, "stepEntryAt" TIMESTAMP NOT NULL DEFAULT now(), "journeyEntry" bigint NOT NULL DEFAULT '0', "journeyEntryAt" TIMESTAMP NOT NULL DEFAULT now(), "moveStarted" bigint, "messageSent" boolean, "journey_id" uuid NOT NULL, "step_id" uuid NOT NULL, "customer_id" bigint NOT NULL, "workspace_id" uuid NOT NULL, CONSTRAINT "PK_ccb6f56366731fb59ab930900d7" PRIMARY KEY ("journey_id", "customer_id"))[1] error: error: column "journey_id" specified more than once[1] [Nest] 2270916 - 01/27/2025, 4:47:17 AM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...[1] QueryFailedError: column "journey_id" specified more than once[1] at PostgresQueryRunner.query (/root/laudspeaker/laudspeaker/src/driver/postgres/PostgresQueryRunner.ts:299:19)[1] at processTicksAndRejections (node:internal/process/task_queues:95:5)[1] at PostgresQueryRunner.executeQueries (/root/laudspeaker/laudspeaker/src/query-runner/BaseQueryRunner.ts:659:13)[1] at PostgresQueryRunner.createTable (/root/laudspeaker/laudspeaker/src/driver/postgres/PostgresQueryRunner.ts:571:9)[1] at RdbmsSchemaBuilder.createNewTables (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:613:13)[1] at RdbmsSchemaBuilder.executeSchemaSyncOperationsInProperOrder (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:224:9)[1] at RdbmsSchemaBuilder.build (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:95:13)[1] at DataSource.synchronize (/root/laudspeaker/laudspeaker/src/data-source/DataSource.ts:335:9)[1] at DataSource.initialize (/root/laudspeaker/laudspeaker/src/data-source/DataSource.ts:273:43)How to reproduce
- fresh install
- npm run start
- watch output
Environment
- Laudspeaker Cloud
- self-hosted Laudspeaker, version/commit:please provide
Additional context
Attempted both docker and external PostgreSQL.
Manual creation and correction of create statement does not solve this and it still throws and error.
Thank you for your bug report – we love squashing them!
Metadata
Metadata
Assignees
Labels
No labels