안녕하세요! 최근 우리를 당황하게 만든 오류가 발생했습니다. 원인을 아는 분이 계신지 혹시 아이디어가 있으실까요. 도움이 되시면 감사하겠습니다.
감사합니다!
우선순위/심각도: 심각
플랫폼: Discourse 3.1.0.beta2 (최신)
설명: 사용자가 새 계정을 생성할 수 없습니다.
최근 수행한 작업은 Lightsail 인스턴스(Ubuntu 20.4)를 더 높은 사양의 인스턴스로 업그레이드한 것입니다(스냅샷 생성, 스냅샷에서 인스턴스 생성).
모든 작업은 순조롭게 진행되었지만, 가입 오류는 그보다 이전에 시작되었을 수 있으며 우리는 그 사실을 인지하지 못했습니다(2개월 된 BBS입니다).
안전 모드에서도 시도해 보았으나 동일한 문제가 발생합니다. 다른 이메일 계정, 다른 IP 주소, 다른 장치를 사용해도 동일한 결과가 나타납니다.
재현 단계: 사이트를 방문하여 새 계정 가입을 시도합니다.
관련 스크린샷:
이미지를 하나만 삽입할 수 있었기 때문에, 여기 또 다른 이미지를 올립니다:
플러그인 외에도 DiscoTOC와 Discourse Docs Card Filter 구성 요소를 설치해 두었습니다.
얼굴에 Discourse Encrypt 플러그인에서 비슷한 오류를 본 적이 있습니다. 당시에는 콘솔에 표시되는 오류가 없었지만, 현재 사용 중인 환경에는 해당 플러그인이 설치되어 있지 않은 것 같습니다. /logs에 오류가 표시되고 있나요?
비슷한 과거 사례에서는 초대 코드를 사용해 가입하는 방식이 더 많은 정보를 제공했습니다. 가능하시다면 이 방법도 시도해 보실 수 있을까요?
다음 명령을 실행할 수 있습니다.
tail -f /var/discourse/shared/standalone/log/rails/production.log
그리고 계정을 생성하려고 할 때 어떤 로그가 출력되는지 확인해 보세요.
안녕하세요 @minami,
여기서 말하는 '초대’는 yoursite/my/invited/pending 페이지에서 초대 링크를 생성한 후, 초대 페이지에서 해당 링크를 사용하여 가입을 시도하는 것을 의미합니다. 즉, 모달 창이 아닌 곳에서 시도하는 것입니다. 설명이 명확하지 않아 죄송합니다. 이렇게 하시면 /logs에서 관련 에러 메시지를 확인하실 수 있을 것입니다.
초대 링크를 시도해 봤는데 내부 서버 오류가 발생했습니다.
Failed to handle exception in exception app middleware : ActiveRecord::RecordNotUnique : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "idx_category_users_user_id_categor
12:44 am
rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler (3.0.0) lib/patches/db/pg.rb:69:in `exec_params'
activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'
activesupport (7.0.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport (7.0.4.1) lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
activesupport (7.0.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'
activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'
activerecord (7.0.4.1) lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:150:in `exec_insert_all'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `exec_insert_all'
activerecord (7.0.4.1) lib/active_record/insert_all.rb:41:in `execute'
activerecord (7.0.4.1) lib/active_record/persistence.rb:213:in `insert_all!'
app/models/user.rb:1961:in `set_default_categories_preferences'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:400:in `block in make_lambda'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `block in invoke_after'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `each'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:599:in `invoke_after'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:108:in `run_callbacks'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:929:in `_run_create_callbacks'
activerecord (7.0.4.1) lib/active_record/callbacks.rb:461:in `_create_record'
activerecord (7.0.4.1) lib/active_record/timestamp.rb:108:in `_create_record'
activerecord (7.0.4.1) lib/active_record/persistence.rb:1067:in `create_or_update'
activerecord (7.0.4.1) lib/active_record/callbacks.rb:457:in `block in create_or_update'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
activerecord (7.0.4.1) lib/active_record/autosave_association.rb:370:in `around_save_collection_association'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:138:in `run_callbacks'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:929:in `_run_save_callbacks'
activerecord (7.0.4.1) lib/active_record/callbacks.rb:457:in `create_or_update'
activerecord (7.0.4.1) lib/active_record/timestamp.rb:126:in `create_or_update'
activerecord (7.0.4.1) lib/active_record/persistence.rb:648:in `save!'
activerecord (7.0.4.1) lib/active_record/validations.rb:53:in `save!'
activerecord (7.0.4.1) lib/active_record/transactions.rb:302:in `block in save!'
activerecord (7.0.4.1) lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
activerecord (7.0.4.1) lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
activerecord (7.0.4.1) lib/active_record/transactions.rb:302:in `save!'
activerecord (7.0.4.1) lib/active_record/suppressor.rb:54:in `save!'
app/models/invite_redeemer.rb:155:in `create_user_from_invite'
app/models/invite_redeemer.rb:219:in `invited_user'
app/models/invite_redeemer.rb:273:in `add_user_to_groups'
app/models/invite_redeemer.rb:237:in `process_invitation'
app/models/invite_redeemer.rb:56:in `block in redeem'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport (7.0.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
activerecord (7.0.4.1) lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
activerecord (7.0.4.1) lib/active_record/transactions.rb:209:in `transaction'
app/models/invite_redeemer.rb:54:in `redeem'
app/models/invite.rb:226:in `redeem'
app/controllers/invites_controller.rb:284:in `perform_accept_invitation'
actionpack (7.0.4.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack (7.0.4.1) lib/abstract_controller/base.rb:215:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/rendering.rb:53:in `process_action'
actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:234:in `block in process_action'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
app/controllers/application_controller.rb:414:in `block in with_resolved_locale'
i18n (1.12.0) lib/i18n.rb:322:in `with_locale'
app/controllers/application_controller.rb:414:in `with_resolved_locale'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:138:in `run_callbacks'
actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:233:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/rescue.rb:22:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `instrument'
actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:66:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord (7.0.4.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack (7.0.4.1) lib/abstract_controller/base.rb:151:in `process'
actionview (7.0.4.1) lib/action_view/rendering.rb:39:in `process'
rack-mini-profiler (3.0.0) lib/mini_profiler/profiling_methods.rb:85:in `block in profile_method'
actionpack (7.0.4.1) lib/action_controller/metal.rb:188:in `dispatch'
actionpack (7.0.4.1) lib/action_controller/metal.rb:251:in `dispatch'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:32:in `serve'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:852:in `call'
lib/middleware/omniauth_bypass_middleware.rb:74:in `call'
rack (2.2.6.2) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.6.2) lib/rack/conditional_get.rb:40:in `call'
rack (2.2.6.2) lib/rack/head.rb:12:in `call'
actionpack (7.0.4.1) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:369:in `call'
rack (2.2
rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:69:in `exec_params'
activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:768:in `block (2 levels) in exec_no_cache'
activesupport-7.0.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport-7.0.4.1/lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:767:in `block in exec_no_cache'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
activesupport-7.0.4.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:766:in `exec_no_cache'
activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:745:in `execute_and_clear'
activerecord-7.0.4.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:54:in `exec_query'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:150:in `exec_insert_all'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `exec_insert_all'
activerecord-7.0.4.1/lib/active_record/insert_all.rb:41:in `execute'
activerecord-7.0.4.1/lib/active_record/persistence.rb:213:in `insert_all!'
/var/www/discourse/app/models/user.rb:1961:in `set_default_categories_preferences'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:400:in `block in make_lambda'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:236:in `block in halting_and_conditional'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `block in invoke_after'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `each'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:599:in `invoke_after'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:108:in `run_callbacks'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:929:in `_run_create_callbacks'
activerecord-7.0.4.1/lib/active_record/callbacks.rb:461:in `_create_record'
activerecord-7.0.4.1/lib/active_record/timestamp.rb:108:in `_create_record'
activerecord-7.0.4.1/lib/active_record/persistence.rb:1067:in `create_or_update'
activerecord-7.0.4.1/lib/active_record/callbacks.rb:457:in `block in create_or_update'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:118:in `block in run_callbacks'
activerecord-7.0.4.1/lib/active_record/autosave_association.rb:370:in `around_save_collection_association'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:138:in `run_callbacks'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:929:in `_run_save_callbacks'
activerecord-7.0.4.1/lib/active_record/callbacks.rb:457:in `create_or_update'
activerecord-7.0.4.1/lib/active_record/timestamp.rb:126:in `create_or_update'
activerecord-7.0.4.1/lib/active_record/persistence.rb:648:in `save!'
activerecord-7.0.4.1/lib/active_record/validations.rb:53:in `save!'
activerecord-7.0.4.1/lib/active_record/transactions.rb:302:in `block in save!'
activerecord-7.0.4.1/lib/active_record/transactions.rb:354:in `block in with_transaction_returning_status'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:314:in `transaction'
activerecord-7.0.4.1/lib/active_record/transactions.rb:350:in `with_transaction_returning_status'
activerecord-7.0.4.1/lib/active_record/transactions.rb:302:in `save!'
activerecord-7.0.4.1/lib/active_record/suppressor.rb:54:in `save!'
/var/www/discourse/app/models/invite_redeemer.rb:155:in `create_user_from_invite'
/var/www/discourse/app/models/invite_redeemer.rb:219:in `invited_user'
/var/www/discourse/app/models/invite_redeemer.rb:273:in `add_user_to_groups'
/var/www/discourse/app/models/invite_redeemer.rb:237:in `process_invitation'
/var/www/discourse/app/models/invite_redeemer.rb:56:in `block in redeem'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/transaction.rb:319:in `block in within_new_transaction'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
activesupport-7.0.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/transaction.rb:317:in `within_new_transaction'
activerecord-7.0.4.1/lib/active_record/connection_adapters/abstract/database_statements.rb:316:in `transaction'
activerecord-7.0.4.1/lib/active_record/transactions.rb:209:in `transaction'
/var/www/discourse/app/models/invite_redeemer.rb:54:in `redeem'
/var/www/discourse/app/models/invite.rb:226:in `redeem'
/var/www/discourse/app/controllers/invites_controller.rb:284:in `perform_accept_invitation'
actionpack-7.0.4.1/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack-7.0.4.1/lib/abstract_controller/base.rb:215:in `process_action'
actionpack-7.0.4.1/lib/action_controller/metal/rendering.rb:53:in `process_action'
actionpack-7.0.4.1/lib/abstract_controller/callbacks.rb:234:in `block in process_action'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:118:in `block in run_callbacks'
/var/www/discourse/app/controllers/application_controller.rb:414:in `block in with_resolved_locale'
i18n-1.12.0/lib/i18n.rb:322:in `with_locale'
/var/www/discourse/app/controllers/application_controller.rb:414:in `with_resolved_locale'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:138:in `run_callbacks'
actionpack-7.0.4.1/lib/abstract_controller/callbacks.rb:233:in `process_action'
actionpack-7.0.4.1/lib/action_controller/metal/rescue.rb:22:in `process_action'
actionpack-7.0.4.1/lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
activesupport-7.0.4.1/lib/active_support/notifications.rb:206:in `block in instrument'
activesupport-7.0.4.1/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport-7.0.4.1/lib/active_support/notifications.rb:206:in `instrument'
actionpack-7.0.4.1/lib/action_controller/metal/instrumentation.rb:66:in `process_action'
actionpack-7.0.4.1/lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord-7.0.4.1/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack-7.0.4.1/lib/abstract_controller/base.rb:151:in `process'
actionview-7.0.4.1/lib/action_view/rendering.rb:39:in `process'
rack-mini-profiler-3.0.0/lib/mini_profiler/profiling_methods.rb:85:in `block in profile_method'
actionpack-7.0.4.1/lib/action_controller/metal.rb:188:in `dispatch'
actionpack-7.0.4.1/lib/action_controller/metal.rb:251:in `dispatch'
actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:32:in `serve'
actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:32:in `each'
actionpack-7.0.4.1/lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack-7.0.4.1/lib/action_dispatch/routing/route_set.rb:852:in `call'
/var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:74:in `call'
rack-2.2.6.2/lib/rack/tempfile_reaper.rb:15:in `call'
rack-2.2.6.2/lib/rack/conditional_get.rb:40:in `call'
rack-2.2.6.2/lib/rack/head.rb:12:in `call'
actionpack-7.0.4.1/lib/action_dispatch/http/permissions_policy.rb:38:in `call'
/var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
/var/www/discourse/lib/middleware/anonymous_cache.rb:369:in `call'
rack-2.2.6.2/lib/rack/session/abstract/id.rb:266:in `context'
rack-2.2.6.2/lib/rack/session/abstract/id.rb:260:in `call'
actionpack-7.0.4.1/lib/action_dispatch/middleware/cookies.rb:704:in `call'
actionpack-7.0.4.1/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
activesupport-7.0.4.1/lib/active_support/callbacks.rb:99:in `run_callbacks'
actionpack-7.0.4.1/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
actionpack-7.0.4.1/lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
actionpack-7.0.4.1/lib/action_dispatch/middleware/show_exceptions.rb:26:in `call'
logster-2.11.3/lib/logster/middleware/reporter.rb:43:in `call'
railties-7.0.4.1/lib/rails/rack/logger.rb:40:in `call_app'
railties-7.0.4.1/lib/rails/rack/logger.rb:27:in `call'
/var/www/discourse/config/initializers/100-quiet_logger.rb:20:in `call'
/var/www/discourse/config/initializers/100-si
다음에 한번 해볼게 
거기에 set_default_categories_preferences에 대한 내용이 있는 것 같습니다. 해당 설정을 초기화해 보고 도움이 되는지 확인해 볼 수 있을까요?
여기서도 비슷한 문제를 발견했습니다:
기본 음소거 카테고리를 초기화했는데, 오류가 수정되었습니다! 그런데 왜 사용자 가입에 영향을 미칠까요?! 하지만 이건 또 다른 날 이야기일지도 모르겠네요.
도와주셔서 정말 감사합니다, @JammyDodger! 잠을 좀 자야겠어요 
걱정 마세요. 도와드릴 수 있어서 기쁩니다. 
이 상황이 이제 다음을 통해 완화되었다고 생각합니다: