Freika
Import Semantic History - Import Failed
Hi, When i try to import Google semantic history files after 20 minutes it fails
Dawarich_sidekiq log:
I, [2024-07-14T12:55:12.912013 #44] INFO -- : Performing ImportJob (Job ID: e5dc35b4-653e-42ce-a1ea-e38ad073b9c1) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.878336537Z with arguments: 1, 32
I, [2024-07-14T12:55:12.912270 #44] INFO -- : Performing ImportJob (Job ID: e189ded7-bc2b-4cde-84af-5cfd1fcc9361) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.879120230Z with arguments: 1, 33
I, [2024-07-14T12:55:12.912398 #44] INFO -- : Performing ImportJob (Job ID: ee910546-e4eb-4c10-b0b1-7bee4a768372) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.877675989Z with arguments: 1, 31
I, [2024-07-14T12:55:12.912499 #44] INFO -- : Performing ImportJob (Job ID: e4faa937-5ea2-4327-a564-f656843cc317) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.876504644Z with arguments: 1, 30
I, [2024-07-14T12:55:12.912577 #44] INFO -- : Performing ImportJob (Job ID: 4c4e0133-c82d-4573-9c2e-cf185728e214) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.875302311Z with arguments: 1, 28
I, [2024-07-14T12:55:12.912843 #44] INFO -- : Performing ImportJob (Job ID: 2e558be0-396b-468c-aa39-ec01991de144) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.880114679Z with arguments: 1, 34
I, [2024-07-14T12:55:12.912920 #44] INFO -- : Performing ImportJob (Job ID: 2c0af317-963a-4da8-a359-6d374942e0d9) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.875858864Z with arguments: 1, 29
I, [2024-07-14T12:55:12.953174 #44] INFO -- : Performing ImportJob (Job ID: 90d3bcdc-1b34-4850-95f3-1d75be2c07c9) from Sidekiq(imports) enqueued at 2024-07-14T12:55:12.873504731Z with arguments: 1, 27
D, [2024-07-14T12:55:13.004517 #44] DEBUG -- : User Load (1.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]]
D, [2024-07-14T12:55:13.004717 #44] DEBUG -- : ↳ app/jobs/import_job.rb:7:in perform' D, [2024-07-14T12:55:13.008130 #44] DEBUG -- : User Load (4.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] D, [2024-07-14T12:55:13.008677 #44] DEBUG -- : ↳ app/jobs/import_job.rb:7:in perform'
D, [2024-07-14T12:55:13.010161 #44] DEBUG -- : User Load (0.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]]
D, [2024-07-14T12:55:13.010523 #44] DEBUG -- : ↳ app/jobs/import_job.rb:7:in perform' D, [2024-07-14T12:55:13.011140 #44] DEBUG -- : User Load (1.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] D, [2024-07-14T12:55:13.011472 #44] DEBUG -- : ↳ app/jobs/import_job.rb:7:in perform'
D, [2024-07-14T12:55:13.011834 #44] DEBUG -- : User Load (2.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]]
D, [2024-07-14T12:55:13.012093 #44] DEBUG -- : ↳ app/jobs/import_job.rb:7:in perform' D, [2024-07-14T12:55:13.039361 #44] DEBUG -- : Import Load (3.0ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."id" = $2 LIMIT $3 [["user_id", 1], ["id", 33], ["LIMIT", 1]] D, [2024-07-14T12:55:13.039651 #44] DEBUG -- : ↳ app/jobs/import_job.rb:8:in perform'
D, [2024-07-14T12:55:13.044559 #44] DEBUG -- : Import Load (2.3ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."id" = $2 LIMIT $3 [["user_id", 1], ["id", 27], ["LIMIT", 1]]
D, [2024-07-14T12:55:13.045153 #44] DEBUG -- : ↳ app/jobs/import_job.rb:8:in perform' D, [2024-07-14T12:55:13.045528 #44] DEBUG -- : Import Load (6.5ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."id" = $2 LIMIT $3 [["user_id", 1], ["id", 34], ["LIMIT", 1]] D, [2024-07-14T12:55:13.045722 #44] DEBUG -- : ↳ app/jobs/import_job.rb:8:in perform'
D, [2024-07-14T12:55:13.050703 #44] DEBUG -- : Import Load (4.8ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."id" = $2 LIMIT $3 [["user_id", 1], ["id", 32], ["LIMIT", 1]]
D, [2024-07-14T12:55:13.050896 #44] DEBUG -- : ↳ app/jobs/import_job.rb:8:in perform' D, [2024-07-14T12:55:13.050960 #44] DEBUG -- : Import Load (12.0ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 AND "imports"."id" = $2 LIMIT $3 [["user_id", 1], ["id", 29], ["LIMIT", 1]] D, [2024-07-14T12:55:13.051509 #44] DEBUG -- : ↳ app/jobs/import_job.rb:8:in perform'
D, [2024-07-14T12:55:13.084291 #44] DEBUG -- : TRANSACTION (0.1ms) BEGIN
D, [2024-07-14T12:55:13.084963 #44] DEBUG -- : ↳ app/services/notifications/create.rb:14:in `call'
D, [2024-07-14T12:55:13.085996 #44] DEBUG -- : Notification Create (1.8ms) INSERT INTO "notifications" ("title", "content", "user_id", "kind", "read_at", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id" [["title", "Import failed"], ["content", "Import "2018_NOVEMBER.json" failed: no implicit conversion of nil into String"], ["user_id", 1], ["kind", 2], ["read_at", nil], ["created_at", "2024-07-14 12:55:13.083975"], ["updated_at", "2024-07-14 12:55:13.083975"]]
Dawarich_app log:
12:55:12 web.1 | D, [2024-07-14T12:55:12.853898 #56] DEBUG -- : ↳ app/controllers/imports_controller.rb:30:in block in create' 12:55:12 web.1 | D, [2024-07-14T12:55:12.859076 #56] DEBUG -- : TRANSACTION (1.6ms) COMMIT 12:55:12 web.1 | D, [2024-07-14T12:55:12.859311 #56] DEBUG -- : ↳ app/controllers/imports_controller.rb:30:in block in create'
12:55:12 web.1 | 2024-07-14T12:55:12.873Z pid=56 tid=g6s INFO: Sidekiq 7.2.4 connecting to Redis with options {:size=>10, :pool_name=>"internal", :url=>"redis://dawarich_redis:6379/0"}
12:55:12 web.1 | I, [2024-07-14T12:55:12.874993 #56] INFO -- : Enqueued ImportJob (Job ID: 90d3bcdc-1b34-4850-95f3-1d75be2c07c9) to Sidekiq(imports) with arguments: 1, 27
12:55:12 web.1 | I, [2024-07-14T12:55:12.875219 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create' 12:55:12 web.1 | I, [2024-07-14T12:55:12.875636 #56] INFO -- : Enqueued ImportJob (Job ID: 4c4e0133-c82d-4573-9c2e-cf185728e214) to Sidekiq(imports) with arguments: 1, 28 12:55:12 web.1 | I, [2024-07-14T12:55:12.875800 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create'
12:55:12 web.1 | I, [2024-07-14T12:55:12.876279 #56] INFO -- : Enqueued ImportJob (Job ID: 2c0af317-963a-4da8-a359-6d374942e0d9) to Sidekiq(imports) with arguments: 1, 29
12:55:12 web.1 | I, [2024-07-14T12:55:12.876449 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create' 12:55:12 web.1 | I, [2024-07-14T12:55:12.877148 #56] INFO -- : Enqueued ImportJob (Job ID: e4faa937-5ea2-4327-a564-f656843cc317) to Sidekiq(imports) with arguments: 1, 30 12:55:12 web.1 | I, [2024-07-14T12:55:12.877619 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create'
12:55:12 web.1 | I, [2024-07-14T12:55:12.878092 #56] INFO -- : Enqueued ImportJob (Job ID: ee910546-e4eb-4c10-b0b1-7bee4a768372) to Sidekiq(imports) with arguments: 1, 31
12:55:12 web.1 | I, [2024-07-14T12:55:12.878281 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create' 12:55:12 web.1 | I, [2024-07-14T12:55:12.878892 #56] INFO -- : Enqueued ImportJob (Job ID: e5dc35b4-653e-42ce-a1ea-e38ad073b9c1) to Sidekiq(imports) with arguments: 1, 32 12:55:12 web.1 | I, [2024-07-14T12:55:12.879066 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create'
12:55:12 web.1 | I, [2024-07-14T12:55:12.879650 #56] INFO -- : Enqueued ImportJob (Job ID: e189ded7-bc2b-4cde-84af-5cfd1fcc9361) to Sidekiq(imports) with arguments: 1, 33
12:55:12 web.1 | I, [2024-07-14T12:55:12.879920 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create' 12:55:12 web.1 | I, [2024-07-14T12:55:12.880425 #56] INFO -- : Enqueued ImportJob (Job ID: 2e558be0-396b-468c-aa39-ec01991de144) to Sidekiq(imports) with arguments: 1, 34 12:55:12 web.1 | I, [2024-07-14T12:55:12.880711 #56] INFO -- : ↳ app/controllers/imports_controller.rb:34:in block in create'
12:55:12 web.1 | I, [2024-07-14T12:55:12.881044 #56] INFO -- : {"method":"POST","path":"/imports","format":"turbo_stream","controller":"ImportsController","action":"create","status":303,"allocations":183912,"duration":239.87,"view":0.0,"db":84.92,"location":"http://10.10.10.244:3000/imports"}
12:55:12 web.1 | D, [2024-07-14T12:55:12.888298 #56] DEBUG -- : User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
12:55:12 web.1 | D, [2024-07-14T12:55:12.888656 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 12:55:12 web.1 | D, [2024-07-14T12:55:12.889312 #56] DEBUG -- : Rendering layout layouts/application.html.erb 12:55:12 web.1 | D, [2024-07-14T12:55:12.889463 #56] DEBUG -- : Rendering imports/index.html.erb within layouts/application 12:55:12 web.1 | D, [2024-07-14T12:55:12.890185 #56] DEBUG -- : Import Exists? (0.2ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.890460 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:10 12:55:12 web.1 | D, [2024-07-14T12:55:12.906301 #56] DEBUG -- : Import Load (15.3ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 1]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.906569 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:32 12:55:12 web.1 | D, [2024-07-14T12:55:12.908487 #56] DEBUG -- : Point Count (0.7ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 34]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.908773 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.911223 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 27]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.911549 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.912387 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 28]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.912704 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.913421 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 29]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.913715 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.914347 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 30]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.914693 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.915518 #56] DEBUG -- : Point Count (0.3ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 31]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.915842 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.916474 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 32]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.916801 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.917433 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT(*) FROM "points" WHERE "points"."import_id" = $1 [["import_id", 33]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.917725 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38 12:55:12 web.1 | D, [2024-07-14T12:55:12.925387 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]] 12:55:12 web.1 | D, [2024-07-14T12:55:12.925792 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65 12:55:12 web.1 | I, [2024-07-14T12:55:12.926341 #56] INFO -- : {"method":"GET","path":"/imports","format":"turbo_stream","controller":"ImportsController","action":"index","status":200,"allocations":20271,"duration":38.91,"view":19.36,"db":17.83} 13:13:41 web.1 | D, [2024-07-14T13:13:41.161791 #56] DEBUG -- : User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:13:41 web.1 | D, [2024-07-14T13:13:41.162080 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications'
13:13:41 web.1 | D, [2024-07-14T13:13:41.162607 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:13:41 web.1 | D, [2024-07-14T13:13:41.162728 #56] DEBUG -- : Rendering imports/index.html.erb within layouts/application
13:13:41 web.1 | D, [2024-07-14T13:13:41.163519 #56] DEBUG -- : Import Exists? (0.4ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.163700 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:10
13:13:41 web.1 | D, [2024-07-14T13:13:41.178471 #56] DEBUG -- : Import Load (14.5ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 1]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.178721 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:32
13:13:41 web.1 | D, [2024-07-14T13:13:41.180711 #56] DEBUG -- : Point Count (0.9ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 34]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.180946 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.181676 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 27]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.181900 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.182425 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 28]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.182635 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.183182 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 29]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.183401 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.183901 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 30]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.184174 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.184688 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 31]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.184943 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.185558 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 32]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.185781 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.186295 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 33]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.186499 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:13:41 web.1 | D, [2024-07-14T13:13:41.193871 #56] DEBUG -- : Notification Load (0.4ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:13:41 web.1 | D, [2024-07-14T13:13:41.194095 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:13:41 web.1 | I, [2024-07-14T13:13:41.201834 #56] INFO -- : {"method":"GET","path":"/imports","format":"html","controller":"ImportsController","action":"index","status":200,"allocations":28497,"duration":54.31,"view":19.72,"db":23.94}
13:13:44 web.1 | D, [2024-07-14T13:13:44.335098 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.335554 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:13:44 web.1 | D, [2024-07-14T13:13:44.336541 #56] DEBUG -- : Notification Load (0.1ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."id" = $1 LIMIT $2 [["id", 2], ["LIMIT", 1]] 13:13:44 web.1 | D, [2024-07-14T13:13:44.336706 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:30:in set_notification'
13:13:44 web.1 | D, [2024-07-14T13:13:44.337500 #56] DEBUG -- : TRANSACTION (0.1ms) BEGIN
13:13:44 web.1 | D, [2024-07-14T13:13:44.338177 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show' 13:13:44 web.1 | D, [2024-07-14T13:13:44.338548 #56] DEBUG -- : User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:13:44 web.1 | D, [2024-07-14T13:13:44.338885 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show'
13:13:44 web.1 | D, [2024-07-14T13:13:44.339762 #56] DEBUG -- : Notification Update (0.3ms) UPDATE "notifications" SET "read_at" = $1, "updated_at" = $2 WHERE "notifications"."id" = $3 [["read_at", "2024-07-14 13:13:44.336839"], ["updated_at", "2024-07-14 13:13:44.339155"], ["id", 2]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.339988 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show' 13:13:44 web.1 | D, [2024-07-14T13:13:44.344157 #56] DEBUG -- : TRANSACTION (4.0ms) COMMIT 13:13:44 web.1 | D, [2024-07-14T13:13:44.344408 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show'
13:13:44 web.1 | D, [2024-07-14T13:13:44.344853 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:13:44 web.1 | D, [2024-07-14T13:13:44.344885 #56] DEBUG -- : Rendering notifications/show.html.erb within layouts/application
13:13:44 web.1 | D, [2024-07-14T13:13:44.352678 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.352887 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:13:44 web.1 | I, [2024-07-14T13:13:44.353411 #56] INFO -- : {"method":"GET","path":"/notifications/2","format":"html","controller":"NotificationsController","action":"show","status":200,"allocations":17478,"duration":19.55,"view":8.54,"db":5.11}
13:13:44 web.1 | D, [2024-07-14T13:13:44.735405 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.735633 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:13:44 web.1 | D, [2024-07-14T13:13:44.736343 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:13:44 web.1 | D, [2024-07-14T13:13:44.736613 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:30:in set_notification'
13:13:44 web.1 | D, [2024-07-14T13:13:44.737151 #56] DEBUG -- : TRANSACTION (0.1ms) BEGIN
13:13:44 web.1 | D, [2024-07-14T13:13:44.737484 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show' 13:13:44 web.1 | D, [2024-07-14T13:13:44.737716 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:13:44 web.1 | D, [2024-07-14T13:13:44.738110 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show'
13:13:44 web.1 | D, [2024-07-14T13:13:44.738829 #56] DEBUG -- : Notification Update (0.2ms) UPDATE "notifications" SET "read_at" = $1, "updated_at" = $2 WHERE "notifications"."id" = $3 [["read_at", "2024-07-14 13:13:44.736771"], ["updated_at", "2024-07-14 13:13:44.738359"], ["id", 1]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.739081 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show' 13:13:44 web.1 | D, [2024-07-14T13:13:44.743701 #56] DEBUG -- : TRANSACTION (4.5ms) COMMIT 13:13:44 web.1 | D, [2024-07-14T13:13:44.743853 #56] DEBUG -- : ↳ app/controllers/notifications_controller.rb:13:in show'
13:13:44 web.1 | D, [2024-07-14T13:13:44.744068 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:13:44 web.1 | D, [2024-07-14T13:13:44.744096 #56] DEBUG -- : Rendering notifications/show.html.erb within layouts/application
13:13:44 web.1 | D, [2024-07-14T13:13:44.750699 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:13:44 web.1 | D, [2024-07-14T13:13:44.750989 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:13:44 web.1 | I, [2024-07-14T13:13:44.751505 #56] INFO -- : {"method":"GET","path":"/notifications/1","format":"html","controller":"NotificationsController","action":"show","status":200,"allocations":15811,"duration":17.22,"view":7.36,"db":5.52}
13:19:40 web.1 | D, [2024-07-14T13:19:40.603507 #56] DEBUG -- : User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:19:40 web.1 | D, [2024-07-14T13:19:40.603831 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:19:40 web.1 | D, [2024-07-14T13:19:40.604604 #56] DEBUG -- : Rendering layout layouts/application.html.erb 13:19:40 web.1 | D, [2024-07-14T13:19:40.604638 #56] DEBUG -- : Rendering settings/index.html.erb within layouts/application 13:19:40 web.1 | D, [2024-07-14T13:19:40.613550 #56] DEBUG -- : Notification Load (0.4ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]] 13:19:40 web.1 | D, [2024-07-14T13:19:40.613774 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65 13:19:40 web.1 | I, [2024-07-14T13:19:40.614436 #56] INFO -- : {"method":"GET","path":"/settings","format":"html","controller":"SettingsController","action":"index","status":200,"allocations":17677,"duration":23.87,"view":9.59,"db":4.51} 13:19:41 web.1 | D, [2024-07-14T13:19:41.061483 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:19:41 web.1 | D, [2024-07-14T13:19:41.061721 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications'
13:19:41 web.1 | D, [2024-07-14T13:19:41.062165 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:19:41 web.1 | D, [2024-07-14T13:19:41.062198 #56] DEBUG -- : Rendering settings/index.html.erb within layouts/application
13:19:41 web.1 | D, [2024-07-14T13:19:41.069481 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:19:41 web.1 | D, [2024-07-14T13:19:41.069673 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:19:41 web.1 | I, [2024-07-14T13:19:41.070243 #56] INFO -- : {"method":"GET","path":"/settings","format":"html","controller":"SettingsController","action":"index","status":200,"allocations":13423,"duration":9.87,"view":7.89,"db":0.48}
13:19:42 web.1 | D, [2024-07-14T13:19:42.990315 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:19:42 web.1 | D, [2024-07-14T13:19:42.990621 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:19:42 web.1 | D, [2024-07-14T13:19:42.991477 #56] DEBUG -- : User Load (0.1ms) SELECT "users".* FROM "users" ORDER BY "users"."id" ASC LIMIT $1 [["LIMIT", 1]] 13:19:42 web.1 | D, [2024-07-14T13:19:42.991746 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:17:in authenticate_first_user!'
13:19:42 web.1 | D, [2024-07-14T13:19:42.992388 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:19:42 web.1 | D, [2024-07-14T13:19:42.992421 #56] DEBUG -- : Rendering settings/background_jobs/index.html.erb within layouts/application
13:19:42 web.1 | D, [2024-07-14T13:19:42.999569 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:19:42 web.1 | D, [2024-07-14T13:19:42.999750 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:19:43 web.1 | I, [2024-07-14T13:19:43.000281 #56] INFO -- : {"method":"GET","path":"/settings/background_jobs","format":"html","controller":"Settings::BackgroundJobsController","action":"index","status":200,"allocations":14336,"duration":11.03,"view":7.83,"db":0.56}
13:19:53 web.1 | D, [2024-07-14T13:19:53.164291 #56] DEBUG -- : User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.164515 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:19:53 web.1 | D, [2024-07-14T13:19:53.165532 #56] DEBUG -- : Rendering layout layouts/application.html.erb 13:19:53 web.1 | D, [2024-07-14T13:19:53.165572 #56] DEBUG -- : Rendering points/index.html.erb within layouts/application 13:19:53 web.1 | D, [2024-07-14T13:19:53.170088 #56] DEBUG -- : Point Count (3.8ms) SELECT COUNT(*) FROM "points" WHERE "points"."user_id" = $1 AND "points"."timestamp" BETWEEN $2 AND $3 [["user_id", 1], ["timestamp", 1718316000], ["timestamp", 1720994399]] 13:19:53 web.1 | D, [2024-07-14T13:19:53.170302 #56] DEBUG -- : ↳ app/views/points/index.html.erb:32 13:19:53 web.1 | D, [2024-07-14T13:19:53.172375 #56] DEBUG -- : Point Load (0.6ms) SELECT "points"."id", "points"."battery_status", "points"."ping", "points"."battery", "points"."tracker_id", "points"."topic", "points"."altitude", "points"."longitude", "points"."velocity", "points"."trigger", "points"."bssid", "points"."ssid", "points"."connection", "points"."vertical_accuracy", "points"."accuracy", "points"."timestamp", "points"."latitude", "points"."mode", "points"."inrids", "points"."in_regions", "points"."import_id", "points"."city", "points"."country", "points"."created_at", "points"."updated_at", "points"."user_id", "points"."geodata" FROM "points" WHERE "points"."user_id" = $1 AND "points"."timestamp" BETWEEN $2 AND $3 ORDER BY "points"."timestamp" DESC LIMIT $4 OFFSET $5 [["user_id", 1], ["timestamp", 1718316000], ["timestamp", 1720994399], ["LIMIT", 50], ["OFFSET", 0]] 13:19:53 web.1 | D, [2024-07-14T13:19:53.172555 #56] DEBUG -- : ↳ app/views/points/index.html.erb:60 13:19:53 web.1 | D, [2024-07-14T13:19:53.183163 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]] 13:19:53 web.1 | D, [2024-07-14T13:19:53.183360 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65 13:19:53 web.1 | I, [2024-07-14T13:19:53.183968 #56] INFO -- : {"method":"GET","path":"/points","format":"html","controller":"PointsController","action":"index","status":200,"allocations":23425,"duration":20.97,"view":13.9,"db":4.88} 13:19:53 web.1 | D, [2024-07-14T13:19:53.400860 #56] DEBUG -- : User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:19:53 web.1 | D, [2024-07-14T13:19:53.401154 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications'
13:19:53 web.1 | D, [2024-07-14T13:19:53.401700 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:19:53 web.1 | D, [2024-07-14T13:19:53.401732 #56] DEBUG -- : Rendering imports/index.html.erb within layouts/application
13:19:53 web.1 | D, [2024-07-14T13:19:53.402626 #56] DEBUG -- : Import Exists? (0.4ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.402794 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:10
13:19:53 web.1 | D, [2024-07-14T13:19:53.417702 #56] DEBUG -- : Import Load (14.5ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 1]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.417897 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:32
13:19:53 web.1 | D, [2024-07-14T13:19:53.419283 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 34]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.419482 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.420452 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 27]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.420596 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.421084 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 28]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.421238 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.421725 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 29]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.421894 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.422370 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 30]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.422520 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.422961 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 31]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.423123 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.423783 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 32]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.423943 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.424415 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 33]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.424573 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:53 web.1 | D, [2024-07-14T13:19:53.431487 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:19:53 web.1 | D, [2024-07-14T13:19:53.431679 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:19:53 web.1 | I, [2024-07-14T13:19:53.432207 #56] INFO -- : {"method":"GET","path":"/imports","format":"html","controller":"ImportsController","action":"index","status":200,"allocations":19141,"duration":32.52,"view":14.08,"db":16.74}
13:19:54 web.1 | D, [2024-07-14T13:19:54.451011 #56] DEBUG -- : User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]]
13:19:54 web.1 | D, [2024-07-14T13:19:54.451256 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications' 13:19:54 web.1 | D, [2024-07-14T13:19:54.451742 #56] DEBUG -- : Rendering layout layouts/application.html.erb 13:19:54 web.1 | D, [2024-07-14T13:19:54.451778 #56] DEBUG -- : Rendering settings/index.html.erb within layouts/application 13:19:54 web.1 | D, [2024-07-14T13:19:54.459616 #56] DEBUG -- : Notification Load (0.3ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]] 13:19:54 web.1 | D, [2024-07-14T13:19:54.459802 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65 13:19:54 web.1 | I, [2024-07-14T13:19:54.460413 #56] INFO -- : {"method":"GET","path":"/settings","format":"html","controller":"SettingsController","action":"index","status":200,"allocations":13444,"duration":10.88,"view":8.42,"db":0.49} 13:19:55 web.1 | D, [2024-07-14T13:19:55.388511 #56] DEBUG -- : User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 1], ["LIMIT", 1]] 13:19:55 web.1 | D, [2024-07-14T13:19:55.388750 #56] DEBUG -- : ↳ app/controllers/application_controller.rb:11:in unread_notifications'
13:19:55 web.1 | D, [2024-07-14T13:19:55.389321 #56] DEBUG -- : Rendering layout layouts/application.html.erb
13:19:55 web.1 | D, [2024-07-14T13:19:55.389355 #56] DEBUG -- : Rendering imports/index.html.erb within layouts/application
13:19:55 web.1 | D, [2024-07-14T13:19:55.389881 #56] DEBUG -- : Import Exists? (0.2ms) SELECT 1 AS one FROM "imports" WHERE "imports"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.390024 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:10
13:19:55 web.1 | D, [2024-07-14T13:19:55.404762 #56] DEBUG -- : Import Load (14.5ms) SELECT "imports".* FROM "imports" WHERE "imports"."user_id" = $1 [["user_id", 1]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.404946 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:32
13:19:55 web.1 | D, [2024-07-14T13:19:55.406424 #56] DEBUG -- : Point Count (0.3ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 34]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.406633 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.407290 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 27]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.407534 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.408070 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 28]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.408236 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.408786 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 29]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.408940 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.409451 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 30]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.409612 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.410182 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 31]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.410337 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.410797 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 32]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.411077 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.411575 #56] DEBUG -- : Point Count (0.2ms) SELECT COUNT() FROM "points" WHERE "points"."import_id" = $1 [["import_id", 33]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.411727 #56] DEBUG -- : ↳ app/views/imports/index.html.erb:38
13:19:55 web.1 | D, [2024-07-14T13:19:55.418664 #56] DEBUG -- : Notification Load (0.2ms) SELECT "notifications".* FROM "notifications" WHERE "notifications"."user_id" = $1 AND "notifications"."read_at" IS NULL [["user_id", 1]]
13:19:55 web.1 | D, [2024-07-14T13:19:55.418852 #56] DEBUG -- : ↳ app/views/shared/_navbar.html.erb:65
13:19:55 web.1 | I, [2024-07-14T13:19:55.419481 #56] INFO -- : {"method":"GET","path":"/imports","format":"html","controller":"ImportsController","action":"index","status":200,"allocations":18991,"duration":32.04,"view":13.71,"db":16.64}
I hope to have included everything.
Thank You
@TehMaat can you send me the json file that caused this error? With anonymized coordinates, of course
Hello Freika, I tried to text you via email... Anyway, i didn't know what "With anonymized coordinates, of course" meant nor how can i do that
I dont use github frequently
@TehMaat as a beginning, I'd recommend to update to latest version first, and try to import your file again, at some point there was a release fixing a problem with google data importing, maybe it was the one you have experienced
@TehMaat PM me in Discord (the link is in the readme) with your file and I'll figure it out :)