신규 사용자가 가입할 수 없음

Discourse 사이트(hub.youthpowercoalition.org)에서 문제가 발생하고 있습니다.

일부 사용자는 가입을 할 수 없습니다. 아직 제한적인 테스트만 진행했지만, 숫자가 포함된 이메일 주소에서만 이런 문제가 발생하는 것일 수도 있습니다.

에러 메시지: “문제가 발생했습니다. 사용자 이름 또는 이메일이 이미 등록되었을 수 있습니다. 비밀번호 찾기 링크를 시도해 보세요.”

하지만 분명히 등록되지 않은 이메일 주소를 사용하고 있습니다.

이 문제를 어떻게 해결할 수 있을까요?

이메일에 일부 숫자를 강제로 넣어 보았는데, 숫자가 있든 없든 가입이 실패했습니다.

로그 영역에서 계정이나 데이터베이스에 문제가 있는지 확인해 보세요 (이 부분은 오직 본인만 접근할 수 있습니다): https://hub.youthpowercoalition.org/logs

이 영역에 대해 몰랐습니다. 감사합니다!

최근 로그의 스크린샷입니다.

월요일 로그의 세부 내용입니다.

Message

ActionDispatch::Http::MimeNegotiation::InvalidType ("%{#context['com.opensymphony.xwork2.dispatcher.httpservletresponse'].addheader('s2qz25z5'" is not a valid MIME type)
lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:353:in `call'
config/initializers/100-quiet_logger.rb:23:in `call'
config/initializers/100-silence_logger.rb:31:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
lib/middleware/request_tracker.rb:187:in `call'

Backtrace

actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:31:in `rescue in block in content_mime_type'
actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:24:in `block in content_mime_type'
rack (2.2.3) lib/rack/request.rb:69:in `fetch'
rack (2.2.3) lib/rack/request.rb:69:in `fetch_header'
actionpack (6.1.4.1) lib/action_dispatch/http/mime_negotiation.rb:23:in `content_mime_type'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:269:in `media_type'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:355:in `form_data?'
rack (2.2.3) lib/rack/request.rb:445:in `POST'
actionpack (6.1.4.1) lib/action_dispatch/http/request.rb:400:in `block (2 levels) in POST'
actionpack (6.1.4.1) lib/action_dispatch/http/parameters.rb:88:in `parse_formatted_parameters'

Env

HTTP HOSTS: hub.youthpowercoalition.org
Message (3 copies reported)

ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "idx_category_users_user_id_category_id"
DETAIL:  Key (user_id, category_id)=(150, 43) already exists.
)
app/models/user.rb:1589:in `set_default_categories_preferences'
app/models/invite_redeemer.rb:73:in `create_user_from_invite'
app/models/invite_redeemer.rb:123:in `get_invited_user'
app/models/invite_redeemer.rb:87:in `invited_user'
app/models/invite_redeemer.rb:167:in `approve_account_if_needed'
app/models/invite_redeemer.rb:91:in `process_invitation'
app/models/invite_redeemer.rb:8:in `block in redeem'
app/models/invite_redeemer.rb:6:in `redeem'
app/models/invite.rb:193:in `redeem'
app/controllers/invites_controller.rb:274:in `perform_accept_invitation'
app/controllers/application_controller.rb:397:in `block in with_resolved_locale'
app/controllers/application_controller.rb:397:in `with_resolved_locale'
lib/middleware/omniauth_bypass_middleware.rb:71:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:355:in `call'
config/initializers/100-quiet_logger.rb:23:in `call'
config/initializers/100-silence_logger.rb:31:in `call'
lib/middleware/enforce_hostname.rb:23:in `call'
lib/middleware/request_tracker.rb:187:in `call'

Backtrace

rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler (2.3.3) lib/patches/db/pg.rb:69:in `exec_params'
activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport (6.1.4.1) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport (6.1.4.1) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord (6.1.4.1) lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
activerecord (6.1.4.1) lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport (6.1.4.1) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

Env

HTTP HOSTS: hub.youthpowercoalition.org
Message (3 copies reported)

Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "idx_category_users_user_id_category_id"
DETAIL:  Key (user_id, category_id)=(150, 43) already exists.


Backtrace

rack-mini-profiler-2.3.3/lib/patches/db/pg.rb:69:in `exec_params'
rack-mini-profiler-2.3.3/lib/patches/db/pg.rb:69:in `exec_params'
activerecord-6.1.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:672:in `block (2 levels) in exec_no_cache'
activesupport-6.1.4.1/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
activesupport-6.1.4.1/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
activesupport-6.1.4.1/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
activerecord-6.1.4.1/lib/active_record/connection_adapters/postgresql_adapter.rb:671:in `block in exec_no_cache'
activerecord-6.1.4.1/lib/active_record/connection_adapters/abstract_adapter.rb:696:in `block (2 levels) in log'
activesupport-6.1.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'
activesupport-6.1.4.1/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
Message

Job exception: One of the users you are sending this message to could not be found.


Backtrace

/var/www/discourse/lib/post_creator.rb:257:in `create!'
/var/www/discourse/lib/post_creator.rb:290:in `create!'
/var/www/discourse/plugins/discourse-narrative-bot/autoload/jobs/send_default_welcome_message.rb:14:in `execute'
/var/www/discourse/app/jobs/base.rb:232:in `block (2 levels) in perform'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rails_multisite-3.1.0/lib/rails_multisite/connection_management.rb:80:in `with_connection'
/var/www/discourse/app/jobs/base.rb:221:in `block in perform'
/var/www/discourse/app/jobs/base.rb:217:in `each'
/var/www/discourse/app/jobs/base.rb:217:in `perform'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/sidekiq-6.2.2/lib/sidekiq/processor.rb:196:in `execute_job'
/var/www/discourse/vendor/bundle/ruby/2.7.0/gems/sidekiq-6.2.2/lib/sidekiq/processor.rb:164:in `block (2 levels) in process'

저희 사이트 관리자가 이 포럼을 통해 해결책을 찾았습니다! 모두 감사드립니다.