Check timeout issues

[zaziemo]

after some investigation in papertrail the before_action set_profile in the `ProfilesController´-> check if we probably have update the friendly_id gem.

[tyranja]

The latest is 5.5.1:

We have 5.5.0.

[tyranja]

Dyno Investiagtion: After reading this article: https://devcenter.heroku.com/articles/addressing-h12-errors-request-timeouts I came to the conclusion that we do not need to add more dynos because is the dyno usage is always way under 1:

https://devcenter.heroku.com/articles/metrics#dyno-load

[tyranja]

we have long run queries and might need to investigate there.

Also we can Add a Timeout to the Webserver

[tyranja]

Jul 11 06:59:49 speakerinnen-liste app/web.1 F, [2024-07-11T04:59:49.578846 #45] FATAL -- : [8c7910a0-106f-48a3-b8fb-3dde22f6699f]
Jul 11 06:59:49 speakerinnen-liste app/web.1 [8c7910a0-106f-48a3-b8fb-3dde22f6699f] ActionController::RoutingError (No route matches [GET] "/de/topics"):

[tyranja]

Jul 11 07:42:30 speakerinnen-liste heroku/router at=info method=GET path="/en/profiles?filter_language=ru&filter_state=berlin&search=Marketing" host=speakerinnen.org request_id=dc486f8a-39b1-4983-b734-88c39bbb682d fwd="66.249.64.130" dyno=web.1 connect=0ms service=15084ms status=200 bytes=11246 protocol=https Jul 11 07:42:30 speakerinnen-liste app/web.1 E, [2024-07-11T05:42:30.319998 #45] ERROR -- : source=rack-timeout id=dc486f8a-39b1-4983-b734-88c39bbb682d wait=3ms timeout=15000ms service=15000ms state=timed_out Jul 11 07:42:30 speakerinnen-liste app/web.1 F, [2024-07-11T05:42:30.397325 #45] FATAL -- : [dc486f8a-39b1-4983-b734-88c39bbb682d]
Jul 11 07:42:30 speakerinnen-liste app/web.1 [dc486f8a-39b1-4983-b734-88c39bbb682d] Rack::Timeout::RequestTimeoutException (Request waited 3ms, then ran for longer than 15000ms ): Jul 11 07:42:30 speakerinnen-liste app/web.1 [dc486f8a-39b1-4983-b734-88c39bbb682d]
Jul 11 07:42:30 speakerinnen-liste app/web.1 [dc486f8a-39b1-4983-b734-88c39bbb682d] app/controllers/profiles_controller.rb:133:in map' Jul 11 07:42:30 [speakerinnen-liste](https://my.papertrailapp.com/systems/speakerinnen-liste/events?focus=1747931431051460618&selected=1747931431051460618) [app/web.1](https://my.papertrailapp.com/groups/39146294/events?q=program%3Aapp%2Fweb.1&focus=1747931431051460618&selected=1747931431051460618) [[dc486f8a-39b1-4983-b734-88c39bbb682d](https://my.papertrailapp.com/groups/39146294/events?q=%22dc486f8a-39b1-4983-b734-88c39bbb682d%22&focus=1747931431051460618&selected=1747931431051460618)] app/controllers/profiles_controller.rb:133:insearch_with_search_params' Jul 11 07:42:30 speakerinnen-liste app/web.1 [dc486f8a-39b1-4983-b734-88c39bbb682d] app/controllers/profiles_controller.rb:17:in `index' Jul 11 07:42:30 speakerinnen-liste heroku/router at=info method=GET path="/en/profiles/sabine-moebs" host=speakerinnen-liste.herokuapp.com request_id=ac944ec7-590d-40fe-9bfc-469460469b54 fwd="173.252.107.114" dyno=web.1 connect=0ms service=5698ms status=200 bytes=16275 protocol=https

[zaziemo]

Hier ist noch eine Übersicht über unterschiedliche Fehler: https://devcenter.heroku.com/articles/error-codes#r14-memory-quota-exceeded

[tyranja]

Block certain url's for all crawlers (example tag_filter url)

[tyranja]

Check slow queries in logs archive and lock for index

[zaziemo]

problem is solved