Error: Los usuarios no pueden crear nuevas cuentas

Hola! Recientemente hemos experimentado un error que nos tiene perplejos. Quizás alguien tenga una idea de qué lo está causando. Agradeceríamos cualquier ayuda.

Gracias!

Prioridad/Severidad: Grave

Plataforma: Discourse 3.1.0.beta2 (última)

Descripción: Los usuarios no pueden crear nuevas cuentas.

El evento reciente que hemos realizado es actualizar la instancia de Lightsail (Ubuntu 20.4) a otra con especificaciones más altas (hacer instantánea, crear instancia a partir de instantánea).

Todo salió bien, aunque el error de registro pudo haber comenzado antes, simplemente no éramos conscientes de ello (es un BBS de 2 meses de antigüedad).

Lo hemos intentado en modo seguro, sucede lo mismo. Hemos utilizado diferentes cuentas de correo electrónico, desde diferentes direcciones IP y diferentes dispositivos, el mismo resultado.

Pasos reproducibles: Visitar el sitio, intentar registrar una nueva cuenta.

Capturas de pantalla relevantes:

Solo pude incrustar una imagen, así que aquí hay otra:

Además de los plugins, tenemos instalados los componentes DiscoTOC y Discourse Docs Card Filter.

Vi un error similar con Discourse Encrypt hace algún tiempo que no arrojaba errores visibles en la consola, pero no parece que tengas ese complemento. ¿Hay algún error en tu /logs?

Para el caso anterior similar, registrarse con una invitación resultó ser más revelador si puedes intentarlo.

2 Me gusta

¡Gracias por revisarlo! Sí, leí ese otro tema, pero parecía muy diferente al mío.

Lo intenté con el código de invitación, mismo resultado.

Aquí están mis registros de errores.

puedes
tail -f /var/discourse/shared/standalone/log/rails/production.log
y ver qué ves cuando intentas crear una cuenta.

3 Me gusta

Hola @minami,

Aquí, la invitación significa crear un enlace de invitación en la página tudominio/my/invited/pending e intentar registrarse con ese enlace en la página de invitaciones. Así que no en la ventana modal. Disculpa si no fui muy claro. Espero que de esta manera obtengas algunos errores relevantes en /logs.

2 Me gusta

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 Me gusta

Lo intentaré la próxima vez :smile:

Veo algo sobre set_default_categories_preferences ahí. ¿Podrías intentar restablecerlas y ver si eso ayuda?

Veo un problema similar aquí:

2 Me gusta

¡Restablecí las categorías silenciadas predeterminadas y el error se solucionó! Pero, ¿por qué eso afectaría los registros de usuarios? Quizás eso sea para otro día.

¡Muchas gracias por la ayuda @JammyDodger! Necesito dormir :sleepy:

2 Me gusta

No te preocupes. Me alegra que hayamos podido ayudar. :slight_smile:

2 Me gusta

Creo que esta situación ya se ha mitigado con:

1 me gusta