# Actualización fallida: ERROR: debe ser propietario de la extensión vector (PG::InsufficientPrivilege) **URL:** https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817 **Category:** Bug **Tags:** ai, fixed **Created:** [8 Agosto, 2024 22:30 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817 "2024-08-08T22:30:55Z") **Posts on this page:** 14 **Page:** 1
### Author: ![MarcP](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/marcp/32/160184_2.png) [@MarcP](https://meta.discourse.org/u/MarcP) #### Post date: [8 Agosto, 2024 22:30 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/1 "2024-08-08T22:30:55Z")
```plaintext I, [2024-08-08T22:28:10.332254 #1] INFO -- : cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' 2024-08-08 22:28:18.660 UTC [1022] discourse@discourse ERROR: debe ser el propietario de la extensión vector 2024-08-08 22:28:18.660 UTC [1022] discourse@discourse STATEMENT: ALTER EXTENSION vector UPDATE TO '0.7.0'; rake aborted! StandardError: Ha ocurrido un error, esta y todas las migraciones posteriores se cancelaron: (StandardError) ERROR: debe ser el propietario de la extensión vector /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/rack-mini-profiler-3.3.1/lib/patches/db/pg.rb:110:in `exec' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/rack-mini-profiler-3.3.1/lib/patches/db/pg.rb:110:in `async_exec' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/postgres/connection.rb:202:in `run' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/active_record_postgres/connection.rb:38:in `block in run' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/active_record_postgres/connection.rb:34:in `block in with_lock' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activesupport-7.1.3.4/lib/active_support/concurrency/null_lock.rb:9:in `synchronize' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/active_record_postgres/connection.rb:34:in `with_lock' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/active_record_postgres/connection.rb:38:in `run' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/mini_sql-1.5.0/lib/mini_sql/postgres/connection.rb:181:in `exec' /var/www/discourse/plugins/discourse-ai/db/migrate/20240611170904_upgrade_pgvector_070.rb:10:in `up' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `public_send' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:989:in `exec_migration' /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration' /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:970:in `block (2 levels) in migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:969:in `block in migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:227:in `with_connection' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:968:in `block in migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1600:in `with_advisory_lock' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `block in migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1600:in `with_advisory_lock' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1448:in `migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1274:in `up' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1249:in `migrate' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/tasks/database_tasks.rb:243:in `migrate' /var/www/discourse/lib/tasks/db.rake:259:in `block (2 levels) in
' /var/www/discourse/lib/distributed_mutex.rb:53:in `block in synchronize' /var/www/discourse/lib/distributed_mutex.rb:49:in `synchronize' /var/www/discourse/lib/distributed_mutex.rb:49:in `synchronize' /var/www/discourse/lib/distributed_mutex.rb:34:in `synchronize' /var/www/discourse/lib/tasks/db.rake:234:in `block in
' /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/exe/rake:27:in `' /usr/local/bin/bundle:25:in `load' /usr/local/bin/bundle:25:in `
' Caused by: PG::InsufficientPrivilege: ERROR: debe ser el propietario de la extensión vector (PG::InsufficientPrivilege) ``` Dos líneas destacan: - 2024-08-08 22:28:18.660 UTC [1022] discourse@discourse ERROR: debe ser el propietario de la extensión vector 2024-08-08 22:28:18.660 UTC [1022] discourse@discourse STATEMENT: ALTER EXTENSION vector UPDATE TO ‘0.7.0’; rake aborted! - PG::InsufficientPrivilege: ERROR: debe ser el propietario de la extensión vector (PG::InsufficientPrivilege) Han pasado ±1-2 semanas desde mi última actualización, ¿alguien puede reproducir esto o tiene algún consejo? **EDIT: Deshabilité discourse-ai - ahora se está reconstruyendo sin problemas.** ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [8 Agosto, 2024 23:19 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/2 "2024-08-08T23:19:24Z")
¿Esta es una instalación estándar con solo un contenedor? ---
### Author: ![MarcP](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/marcp/32/160184_2.png) [@MarcP](https://meta.discourse.org/u/MarcP) #### Post date: [8 Agosto, 2024 23:19 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/3 "2024-08-08T23:19:51Z")
Sí, lo está, instalado hace unos años usando la guía oficial. ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [9 Agosto, 2024 01:18 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/5 "2024-08-09T01:18:14Z")
> ---
### Author: ![Jagster](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jagster/32/192154_2.png) [@Jagster](https://meta.discourse.org/u/Jagster) #### Post date: [9 Agosto, 2024 11:00 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/6 "2024-08-09T11:00:36Z")
Sí, todavía está ahí, porque olvidé comprobar si esto está fusionado o todavía está abierto 🤦‍♂️ ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [9 Agosto, 2024 14:16 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/7 "2024-08-09T14:16:58Z")
Ya está fusionado ---
### Author: ![Bathinda](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bathinda/32/135888_2.png) [@Bathinda](https://meta.discourse.org/u/Bathinda) #### Post date: [9 Agosto, 2024 14:54 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/8 "2024-08-09T14:54:12Z")
> [@Falco](#): > > Ya está fusionado Lo siento, ¿pero significa que este problema está resuelto? Tengo un problema similar al discutido [aquí](https://meta.discourse.org/t/discourse-ai-plugin-failing-container-rebuilds-bootstrappings/320875/8). ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [9 Agosto, 2024 15:19 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/9 "2024-08-09T15:19:56Z")
Sí, intenta actualizar tu sitio mediante una reconstrucción. ---
### Author: ![Bathinda](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bathinda/32/135888_2.png) [@Bathinda](https://meta.discourse.org/u/Bathinda) #### Post date: [10 Agosto, 2024 04:55 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/10 "2024-08-10T04:55:49Z")
Lamentablemente, falló. ![Esta imagen muestra una pantalla de computadora con un editor de código de programación abierto, mostrando un script de Python. (Subtitulado por IA)](https://global.discourse-cdn.com/meta/original/4X/c/b/0/cb0b62d563bf224e82664d5d5575237d6378c76f.png) Se proporcionó más información en [este](https://meta.discourse.org/t/discourse-ai-plugin-failing-container-rebuilds-bootstrappings/320875/8) tema, si eso ayuda. También, por favor, tenga en cuenta que el mío es una configuración de 2 contenedores. Además, si eso está relacionado: ```plaintext :/var/www/discourse# LOAD_PLUGINS=1 bundle exec rake db:migrate fatal: detected dubious ownership in repository at '/var/www/discourse' To add an exception for this directory, call: git config --global --add safe.directory /var/www/discourse ``` ---
### Author: ![Jagster](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jagster/32/192154_2.png) [@Jagster](https://meta.discourse.org/u/Jagster) #### Post date: [10 Agosto, 2024 05:21 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/11 "2024-08-10T05:21:04Z")
Para mí funcionó ---
### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco) #### Post date: [10 Agosto, 2024 17:17 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/12 "2024-08-10T17:17:02Z")
> [@Bathinda](#): > > También, por favor, ten en cuenta que el mío es una configuración de 2 contenedores. Como siempre, si tienes una configuración de dos contenedores, necesitas actualizar ambos. ---
### Author: ![MarcP](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/marcp/32/160184_2.png) [@MarcP](https://meta.discourse.org/u/MarcP) #### Post date: [10 Agosto, 2024 18:21 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/13 "2024-08-10T18:21:05Z")
Confirmo que la corrección solucionó el problema para mí. ¡Gracias! ---
### Author: ![Bathinda](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/bathinda/32/135888_2.png) [@Bathinda](https://meta.discourse.org/u/Bathinda) #### Post date: [11 Agosto, 2024 12:03 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/14 "2024-08-11T12:03:25Z")
> [@Falco](#): > > necesitas actualizar ambos Gracias, no lo sabía. Pero cuando intenté iniciar mi contenedor ‘data’, me sale este error: ![The image displays a computer screen with a terminal showing the output of a command, which seems to be related to software development, specifically working with a database or a server. The terminal output includes text that appears to be from a command-line interface, possibly from a software package like PostgreSQL or a configuration file. The text has various lines of code or commands, with some lines highlighted, indicating the importance of those lines. The content of the terminal output includes commands such as "CREATE TABLE," "INSERT INTO," and "SELECT," which are commonly used in SQL for creating, modifying, and querying database tables. The image captures the essence of a developer's workspace, where they might be working on a database setup or a script that interacts with a database. (Captioned by AI)](https://global.discourse-cdn.com/meta/original/4X/b/5/8/b58885d0a223ffa6fca080d977c7b51343754e52.png) ¿Necesito detener primero mi contenedor ‘Web\_only’? Aunque también lo he intentado, como precaución. ---
### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger) #### Post date: [14 Agosto, 2024 18:21 UTC](https://meta.discourse.org/t/broken-update-error-must-be-owner-of-extension-vector-pg-insufficientprivilege/320817/15 "2024-08-14T18:21:08Z")
Este tema se cerró automáticamente después de 3 días. Ya no se permiten nuevas respuestas.