こんにちは！最近、原因不明のエラーが発生しており、困っています。何か原因をご存知の方はいらっしゃいますでしょうか。ご協力いただけると幸いです。
よろしくお願いいたします。
優先度/重大度: 重大
プラットフォーム: Discourse 3.1.0.beta2 (最新)
説明: ユーザーが新しいアカウントを作成できません。
最近行ったことは、Lightsailインスタンス（Ubuntu 20.4）をより高性能なものにアップグレードしたことです（スナップショットを作成し、スナップショットからインスタンスを作成しました）。
すべて順調に進みましたが、サインアップエラーはそれ以前から発生していた可能性があり、私たちが気づいていなかっただけかもしれません（これは2ヶ月前のBBSです）。
セーフモードで試しましたが、同じことが起こります。異なるメールアカウント、異なるIPアドレス、異なるデバイスを使用しましたが、結果は同じでした。
再現手順: サイトにアクセスし、新しいアカウントの登録を試みます。
関連スクリーンショット:
以前、Discourse Encryptでも同様のエラーを見かけましたが、コンソールには何も表示されませんでした。しかし、あなたにはそのプラグインがないようです。/logsにエラーはありますか？
以前の同様のケースでは、招待で登録するとより多くの情報が明らかになることが判明しました。試していただけますか？
アカウントを作成しようとしたときに、
tail -f /var/discourse/shared/standalone/log/rails/production.log
を実行して何が表示されるか確認できます。
こんにちは、@minamiさん
ここでいう招待とは、yoursite/my/invited/pending ページで招待リンクを作成し、そのリンクを使って招待ページで登録しようとすることです。モーダルではなく。すみません、明確ではありませんでした。これで /logs で関連するエラーが表示されることを願っています。
Okay I tried the invite link and got an internal server error.
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、大変助かりました！もう寝る時間です 
どういたしまして。お役に立てて嬉しいです。
これは、以下のことにより緩和されたと考えられます。