500 error using automation plugin

Hi,

We have been receiving a 500 internal server error using the automation plugin since the last update.

plugins/automation/lib/discourse_automation/scripts/auto_responder.rb:60:in `block (2 levels) in <main>'

plugins/automation/app/models/discourse_automation/automation.rb:141:in `trigger!'

plugins/automation/lib/discourse_automation/event_handlers.rb:64:in `block in handle_post_created_edited'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:71:in `each'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:71:in `block in find_each'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:138:in `block in find_in_batches'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:245:in `block in in_batches'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:229:in `loop'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:229:in `in_batches'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:137:in `find_in_batches'

activerecord (7.0.8.1) lib/active_record/relation/batches.rb:70:in `find_each'

plugins/automation/lib/discourse_automation/event_handlers.rb:14:in `handle_post_created_edited'

plugins/automation/plugin.rb:186:in `block (2 levels) in activate!'

lib/plugin/instance.rb:554:in `block in on'

lib/discourse_event.rb:12:in `block in trigger'

/usr/local/lib/ruby/3.2.0/set.rb:511:in `each_key'

/usr/local/lib/ruby/3.2.0/set.rb:511:in `each'

lib/discourse_event.rb:12:in `trigger'

lib/post_creator.rb:258:in `trigger_after_events'

lib/post_creator.rb:220:in `create'

lib/new_post_manager.rb:318:in `perform_create_post'

lib/new_post_manager.rb:252:in `perform'

app/controllers/posts_controller.rb:201:in `create'

actionpack (7.0.8.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'

actionpack (7.0.8.1) lib/abstract_controller/base.rb:215:in `process_action'

actionpack (7.0.8.1) lib/action_controller/metal/rendering.rb:165:in `process_action'

actionpack (7.0.8.1) lib/abstract_controller/callbacks.rb:234:in `block in process_action'

activesupport (7.0.8.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'

app/controllers/application_controller.rb:423:in `block in with_resolved_locale'

i18n (1.14.4) lib/i18n.rb:322:in `with_locale'

app/controllers/application_controller.rb:423:in `with_resolved_locale'

activesupport (7.0.8.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'

activesupport (7.0.8.1) lib/active_support/callbacks.rb:138:in `run_callbacks'

actionpack (7.0.8.1) lib/abstract_controller/callbacks.rb:233:in `process_action'

actionpack (7.0.8.1) lib/action_controller/metal/rescue.rb:23:in `process_action'

actionpack (7.0.8.1) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'

activesupport (7.0.8.1) lib/active_support/notifications.rb:206:in `block in instrument'

activesupport (7.0.8.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'

activesupport (7.0.8.1) lib/active_support/notifications.rb:206:in `instrument'

actionpack (7.0.8.1) lib/action_controller/metal/instrumentation.rb:66:in `process_action'

actionpack (7.0.8.1) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'

activerecord (7.0.8.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action'

actionpack (7.0.8.1) lib/abstract_controller/base.rb:151:in `process'

actionview (7.0.8.1) lib/action_view/rendering.rb:39:in `process'

rack-mini-profiler (3.3.1) lib/mini_profiler/profiling_methods.rb:89:in `block in profile_method'

actionpack (7.0.8.1) lib/action_controller/metal.rb:188:in `dispatch'

actionpack (7.0.8.1) lib/action_controller/metal.rb:251:in `dispatch'

actionpack (7.0.8.1) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'

actionpack (7.0.8.1) lib/action_dispatch/routing/route_set.rb:32:in `serve'

actionpack (7.0.8.1) lib/action_dispatch/journey/router.rb:50:in `block in serve'

actionpack (7.0.8.1) lib/action_dispatch/journey/router.rb:32:in `each'

actionpack (7.0.8.1) lib/action_dispatch/journey/router.rb:32:in `serve'

actionpack (7.0.8.1) lib/action_dispatch/routing/route_set.rb:852:in `call'

lib/middleware/omniauth_bypass_middleware.rb:64:in `call'

rack (2.2.9) lib/rack/tempfile_reaper.rb:15:in `call'

rack (2.2.9) lib/rack/conditional_get.rb:40:in `call'

rack (2.2.9) lib/rack/head.rb:12:in `call'

actionpack (7.0.8.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:393:in `call'

lib/middleware/csp_script_nonce_injector.rb:12:in `call'

config/initializers/008-rack-cors.rb:14:in `call'

rack (2.2.9) lib/rack/session/abstract/id.rb:266:in `context'

rack (2.2.9) lib/rack/session/abstract/id.rb:260:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/cookies.rb:704:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'

activesupport (7.0.8.1) lib/active_support/callbacks.rb:99:in `run_callbacks'

actionpack (7.0.8.1) lib/action_dispatch/middleware/callbacks.rb:26:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/show_exceptions.rb:29:in `call'

logster (2.19.1) lib/logster/middleware/reporter.rb:40:in `call'

railties (7.0.8.1) lib/rails/rack/logger.rb:40:in `call_app'

railties (7.0.8.1) lib/rails/rack/logger.rb:27:in `call'

config/initializers/100-quiet_logger.rb:20:in `call'

config/initializers/100-silence_logger.rb:29:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/remote_ip.rb:93:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/request_id.rb:26:in `call'

lib/middleware/enforce_hostname.rb:24:in `call'

rack (2.2.9) lib/rack/method_override.rb:24:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/executor.rb:14:in `call'

rack (2.2.9) lib/rack/sendfile.rb:110:in `call'

actionpack (7.0.8.1) lib/action_dispatch/middleware/host_authorization.rb:131:in `call'

rack-mini-profiler (3.3.1) lib/mini_profiler.rb:191:in `call'

message_bus (4.3.8) lib/message_bus/rack/middleware.rb:60:in `call'

lib/middleware/request_tracker.rb:274:in `call'

railties (7.0.8.1) lib/rails/engine.rb:530:in `call'

railties (7.0.8.1) lib/rails/railtie.rb:226:in `public_send'

railties (7.0.8.1) lib/rails/railtie.rb:226:in `method_missing'

rack (2.2.9) lib/rack/urlmap.rb:74:in `block in call'

rack (2.2.9) lib/rack/urlmap.rb:58:in `each'

rack (2.2.9) lib/rack/urlmap.rb:58:in `call'

unicorn (6.1.0) lib/unicorn/http_server.rb:634:in `process_client'

unicorn (6.1.0) lib/unicorn/http_server.rb:739:in `worker_loop'

unicorn (6.1.0) lib/unicorn/http_server.rb:547:in `spawn_missing_workers'

unicorn (6.1.0) lib/unicorn/http_server.rb:143:in `start'

unicorn (6.1.0) bin/unicorn:128:in `<top (required)>'

vendor/bundle/ruby/3.2.0/bin/unicorn:25:in `load'

vendor/bundle/ruby/3.2.0/bin/unicorn:25:in `<main>'

We are running the latest version of the Discourse and the automation plugin. Any thoughts how this can be resolved? Thanks for the help!

I don’t know if it’s related, but

So you might try removing the plugin from your app.yml.

Hmm we already blanked out the repo so this is not related to the old plugin.

We did play with this trigger a bit recently, maybe @Osama has some ideas.

Any more info in your logs @Festinger, what is the message?

Can you create a new automation rule from scratch for same action, does that work around the issue?

Can you please share the error message? It should be displayed right before the stack trace that you’ve shared.

Thank you all for the feedback.

Upon checking the automation rules, I noticed that the username assigned to a rule has been changed, and we forgot to update the username.

As we assigned the right username now, the errors are gone and the automation rules are working again.