[Bug]: Formbricks: db:migrate:deploy failed with error:

[crocofied]

Error Message and Logs

If you try to start a Formbricks application you get this error in the logs:

2024-11-09T20:23:38.582642086Z npm error command sh -c env DATABASE_URL="${MIGRATE_DATABASE_URL:-$DATABASE_URL}" prisma migrate deploy
2024-11-09T20:24:30.329160194Z 
2024-11-09T20:24:30.329189414Z > @formbricks/[email protected] db:migrate:deploy
2024-11-09T20:24:30.329192974Z > env DATABASE_URL="${MIGRATE_DATABASE_URL:-$DATABASE_URL}" prisma migrate deploy
2024-11-09T20:24:30.329195754Z 
2024-11-09T20:24:30.894464274Z Prisma schema loaded from schema.prisma
2024-11-09T20:24:30.901495914Z Datasource "db": PostgreSQL database "formbricks", schema "public" at "postgresql:5432"
2024-11-09T20:24:30.971287934Z 
2024-11-09T20:24:30.971317825Z 99 migrations found in prisma/migrations
2024-11-09T20:24:30.971320894Z 
2024-11-09T20:24:31.011658194Z Error: P3009
2024-11-09T20:24:31.011689725Z 
2024-11-09T20:24:31.011692805Z migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve
2024-11-09T20:24:31.011708534Z The `20241017124431_add_documents_and_insights` migration started at 2024-11-09 20:22:36.015623 UTC failed
2024-11-09T20:24:31.011711134Z 
2024-11-09T20:24:31.011713314Z 
2024-11-09T20:24:31.022912305Z npm error Lifecycle script `db:migrate:deploy` failed with error:
2024-11-09T20:24:31.023311105Z npm error code 1
2024-11-09T20:24:31.023346094Z npm error path /home/nextjs/packages/database
2024-11-09T20:24:31.023586505Z npm error workspace @formbricks/[email protected]
2024-11-09T20:24:31.023616385Z npm error location /home/nextjs/packages/database
2024-11-09T20:24:31.023619705Z npm error command failed
2024-11-09T20:24:31.023622374Z npm error command sh -c env DATABASE_URL="${MIGRATE_DATABASE_URL:-$DATABASE_URL}" prisma migrate deploy

Steps to Reproduce

1. New application
2. Select Formbricks
3. Deploy

Example Repository URL

No response

Coolify Version

v.4.0.0-beta.364

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Debian 12

Additional Information

No response

[corentinclichy]

Hello,
I have the same problem here.

I suppose this is link with the pgvector plugin:
https://github.com/formbricks/formbricks/releases

[corentinclichy]

@crocofied did you manage to find a solution for that ?