Chatwoot Template Redeploy Crash

AnonymousPRO

2 months ago

Hi, everyone

I've been using Chatwoot through a template for about 4 months now.
However, I had never tried updating its version before.
Today, I tried doing it the same way I always do with n8n, by 'redeploying' the frontend.

But now it doesn’t work anymore — it keeps crashing repeatedly.

Has anyone else experienced this? Or does anyone know of an alternative way to recreate the environment without losing my data?

Error log:

ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR: could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory (ActiveRecord::StatementInvalid)

Apr 16 18:04:35

/app/db/migrate/20250104200055_create_captain_tables.rb:28:in `setup_vector_extension'

Apr 16 18:04:35

/app/db/migrate/20250104200055_create_captain_tables.rb:5:in `up'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:26:in `block (3 levels) in <main>'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:18:in `each'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'

Apr 16 18:04:35

Apr 16 18:04:35

Caused by:

Apr 16 18:04:35

PG::UndefinedFile: ERROR: could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory (PG::UndefinedFile)

Apr 16 18:04:35

/app/db/migrate/20250104200055_create_captain_tables.rb:28:in `setup_vector_extension'

Apr 16 18:04:35

/app/db/migrate/20250104200055_create_captain_tables.rb:5:in `up'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:26:in `block (3 levels) in <main>'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:18:in `each'

Apr 16 18:04:35

/app/lib/tasks/db_enhancements.rake:18:in `block (2 levels) in <main>'

Apr 16 18:04:35

Tasks: TOP => db:migrate

Apr 16 18:04:35

(See full trace by running task with --trace)

Solved

2 Replies

AnonymousPRO

2 months ago

I got it working!
You just need to rename the Docker image to: pgvector/pgvector:pg14

In my case, I was using the 14-alpine image.


I got it working!You just need to rename the Docker image to: pgvector/pgvector:pg14In my case, I was using the 14-alpine image.

2 months ago

Glad to see that this worked for you!

(Marking as resolved.)


Status changed to Awaiting User Response railway[bot] about 2 months ago


Status changed to Solved angelo about 2 months ago