Shared month stats missing last day hexagons

[Kiriyashiki]

OS & Hardware
Ubuntu 24.04

Version
0.35.1

Describe the bug
The map of the Shared month stats page is missing hexagons from the last day in the month

Screenshots
Tracks (fow) for start_at=2025-10-01T00%3A00 end_at=2025-10-31T23%3A59

Hexagons map for October 2025 with missing area highlighted

Logs
No outstanding errors in logs.
Browser:

🏁 Controller connected - loading overlay should be visible public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:18:13
🎯 loadHexagons started - checking overlay state public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:75:13
📊 Initial overlay display: default public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:77:13
⏳ About to wait for map moveend - overlay should still be visible public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:91:17
✅ Map fitBounds complete - checking overlay state public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:97:17
📊 After fitBounds overlay display: default public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:99:17
🔄 Loading static hexagons for public sharing... public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:132:13
👁️ Loading overlay ENSURED visible - should be visible now public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:141:15
📍 Fetching static hexagons from: /api/v1/maps/hexagons?min_lon=2.7686029&min_lat=50.2749798&max_lon=3.1117856&max_lat=50.4399265&start_date=2025-09-30T22%3A00%3A00.000Z&end_date=2025-10-31T22%3A59%3A59.000Z&uuid=0f857787-4cea-44eb-9d91-221ed5b02a60 public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:175:15
✅ Loaded 128 hexagons public_stat_map_controller-b84326e4ff50f456fb45fc398b82f61d63071722a56d07fd2f78f20e0ba5b078.js:190:15
🚫 Loading overlay hidden - hexagons are fully loaded

Docker logs

dawarich_app       |   Stat Load (8.0ms)  SELECT "stats".* FROM "stats" WHERE "stats"."sharing_uuid" = $1 LIMIT $2  [["sharing_uuid", "0f857787-4cea-44eb-9d91-221ed5b02a60"], ["LIMIT", 1]]
dawarich_app       |   ↳ app/controllers/shared/stats_controller.rb:8:in 'Shared::StatsController#show'
dawarich_app       |   User Load (2.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app       |   ↳ app/controllers/shared/stats_controller.rb:17:in 'Shared::StatsController#show'
dawarich_app       |   Point Count (80.2ms)  SELECT COUNT(*) FROM "points" WHERE "points"."user_id" = $1 AND "points"."timestamp" BETWEEN $2 AND $3  [["user_id", 1], ["timestamp", 1759269600], ["timestamp", 1761951599]]
dawarich_app       |   ↳ app/models/stat.rb:104:in 'Stat#calculate_data_bounds'
dawarich_app       |   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."api_key" IS NULL LIMIT $1  [["LIMIT", 1]]
dawarich_app       |   ↳ app/controllers/api_controller.rb:30:in 'ApiController#current_api_user'
dawarich_app       | {"method":"GET","path":"/api/v1/health","format":"*/*","controller":"Api::V1::HealthController","action":"index","status":200,"allocations":985,"duration":3.41,"view":0.11,"db":0.28}
dawarich_app       |   data_bounds_query (221.4ms)  SELECT MIN(ST_Y(lonlat::geometry)) as min_lat, MAX(ST_Y(lonlat::geometry)) as max_lat,
dawarich_app       |               MIN(ST_X(lonlat::geometry)) as min_lng, MAX(ST_X(lonlat::geometry)) as max_lng
dawarich_app       |        FROM points
dawarich_app       |        WHERE user_id = $1
dawarich_app       |        AND timestamp BETWEEN $2 AND $3
dawarich_app       |        AND lonlat IS NOT NULL  [[nil, 1], [nil, 1759269600], [nil, 1761951599]]
dawarich_app       |   ↳ app/models/stat.rb:108:in 'Stat#calculate_data_bounds'
dawarich_app       |   Rendering layout layouts/application.html.erb
dawarich_app       |   Rendering stats/public_month.html.erb within layouts/application
dawarich_app       | {"method":"GET","path":"/shared/month/0f857787-4cea-44eb-9d91-221ed5b02a60","format":"*/*","controller":"Shared::StatsController","action":"show","status":200,"allocations":29619,"duration":434.27,"view":79.31,"db":311.54}
...
dawarich_app       |   ↳ app/controllers/api/v1/maps/hexagons_controller.rb:66:in 'Api::V1::Maps::HexagonsController#resolve_public_sharing_context'
dawarich_app       |   User Load (0.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app       |   ↳ app/controllers/api/v1/maps/hexagons_controller.rb:70:in 'Api::V1::Maps::HexagonsController#resolve_public_sharing_context'

Additional context
The missing areas highlighted correspond to tracks recorded on October 31 between 16:00 and 22:00 UTC+1.

[Freika]

Should be fixed in 1.3.4