고장난 업데이트: ERROR: extension vector의 소유자여야 합니다 (PG::InsufficientPrivilege)

기여 버그
,
1 
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:  must be owner of extension vector
2024-08-08 22:28:18.660 UTC [1022] discourse@discourse STATEMENT:  ALTER EXTENSION vector UPDATE TO '0.7.0';
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled: (StandardError)

ERROR:  must be owner of extension 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 `migrate'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1178:in `migrate'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1529:in `block in execute_migration_in_transaction'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/transaction.rb:535:in `block in within_new_transaction'
/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/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/transaction.rb:532:in `within_new_transaction'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/connection_adapters/abstract/database_statements.rb:344:in `transaction'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1580:in `ddl_transaction'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1528:in `execute_migration_in_transaction'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `each'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/activerecord-7.1.3.4/lib/active_record/migration.rb:1503:in `migrate_without_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 <main>'
/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 <main>'
/var/www/discourse/vendor/bundle/ruby/3.3.0/gems/rake-13.2.1/exe/rake:27:in `<top (required)>'
/usr/local/bin/bundle:25:in `load'
/usr/local/bin/bundle:25:in `<main>'

Caused by:
PG::InsufficientPrivilege: ERROR:  must be owner of extension vector (PG::InsufficientPrivilege)

두 줄이 눈에 띕니다:

  • 2024-08-08 22:28:18.660 UTC [1022] discourse@discourse ERROR: must be owner of extension 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: must be owner of extension vector (PG::InsufficientPrivilege)

마지막 업그레이드 이후 약 1~2주가 지났습니다. 이 문제를 재현해 보신 분이나 조언을 주실 분이 계신가요?

수정: discourse-ai를 비활성화했습니다. 이제 문제가 없이 재빌드되고 있습니다.

2개의 좋아요
Discourse AI plugin failing container rebuilds/bootstrappings
Discourse AI causing rebuild to fail
Still an issue: ERROR: must be owner of extension vector
Discourse AI Topic Summary :robot:
Discourse AI plugin failing container rebuilds/bootstrappings
Discourse AI plugin failing container rebuilds/bootstrappings
2

이것은 컨테이너가 하나뿐인 표준 설치인가요?

3

네, 맞아요. 몇 년 전에 공식 가이드를 따라 설치했거든요.

1개의 좋아요
5

https://github.com/discourse/discourse_docker/pull/825

3개의 좋아요
6

네, 아직 남아 있어요 — 이게 머지됐는지 아니면 아직 오픈 상태인지 확인하는 걸 잊었거든요 :man_facepalming:

1개의 좋아요
7

이제 병합되었습니다

8

죄송하지만, 이 문제가 해결된 것을 의미합니까?
여기에서 논의된 것과 비슷한 문제를 겪고 있습니다.

9

네, 재빌드를 통해 사이트를 업데이트해 보세요.

3개의 좋아요
10

아쉽게도 실패했습니다.

이 이미지는 프로그래밍 코드 편집기가 열린 컴퓨터 화면을 보여주며, Python 스크립트가 표시되어 있습니다. (AI 캡션)
이 이미지는 프로그래밍 코드 편집기가 열린 컴퓨터 화면을 보여주며, Python 스크립트가 표시되어 있습니다. (AI 캡션)1360×768 54.2 KB

도움이 된다면, 더 자세한 내용은 이 주제에 제가 붙여넣어 두었습니다.
또한 제 환경은 컨테이너 2개로 구성된 세팅이라는 점도 참고해 주세요.

그리고 이것이 관련이 있다면:

:/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
11

나한테는 잘 작동했어

1개의 좋아요
12

항상 그렇듯이, 컨테이너 2개 환경이라면 두 컨테이너 모두를 업데이트해야 합니다.

1개의 좋아요
13

수정 덕분에 문제가 해결되었습니다. 감사합니다!

3개의 좋아요
14

감사합니다. 이걸 몰랐습니다.

하지만 ‘data’ 컨테이너를 부트스트랩하려고 하니 다음과 같은 오류가 발생합니다:

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)
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)1360×768 44 KB

먼저 ‘Web_only’ 컨테이너를 중지해야 하나요? 예방 차원에서 그걸 시도해 보기도 했습니다.

15

이 주제는 3일 후 자동으로 닫혔습니다. 더 이상 답변을 작성할 수 없습니다.