# Oblyk API – Weekly Report: Jun 22 → Jun 29

## Requests (1,148,320)

- **95P:** 292.9 ms
- **Throughput:** 113.92 /min
- **Errors:** 0.06610%

| Name | 95P ms | Throughput /min | Impact |
| ---- | -----: | --------------: | -----: |
| Api::V1::TownsController#show | 311 | 18.81 | 14.6% |
| Api::V1::CragsController#show | 254 | 16.82 | 10.6% |
| Api::V1::CurrentUsersController#suggested_friends | 12705 | 0.19 | 7.9% |
| Api::V1::PublicationsController#my_publication_feed | 1205 | 1.12 | 4.3% |
| Api::V1::GymsController#show | 417 | 2.9 | 4.1% |
| Api::V1::CurrentUsersController#show | 662 | 2.49 | 4.0% |
| Api::V1::CragsController#geo_json | 1195 | 0.92 | 3.5% |
| Api::V1::PublicationViewsController#my_unread_count | 831 | 1.03 | 2.6% |
| Api::V1::PartnersController#partners_around | 311 | 2.42 | 2.6% |
| Api::V1::CommonsController#micro_stats | 949 | 0.61 | 2.3% |
| Api::V1::CommonsController#figures | 6766 | 0.08 | 2.1% |
| Api::V1::ClimbingSessionsController#friends_climbing_sessions | 601 | 1.04 | 1.9% |
| Api::V1::Sessions::TokenController#refresh | 522 | 1.06 | 1.8% |
| Api::V1::GymRoutesController#paginated | 250 | 2.86 | 1.8% |
| Api::V1::FastAccessesController#index | 522 | 1.04 | 1.8% |
| Api::V1::PublicationsController#drafts | 387 | 1.27 | 1.7% |
| Api::V1::NotificationsController#unread_count | 330 | 1.7 | 1.5% |
| Api::V1::CurrentUsersController#likes | 306 | 1.74 | 1.5% |
| Api::V1::SearchesController#search_all | 5411 | 0.06 | 1.5% |
| Api::V1::CragSectorsController#show | 83 | 5.78 | 1.4% |
| Api::V1::GymsController#ascent_scores | 1913 | 0.18 | 1.4% |
| Api::V1::LogBooks::IndoorsController#figures | 748 | 0.57 | 1.2% |
| Api::V1::CurrentUsersController#favorite_gyms | 705 | 0.6 | 1.2% |
| Api::V1::GymsController#index | 1316 | 0.2 | 1.1% |
| Api::V1::CurrentUsersController#upcoming_contests | 745 | 0.52 | 1.1% |

## Jobs (1,998)

- **95P:** 862.4 ms
- **Throughput:** 0.2 /min
- **Errors:** 0.35035%

| Name | 95P ms | Throughput /min | Impact |
| ---- | -----: | --------------: | -----: |
| ActiveStorage::AnalyzeJob | 922 | 0.11 | 53.1% |
| EmailNotificationJob | 3277 | 0.02 | 35.7% |
| ActionMailer::MailDeliveryJob | 152 | 0.03 | 3.0% |
| HistorizeTownJob | 176 | 0.03 | 2.6% |
| HistorizeCragStaticMapJob | 2630 | 0.0 | 2.0% |
| SendPublicationsEmailsJob | 3482 | 0.0 | 1.7% |
| ActiveStorage::PurgeJob | 323 | 0.01 | 1.2% |

## Errors (766)
| Exception | Message | Location | Count | Last |
| --------- | ------- | -------- | ----: | ---- |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/models/concerns/soft_deletable.rb:7 | 206 | 25 Jun 15:14 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/api_controller.rb:26 | 130 | 25 Jun 15:14 |
| **NoMethodError** | undefined method `level_color' for nil:NilClass | app/controllers/api/v1/climbing_sessions_controller.rb:111 | 112 | 28 Jun 17:08 |
| **NoMethodError** | undefined method `+' for nil:NilClass | app/controllers/api/v1/gyms_controller.rb:175 | 58 | 28 Jun 15:37 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/towns_controller.rb:82 | 53 | 25 Jun 14:48 |
| **NoMethodError** | undefined method `first' for nil:NilClass | app/models/color.rb:7 | 37 | 28 Jun 18:10 |
| **NoMethodError** | undefined method `boulder_ranking' for nil:NilClass | app/models/gym_route.rb:50 | 22 | 28 Jun 01:37 |
| **BCrypt::Errors::InvalidHash** | invalid hash | app/controllers/api/v1/sessions/signin_controller.rb:11 | 17 | 26 Jun 20:33 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/commons_controller.rb:37 | 11 | 25 Jun 14:44 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/climber_proximity.rb:107 | 11 | 25 Jun 14:39 |
| **NoMethodError** | undefined method `to_sym' for nil:NilClass | app/controllers/api/v1/gyms_controller.rb:173 | 11 | 28 Jun 13:04 |
| **NoMethodError** | undefined method `summary_to_json' for nil:NilClass | app/models/follow.rb:52 | 9 | 28 Jun 15:44 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | /gems/mysql2-0.5.3/lib/mysql2/client.rb:90 | 9 | 25 Jun 14:42 |
| **NoMethodError** | undefined method `optional_gender' for nil:NilClass | app/models/contest_participant.rb:23 | 9 | 28 Jun 09:03 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/models/notification.rb:31 | 7 | 25 Jun 15:14 |
| **Seahorse::Client::NetworkingError** | execution expired | /home/oblyk/.rbenv/versions/2.6.5/lib/ruby/2.6.0/net/http.rb:947 | 5 | 23 Jun 22:25 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/articles_controller.rb:11 | 5 | 25 Jun 14:44 |
| **ActiveStorage::UnpreviewableError** | ActiveStorage::UnpreviewableError | app/models/video.rb:112 | 5 | 26 Jun 20:57 |
| **NoMethodError** | undefined method `public_profile' for nil:NilClass | app/controllers/api/v1/users_controller.rb:107 | 5 | 28 Jun 11:14 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/departments_controller.rb:73 | 4 | 25 Jun 14:45 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/users_controller.rb:157 | 3 | 25 Jun 14:44 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/search.rb:24 | 3 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | /gems/mysql2-0.5.3/lib/mysql2/client.rb:131 | 2 | 25 Jun 14:39 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (110) | app/controllers/api/v1/partners_controller.rb:20 | 2 | 25 Jun 14:42 |
| **NoMethodError** | undefined method `detail_to_json' for nil:NilClass | app/controllers/api/v1/departments_controller.rb:26 | 2 | 28 Jun 16:39 |
| **NoMethodError** | undefined method `summary_to_json' for nil:NilClass | app/models/crag_sector.rb:121 | 2 | 27 Jun 06:19 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/models/search.rb:14 | 2 | 25 Jun 14:44 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/guide_book_papers_controller.rb:327 | 2 | 25 Jun 14:47 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error::ConnectionError: Lost connection to MySQL server during query | app/controllers/api/v1/gyms_controller.rb:523 | 2 | 25 Jun 14:39 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/guide_book_papers_controller.rb:155 | 1 | 25 Jun 14:43 |
| **ActiveSupport::MessageVerifier::InvalidSignature** | ActiveSupport::MessageVerifier::InvalidSignature | app/controllers/api/v1/videos_controller.rb:25 | 1 | 25 Jun 15:22 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/controllers/api/v1/gyms_controller.rb:155 | 1 | 25 Jun 14:39 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/videos_controller.rb:14 | 1 | 25 Jun 14:42 |
| **RuntimeError** | Can't modify frozen hash | app/models/publication.rb:79 | 1 | 27 Jun 12:48 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/partners_controller.rb:9 | 1 | 25 Jun 14:43 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/gym.rb:202 | 1 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/gym.rb:199 | 1 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error::ConnectionError: Lost connection to MySQL server during query | app/controllers/api/v1/towns_controller.rb:82 | 1 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/controllers/api/v1/commons_controller.rb:28 | 1 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/crag_sector.rb:129 | 1 | 25 Jun 14:39 |
| **NoMethodError** | undefined method `+' for nil:NilClass | app/controllers/api/v1/gyms_controller.rb:179 | 1 | 28 Jun 21:20 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/models/gym_space.rb:194 | 1 | 25 Jun 14:39 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/areas_controller.rb:194 | 1 | 25 Jun 14:44 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (111) | app/controllers/api/v1/publications_controller.rb:238 | 1 | 25 Jun 14:40 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/controllers/api/v1/partners_controller.rb:27 | 1 | 25 Jun 14:39 |
| **Mysql2::Error::ConnectionError** | Can't connect to MySQL server on '185.163.127.177:3306' (110) | app/controllers/api/v1/publications_controller.rb:42 | 1 | 25 Jun 14:42 |
| **NoMethodError** | undefined method `<' for nil:NilClass | app/models/contest.rb:372 | 1 | 26 Jun 10:19 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error: Server shutdown in progress | app/controllers/api/v1/gym_routes_controller.rb:413 | 1 | 25 Jun 14:39 |
| **ActiveRecord::StatementInvalid** | Mysql2::Error::ConnectionError: Lost connection to MySQL server during query | app/models/department.rb:45 | 1 | 25 Jun 14:39 |

## Deployments (7)
| Revision | Date | Req 95P ms | Req /min | Req Errors | Job 95P ms | Job /min | Job Errors |
| -------- | ---- | ---------: | -------: | ---------: | ---------: | -------: | ---------: |
| On retourne une 404 si l'utilisateur n'existe pas en base de donnée | 28 Jun 17:59 | 68.5 | 121.33 | 0.03929% | 330.6 | 0.05 | 0.00000% |
| Fix couleur du text dans les croix des potes | 28 Jun 18:20 | 48.1 | 103.62 | 0.00178% | 430.9 | 0.33 | 0.00000% |
| Mise à jour de capistrano pour le déploiement sur un nouveau serveur | 26 Jun 20:16 | 65.3 | 67.47 | 0.02188% | 459.4 | 0.05 | 0.00000% |
| Changement du lien pour les thumbnails des videos | 27 Jun 16:25 | 66.5 | 101.3 | 0.04288% | 529.4 | 0.12 | 0.00000% |
| Mise à jour de capistrano pour le déploiement sur un nouveau serveur | 27 Jun 09:48 | 69.6 | 140.17 | 0.01979% | 325.2 | 0.34 | 0.00000% |
| Ajout d'index et d'un cache sur les "en quelques chiffres" d'oblyk | 28 Jun 15:26 | 48.3 | 146.49 | 0.03581% | 384.2 | 0.1 | 0.00000% |
| Ajout du chemin vers le spaces pour le eagerloading | 26 Jun 10:28 | 74.4 | 137.41 | 0.02229% | 896.6 | 0.3 | 0.00000% |

[View on RoRvsWild ↗](https://www.rorvswild.com/applications/135627/reports/2026-06-22..2026-06-29)