search

teslamate-org / teslamate

A self-hosted data logger for your Tesla 🚘
https://docs.teslamate.org
MIT License
5.81k stars 727 forks source link

500 Status - Grafana not loading data #3327

Closed ID-Ant closed 1 year ago

ID-Ant commented 1 year ago

Is there an existing issue for this?

What happened?

Installed successfully via Docker - how ever on the dashboards i am getting a Query Data Error on all the dashboards:

Grafana Query Data Error:

Query data error
Object
status:500
statusText:"Internal Server Error"
data:Object
message:"Query data error"
traceID:"00000000000000000000000000000000"
config:Object
url:"api/ds/query"
method:"POST"
data:Object
requestId:"Q140"
retry:0
headers:Object
hideFromInspector:false
message:"Query data error"

Docker is showing the following error messages:

docker-grafana-1 | logger=tsdb.postgres t=2023-08-31T14:04:33.35+0000 lvl=eror msg="Failed connecting to Postgres" err="invalid option: \"9KJj0jRoQr'\""

docker-grafana-1 | logger=context traceID=00000000000000000000000000000000 userId=1 orgId=1 uname=admin t=2023-08-31T14:03:03.8+0000 lvl=eror msg="Request Completed" method=POST path=/api/ds/query status=500 remote_addr=192.168.1.210 time_ms=68 duration=68.775142ms size=75 referer="http://192.168.1.210:3000/d/kOuP_Fggz/overview?orgId=1&refresh=30s" traceID=00000000000000000000000000000000

Not sure why 500 error is being returned? I have driven the car as well to ensure something would be loaded into the DB but seemingly not?

Expected Behavior

Data should be shown?

Steps To Reproduce

go to http://192.168.1.210:3000/d/_7WkNSyWk/drive-stats?orgId=1 for example tables showing error

Relevant log output

docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | waiting for postgres at database:5432
docker-teslamate-1  | 2023-08-31 12:24:40.290 [info] == Running 20190330150000 TeslaMate.Repo.Migrations.CreateCar.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.296 [info] create table cars
docker-teslamate-1  | 2023-08-31 12:24:40.327 [info] create index cars_eid_index
docker-teslamate-1  | 2023-08-31 12:24:40.337 [info] create index cars_vid_index
docker-teslamate-1  | 2023-08-31 12:24:40.352 [info] == Migrated 20190330150000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.450 [info] == Running 20190330160000 TeslaMate.Repo.Migrations.CreateTrips.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.451 [info] create table trips
docker-teslamate-1  | 2023-08-31 12:24:40.489 [info] == Migrated 20190330160000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.511 [info] == Running 20190330170000 TeslaMate.Repo.Migrations.CreatePositions.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.512 [info] create table positions
docker-teslamate-1  | 2023-08-31 12:24:40.564 [info] == Migrated 20190330170000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.584 [info] == Running 20190330180000 TeslaMate.Repo.Migrations.CreateStates.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.592 [info] execute "CREATE TYPE states_status AS ENUM ('online', 'offline', 'asleep')"
docker-teslamate-1  | 2023-08-31 12:24:40.598 [info] create table states
docker-teslamate-1  | 2023-08-31 12:24:40.617 [info] == Migrated 20190330180000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.634 [info] == Running 20190330190000 TeslaMate.Repo.Migrations.CreateChargingProcesses.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.635 [info] create table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:40.657 [info] == Migrated 20190330190000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.672 [info] == Running 20190330200000 TeslaMate.Repo.Migrations.CreateCharges.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.673 [info] create table charges
docker-teslamate-1  | 2023-08-31 12:24:40.705 [info] == Migrated 20190330200000 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.722 [info] == Running 20190408203117 TeslaMate.Repo.Migrations.CreateUpdates.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.723 [info] create table updates
docker-teslamate-1  | 2023-08-31 12:24:40.740 [info] == Migrated 20190408203117 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.767 [info] == Running 20190415103933 TeslaMate.Repo.Migrations.AddInsideTemp.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.768 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:40.772 [info] alter table trips
docker-teslamate-1  | 2023-08-31 12:24:40.779 [info] == Migrated 20190415103933 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.793 [info] == Running 20190415115227 TeslaMate.Repo.Migrations.AddBatteryHeaterFields.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.794 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:40.797 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:40.802 [info] == Migrated 20190415115227 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.816 [info] == Running 20190415130006 TeslaMate.Repo.Migrations.CreateAddresses.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.817 [info] create table addresses
docker-teslamate-1  | 2023-08-31 12:24:40.846 [info] create index addresses_place_id_index
docker-teslamate-1  | 2023-08-31 12:24:40.859 [info] == Migrated 20190415130006 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.872 [info] == Running 20190415130705 TeslaMate.Repo.Migrations.AddAddressesToTrips.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.873 [info] alter table trips
docker-teslamate-1  | 2023-08-31 12:24:40.893 [info] == Migrated 20190415130705 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.908 [info] == Running 20190415192200 TeslaMate.Repo.Migrations.AddAddressToChargingProcess.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.909 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:40.924 [info] == Migrated 20190415192200 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.936 [info] == Running 20190416125429 TeslaMate.Repo.Migrations.AddIndexesOnDates.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.937 [info] create index positions_date_index
docker-teslamate-1  | 2023-08-31 12:24:40.952 [info] create index charges_date_index
docker-teslamate-1  | 2023-08-31 12:24:40.970 [info] == Migrated 20190416125429 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:40.985 [info] == Running 20190525125700 TeslaMate.Repo.Migrations.RenameSocFields.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:40.986 [info] rename column start_soc to start_range_km on table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:40.990 [info] rename column end_soc to end_range_km on table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:40.993 [info] == Migrated 20190525125700 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.009 [info] == Running 20190717184003 TeslaMate.Repo.Migrations.AddFkeyIndexes.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.011 [info] create index charges_charging_process_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.024 [info] create index charging_processes_car_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.038 [info] create index charging_processes_position_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.064 [info] create index charging_processes_address_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.078 [info] create index positions_car_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.088 [info] create index positions_trip_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.100 [info] create index states_car_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.114 [info] create index trips_car_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.126 [info] create index trips_start_address_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.133 [info] create index trips_end_address_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.146 [info] create index updates_car_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.155 [info] == Migrated 20190717184003 in 0.1s
docker-teslamate-1  | 2023-08-31 12:24:41.167 [info] == Running 20190729142656 TeslaMate.Repo.Migrations.AddConversionFunctions.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.168 [info] execute "CREATE FUNCTION convert_celsius(n double precision, unit text)\nRETURNS double precision\nAS $$\n  SELECT\n    CASE WHEN $2 = 'C' THEN $1\n         WHEN $2 = 'F' THEN ($1 * 9 / 5) + 32\n    END;\n$$\nLANGUAGE SQL\nIMMUTABLE\nRETURNS NULL ON NULL INPUT;\n"
docker-teslamate-1  | 2023-08-31 12:24:41.181 [info] execute "CREATE FUNCTION convert_km(n double precision, unit text)\nRETURNS double precision\nAS $$\n  SELECT\n    CASE WHEN $2 = 'km' THEN $1\n         WHEN $2 = 'mi' THEN $1 / 1.60934\n    END;\n$$\nLANGUAGE SQL\nIMMUTABLE\nRETURNS NULL ON NULL INPUT;\n"
docker-teslamate-1  | 2023-08-31 12:24:41.187 [info] == Migrated 20190729142656 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.202 [info] == Running 20190729181314 TeslaMate.Repo.Migrations.FixTripEfficiency.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.211 [info] == Migrated 20190729181314 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.228 [info] == Running 20190730101523 TeslaMate.Repo.Migrations.CreateTokens.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.229 [info] create table tokens
docker-teslamate-1  | 2023-08-31 12:24:41.274 [info] == Migrated 20190730101523 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.290 [info] == Running 20190731154452 TeslaMate.Repo.Migrations.CreateSettings.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.292 [info] create table settings
docker-teslamate-1  | 2023-08-31 12:24:41.317 [info] == Migrated 20190731154452 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.329 [info] == Running 20190805092941 TeslaMate.Repo.Migrations.FixIncompleteChargingProcesses.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.329 [info] == Migrated 20190805092941 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.343 [info] == Running 20190810105216 TeslaMate.Repo.Migrations.UnitOfLengthAndTemperature.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.349 [info] execute "CREATE TYPE length AS ENUM ('km', 'mi')"
docker-teslamate-1  | 2023-08-31 12:24:41.352 [info] execute "CREATE TYPE temperature AS ENUM ('C', 'F')"
docker-teslamate-1  | 2023-08-31 12:24:41.355 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:41.400 [info] == Migrated 20190810105216 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.414 [info] == Running 20190810131321 TeslaMate.Repo.Migrations.PersistSuspendSettings.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.417 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:41.423 [info] == Migrated 20190810131321 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.436 [info] == Running 20190810151901 TeslaMate.Repo.Migrations.CreateGeofences.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.438 [info] create table geofences
docker-teslamate-1  | 2023-08-31 12:24:41.460 [info] create index geofences_address_id_index
docker-teslamate-1  | 2023-08-31 12:24:41.478 [info] == Migrated 20190810151901 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.490 [info] == Running 20190812191616 TeslaMate.Repo.Migrations.RenameTripsToDrives.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.490 [info] rename table trips to drives
docker-teslamate-1  | 2023-08-31 12:24:41.495 [info] rename column trip_id to drive_id on table positions
docker-teslamate-1  | 2023-08-31 12:24:41.502 [info] execute "ALTER INDEX positions_trip_id_index RENAME TO positions_drive_id_index;"
docker-teslamate-1  | 2023-08-31 12:24:41.505 [info] execute "ALTER TABLE positions RENAME CONSTRAINT positions_trip_id_fkey TO positions_drive_id_fkey"
docker-teslamate-1  | 2023-08-31 12:24:41.507 [info] == Migrated 20190812191616 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.523 [info] == Running 20190813184320 TeslaMate.Repo.Migrations.FixIncompleteChargingProcessesV2.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.524 [info] == Migrated 20190813184320 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.537 [info] == Running 20190814152810 TeslaMate.Repo.Migrations.IncreaseSuspendMin.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.537 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:41.546 [info] == Migrated 20190814152810 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.558 [info] == Running 20190816165713 TeslaMate.Repo.Migrations.ExtendCarTable.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.559 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:41.574 [info] == Migrated 20190816165713 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.601 [info] == Running 20190816200723 TeslaMate.Repo.Migrations.AddEstBatteryRangeKm.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.602 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:41.605 [info] == Migrated 20190816200723 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.620 [info] == Running 20190821143938 TeslaMate.Repo.Migrations.AddConstraints.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.620 [info] create index states_car_id__end_date_IS_NULL_index
docker-teslamate-1  | 2023-08-31 12:24:41.636 [info] create check constraint positive_duration on table states
docker-teslamate-1  | 2023-08-31 12:24:41.643 [info] create check constraint positive_duration on table updates
docker-teslamate-1  | 2023-08-31 12:24:41.646 [info] == Migrated 20190821143938 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.663 [info] == Running 20190821155748 TeslaMate.Repo.Migrations.DropConsumptionColumns.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.664 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:41.671 [info] == Migrated 20190821155748 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.689 [info] == Running 20190823173437 TeslaMate.Repo.Migrations.AddSleepRequirements.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.689 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:41.693 [info] == Migrated 20190823173437 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.710 [info] == Running 20190826142828 TeslaMate.Repo.Migrations.FixIncompleteChargingProcessesV3.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.711 [info] == Migrated 20190826142828 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.722 [info] == Running 20190828094708 TeslaMate.Repo.Migrations.AddBatteryRange.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.724 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:41.728 [info] == Migrated 20190828094708 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.743 [info] == Running 20190828104902 TeslaMate.Repo.Migrations.AddElevation.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.744 [info] rename column altitude to elevation on table positions
docker-teslamate-1  | 2023-08-31 12:24:41.747 [info] == Migrated 20190828104902 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.759 [info] == Running 20190828122529 TeslaMate.Repo.Migrations.AddMToFtConversionHelper.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.759 [info] execute "CREATE FUNCTION convert_m(n double precision, unit text)\nRETURNS double precision\nAS $$\n  SELECT\n    CASE WHEN $2 = 'm' THEN $1\n         WHEN $2 = 'ft' THEN $1 * 3.28084\n    END;\n$$\nLANGUAGE SQL\nIMMUTABLE\nRETURNS NULL ON NULL INPUT;\n"
docker-teslamate-1  | 2023-08-31 12:24:41.771 [info] == Migrated 20190828122529 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.784 [info] == Running 20190828150058 TeslaMate.Repo.Migrations.DoNotRequireEfficiency.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.785 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:41.789 [info] rename column version to trim_badging on table cars
docker-teslamate-1  | 2023-08-31 12:24:41.791 [info] == Migrated 20190828150058 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.804 [info] == Running 20190903151524 TeslaMate.Repo.Migrations.AddUniqueIndexOnVins.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.805 [info] create index cars_vin_index
docker-teslamate-1  | 2023-08-31 12:24:41.820 [info] == Migrated 20190903151524 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.835 [info] == Running 20190913165850 TeslaMate.Repo.Migrations.AddRangeEnum.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.836 [info] execute "CREATE TYPE range AS ENUM ('ideal', 'rated')"
docker-teslamate-1  | 2023-08-31 12:24:41.845 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:41.848 [info] == Migrated 20190913165850 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.862 [info] == Running 20190913175011 TeslaMate.Repo.Migrations.AddRatedRangeToDrives.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.864 [info] rename column battery_range_km to rated_battery_range_km on table positions
docker-teslamate-1  | 2023-08-31 12:24:41.867 [info] rename column start_range_km to start_ideal_range_km on table drives
docker-teslamate-1  | 2023-08-31 12:24:41.871 [info] rename column end_range_km to end_ideal_range_km on table drives
docker-teslamate-1  | 2023-08-31 12:24:41.875 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:41.880 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:41.884 [info] rename column start_range_km to start_ideal_range_km on table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:41.887 [info] rename column end_range_km to end_ideal_range_km on table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:41.890 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:41.895 [info] == Migrated 20190913175011 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.913 [info] == Running 20190913175543 TeslaMate.Repo.Migrations.SetStartAndEndRatedRangeKm.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.956 [info] == Migrated 20190913175543 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:41.968 [info] == Running 20190925152807 TeslaMate.Repo.Migrations.CreateGeoExtensions.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:41.969 [info] execute "CREATE EXTENSION IF NOT EXISTS cube"
docker-teslamate-1  | 2023-08-31 12:24:42.078 [info] execute "CREATE EXTENSION IF NOT EXISTS earthdistance"
docker-teslamate-1  | 2023-08-31 12:24:42.097 [info] create index geofences__earth_box_ll_to_earth_latitude__longitude___radius_index
docker-teslamate-1  | 2023-08-31 12:24:42.131 [info] == Migrated 20190925152807 in 0.1s
docker-teslamate-1  | 2023-08-31 12:24:42.157 [info] == Running 20190925161034 TeslaMate.Repo.Migrations.CreateIndexOnAddressPositions.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.158 [info] create index addresses_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.177 [info] == Migrated 20190925161034 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.192 [info] == Running 20190925182253 TeslaMate.Repo.Migrations.AddGeofenceIdToAddresses.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.193 [info] alter table addresses
docker-teslamate-1  | 2023-08-31 12:24:42.208 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:42.216 [info] create index addresses_geofence_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.228 [info] == Migrated 20190925182253 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.241 [info] == Running 20190928155641 TeslaMate.Repo.Migrations.AddBaseUrlSetting.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.243 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:42.247 [info] == Migrated 20190928155641 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.266 [info] == Running 20191003130650 TeslaMate.Repo.Migrations.AddStartAndEndPositionToDrives.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.268 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:42.292 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:42.299 [info] alter table addresses
docker-teslamate-1  | 2023-08-31 12:24:42.305 [info] create index positions_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.332 [info] == Migrated 20191003130650 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.348 [info] == Running 20191003132415 TeslaMate.Repo.Migrations.AddPositionIdsAndApplyGeofences.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.359 [info] == Migrated 20191003132415 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.374 [info] == Running 20191007105010 TeslaMate.Repo.Migrations.AddNewFkeyIndexes.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.376 [info] create index drives_start_position_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.389 [info] create index drives_end_position_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.402 [info] create index drives_start_geofence_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.416 [info] create index drives_end_geofence_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.427 [info] drop index positions_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.429 [info] drop index addresses_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.432 [info] drop index geofences__earth_box_ll_to_earth_latitude__longitude___radius_index
docker-teslamate-1  | 2023-08-31 12:24:42.437 [info] create index positions_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.444 [info] create index addresses_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:42.451 [info] == Migrated 20191007105010 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.467 [info] == Running 20191008191431 TeslaMate.Repo.Migrations.FixLlToEarth.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.467 [info] execute "CREATE OR REPLACE FUNCTION public.ll_to_earth(float8, float8)\nRETURNS public.earth\nLANGUAGE SQL\nIMMUTABLE STRICT\nPARALLEL SAFE\nAS 'SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians($1))*cos(radians($2))),public.earth()*cos(radians($1))*sin(radians($2))),public.earth()*sin(radians($1)))::public.earth';\n"
docker-teslamate-1  | 2023-08-31 12:24:42.473 [info] == Migrated 20191008191431 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.487 [info] == Running 20191017003836 TeslaMate.Repo.Migrations.AddEstTotalChargeEnergy.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.489 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:42.492 [info] == Migrated 20191017003836 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.505 [info] == Running 20191020130234 TeslaMate.Repo.Migrations.IncreaseDatetimePrecision.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.506 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:42.510 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:42.513 [info] alter table states
docker-teslamate-1  | 2023-08-31 12:24:42.531 [info] alter table updates
docker-teslamate-1  | 2023-08-31 12:24:42.537 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:42.543 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:42.555 [info] == Migrated 20191020130234 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.572 [info] == Running 20191026144449 TeslaMate.Repo.Migrations.DropCpConfidenceAndInterval.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.573 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:42.578 [info] == Migrated 20191026144449 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.591 [info] == Running 20191026145925 TeslaMate.Repo.Migrations.PhaseCorrection.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.591 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:42.596 [info] == Migrated 20191026145925 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.609 [info] == Running 20191026185642 TeslaMate.Repo.Migrations.CalculateChargeEnergyUsed.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.615 [info] == Migrated 20191026185642 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.628 [info] == Running 20191117042320 TeslaMate.Repo.Migrations.AddCostFieldToCharges.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.629 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:42.632 [info] == Migrated 20191117042320 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.647 [info] == Running 20191117143038 TeslaMate.Repo.Migrations.AddGrafanaUrl.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.648 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:42.672 [info] == Migrated 20191117143038 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.682 [info] == Running 20191117171307 TeslaMate.Repo.Migrations.CarSettings.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.684 [info] create table car_settings
docker-teslamate-1  | 2023-08-31 12:24:42.708 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:42.727 [info] drop constraint cars_settings_id_fkey from table cars
docker-teslamate-1  | 2023-08-31 12:24:42.729 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:42.737 [info] create index cars_settings_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.751 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:42.759 [info] == Migrated 20191117171307 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.775 [info] == Running 20191119162847 TeslaMate.Repo.Migrations.GeofenceSleep.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.777 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:42.783 [info] create table geofence_sleep_mode_whitelist
docker-teslamate-1  | 2023-08-31 12:24:42.804 [info] create table geofence_sleep_mode_blacklist
docker-teslamate-1  | 2023-08-31 12:24:42.822 [info] == Migrated 20191119162847 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.840 [info] == Running 20191212215130 TeslaMate.Repo.Migrations.RemovePhaseCorrection.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.841 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:42.845 [info] == Migrated 20191212215130 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.858 [info] == Running 20191212230527 TeslaMate.Repo.Migrations.RecalcEnergyUsed.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.861 [info] == Migrated 20191212230527 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.878 [info] == Running 20200103073606 TeslaMate.Repo.Migrations.AddUsableBatteryLevel.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.879 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:42.882 [info] == Migrated 20200103073606 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.894 [info] == Running 20200116190926 TeslaMate.Repo.Migrations.ChargesAddUsableBatteryLevel.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.894 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:42.900 [info] == Migrated 20200116190926 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.912 [info] == Running 20200120130125 TeslaMate.Repo.Migrations.AddLanguage.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.912 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:42.916 [info] == Migrated 20200120130125 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.935 [info] == Running 20200120142602 TeslaMate.Repo.Migrations.ReplacePlaceIdWithOsmid.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.936 [info] drop index addresses_place_id_index
docker-teslamate-1  | 2023-08-31 12:24:42.939 [info] alter table addresses
docker-teslamate-1  | 2023-08-31 12:24:42.945 [info] create index addresses_osm_id_osm_type_index
docker-teslamate-1  | 2023-08-31 12:24:42.957 [info] execute "UPDATE drives SET start_address_id = NULL, end_address_id = NULL;"
docker-teslamate-1  | 2023-08-31 12:24:42.961 [info] execute "UPDATE charging_processes SET address_id = NULL;"
docker-teslamate-1  | 2023-08-31 12:24:42.966 [info] execute "DELETE FROM addresses;"
docker-teslamate-1  | 2023-08-31 12:24:42.971 [info] execute "ALTER SEQUENCE addresses_id_seq RESTART;"
docker-teslamate-1  | 2023-08-31 12:24:42.976 [info] == Migrated 20200120142602 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:42.993 [info] == Running 20200203120311 TeslaMate.Repo.Migrations.CascadeDelete.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:42.994 [info] drop constraint cars_settings_id_fkey from table cars
docker-teslamate-1  | 2023-08-31 12:24:42.999 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:43.006 [info] drop constraint charges_charging_process_id_fkey from table charges
docker-teslamate-1  | 2023-08-31 12:24:43.013 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:43.025 [info] drop constraint charging_processes_car_id_fkey from table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:43.031 [info] drop constraint charging_processes_address_id_fkey from table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:43.036 [info] drop constraint charging_processes_geofence_id_fkey from table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:43.042 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:43.056 [info] drop constraint if exists trips_car_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.061 [info] drop constraint if exists drives_car_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.066 [info] constraint "drives_car_id_fkey" of relation "drives" does not exist, skipping
docker-teslamate-1  | 2023-08-31 12:24:43.067 [info] drop constraint drives_start_position_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.075 [info] drop constraint drives_end_position_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.080 [info] drop constraint if exists trips_start_address_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.085 [info] drop constraint if exists trips_end_address_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.088 [info] drop constraint if exists drives_start_address_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.090 [info] constraint "drives_start_address_id_fkey" of relation "drives" does not exist, skipping
docker-teslamate-1  | 2023-08-31 12:24:43.090 [info] drop constraint if exists drives_end_address_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.092 [info] constraint "drives_end_address_id_fkey" of relation "drives" does not exist, skipping
docker-teslamate-1  | 2023-08-31 12:24:43.092 [info] drop constraint drives_start_geofence_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.098 [info] drop constraint drives_end_geofence_id_fkey from table drives
docker-teslamate-1  | 2023-08-31 12:24:43.104 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:43.132 [info] drop constraint positions_car_id_fkey from table positions
docker-teslamate-1  | 2023-08-31 12:24:43.136 [info] drop constraint positions_drive_id_fkey from table positions
docker-teslamate-1  | 2023-08-31 12:24:43.141 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:43.153 [info] drop constraint states_car_id_fkey from table states
docker-teslamate-1  | 2023-08-31 12:24:43.157 [info] alter table states
docker-teslamate-1  | 2023-08-31 12:24:43.190 [info] drop constraint updates_car_id_fkey from table updates
docker-teslamate-1  | 2023-08-31 12:24:43.195 [info] alter table updates
docker-teslamate-1  | 2023-08-31 12:24:43.207 [info] == Migrated 20200203120311 in 0.2s
docker-teslamate-1  | 2023-08-31 12:24:43.232 [info] == Running 20200203180529 TeslaMate.Repo.Migrations.LocationBasedChargeCost.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.234 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:43.239 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:43.242 [info] == Migrated 20200203180529 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.255 [info] == Running 20200212001245 TeslaMate.Repo.Migrations.LocationBasedChargeCostIncreaseScale.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.256 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:43.273 [info] == Migrated 20200212001245 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.288 [info] == Running 20200216121330 TeslaMate.Repo.Migrations.UseRatedAsDefaultPreferredRange.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.288 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:43.294 [info] == Migrated 20200216121330 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.310 [info] == Running 20200302100654 TeslaMate.Repo.Migrations.AddVehicleConfigAttrbitues.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.312 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:43.316 [info] == Migrated 20200302100654 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.331 [info] == Running 20200306130218 TeslaMate.Repo.Migrations.UpdateCities.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.332 [info] execute "UPDATE addresses a\nSET city = (\n  SELECT trim(BOTH '\"' FROM COALESCE(\n    raw -> 'address' -> 'city',\n    raw -> 'address' -> 'town',\n    raw -> 'address' -> 'municipality',\n    raw -> 'address' -> 'village',\n    raw -> 'address' -> 'hamlet',\n    raw -> 'address' -> 'locality',\n    raw -> 'address' -> 'croft'\n  )::text)\n  FROM addresses\n  WHERE a.id = id\n) WHERE\n  raw -> 'address' -> 'village' IS NOT NULL OR\n  raw -> 'address' -> 'hamlet' IS NOT NULL OR\n  raw -> 'address' -> 'locality' IS NOT NULL OR\n  raw -> 'address' -> 'croft' IS NOT NULL;\n"
docker-teslamate-1  | 2023-08-31 12:24:43.337 [info] == Migrated 20200306130218 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.351 [info] == Running 20200306133847 TeslaMate.Repo.Migrations.AddFlatFee.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.352 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:43.356 [info] == Migrated 20200306133847 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.372 [info] == Running 20200318164021 TeslaMate.Repo.Migrations.UseStreamingApi.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.374 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:43.377 [info] == Migrated 20200318164021 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.387 [info] == Running 20200320140020 TeslaMate.Repo.Migrations.DropPowerAvg.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.388 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:43.393 [info] == Migrated 20200320140020 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.405 [info] == Running 20200401170940 TeslaMate.Repo.Migrations.RemoveSleepModeToggles.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.406 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:43.409 [info] drop table geofence_sleep_mode_whitelist
docker-teslamate-1  | 2023-08-31 12:24:43.414 [info] drop table geofence_sleep_mode_blacklist
docker-teslamate-1  | 2023-08-31 12:24:43.421 [info] == Migrated 20200401170940 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.437 [info] == Running 20200401171402 TeslaMate.Repo.Migrations.RemoveSleepModeRequirements.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.438 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:43.443 [info] == Migrated 20200401171402 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.456 [info] == Running 20200401171923 TeslaMate.Repo.Migrations.EnableStreaming.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.468 [info] == Migrated 20200401171923 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:43.482 [info] == Running 20200410112005 TeslaMate.Repo.Migrations.DatabaseEfficiencyImprovements.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:43.485 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:43.569 [info] alter table addresses
docker-teslamate-1  | 2023-08-31 12:24:43.618 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:43.685 [info] alter table drives
docker-teslamate-1  | 2023-08-31 12:24:43.787 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:43.820 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:43.894 [info] alter table charges
docker-teslamate-1  | 2023-08-31 12:24:43.938 [info] alter table states
docker-teslamate-1  | 2023-08-31 12:24:43.972 [info] alter table tokens
docker-teslamate-1  | 2023-08-31 12:24:43.997 [info] alter table updates
docker-teslamate-1  | 2023-08-31 12:24:44.025 [info] == Migrated 20200410112005 in 0.5s
docker-teslamate-1  | 2023-08-31 12:24:44.058 [info] == Running 20200502140646 TeslaMate.Repo.Migrations.DropUnusedIndexes.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.059 [info] drop index if exists positions_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:44.064 [info] drop index if exists addresses_ll_to_earth_latitude__longitude_index
docker-teslamate-1  | 2023-08-31 12:24:44.067 [info] == Migrated 20200502140646 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.087 [info] == Running 20200528163852 TeslaMate.Repo.Migrations.CostByMinute.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.088 [info] execute "CREATE TYPE billing_type AS ENUM ('per_kwh', 'per_minute')"
docker-teslamate-1  | 2023-08-31 12:24:44.091 [info] alter table geofences
docker-teslamate-1  | 2023-08-31 12:24:44.095 [info] rename column cost_per_kwh to cost_per_unit on table geofences
docker-teslamate-1  | 2023-08-31 12:24:44.097 [info] == Migrated 20200528163852 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.112 [info] == Running 20200528173223 TeslaMate.Repo.Migrations.RenameUnitEnums.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.113 [info] execute "ALTER TYPE length RENAME TO unit_of_length"
docker-teslamate-1  | 2023-08-31 12:24:44.116 [info] execute "ALTER TYPE temperature RENAME TO unit_of_temperature"
docker-teslamate-1  | 2023-08-31 12:24:44.118 [info] == Migrated 20200528173223 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.130 [info] == Running 20200528175158 TeslaMate.Repo.Migrations.OptimizeConversionHelpers.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.135 [info] execute "DROP FUNCTION IF EXISTS public.convert_km(double precision, text);"
docker-teslamate-1  | 2023-08-31 12:24:44.139 [info] execute "CREATE OR REPLACE FUNCTION public.convert_km(n numeric(6,2), unit text)\nRETURNS numeric(6,2)\nLANGUAGE 'sql'\nCOST 100\nVOLATILE\nAS $BODY$\n  SELECT\n  CASE $2 WHEN 'km' THEN $1\n          WHEN 'mi' THEN $1 / 1.60934\n  END;\n$BODY$;\n"
docker-teslamate-1  | 2023-08-31 12:24:44.147 [info] execute "DROP FUNCTION IF EXISTS public.convert_celsius(double precision, text);"
docker-teslamate-1  | 2023-08-31 12:24:44.150 [info] execute "CREATE OR REPLACE FUNCTION public.convert_celsius(n numeric(4,1), unit text)\nRETURNS numeric(4,1)\nLANGUAGE 'sql'\nCOST 100\nVOLATILE\nAS $BODY$\n  SELECT\n  CASE $2 WHEN 'C' THEN $1\n          WHEN 'F' THEN ($1 * 9 / 5) + 32\n  END;\n$BODY$;\n"
docker-teslamate-1  | 2023-08-31 12:24:44.159 [info] == Migrated 20200528175158 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.168 [info] == Running 20200709165119 TeslaMate.Repo.Migrations.ChangeSleepRequirementsDefault.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.170 [info] alter table car_settings
docker-teslamate-1  | 2023-08-31 12:24:44.177 [info] == Migrated 20200709165119 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.190 [info] == Running 20210130174838 TeslaMate.Repo.Migrations.UseVariableLengthTypeForTokens.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.191 [info] alter table tokens
docker-teslamate-1  | 2023-08-31 12:24:44.195 [info] == Migrated 20210130174838 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.206 [info] == Running 20210812173700 TeslaMate.Repo.Migrations.CarPriorities.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.207 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:44.214 [info] == Migrated 20210812173700 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.228 [info] == Running 20210831153305 TeslaMate.Repo.Migrations.AddNotNullConstraintToDisplayPriority.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.230 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:44.234 [info] == Migrated 20210831153305 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.249 [info] == Running 20211022103654 TeslaMate.Repo.Migrations.AddNotNullConstraintToStartDate.up/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.250 [info] alter table charging_processes
docker-teslamate-1  | 2023-08-31 12:24:44.254 [info] == Migrated 20211022103654 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.266 [info] == Running 20220123131732 TeslaMate.Repo.Migrations.EncryptApiTokens.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.267 [info] alter table tokens
docker-teslamate-1  | 2023-08-31 12:24:44.275 [info] alter table tokens
docker-teslamate-1  | 2023-08-31 12:24:44.282 [info] rename column encrypted_access to access on table tokens
docker-teslamate-1  | 2023-08-31 12:24:44.285 [info] rename column encrypted_refresh to refresh on table tokens
docker-teslamate-1  | 2023-08-31 12:24:44.290 [info] == Migrated 20220123131732 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.302 [info] == Running 20220422132017 TeslaMate.Repo.Migrations.AddMarketingNameToCar.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.304 [info] alter table cars
docker-teslamate-1  | 2023-08-31 12:24:44.308 [info] == Migrated 20220422132017 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.321 [info] == Running 20220617170400 TeslaMate.Repo.Migrations.AddTirePressures.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.322 [info] alter table positions
docker-teslamate-1  | 2023-08-31 12:24:44.326 [info] execute "CREATE OR REPLACE FUNCTION public.convert_tire_pressure(n numeric(6,2), character varying)\nRETURNS numeric(6,2)\nLANGUAGE 'sql'\nCOST 100\nVOLATILE\nAS $BODY$\nSELECT\nCASE $2 WHEN 'bar' THEN $1\n    WHEN 'psi' THEN $1 * 14.503773773\nEND;\n$BODY$;\n"
docker-teslamate-1  | 2023-08-31 12:24:44.331 [info] == Migrated 20220617170400 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.342 [info] == Running 20220718085412 TeslaMate.Repo.Migrations.AddUnitOfPressureToGlobalSettings.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.343 [info] execute "CREATE TYPE unit_of_pressure AS ENUM ('bar', 'psi')"
docker-teslamate-1  | 2023-08-31 12:24:44.345 [info] alter table settings
docker-teslamate-1  | 2023-08-31 12:24:44.349 [info] == Migrated 20220718085412 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:44.361 [info] == Running 20230417225712 TeslaMate.Repo.Migrations.AddCompositeIndexToPositions.change/0 forward
docker-teslamate-1  | 2023-08-31 12:24:44.362 [info] create index positions_drive_id_date_index
docker-teslamate-1  | 2023-08-31 12:24:44.375 [info] drop index positions_drive_id_index
docker-teslamate-1  | 2023-08-31 12:24:44.378 [info] == Migrated 20230417225712 in 0.0s
docker-teslamate-1  | 2023-08-31 12:24:50.089 [info] System Info: Erlang/OTP 26 (emu)
docker-teslamate-1  | 2023-08-31 12:24:50.089 [info] Version: 1.27.3
docker-teslamate-1  | 2023-08-31 12:24:50.281 [info] Running TeslaMateWeb.Endpoint with cowboy 2.10.0 at :::4000 (http)
docker-teslamate-1  | 2023-08-31 12:24:50.284 [info] Access TeslaMateWeb.Endpoint at http://localhost
docker-teslamate-1  | 2023-08-31 12:24:50.305 [info] MQTT connection has been established
docker-teslamate-1  | 2023-08-31 12:24:53.628 [info] tzdata release in place is from a file last modified Fri, 22 Oct 2021 02:20:47 GMT. Release file on server was last modified Tue, 28 Mar 2023 20:25:39 GMT.
docker-teslamate-1  | 2023-08-31 12:24:57.213 [info] Tzdata has updated the release from 2021e to 2023c
docker-teslamate-1  | 2023-08-31 12:26:20.656 [info] GET /
docker-teslamate-1  | 2023-08-31 12:26:20.840 [info] Sent 302 in 180ms
docker-teslamate-1  | 2023-08-31 12:26:21.005 [info] GET /sign_in
docker-teslamate-1  | 2023-08-31 12:26:21.071 [info] Sent 200 in 66ms
docker-teslamate-1  | 2023-08-31 12:28:22.099 [info] POST https://auth.tesla.com/oauth2/v3/token -> 200 (2140.017 ms)
docker-teslamate-1  | 2023-08-31 12:28:22.292 [info] Scheduling token refresh in 6 h
docker-teslamate-1  | 2023-08-31 12:28:22.487 [info] Starting logger for 'The Beast'
docker-teslamate-1  | 2023-08-31 12:28:22.620 car_id=1 [info] Start / :asleep
docker-teslamate-1  | 2023-08-31 12:28:23.961 [info] GET /
docker-teslamate-1  | 2023-08-31 12:28:23.992 [info] Sent 200 in 31ms
docker-teslamate-1  | 2023-08-31 12:28:39.589 [info] GET /settings
docker-teslamate-1  | 2023-08-31 12:28:40.171 [info] Sent 200 in 570ms
docker-teslamate-1  | 2023-08-31 12:29:01.871 [info] GET /
docker-teslamate-1  | 2023-08-31 12:29:01.981 [info] Sent 200 in 93ms
docker-teslamate-1  | 2023-08-31 12:38:09.324 [info] GET /
docker-teslamate-1  | 2023-08-31 12:38:09.474 [info] Sent 200 in 141ms
docker-teslamate-1  | 2023-08-31 12:47:06.222 [info] GET /
docker-teslamate-1  | 2023-08-31 12:47:06.250 [info] Sent 200 in 27ms
docker-teslamate-1  | 2023-08-31 12:47:12.295 [info] GET /settings
docker-teslamate-1  | 2023-08-31 12:47:12.338 [info] Sent 200 in 42ms
docker-teslamate-1  | 2023-08-31 12:47:49.533 [info] GET /
docker-teslamate-1  | 2023-08-31 12:47:49.551 [info] Sent 200 in 17ms
docker-teslamate-1  | 2023-08-31 12:47:51.914 [info] GET /
docker-teslamate-1  | 2023-08-31 12:47:51.921 [info] Sent 200 in 6ms
docker-teslamate-1  | 2023-08-31 12:48:13.375 [info] GET /geo-fences
docker-teslamate-1  | 2023-08-31 12:48:13.397 [info] Sent 200 in 21ms
docker-teslamate-1  | 2023-08-31 12:48:25.429 [info] GET /
docker-teslamate-1  | 2023-08-31 12:48:25.448 [info] Sent 200 in 19ms
docker-teslamate-1  | 2023-08-31 12:53:39.666 car_id=1 [info] Start / :online
docker-teslamate-1  | 2023-08-31 12:53:39.781 car_id=1 [info] Connecting ...
docker-teslamate-1  | 2023-08-31 12:53:39.783 [info] Start of drive initiated by: %TeslaApi.Vehicle.State.Drive{gps_as_of: 1693486418, heading: 221, latitude: 53.573981, longitude: -2.877046, native_latitude: 53.573981, native_location_supported: 1, native_longitude: -2.877046, native_type: "wgs", power: 21, shift_state: "D", speed: 15, timestamp: 1693486420142}
docker-teslamate-1  | 2023-08-31 12:53:39.783 car_id=1 [info] Driving / Start
docker-teslamate-1  | 2023-08-31 13:12:16.060 [info] GET https://owner-api.teslamotors.com/api/1/vehicles/930113316662945/vehicle_data -> 408 (9087.558 ms)
docker-teslamate-1  | 2023-08-31 13:12:16.061 [warning] TeslaApi.Error / %{"error" => "{\"error\": \"timeout\"}", "error_description" => "", "response" => nil}
docker-teslamate-1  | 2023-08-31 13:12:16.061 car_id=1 [error] Error / :unknown
docker-teslamate-1  | 2023-08-31 13:13:40.897 [info] GET https://nominatim.openstreetmap.org/reverse -> 200 (644.087 ms)
docker-teslamate-1  | 2023-08-31 13:13:40.976 [info] GET https://nominatim.openstreetmap.org/reverse -> 200 (53.295 ms)
docker-teslamate-1  | 2023-08-31 13:13:41.009 [info] End of drive initiated by: %TeslaApi.Vehicle.State.Drive{gps_as_of: 1693487618, heading: 214, latitude: 53.572091, longitude: -2.879732, native_latitude: 53.572091, native_location_supported: 1, native_longitude: -2.879732, native_type: "wgs", power: 1, shift_state: "P", speed: 0, timestamp: 1693487620101}
docker-teslamate-1  | 2023-08-31 13:13:41.011 car_id=1 [info] Driving / Ended / 4 km – 20 min
docker-teslamate-1  | 2023-08-31 13:13:41.011 car_id=1 [info] Start / :online
docker-teslamate-1  | 2023-08-31 13:16:59.558 car_id=1 [info] Suspending logging
docker-teslamate-1  | 2023-08-31 13:21:57.264 [info] Start of drive initiated by: %TeslaApi.Stream.Data{time: ~U[2023-08-31 13:21:57.210Z], speed: 0, odometer: 26571.8, soc: 55, elevation: 41, est_heading: 214, est_lat: 53.572091, est_lng: -2.879732, power: 1, shift_state: "R", range: 186, est_range: 183, heading: 210}
docker-teslamate-1  | 2023-08-31 13:21:57.264 car_id=1 [info] Driving / Start
docker-teslamate-1  | 2023-08-31 13:23:36.391 [info] GET https://nominatim.openstreetmap.org/reverse -> 200 (191.971 ms)
docker-teslamate-1  | 2023-08-31 13:23:36.891 [info] GET https://nominatim.openstreetmap.org/reverse -> 200 (491.322 ms)
docker-teslamate-1  | 2023-08-31 13:23:36.925 [info] End of drive initiated by: %TeslaApi.Vehicle.State.Drive{gps_as_of: 1693488213, heading: 140, latitude: 53.573976, longitude: -2.876879, native_latitude: 53.573976, native_location_supported: 1, native_longitude: -2.876879, native_type: "wgs", power: 1, shift_state: "P", speed: 0, timestamp: 1693488216054}
docker-teslamate-1  | 2023-08-31 13:23:36.925 car_id=1 [info] Driving / Ended / 1 km – 2 min
docker-teslamate-1  | 2023-08-31 13:23:36.925 car_id=1 [info] Start / :online
docker-teslamate-1  | 2023-08-31 13:26:54.668 car_id=1 [warning] Unlocked ...
docker-teslamate-1  | 2023-08-31 13:27:24.978 car_id=1 [warning] Unlocked ...
docker-teslamate-1  | 2023-08-31 13:27:55.703 car_id=1 [info] Suspending logging
docker-teslamate-1  | 2023-08-31 13:40:29.917 car_id=1 [info] Fetching vehicle state ...
docker-teslamate-1  | 2023-08-31 13:40:29.962 [error] GET https://owner-api.teslamotors.com/api/1/vehicles/930113316662945 -> error: "socket closed" (42.657 ms)
docker-teslamate-1  | 2023-08-31 13:40:29.962 [warning] TeslaApi.Error / socket closed
docker-teslamate-1  | 2023-08-31 13:40:29.963 car_id=1 [info] Unhandled fetch result: {:error, :unknown}
docker-teslamate-1  | 2023-08-31 13:45:32.148 car_id=1 [info] Fetching vehicle state ...
docker-teslamate-1  | 2023-08-31 13:45:32.481 car_id=1 [info] Start / :asleep
docker-teslamate-1  | 2023-08-31 13:45:32.495 car_id=1 [info] Disconnecting ...
docker-teslamate-1  | 2023-08-31 13:59:15.369 car_id=1 [info] Start / :online
docker-teslamate-1  | 2023-08-31 13:59:15.407 car_id=1 [info] Connecting ...
docker-teslamate-1  | 2023-08-31 14:00:08.267 [info] GET /
docker-teslamate-1  | 2023-08-31 14:00:08.276 [info] Sent 200 in 8ms
docker-teslamate-1  | 2023-08-31 14:00:55.330 car_id=1 [info] Suspending logging [Triggered manually]
docker-teslamate-1  | 2023-08-31 14:08:45.393 [info] GET /settings
docker-teslamate-1  | 2023-08-31 14:08:45.471 [info] Sent 200 in 73ms
docker-teslamate-1  | 2023-08-31 14:12:42.515 [info] GET /
docker-teslamate-1  | 2023-08-31 14:12:42.548 [info] Sent 200 in 31ms
docker-teslamate-1  | 2023-08-31 14:12:53.648 car_id=1 [info] Fetching vehicle state ...
docker-teslamate-1  | 2023-08-31 14:12:53.710 [error] GET https://owner-api.teslamotors.com/api/1/vehicles/930113316662945 -> error: "socket closed" (51.418 ms)
docker-teslamate-1  | 2023-08-31 14:12:53.711 [warning] TeslaApi.Error / socket closed
docker-teslamate-1  | 2023-08-31 14:12:53.711 car_id=1 [info] Unhandled fetch result: {:error, :unknown}
docker-teslamate-1  | 2023-08-31 14:17:56.171 car_id=1 [info] Fetching vehicle state ...
docker-teslamate-1  | 2023-08-31 14:17:56.739 car_id=1 [info] Start / :asleep
docker-teslamate-1  | 2023-08-31 14:17:56.820 car_id=1 [info] Disconnecting ...
docker-teslamate-1  | 2023-08-31 14:59:03.156 [info] Migrations already up
docker-teslamate-1  | 2023-08-31 14:59:08.178 [info] System Info: Erlang/OTP 26 (emu)
docker-teslamate-1  | 2023-08-31 14:59:08.178 [info] Version: 1.27.3
docker-teslamate-1  | 2023-08-31 14:59:09.101 [info] POST https://auth.tesla.com/oauth2/v3/token -> 200 (627.670 ms)
docker-teslamate-1  | 2023-08-31 14:59:09.102 [info] Refreshed api tokens
docker-teslamate-1  | 2023-08-31 14:59:09.148 [info] Scheduling token refresh in 6 h
docker-teslamate-1  | 2023-08-31 14:59:09.157 [info] Running TeslaMateWeb.Endpoint with cowboy 2.10.0 at :::4000 (http)
docker-teslamate-1  | 2023-08-31 14:59:09.178 [info] Access TeslaMateWeb.Endpoint at http://localhost
docker-teslamate-1  | 2023-08-31 14:59:09.288 [info] GET /
docker-teslamate-1  | 2023-08-31 14:59:09.425 [info] Starting logger for 'The Beast'
docker-teslamate-1  | 2023-08-31 14:59:09.460 [info] Sent 200 in 172ms
docker-teslamate-1  | 2023-08-31 14:59:09.462 [info] MQTT connection has been established
docker-teslamate-1  | 2023-08-31 14:59:09.803 car_id=1 [info] Start / :asleep
docker-teslamate-1  | 2023-08-31 15:05:48.954 [info] GET /
docker-teslamate-1  | 2023-08-31 15:05:49.024 [info] Sent 200 in 66ms

Screenshots

Screenshot 2023-08-31 at 15 08 21

Additional data

No response

Type of installation

Docker

Version

v1.27.3

DrMichael commented 1 year ago

What says the database log? docker-compse -l database

ID-Ant commented 1 year ago

bash: docker-compse: command not found

seemingly I've not installed something correctly? created the docker-composer.yaml file and ran docker.

DrMichael commented 1 year ago

Try docker compose -l database

ID-Ant commented 1 year ago

unknown shorthand flag: 'l' in -l

DrMichael commented 1 year ago

Not sure, how it goes with docker compose. Perhaps you can install docker-compose?

ID-Ant commented 1 year ago 
docker compose version
Docker Compose version v2.20.2

So seemingly installed, correctly or not is a different story i guess? not sure how to verify the postgres DB is running correctly. I can see it when running docker ps - 023d442aac83 postgres:15 "docker-entrypoint.s…" 3 hours ago Up 3 hours 5432/tcp docker-database-1

DrMichael commented 1 year ago

https://docs.docker.com/engine/reference/commandline/logs might help... docker logs --follow <container id of database>

ID-Ant commented 1 year ago

thanks for that! nothing obvious to me in this thought :(

`The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....2023-08-31 12:24:22.493 UTC [48] LOG:  starting PostgreSQL 15.4 (Debian 15.4-1.pgdg120+1) on arm-unknown-linux-gnueabihf, compiled by gcc (Debian 12.2.0-14) 12.2.0, 32-bit
2023-08-31 12:24:22.507 UTC [48] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-08-31 12:24:22.544 UTC [51] LOG:  database system was shut down at 2023-08-31 12:24:17 UTC
2023-08-31 12:24:22.567 UTC [48] LOG:  database system is ready to accept connections
 done
server started
CREATE DATABASE

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

2023-08-31 12:24:23.725 UTC [48] LOG:  received fast shutdown request
waiting for server to shut down....2023-08-31 12:24:23.837 UTC [48] LOG:  aborting any active transactions
2023-08-31 12:24:23.844 UTC [48] LOG:  background worker "logical replication launcher" (PID 54) exited with exit code 1
2023-08-31 12:24:23.845 UTC [49] LOG:  shutting down
2023-08-31 12:24:23.851 UTC [49] LOG:  checkpoint starting: shutdown immediate
2023-08-31 12:24:24.273 UTC [49] LOG:  checkpoint complete: wrote 918 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.119 s, sync=0.270 s, total=0.428 s; sync files=301, longest=0.263 s, average=0.001 s; distance=4223 kB, estimate=4223 kB
2023-08-31 12:24:24.297 UTC [48] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2023-08-31 12:24:24.447 UTC [1] LOG:  starting PostgreSQL 15.4 (Debian 15.4-1.pgdg120+1) on arm-unknown-linux-gnueabihf, compiled by gcc (Debian 12.2.0-14) 12.2.0, 32-bit
2023-08-31 12:24:24.449 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-08-31 12:24:24.450 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2023-08-31 12:24:24.460 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-08-31 12:24:24.483 UTC [64] LOG:  database system was shut down at 2023-08-31 12:24:24 UTC
2023-08-31 12:24:24.506 UTC [1] LOG:  database system is ready to accept connections
2023-08-31 12:29:24.580 UTC [62] LOG:  checkpoint starting: time
2023-08-31 12:30:00.637 UTC [62] LOG:  checkpoint complete: wrote 360 buffers (2.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=35.953 s, sync=0.019 s, total=36.057 s; sync files=276, longest=0.012 s, average=0.001 s; distance=2368 kB, estimate=2368 kB
2023-08-31 12:49:25.011 UTC [62] LOG:  checkpoint starting: time
2023-08-31 12:49:25.460 UTC [62] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.409 s, sync=0.011 s, total=0.450 s; sync files=5, longest=0.008 s, average=0.003 s; distance=1 kB, estimate=2131 kB
2023-08-31 12:54:25.559 UTC [62] LOG:  checkpoint starting: time
2023-08-31 12:54:32.693 UTC [62] LOG:  checkpoint complete: wrote 71 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.044 s, sync=0.042 s, total=7.134 s; sync files=40, longest=0.026 s, average=0.002 s; distance=117 kB, estimate=1930 kB
2023-08-31 12:59:25.794 UTC [62] LOG:  checkpoint starting: time
2023-08-31 12:59:36.061 UTC [62] LOG:  checkpoint complete: wrote 93 buffers (0.6%); 1 WAL file(s) added, 0 removed, 0 recycled; write=9.233 s, sync=0.032 s, total=10.268 s; sync files=15, longest=0.019 s, average=0.003 s; distance=576 kB, estimate=1795 kB
2023-08-31 13:04:25.081 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:04:34.156 UTC [62] LOG:  checkpoint complete: wrote 92 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.030 s, sync=0.026 s, total=9.076 s; sync files=14, longest=0.024 s, average=0.002 s; distance=382 kB, estimate=1653 kB
2023-08-31 13:09:25.257 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:09:29.822 UTC [62] LOG:  checkpoint complete: wrote 46 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.523 s, sync=0.021 s, total=4.566 s; sync files=12, longest=0.019 s, average=0.002 s; distance=294 kB, estimate=1517 kB
2023-08-31 13:14:25.870 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:14:34.167 UTC [62] LOG:  checkpoint complete: wrote 83 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.235 s, sync=0.040 s, total=8.298 s; sync files=31, longest=0.039 s, average=0.002 s; distance=537 kB, estimate=1419 kB
2023-08-31 13:19:25.190 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:19:25.941 UTC [62] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.709 s, sync=0.021 s, total=0.752 s; sync files=8, longest=0.019 s, average=0.003 s; distance=23 kB, estimate=1280 kB
2023-08-31 13:24:26.020 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:24:31.990 UTC [62] LOG:  checkpoint complete: wrote 60 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.924 s, sync=0.026 s, total=5.970 s; sync files=24, longest=0.025 s, average=0.002 s; distance=330 kB, estimate=1185 kB
2023-08-31 13:29:27.034 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:29:27.886 UTC [62] LOG:  checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.809 s, sync=0.019 s, total=0.853 s; sync files=9, longest=0.015 s, average=0.003 s; distance=20 kB, estimate=1068 kB
2023-08-31 13:49:28.233 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:49:28.894 UTC [62] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.609 s, sync=0.013 s, total=0.661 s; sync files=7, longest=0.011 s, average=0.002 s; distance=1 kB, estimate=962 kB
2023-08-31 13:59:29.095 UTC [62] LOG:  checkpoint starting: time
2023-08-31 13:59:30.344 UTC [62] LOG:  checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.208 s, sync=0.021 s, total=1.250 s; sync files=13, longest=0.020 s, average=0.002 s; distance=20 kB, estimate=867 kB
2023-08-31 14:04:29.346 UTC [62] LOG:  checkpoint starting: time
2023-08-31 14:04:30.175 UTC [62] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.727 s, sync=0.039 s, total=0.830 s; sync files=8, longest=0.037 s, average=0.005 s; distance=19 kB, estimate=783 kB
2023-08-31 14:19:29.395 UTC [62] LOG:  checkpoint starting: time
2023-08-31 14:19:30.076 UTC [62] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.614 s, sync=0.015 s, total=0.682 s; sync files=7, longest=0.013 s, average=0.003 s; distance=2 kB, estimate=704 kB
2023-08-31 14:59:29.663 UTC [62] LOG:  checkpoint starting: time
2023-08-31 14:59:30.637 UTC [62] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.635 s, sync=0.035 s, total=1.060 s; sync files=5, longest=0.027 s, average=0.007 s; distance=4 kB, estimate=634 kB
`
ID-Ant commented 1 year ago

https://github.com/adriankumpf/teslamate/discussions/2773 for future references - the trailing space in the docker-compose.yml breaks things