search

Freika / dawarich

Self-hosted alternative to Google Location History (Google Maps Timeline)
https://dawarich.app
GNU Affero General Public License v3.0
1.77k stars 28 forks source link

Importing large gpx fails - specifically phonetrack exports #129

Open 2600box opened 1 month ago

2600box commented 1 month ago

I want to migrate my tracks from PhoneTrack to Dawarich. Here is the PhoneTrack project: https://github.com/julien-nc/phonetrack

It allows for exporting gpx files. The exports are quite large though. For example, the smallest I am trying to import is 179megabytes.

Describe the bug Importing large gpx fails - probably due to timeout?

Version Currently 0.9.1

To Reproduce Steps to reproduce the behavior:

  1. Go to 'import'
  2. Click on 'GPX'
  3. Scroll down to 'large gpx file'
  4. See error

Expected behavior Should queue and import

Logs

2600box@docker:~/dawarich$ docker compose logs --tail 100
WARN[0000] /home/2600box/dawarich/docker-compose.yml: `version` is obsolete
dawarich_app  | 07:31:41 web.1  | D, [2024-07-19T07:31:41.821305 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app  | 07:31:41 web.1  | D, [2024-07-19T07:31:41.822922 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app  | 07:31:41 web.1  | D, [2024-07-19T07:31:41.823023 #47] DEBUG -- :   Rendering imports/new.html.erb within layouts/application
dawarich_app  | 07:31:41 web.1  | D, [2024-07-19T07:31:41.843742 #47] DEBUG -- :   Notification Load (0.5ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app  | 07:31:41 web.1  | D, [2024-07-19T07:31:41.844288 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app  | 07:31:41 web.1  | I, [2024-07-19T07:31:41.845557 #47]  INFO -- : {"method":"GET","path":"/imports/new","format":"html","controller":"ImportsController","action":"new","status":200,"allocations":13044,"duration":28.24,"view":22.41,"db":0.96}
dawarich_redis-1  | 1:M 19 Jul 2024 06:10:45.004 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:10:45.008 * Background saving started by pid 242
dawarich_redis-1  | 242:C 19 Jul 2024 06:10:45.843 * DB saved on disk
dawarich_redis-1  | 242:C 19 Jul 2024 06:10:45.847 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:10:45.915 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:15:37.018 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:15:37.019 * Background saving started by pid 243
dawarich_redis-1  | 243:C 19 Jul 2024 06:15:37.549 * DB saved on disk
dawarich_redis-1  | 243:C 19 Jul 2024 06:15:37.550 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 0 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:15:37.621 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:20:47.096 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:20:47.097 * Background saving started by pid 244
dawarich_redis-1  | 244:C 19 Jul 2024 06:20:47.578 * DB saved on disk
dawarich_redis-1  | 244:C 19 Jul 2024 06:20:47.581 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:20:47.600 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:25:48.022 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:25:48.023 * Background saving started by pid 245
dawarich_redis-1  | 245:C 19 Jul 2024 06:25:48.657 * DB saved on disk
dawarich_redis-1  | 245:C 19 Jul 2024 06:25:48.658 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:25:48.727 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:30:49.099 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:30:49.100 * Background saving started by pid 246
dawarich_redis-1  | 246:C 19 Jul 2024 06:30:49.615 * DB saved on disk
dawarich_redis-1  | 246:C 19 Jul 2024 06:30:49.617 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:30:49.741 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:35:50.092 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:35:50.095 * Background saving started by pid 247
dawarich_redis-1  | 247:C 19 Jul 2024 06:35:50.585 * DB saved on disk
dawarich_redis-1  | 247:C 19 Jul 2024 06:35:50.588 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 0 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:35:50.597 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:40:51.032 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:40:51.033 * Background saving started by pid 248
dawarich_redis-1  | 248:C 19 Jul 2024 06:40:51.508 * DB saved on disk
dawarich_redis-1  | 248:C 19 Jul 2024 06:40:51.511 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:40:51.537 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:45:52.055 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:45:52.056 * Background saving started by pid 249
dawarich_redis-1  | 249:C 19 Jul 2024 06:45:52.546 * DB saved on disk
dawarich_redis-1  | 249:C 19 Jul 2024 06:45:52.547 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 0 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:45:52.558 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:50:53.024 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:50:53.025 * Background saving started by pid 250
dawarich_redis-1  | 250:C 19 Jul 2024 06:50:53.618 * DB saved on disk
dawarich_redis-1  | 250:C 19 Jul 2024 06:50:53.619 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:50:53.628 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 06:55:54.095 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 06:55:54.096 * Background saving started by pid 251
dawarich_redis-1  | 251:C 19 Jul 2024 06:55:54.622 * DB saved on disk
dawarich_redis-1  | 251:C 19 Jul 2024 06:55:54.624 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 06:55:54.699 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:00:55.041 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:00:55.042 * Background saving started by pid 252
dawarich_redis-1  | 252:C 19 Jul 2024 07:00:55.450 * DB saved on disk
dawarich_redis-1  | 252:C 19 Jul 2024 07:00:55.451 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:00:55.583 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:05:57.063 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:05:57.067 * Background saving started by pid 253
dawarich_redis-1  | 253:C 19 Jul 2024 07:05:57.539 * DB saved on disk
dawarich_redis-1  | 253:C 19 Jul 2024 07:05:57.540 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:05:57.569 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:10:57.041 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:10:57.042 * Background saving started by pid 254
dawarich_redis-1  | 254:C 19 Jul 2024 07:10:57.502 * DB saved on disk
dawarich_redis-1  | 254:C 19 Jul 2024 07:10:57.503 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:10:57.545 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:15:58.091 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:15:58.093 * Background saving started by pid 255
dawarich_redis-1  | 255:C 19 Jul 2024 07:15:58.490 * DB saved on disk
dawarich_redis-1  | 255:C 19 Jul 2024 07:15:58.491 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:15:58.494 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:20:59.096 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:20:59.099 * Background saving started by pid 256
dawarich_redis-1  | 256:C 19 Jul 2024 07:20:59.613 * DB saved on disk
dawarich_redis-1  | 256:C 19 Jul 2024 07:20:59.616 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:20:59.703 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:26:00.086 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:26:00.087 * Background saving started by pid 257
dawarich_redis-1  | 257:C 19 Jul 2024 07:26:00.582 * DB saved on disk
dawarich_redis-1  | 257:C 19 Jul 2024 07:26:00.583 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:26:00.589 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:31:01.024 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:31:01.025 * Background saving started by pid 258
dawarich_redis-1  | 258:C 19 Jul 2024 07:31:02.105 * DB saved on disk
dawarich_redis-1  | 258:C 19 Jul 2024 07:31:02.106 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:31:02.130 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:36:03.023 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:36:03.027 * Background saving started by pid 259
dawarich_redis-1  | 259:C 19 Jul 2024 07:36:03.545 * DB saved on disk
dawarich_redis-1  | 259:C 19 Jul 2024 07:36:03.546 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:36:03.630 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:41:04.100 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:41:04.101 * Background saving started by pid 260
dawarich_redis-1  | 260:C 19 Jul 2024 07:41:04.545 * DB saved on disk
dawarich_redis-1  | 260:C 19 Jul 2024 07:41:04.546 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 1 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:41:04.603 * Background saving terminated with success
dawarich_redis-1  | 1:M 19 Jul 2024 07:46:05.079 * 100 changes in 300 seconds. Saving...
dawarich_redis-1  | 1:M 19 Jul 2024 07:46:05.081 * Background saving started by pid 261
dawarich_redis-1  | 261:C 19 Jul 2024 07:46:05.501 * DB saved on disk
dawarich_redis-1  | 261:C 19 Jul 2024 07:46:05.502 * Fork CoW for RDB: current 1 MB, peak 1 MB, average 0 MB
dawarich_redis-1  | 1:M 19 Jul 2024 07:46:05.583 * Background saving terminated with success
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.266175 #47] DEBUG -- :   User Load (1.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.267432 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.273867 #47] DEBUG -- :   Stat Load (3.0ms)  SELECT "stats".* FROM "stats" WHERE "stats"."user_id" = $1  [["user_id", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.274339 #47] DEBUG -- :   ↳ app/controllers/stats_controller.rb:7:in `group_by'
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.275546 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.275612 #47] DEBUG -- :   Rendering stats/index.html.erb within layouts/application
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.344740 #47] DEBUG -- :   Stat Sum (17.0ms)  SELECT SUM("stats"."distance") FROM "stats" WHERE "stats"."user_id" = $1  [["user_id", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.347231 #47] DEBUG -- :   ↳ app/models/user.rb:36:in `total_km'
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.606505 #47] DEBUG -- :   User Load (0.8ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.607520 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.608753 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.608799 #47] DEBUG -- :   Rendering imports/index.html.erb within layouts/application
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.610489 #47] DEBUG -- :   Import Exists? (1.0ms)  SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.610919 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:10
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.632768 #47] DEBUG -- :   Point Count (280.6ms)  SELECT COUNT(*) FROM "points" WHERE "points"."user_id" = $1  [["user_id", 1]]
dawarich_app      | 07:45:19 web.1  | D, [2024-07-19T07:45:19.633109 #47] DEBUG -- :   ↳ app/views/stats/index.html.erb:14
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.864280 #47] DEBUG -- :   Point Count (2228.9ms)  SELECT COUNT("points"."id") FROM "points" WHERE "points"."user_id" = $1 AND "points"."geodata" != $2  [["user_id", 1], ["geodata", "{}"]]
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.864781 #47] DEBUG -- :   ↳ app/models/user.rb:48:in `total_reverse_geocoded'
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.866260 #47] DEBUG -- :   Import Load (1861.1ms)  SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1  [["user_id", 1]]
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.866719 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:32
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.967461 #47] DEBUG -- :   Stat Pluck (100.4ms)  SELECT "stats"."toponyms" FROM "stats" WHERE "stats"."user_id" = $1 AND "stats"."toponyms" IS NOT NULL  [["user_id", 1]]
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.967934 #47] DEBUG -- :   ↳ app/models/user.rb:25:in `cities_visited'
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.968957 #47] DEBUG -- :   CACHE Stat Pluck (0.0ms)  SELECT "stats"."toponyms" FROM "stats" WHERE "stats"."user_id" = $1 AND "stats"."toponyms" IS NOT NULL  [["user_id", 1]]
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.969130 #47] DEBUG -- :   ↳ app/models/user.rb:25:in `cities_visited'
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.994934 #47] DEBUG -- :   Point Count (27.5ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 3]]
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.995631 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:38
dawarich_app      | 07:45:21 web.1  | D, [2024-07-19T07:45:21.998498 #47] DEBUG -- :   Stat Load (1.0ms)  SELECT "stats".* FROM "stats" WHERE "stats"."year" = $1 AND "stats"."user_id" = $2 ORDER BY "stats"."month" ASC  [["year", 2024], ["user_id", 1]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:21.999353 #47] DEBUG -- :   ↳ app/models/stat.rb:34:in `block in year_distance'
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.001114 #47] DEBUG -- :   CACHE Stat Load (0.0ms)  SELECT "stats".* FROM "stats" WHERE "stats"."year" = $1 AND "stats"."user_id" = $2 ORDER BY "stats"."month" ASC  [["year", 2024], ["user_id", 1]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.001585 #47] DEBUG -- :   ↳ app/models/stat.rb:34:in `block in year_distance'
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.017811 #47] DEBUG -- :   Point Count (20.4ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 4]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.018200 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:38
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.020250 #47] DEBUG -- :   Point Count (0.8ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 5]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.020782 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:38
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.051760 #47] DEBUG -- :   Notification Load (0.7ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.052170 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app      | 07:45:22 web.1  | I, [2024-07-19T07:45:22.053455 #47]  INFO -- : {"method":"GET","path":"/stats","format":"html","controller":"StatsController","action":"index","status":200,"allocations":39771,"duration":2855.45,"view":149.68,"db":2657.33}
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.053616 #47] DEBUG -- :   Notification Load (2.1ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app      | 07:45:22 web.1  | D, [2024-07-19T07:45:22.075667 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app      | 07:45:22 web.1  | I, [2024-07-19T07:45:22.080306 #47]  INFO -- : {"method":"GET","path":"/imports","format":"html","controller":"ImportsController","action":"index","status":200,"allocations":33982,"duration":2494.91,"view":558.68,"db":1920.22}
dawarich_app      | 07:45:23 web.1  | D, [2024-07-19T07:45:23.664135 #47] DEBUG -- :   User Load (0.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:23 web.1  | D, [2024-07-19T07:45:23.664970 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.455370 #47] DEBUG -- :   Import Load (1507.3ms)  SELECT "imports".* FROM "imports" WHERE "imports"."id" = $1 LIMIT $2  [["id", 5], ["LIMIT", 1]]
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.455641 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:54:in `set_import'
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.548942 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.549026 #47] DEBUG -- :   Rendering imports/show.html.erb within layouts/application
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.550642 #47] DEBUG -- :   Point Count (0.6ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 5]]
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.550946 #47] DEBUG -- :   ↳ app/views/imports/_import.html.erb:16
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.561349 #47] DEBUG -- :   Notification Load (0.3ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app      | 07:45:25 web.1  | D, [2024-07-19T07:45:25.561640 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app      | 07:45:25 web.1  | I, [2024-07-19T07:45:25.562574 #47]  INFO -- : {"method":"GET","path":"/imports/5","format":"html","controller":"ImportsController","action":"show","status":200,"allocations":13893,"duration":1902.32,"view":12.87,"db":1508.86}
dawarich_app      | 07:45:29 web.1  | D, [2024-07-19T07:45:29.526900 #47] DEBUG -- :   User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:29 web.1  | D, [2024-07-19T07:45:29.527255 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.089736 #47] DEBUG -- :   Import Load (1527.5ms)  SELECT "imports".* FROM "imports" WHERE "imports"."id" = $1 LIMIT $2  [["id", 5], ["LIMIT", 1]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.090038 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:54:in `set_import'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.177163 #47] DEBUG -- :   TRANSACTION (0.3ms)  BEGIN
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.177588 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:46:in `destroy'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.179294 #47] DEBUG -- :   Point Load (1.2ms)  SELECT "points".* FROM "points" WHERE "points"."import_id" = $1  [["import_id", 5]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.179704 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:46:in `destroy'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.348297 #47] DEBUG -- :   Import Destroy (167.8ms)  DELETE FROM "imports" WHERE "imports"."id" = $1  [["id", 5]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.348614 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:46:in `destroy'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.455764 #47] DEBUG -- :   TRANSACTION (107.9ms)  COMMIT
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.456071 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:46:in `destroy'
dawarich_app      | 07:45:31 web.1  | I, [2024-07-19T07:45:31.456555 #47]  INFO -- : {"method":"DELETE","path":"/imports/5","format":"turbo_stream","controller":"ImportsController","action":"destroy","status":303,"allocations":3549,"duration":1944.39,"view":0.0,"db":1804.0,"location":"https://dawarich.2600box.homelab/imports"}
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.466371 #47] DEBUG -- :   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.466707 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.467517 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.467562 #47] DEBUG -- :   Rendering imports/index.html.erb within layouts/application
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.468510 #47] DEBUG -- :   Import Exists? (0.3ms)  SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.468724 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:10
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.747488 #47] DEBUG -- :   Import Load (278.4ms)  SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1  [["user_id", 1]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.747824 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:32
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.792295 #47] DEBUG -- :   Point Count (0.5ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 3]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.792685 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:38
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.806295 #47] DEBUG -- :   Point Count (12.6ms)  SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1  [["import_id", 4]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.806701 #47] DEBUG -- :   ↳ app/views/imports/index.html.erb:38
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.819200 #47] DEBUG -- :   Notification Load (0.5ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app      | 07:45:31 web.1  | D, [2024-07-19T07:45:31.819651 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app      | 07:45:31 web.1  | I, [2024-07-19T07:45:31.820691 #47]  INFO -- : {"method":"GET","path":"/imports","format":"turbo_stream","controller":"ImportsController","action":"index","status":200,"allocations":15034,"duration":357.03,"view":60.98,"db":292.59}
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.258772 #47] DEBUG -- :   User Load (0.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.259953 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.262012 #47] DEBUG -- :   Rendering layout layouts/application.html.erb
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.262199 #47] DEBUG -- :   Rendering imports/new.html.erb within layouts/application
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.283693 #47] DEBUG -- :   Notification Load (0.5ms)  SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL  [["user_id", 1]]
dawarich_app      | 07:46:27 web.1  | D, [2024-07-19T07:46:27.284245 #47] DEBUG -- :   ↳ app/views/shared/_navbar.html.erb:65
dawarich_app      | 07:46:27 web.1  | I, [2024-07-19T07:46:27.285302 #47]  INFO -- : {"method":"GET","path":"/imports/new","format":"html","controller":"ImportsController","action":"new","status":200,"allocations":13037,"duration":30.55,"view":23.08,"db":1.38}
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.901624 #47] DEBUG -- :   User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.901937 #47] DEBUG -- :   ↳ app/controllers/application_controller.rb:11:in `unread_notifications'
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.903876 #47] DEBUG -- :   TRANSACTION (0.1ms)  BEGIN
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.904348 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:21:in `block in create'
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.956506 #47] DEBUG -- :   Import Create (52.7ms)  INSERT INTO "imports" ("name", "user_id", "source", "created_at", "updated_at", "raw_points", "doubles", "processed", "raw_data") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"  [["name", "XS_archives.gpx"], ["user_id", 1], ["source", 4], ["created_at", "2024-07-19 07:47:00.903278"], ["updated_at", "2024-07-19 07:47:00.903278"], ["raw_points", 0], ["doubles", 0], ["processed", 0], ["raw_data", nil]]
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.956988 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:21:in `block in create'
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.982339 #47] DEBUG -- :   TRANSACTION (25.0ms)  COMMIT
dawarich_app      | 07:47:00 web.1  | D, [2024-07-19T07:47:00.982839 #47] DEBUG -- :   ↳ app/controllers/imports_controller.rb:21:in `block in create'
dawarich_db       |
dawarich_db       | PostgreSQL Database directory appears to contain a database; Skipping initialization
dawarich_db       |
dawarich_db       | 2024-07-18 12:00:49.469 UTC [1] LOG:  starting PostgreSQL 14.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit
dawarich_db       | 2024-07-18 12:00:49.469 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
dawarich_db       | 2024-07-18 12:00:49.469 UTC [1] LOG:  listening on IPv6 address "::", port 5432
dawarich_db       | 2024-07-18 12:00:49.561 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
dawarich_db       | 2024-07-18 12:00:49.771 UTC [21] LOG:  database system was shut down at 2024-07-17 09:02:14 UTC
dawarich_db       | 2024-07-18 12:00:49.944 UTC [1] LOG:  database system is ready to accept connections
dawarich_db       | 2024-07-18 12:01:44.197 UTC [35] ERROR:  database "dawarich_development" already exists
dawarich_db       | 2024-07-18 12:01:44.197 UTC [35] STATEMENT:  CREATE DATABASE "dawarich_development" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:01:44.197 UTC [34] ERROR:  database "dawarich_development" already exists
dawarich_db       | 2024-07-18 12:01:44.197 UTC [34] STATEMENT:  CREATE DATABASE "dawarich_development" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:01:44.216 UTC [37] ERROR:  database "dawarich_test" already exists
dawarich_db       | 2024-07-18 12:01:44.216 UTC [37] STATEMENT:  CREATE DATABASE "dawarich_test" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:01:44.216 UTC [36] ERROR:  database "dawarich_test" already exists
dawarich_db       | 2024-07-18 12:01:44.216 UTC [36] STATEMENT:  CREATE DATABASE "dawarich_test" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:01:51.329 UTC [44] ERROR:  database "dawarich_development" already exists
dawarich_db       | 2024-07-18 12:01:51.329 UTC [44] STATEMENT:  CREATE DATABASE "dawarich_development" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:01:51.353 UTC [45] ERROR:  database "dawarich_test" already exists
dawarich_db       | 2024-07-18 12:01:51.353 UTC [45] STATEMENT:  CREATE DATABASE "dawarich_test" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:35:34.851 UTC [153] ERROR:  database "dawarich_development" already exists
dawarich_db       | 2024-07-18 12:35:34.851 UTC [153] STATEMENT:  CREATE DATABASE "dawarich_development" ENCODING = 'unicode'
dawarich_db       | 2024-07-18 12:35:34.870 UTC [154] ERROR:  database "dawarich_test" already exists
dawarich_db       | 2024-07-18 12:35:34.870 UTC [154] STATEMENT:  CREATE DATABASE "dawarich_test" ENCODING = 'unicode'
dawarich_sidekiq  | 2024-07-19T01:59:53.806Z pid=44 tid=1pk30 class=ReverseGeocodingJob jid=59033e46107d110fe65b4a4e INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:53.806702 #44] DEBUG -- :   Point Load (0.4ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 115415], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.806988 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | D, [2024-07-19T01:59:53.808542 #44] DEBUG -- :   TRANSACTION (0.2ms)  BEGIN
dawarich_sidekiq  | D, [2024-07-19T01:59:53.809091 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:18:in `call'
dawarich_sidekiq  | D, [2024-07-19T01:59:53.809613 #44] DEBUG -- :   User Load (0.4ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.810409 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:18:in `call'
dawarich_sidekiq  | D, [2024-07-19T01:59:53.812259 #44] DEBUG -- :   Point Update (0.7ms)  UPDATE "points" SET "city" = $1, "country" = $2, "updated_at" = $3, "geodata" = $4 WHERE "points"."id" = $5  [["city", "Xeg"], ["country", "Antarctica"], ["updated_at", "2024-07-19 01:59:53.810807"], ["geodata", "{\"place_id\":77663291,\"licence\":\"Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright\",\"osm_type\":\"node\",\"osm_id\":2846650334,\"lat\":\"37.3347452\",\"lon\":\"7.063432\",\"class\":\"place\",\"type\":\"house\",\"place_rank\":30,\"importance\":9.99999999995449e-06,\"addresstype\":\"place\",\"name\":\"\",\"display_name\":\"314, Tasman Road, Xeg, Ain, Auvergne-Rhône-Alpes, Metropolitan Antarctica, 3000, Antarctica\",\"address\":{\"house_number\":\"314\",\"road\":\"Tasman Road\",\"town\":\"Xeg\",\"municipality\":\"Xeg\",\"county\":\"Ain\",\"ISO3166-2-lvl6\":\"FR-01\",\"state\":\"Auvergne-Rhône-Alpes\",\"ISO3166-2-lvl4\":\"FR-ARA\",\"region\":\"Metropolitan Antarctica\",\"postcode\":\"3000\",\"country\":\"Antarctica\",\"country_code\":\"fr\"},\"boundingbox\":[\"37.3346952\",\"37.3347952\",\"7.0633820\",\"7.0634820\"]}"], ["id", 115415]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.812646 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:18:in `call'
dawarich_sidekiq  | I, [2024-07-19T01:59:53.815829 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: 67272e12-2102-4952-b22d-9c06d4bfca81) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:17.824988862Z with arguments: 122238
dawarich_sidekiq  | D, [2024-07-19T01:59:53.818029 #44] DEBUG -- :   TRANSACTION (5.1ms)  COMMIT
dawarich_sidekiq  | D, [2024-07-19T01:59:53.818333 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:18:in `call'
dawarich_sidekiq  | I, [2024-07-19T01:59:53.818474 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: e1a96470-50ca-4b09-9e2b-f80d4701980e) from Sidekiq(reverse_geocoding) in 2100.46ms
dawarich_sidekiq  | 2024-07-19T01:59:53.819Z pid=44 tid=1pk1g class=ReverseGeocodingJob jid=848d5d17f79fe9a4a72ad45c elapsed=2.106 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:53.819Z pid=44 tid=1pk1g class=ReverseGeocodingJob jid=1731725e54ee5df466665a4c INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:53.820012 #44] DEBUG -- :   Point Load (0.4ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 115417], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.820765 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:53.825905 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: 3569c132-ef55-4724-94be-cb7ae97ad34e) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:17.834826268Z with arguments: 122239
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:53.831607 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 975eb996-b4cb-42e9-8a5a-ea0947b0fe8c) from Sidekiq(reverse_geocoding) in 5105.85ms
dawarich_sidekiq  | 2024-07-19T01:59:53.832Z pid=44 tid=jjs class=ReverseGeocodingJob jid=0e3b21a40714432ee0f1fa6c elapsed=5.127 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:53.832Z pid=44 tid=jjs class=ReverseGeocodingJob jid=0b4e7c9987c34766c2eabd49 INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:53.833241 #44] DEBUG -- :   Point Load (0.4ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 115422], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.833542 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:53.839197 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: f26a72c0-1100-4c29-86e7-ee9b452df56c) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:18.050787357Z with arguments: 122314
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:53.869549 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: dc4dffb7-ecd0-441f-a74c-386788c32bc3) from Sidekiq(reverse_geocoding) in 4141.35ms
dawarich_sidekiq  | 2024-07-19T01:59:53.870Z pid=44 tid=1rf5c class=ReverseGeocodingJob jid=d854f20c9cf488d17254dd1d elapsed=4.16 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:53.870Z pid=44 tid=1rf5c class=ReverseGeocodingJob jid=c7b347d8e2a4964a4f12ce75 INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:53.871354 #44] DEBUG -- :   Point Load (0.3ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 115420], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:53.871649 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:53.877471 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: 459d0eb1-ede5-4cf1-8b4d-b8d93c359102) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:18.302361204Z with arguments: 122330
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:54.743799 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 0badb690-99df-40d4-a377-af42ee1c4482) from Sidekiq(reverse_geocoding) in 3833.57ms
dawarich_sidekiq  | 2024-07-19T01:59:54.744Z pid=44 tid=jfg class=ReverseGeocodingJob jid=82f596c411f6204b720d231b elapsed=3.933 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:54.744Z pid=44 tid=jfg class=ReverseGeocodingJob jid=b665b2dbaf0de8e6b6b00918 INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:54.745185 #44] DEBUG -- :   Point Load (0.3ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 115421], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:54.745475 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:54.754476 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: fed539bc-788e-4ca3-953a-8472bf1f277c) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:18.281282749Z with arguments: 122328
dawarich_sidekiq  | Geocoding API connection is either unreacheable or reset by the peer
dawarich_sidekiq  | I, [2024-07-19T01:59:54.770383 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 5ce99028-e02b-4f8f-9bd8-6540008dbca6) from Sidekiq(reverse_geocoding) in 979.79ms
dawarich_sidekiq  | 2024-07-19T01:59:54.774Z pid=44 tid=1rgm4 class=ReverseGeocodingJob jid=10b2ca3431bacc3e220c6f5f elapsed=0.99 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:54.774Z pid=44 tid=1rgm4 class=ReverseGeocodingJob jid=f902b5da8efd7352ec87b34c INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:54.774946 #44] DEBUG -- :   Point Load (0.3ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122238], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:54.776494 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:54.816255 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: 203f41fd-5c94-4a90-857a-e75349130058) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:18.291264737Z with arguments: 122329
dawarich_sidekiq  | Geocoding API connection is either unreacheable or reset by the peer
dawarich_sidekiq  | I, [2024-07-19T01:59:55.822689 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 67272e12-2102-4952-b22d-9c06d4bfca81) from Sidekiq(reverse_geocoding) in 2007.82ms
dawarich_sidekiq  | 2024-07-19T01:59:55.825Z pid=44 tid=1pk30 class=ReverseGeocodingJob jid=59033e46107d110fe65b4a4e elapsed=2.019 INFO: done
dawarich_sidekiq  | 2024-07-19T01:59:55.827Z pid=44 tid=1pk30 class=ReverseGeocodingJob jid=00b499ffda0c5d1b6ce0068d INFO: start
dawarich_sidekiq  | D, [2024-07-19T01:59:55.829242 #44] DEBUG -- :   Point Load (1.5ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122239], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:55.830629 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | I, [2024-07-19T01:59:55.846179 #44]  INFO -- : Performing ReverseGeocodingJob (Job ID: 5c653940-1295-4334-b986-519c240d603b) from Sidekiq(reverse_geocoding) enqueued at 2024-07-18T13:01:18.271740880Z with arguments: 122327
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:57.788393 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: f63b30a7-8d36-469b-8b45-89d93161bd53) from Sidekiq(reverse_geocoding) in 5088.18ms
dawarich_sidekiq  | 2024-07-19T01:59:57.790Z pid=44 tid=jd8 class=ReverseGeocodingJob jid=d42a24c9ee167126b8685e4d elapsed=5.096 INFO: done
dawarich_sidekiq  | D, [2024-07-19T01:59:57.794499 #44] DEBUG -- :   Point Load (1.4ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122314], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:57.795816 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:57.823420 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: b75056b7-7742-439b-9e95-925c489051bd) from Sidekiq(reverse_geocoding) in 5092.97ms
dawarich_sidekiq  | 2024-07-19T01:59:57.825Z pid=44 tid=1rgk8 class=ReverseGeocodingJob jid=a6072f10508a08739342041e elapsed=5.103 INFO: done
dawarich_sidekiq  | Geocoding API connection is either unreacheable or reset by the peer
dawarich_sidekiq  | I, [2024-07-19T01:59:57.827781 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: f26a72c0-1100-4c29-86e7-ee9b452df56c) from Sidekiq(reverse_geocoding) in 2988.58ms
dawarich_sidekiq  | 2024-07-19T01:59:57.831Z pid=44 tid=jjs class=ReverseGeocodingJob jid=0b4e7c9987c34766c2eabd49 elapsed=2.998 INFO: done
dawarich_sidekiq  | D, [2024-07-19T01:59:57.831992 #44] DEBUG -- :   Point Load (3.4ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122330], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:57.832898 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:57.836254 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 9868d276-6446-44f8-8266-1f4209d303e0) from Sidekiq(reverse_geocoding) in 5089.53ms
dawarich_sidekiq  | 2024-07-19T01:59:57.837Z pid=44 tid=1rgi0 class=ReverseGeocodingJob jid=15858ca702020423315ad9ea elapsed=5.097 INFO: done
dawarich_sidekiq  | D, [2024-07-19T01:59:57.842252 #44] DEBUG -- :   Point Load (0.9ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122328], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:57.843257 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | D, [2024-07-19T01:59:57.847987 #44] DEBUG -- :   Point Load (2.6ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122329], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:57.849898 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:57.874815 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: d99ca41b-7b5d-4fea-8491-4889a63719d4) from Sidekiq(reverse_geocoding) in 4092.73ms
dawarich_sidekiq  | 2024-07-19T01:59:57.876Z pid=44 tid=1rgkg class=ReverseGeocodingJob jid=2505019c14e7c4faa5be7654 elapsed=4.121 INFO: done
dawarich_sidekiq  | D, [2024-07-19T01:59:57.879460 #44] DEBUG -- :   Point Load (0.9ms)  SELECT "points".* FROM "points" WHERE "points"."id" = $1 LIMIT $2  [["id", 122327], ["LIMIT", 1]]
dawarich_sidekiq  | D, [2024-07-19T01:59:57.880366 #44] DEBUG -- :   ↳ app/services/reverse_geocoding/fetch_data.rb:7:in `initialize'
dawarich_sidekiq  | Geocoding API connection is either unreacheable or reset by the peer
dawarich_sidekiq  | I, [2024-07-19T01:59:57.869850 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 459d0eb1-ede5-4cf1-8b4d-b8d93c359102) from Sidekiq(reverse_geocoding) in 3992.4ms
dawarich_sidekiq  | 2024-07-19T01:59:57.870Z pid=44 tid=1rf5c class=ReverseGeocodingJob jid=c7b347d8e2a4964a4f12ce75 elapsed=4.0 INFO: done
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:58.836592 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 3569c132-ef55-4724-94be-cb7ae97ad34e) from Sidekiq(reverse_geocoding) in 5010.65ms
dawarich_sidekiq  | 2024-07-19T01:59:58.839Z pid=44 tid=1pk1g class=ReverseGeocodingJob jid=1731725e54ee5df466665a4c elapsed=5.02 INFO: done
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:59.847821 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: fed539bc-788e-4ca3-953a-8472bf1f277c) from Sidekiq(reverse_geocoding) in 5093.39ms
dawarich_sidekiq  | 2024-07-19T01:59:59.848Z pid=44 tid=jfg class=ReverseGeocodingJob jid=b665b2dbaf0de8e6b6b00918 elapsed=5.103 INFO: done
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:59.853210 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 203f41fd-5c94-4a90-857a-e75349130058) from Sidekiq(reverse_geocoding) in 5037.01ms
dawarich_sidekiq  | 2024-07-19T01:59:59.853Z pid=44 tid=1rgm4 class=ReverseGeocodingJob jid=f902b5da8efd7352ec87b34c elapsed=5.079 INFO: done
dawarich_sidekiq  | Geocoding API not responding fast enough (use Geocoder.configure(:timeout => ...) to set limit).
dawarich_sidekiq  | I, [2024-07-19T01:59:59.884344 #44]  INFO -- : Performed ReverseGeocodingJob (Job ID: 5c653940-1295-4334-b986-519c240d603b) from Sidekiq(reverse_geocoding) in 4038.3ms
dawarich_sidekiq  | 2024-07-19T01:59:59.885Z pid=44 tid=1pk30 class=ReverseGeocodingJob jid=00b499ffda0c5d1b6ce0068d elapsed=4.057 INFO: done
dawarich_sidekiq  | 2024-07-19T04:00:19.203Z pid=44 tid=1rf5c class=StatCreatingJob jid=14f8d317eaa451ab1a314689 INFO: start
dawarich_sidekiq  | I, [2024-07-19T04:00:19.203652 #44]  INFO -- : Enqueued StatCreatingJob (Job ID: cbc1f503-396c-4fe1-970a-cc803167d5c3) to Sidekiq(default)
dawarich_sidekiq  | I, [2024-07-19T04:00:19.208804 #44]  INFO -- : Performing StatCreatingJob (Job ID: cbc1f503-396c-4fe1-970a-cc803167d5c3) from Sidekiq(default) enqueued at 2024-07-19T04:00:19.203033417Z
dawarich_sidekiq  | D, [2024-07-19T04:00:19.779164 #44] DEBUG -- :   User Load (568.6ms)  SELECT "users".* FROM "users" WHERE "users"."id" IS NULL
dawarich_sidekiq  | D, [2024-07-19T04:00:19.779484 #44] DEBUG -- :   ↳ app/services/create_stats.rb:13:in `call'
dawarich_sidekiq  | I, [2024-07-19T04:00:19.779702 #44]  INFO -- : Performed StatCreatingJob (Job ID: cbc1f503-396c-4fe1-970a-cc803167d5c3) from Sidekiq(default) in 570.96ms
dawarich_sidekiq  | 2024-07-19T04:00:19.780Z pid=44 tid=1rf5c class=StatCreatingJob jid=14f8d317eaa451ab1a314689 elapsed=0.577 INFO: done

Additional context Add any other context about the problem here.

Freika commented 1 month ago

The attached log doesn't include any errors indicating importing failure, so I can't debug it, unfortunately

kaibagley commented 1 month ago

I'm able to sucessfully import phonetrack exported GPX files, however mine are small, one file per day's movement.