minami
January 26, 2023, 2:40pm
1
Hi! We have recently experienced an error that have us stumped. Maybe somebody has an idea what is causing it. We’d appreciate any help.
Thanks!
Priority/Severity : Sever
Platform : Discourse 3.1.0.beta2 (latest)
Description : Users cannot create new accounts.
The recent event that we have done is to upgrade the Lightsail instance (Ubuntu 20.4) to another with higher specs (make snapshot, create instance from snapshot).
Everything went well, although the signup error may have starter before that, we were just unaware of it (it’s a 2-month-old BBS).
We have tried it in safe mode , same thing happens. Used different email accounts, from different IP addresses, and different devices, same result.
Reproducible steps : Visit site, try to register new account.
Filipinos in Japan
Relevant screenshots :
minami
January 26, 2023, 2:40pm
2
I could only embed one image, so here’s another:
Besides plugins, we have DiscoTOC and Discourse Docs Card Filter components installed.
I saw a similar error with Discourse Encrypt some time ago that didn’t give any visible errors in the console, but it doesn’t look like you have that plugin. Are there any errors in your /logs?
For the similar previous case, registering with an invite proved to be more revealing if you can give that a shot?
I tried to register with invite and it dropped me finally an Internal Server Error [Screenshot 2022-11-23 at 11.05.09]
Info ActiveRecord::NotNullViolation (PG::NotNullViolation: ERROR: null value in column "encrypt_pms_default" of relation "user_options" violates not-null constraint
DETAIL: Failing row contains (5333, f, t, t, t, f, t, 10080, 300000, 2880, null, 2, f, 1, 1, f, 2, 0, t, null, {}, f, 0, 0, 1, 0, 0, …
2 Likes
minami
January 26, 2023, 2:59pm
4
Thanks for checking it out! Yes, I read that other topic but it looked very different from mine.
I tried with invite code, same result.
pfaffman
January 26, 2023, 3:34pm
6
you can
tail -f /var/discourse/shared/standalone/log/rails/production.log
and see what you see when you try to create an account.
3 Likes
Don
January 26, 2023, 3:40pm
7
Hello @minami ,
Here, the invite means create an invite link on yoursite/my/invited/pending page and try to register with that link on the invites page. So not on the modal. Sorry I wasn’t too clear with it. Hopefully this way you get some relevant errors on /logs.
2 Likes
minami
January 26, 2023, 3:56pm
8
Okay I tried the invite link and got an internal server error.
Info
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
Backtrace
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 Likes
I see something about set_default_categories_preferences in there. Could you try resetting those and see if that helps?
I see a similar issue here:
Dear Sam, you are great!
I caused this problem myself. I set a default watch category for users with Trust_level_0. This created a problem and signups failed. So I deleted the watched category for this group and now signups are working.
2 Likes
minami
January 26, 2023, 4:20pm
11
I reset the default muted categories and the error was fixed! But why would that affect user signups?! But maybe that’s for another day.
Thanks very much for the help @JammyDodger ! I need some sleep
2 Likes
No worries. Glad we could help.
2 Likes
I believe this situation has now been mitigated by:
discourse:main ← discourse:group-default-categories
opened 10:13AM - 25 Mar 23 UTC
`default_categories_*` site settings will update the category preferences on use… r create. But it should update user's category preference if a group's setting already updated it for that user.
1 Like
