Ошибка: Пользователи не могут создавать новые аккаунты

Привет! Недавно мы столкнулись с ошибкой, которая нас озадачила. Возможно, у кого-то есть идея, что её вызывает. Мы будем благодарны за любую помощь.

Спасибо!

Приоритет/Серьёзность: Серьёзно

Платформа: Discourse 3.1.0.beta2 (последняя версия)

Описание: Пользователи не могут создавать новые учётные записи.

Недавнее действие, которое мы выполнили, — это миграция экземпляра Lightsail (Ubuntu 20.4) на другой с более высокими характеристиками (создание снимка, запуск экземпляра из снимка).

Всё прошло успешно, хотя ошибка регистрации могла возникнуть ещё до этого, мы просто не знали об этом (наш BBS работает уже 2 месяца).

Мы пробовали в безопасном режиме — результат тот же. Пробовали с разных учётных записей электронной почты, с разных IP-адресов и с разных устройств — результат одинаковый.

Шаги для воспроизведения: Перейти на сайт, попытаться зарегистрировать новую учётную запись.

Соответствующие скриншоты:

Я мог вставить только одно изображение, поэтому вот ещё одно:

Помимо плагинов, у нас установлены компоненты DiscoTOC и Discourse Docs Card Filter.

Некоторое время назад я сталкивался с похожей ошибкой с плагином Discourse Encrypt, которая не отображалась в консоли, но у вас, похоже, этот плагин не установлен. Есть ли какие-либо ошибки в вашем /logs?

В предыдущем похожем случае регистрация по приглашению оказалась более информативной, если у вас получится это попробовать?

2 лайка

Спасибо, что проверили! Да, я читал ту другую тему, но она выглядела очень иначе, чем моя.

Я пробовал с кодом приглашения — результат тот же.

Вот мои логи ошибок.

Вы можете

 tail -f /var/discourse/shared/standalone/log/rails/production.log

и посмотреть, что вы увидите, когда попытаетесь создать учётную запись.

3 лайка

Привет @minami,

Здесь под «приглашением» имеется в виду создание ссылки-приглашения на странице yoursite/my/invited/pending и попытка регистрации по этой ссылке на странице приглашений. То есть не через модальное окно. Извините, я не был достаточно ясен. Надеюсь, теперь вы получите более релевантные ошибки в /logs.

2 лайка

Хорошо, я попробовал перейти по ссылке-приглашению и получил ошибку внутреннего сервера.

image

Инфо
Не удалось обработать исключение в промежуточном ПО обработки исключений: ActiveRecord::RecordNotUnique : PG::UniqueViolation: ОШИБКА: дубликат ключа нарушает уникальное ограничение "idx_category_users_user_id_categor

00:44

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
2 лайка

Следующим попробую это :smile:

Я вижу упоминание set_default_categories_preferences. Попробуйте сбросить эти настройки и посмотрите, поможет ли это.

Я наткнулся на похожую проблему здесь:

2 лайка

Я сбросил категории по умолчанию, которые были заглушены, и ошибка исправилась! Но почему это должно влиять на регистрацию пользователей?! Хотя, возможно, это тема для другого дня.

Огромное спасибо за помощь @JammyDodger! Мне нужно немного поспать :sleepy:

2 лайка

Не волнуйтесь. Рады, что смогли помочь. :slight_smile:

2 лайка

Я считаю, что данная ситуация теперь устранена благодаря:

1 лайк