Teslamate: Teslamate not running on Synology DS713+

Created on 28 May 2020  路  16Comments  路  Source: adriankumpf/teslamate

Describe the bug

After following the below guide on a DS713+ (with 2GB RAM) :
https://github.com/adriankumpf/teslamate/issues/113
Grafana on port 3000 is working fine, but Teslamate on port 4000 is not responding.
It works fine on both Raspberry Pis on which i installed it.

Expected behavior

when typing http://MyIP:4000, I should get the page to enter my Tesla credentials

How to reproduce it (as minimally and precisely as possible):

  1. Follow Synology install guide (with current docker-composer.yml)
  2. open http://MyIP:4000

Relevant entries from the logs

Database_1 Logs :

date | stream | content
-- | -- | --
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.732聽UTC聽[1]聽LOG:聽聽database聽system聽is聽ready聽to聽accept聽connections
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.709聽UTC聽[63]聽LOG:聽聽database聽system聽was聽shut聽down聽at聽2020-05-28聽07:45:30聽UTC
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.649聽UTC聽[1]聽LOG:聽聽listening聽on聽Unix聽socket聽"/var/run/postgresql/.s.PGSQL.5432"
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.641聽UTC聽[1]聽LOG:聽聽listening聽on聽IPv6聽address聽"::",聽port聽5432
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.641聽UTC聽[1]聽LOG:聽聽listening聽on聽IPv4聽address聽"0.0.0.0",聽port聽5432
2020-05-28聽07:45:30 | stderr | 2020-05-28聽07:45:30.640聽UTC聽[1]聽LOG:聽聽starting聽PostgreSQL聽12.3聽(Debian聽12.3-1.pgdg100+1)聽on聽x86_64-pc-linux-gnu,聽compiled聽by聽gcc聽(Debian聽8.3.0-6)聽8.3.0,聽64-bit
2020-05-28聽07:45:30 | stdout | 聽
2020-05-28聽07:45:30 | stdout | PostgreSQL聽init聽process聽complete;聽ready聽for聽start聽up.
2020-05-28聽07:45:30 | stdout | 聽
2020-05-28聽07:45:30 | stdout | server聽stopped
2020-05-28聽07:45:30 | stdout | done
2020-05-28聽07:45:30 | stdout | 2020-05-28聽07:45:30.473聽UTC聽[45]聽LOG:聽聽database聽system聽is聽shut聽down
2020-05-28聽07:45:30 | stdout | 2020-05-28聽07:45:30.369聽UTC聽[47]聽LOG:聽聽shutting聽down
2020-05-28聽07:45:30 | stdout | 2020-05-28聽07:45:30.368聽UTC聽[45]聽LOG:聽聽background聽worker聽"logical聽replication聽launcher"聽(PID聽52)聽exited聽with聽exit聽code聽1
2020-05-28聽07:45:30 | stdout | waiting聽for聽server聽to聽shut聽down....2020-05-28聽07:45:30.360聽UTC聽[45]聽LOG:聽聽aborting聽any聽active聽transactions
2020-05-28聽07:45:30 | stdout | 2020-05-28聽07:45:30.355聽UTC聽[45]聽LOG:聽聽received聽fast聽shutdown聽request
2020-05-28聽07:45:30 | stdout | 聽
2020-05-28聽07:45:30 | stdout | /usr/local/bin/docker-entrypoint.sh:聽ignoring聽/docker-entrypoint-initdb.d/*
2020-05-28聽07:45:30 | stdout | 聽
2020-05-28聽07:45:30 | stdout | 聽
2020-05-28聽07:45:30 | stdout | CREATE聽DATABASE
2020-05-28聽07:45:28 | stdout | server聽started
2020-05-28聽07:45:28 | stdout | done
2020-05-28聽07:45:28 | stdout | 2020-05-28聽07:45:28.895聽UTC聽[45]聽LOG:聽聽database聽system聽is聽ready聽to聽accept聽connections
2020-05-28聽07:45:28 | stdout | 2020-05-28聽07:45:28.859聽UTC聽[46]聽LOG:聽聽database聽system聽was聽shut聽down聽at聽2020-05-28聽07:45:26聽UTC
2020-05-28聽07:45:28 | stdout | 2020-05-28聽07:45:28.600聽UTC聽[45]聽LOG:聽聽listening聽on聽Unix聽socket聽"/var/run/postgresql/.s.PGSQL.5432"
2020-05-28聽07:45:28 | stdout | waiting聽for聽server聽to聽start....2020-05-28聽07:45:28.583聽UTC聽[45]聽LOG:聽聽starting聽PostgreSQL聽12.3聽(Debian聽12.3-1.pgdg100+1)聽on聽x86_64-pc-linux-gnu,聽compiled聽by聽gcc聽(Debian聽8.3.0-6)聽8.3.0,聽64-bit
2020-05-28聽07:45:28 | stderr | --auth-local聽and聽--auth-host,聽the聽next聽time聽you聽run聽initdb.
2020-05-28聽07:45:28 | stderr | You聽can聽change聽this聽by聽editing聽pg_hba.conf聽or聽using聽the聽option聽-A,聽or
2020-05-28聽07:45:28 | stderr | initdb:聽warning:聽enabling聽"trust"聽authentication聽for聽local聽connections
2020-05-28聽07:45:28 | stdout | 聽
2020-05-28聽07:45:28 | stdout | pg_ctl聽-D聽/var/lib/postgresql/data聽-l聽logfile聽start
2020-05-28聽07:45:28 | stdout | 聽
2020-05-28聽07:45:28 | stdout | Success.聽You聽can聽now聽start聽the聽database聽server聽using:
2020-05-28聽07:45:28 | stdout | 聽
2020-05-28聽07:45:28 | stdout | 聽
2020-05-28聽07:45:28 | stdout | syncing聽data聽to聽disk聽...聽ok
2020-05-28聽07:45:26 | stdout | performing聽post-bootstrap聽initialization聽...聽ok
2020-05-28聽07:45:21 | stdout | running聽bootstrap聽script聽...聽ok
2020-05-28聽07:45:20 | stdout | creating聽configuration聽files聽...聽ok
2020-05-28聽07:45:20 | stdout | selecting聽default聽time聽zone聽...聽Etc/UTC
2020-05-28聽07:45:20 | stdout | selecting聽default聽shared_buffers聽...聽128MB
2020-05-28聽07:45:20 | stdout | selecting聽default聽max_connections聽...聽100
2020-05-28聽07:45:19 | stdout | selecting聽dynamic聽shared聽memory聽implementation聽...聽posix
2020-05-28聽07:45:19 | stdout | creating聽subdirectories聽...聽ok
2020-05-28聽07:45:19 | stdout | fixing聽permissions聽on聽existing聽directory聽/var/lib/postgresql/data聽...聽ok
2020-05-28聽07:45:19 | stdout | 聽
2020-05-28聽07:45:19 | stdout | Data聽page聽checksums聽are聽disabled.
2020-05-28聽07:45:19 | stdout | 聽
2020-05-28聽07:45:19 | stdout | The聽default聽text聽search聽configuration聽will聽be聽set聽to聽"english".
2020-05-28聽07:45:19 | stdout | The聽default聽database聽encoding聽has聽accordingly聽been聽set聽to聽"UTF8".
2020-05-28聽07:45:19 | stdout | The聽database聽cluster聽will聽be聽initialized聽with聽locale聽"en_US.utf8".
2020-05-28聽07:45:19 | stdout | 聽
2020-05-28聽07:45:19 | stdout | This聽user聽must聽also聽own聽the聽server聽process.
2020-05-28聽07:45:19 | stdout | The聽files聽belonging聽to聽this聽database聽system聽will聽be聽owned聽by聽user聽"postgres".

Teslamate_1 Logs :

2020-05-28聽08:21:25 | stdout | waiting聽for聽postgres聽at聽database:5432聽(1024sec)
2020-05-28聽08:10:45 | stdout | waiting聽for聽postgres聽at聽database:5432聽(512sec)
2020-05-28聽08:04:22 | stdout | waiting聽for聽postgres聽at聽database:5432聽(256sec)
2020-05-28聽08:00:07 | stdout | waiting聽for聽postgres聽at聽database:5432聽(128sec)
2020-05-28聽07:56:56 | stdout | waiting聽for聽postgres聽at聽database:5432聽(64sec)
2020-05-28聽07:54:16 | stdout | waiting聽for聽postgres聽at聽database:5432聽(32sec)
2020-05-28聽07:51:53 | stdout | waiting聽for聽postgres聽at聽database:5432聽(16sec)
2020-05-28聽07:49:38 | stdout | waiting聽for聽postgres聽at聽database:5432聽(8sec)
2020-05-28聽07:47:27 | stdout | waiting聽for聽postgres聽at聽database:5432聽(4sec)
2020-05-28聽07:45:17 | stdout | waiting聽for聽postgres聽at聽database:5432聽(2sec)

Screenshots

Screen recording of the install on a fresh Docker (after having completely deleted and reinstalled the docker package)
https://www.youtube.com/watch?v=sGRL6A-bSZQ

Environment

  • TeslaMate version: 1.19.3 - 2020-05-03
  • Type of installation: Docker
  • OS TeslaMate is installed on: Synology Disk Station on DS713+ with 2MB RAM
  • User OS & Browser: Windows / Chrome
  • Others:
Stale question
Source
picture Benn

Most helpful comment

Yes, it apparently did manage to run the initial migrations, but initialization of teslamate itself failed. You could try setting DATABASE_POOL_SIZE: 20 in environment section of the teslamate containing in docker-compose.yml (where MQTT_HOST is set) but I don't know if that will help.

picture dyxyl on 18 Jun 2020
👍2

All 16 comments

Which version of Docker do you have?

dyxyl picture dyxyl on 7 Jun 2020

Docker聽version聽18.09.8,聽build聽bfed4f5

聽

Benn picture Benn on 8 Jun 2020

It could be another broken version of the Docker package.

What is the output of the following two commands after starting the containers and waiting a while?

docker-compose exec teslamate nc -vvz -w 5 database 5432

docker-compose config

Even though it is a different problem, you could also try to downgrade Docker (see https://github.com/adriankumpf/teslamate/issues/108#issuecomment-526623459).

dyxyl picture dyxyl on 9 Jun 2020
👍1

I am on the same version on Synology and this is working OK.

From what I could gather from your video the only difference I caught was the explicit IP but it was too quick so I might be wrong. Here is my docker compose file if it helps.

version: '3'
services:
  teslamate:
    image: teslamate/teslamate:latest
    restart: always
    environment:
      - DATABASE_USER=teslamate
      - DATABASE_PASS=retracted
      - DATABASE_NAME=teslamate
      - DATABASE_HOST=database
      - MQTT_HOST=mosquitto
      - VIRTUAL_HOST=192.168.10.2
      - TZ=America/Los_Angeles # (optional) replace to use local time in debug logs. See "Configuration".
    ports:
      - 4000:4000
    cap_drop:
      - all

  database:
    image: postgres:12
    restart: always
    environment:
      - POSTGRES_USER=teslamate
      - POSTGRES_PASSWORD=teslamate
      - POSTGRES_DB=teslamate
    ports:
      - 6432:5432
    volumes:
      - teslamate-db:/var/lib/postgresql/data

  grafana:
    image: teslamate/grafana:latest
    restart: always
    environment:
      - DATABASE_USER=teslamate
      - DATABASE_PASS=teslamate
      - DATABASE_NAME=teslamate
      - DATABASE_HOST=database
    ports:
      - 4001:3000
    volumes:
      - teslamate-grafana-data:/var/lib/grafana

  mosquitto:
    image: eclipse-mosquitto:1.6
    restart: always
    ports:
      - 1883:1883
      - 9001:9001
    volumes:
      - mosquitto-conf:/mosquitto/config
      - mosquitto-data:/mosquitto/data

volumes:
    teslamate-db:
    teslamate-grafana-data:
    mosquitto-conf:
    mosquitto-data:
bahree picture bahree on 9 Jun 2020

Hi @dyxyl ,
The first comment returns

nc: database (172.18.0.4:5432): Operation timed out
sent 0, rcvd 0

The second one

^[[D^[[D^[[Dservices:
  database:
    environment:
      POSTGRES_DB: teslamate
      POSTGRES_PASSWORD: secret
      POSTGRES_USER: teslamate
    image: postgres:12
    restart: always
    volumes:
    - teslamate-db:/var/lib/postgresql/data:rw
  grafana:
    environment:
      DATABASE_HOST: database
      DATABASE_NAME: teslamate
      DATABASE_PASS: secret
      DATABASE_USER: teslamate
    image: teslamate/grafana:latest
    ports:
    - 3000:3000/tcp
    restart: always
    volumes:
    - teslamate-grafana-data:/var/lib/grafana:rw
  mosquitto:
    image: eclipse-mosquitto:1.6
    ports:
    - 1883:1883/tcp
    restart: always
    volumes:
    - mosquitto-conf:/mosquitto/config:rw
    - mosquitto-data:/mosquitto/data:rw
  teslamate:
    cap_drop:
    - all
    environment:
      DATABASE_HOST: database
      DATABASE_NAME: teslamate
      DATABASE_PASS: secret
      DATABASE_USER: teslamate
      MQTT_HOST: mosquitto
    image: teslamate/teslamate:latest
    ports:
    - 4000:4000/tcp
    restart: always
    volumes:
    - /volume1/@docker/import:/opt/app/import:rw
version: '3.0'
volumes:
  mosquitto-conf: {}
  mosquitto-data: {}
  teslamate-db: {}
  teslamate-grafana-data: {}
Benn picture Benn on 9 Jun 2020

I've also tried downgrading the docker version previously, no luck.
I've tried with your yml settings @bahree , no luck :(

Benn picture Benn on 10 Jun 2020

The config looks good, but Operation timed out suggests a firewall problem. Did it take roughly 5 seconds before it returned this error?

Some more commands to try (5433 is not a typo):

docker-compose exec teslamate nc -vvz -w 5 database 5433

docker-compose exec grafana nc -vvz -w 5 database 5432

iptables -L -v
dyxyl picture dyxyl on 10 Jun 2020
👍1

@dyxyl
Yes, it does take about 5 seconds.
Here are the results :

root@SynoFeB:/volume1/@docker# docker-compose exec teslamate nc -vvz -w 5 databa                                                                                        se 5433
nc: database (172.18.0.3:5433): Operation timed out
sent 0, rcvd 0
 5432SynoFeB:/volume1/@docker# docker-compose exec grafana nc -vvz -w 5 database
nc: database (172.18.0.3:5432): Operation timed out
sent 0, rcvd 0
root@SynoFeB:/volume1/@docker# iptables -L -v
Chain INPUT (policy ACCEPT 143K packets, 41M bytes)
 pkts bytes target     prot opt in     out     source               destination
  22M 6752M DOS_PROTECT  all  --  any    any     anywhere             anywhere
  13M 1398M INPUT_FIREWALL  all  --  any    any     anywhere             anywhere

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination
 1420 81456 FORWARD_FIREWALL  all  --  any    any     anywhere             anywhere

Chain OUTPUT (policy ACCEPT 1195K packets, 423M bytes)
 pkts bytes target     prot opt in     out     source               destination

Chain DOCKER (0 references)
 pkts bytes target     prot opt in     out     source               destination
    0     0 ACCEPT     tcp  --  !docker-ee227685 docker-ee227685  anywhere             172.18.0.2           tcp dpt:9001
    0     0 ACCEPT     tcp  --  !docker-ee227685 docker-ee227685  anywhere             172.18.0.2           tcp dpt:1883
    0     0 ACCEPT     tcp  --  !docker-ee227685 docker-ee227685  anywhere             172.18.0.3           tcp dpt:postgres
    0     0 ACCEPT     tcp  --  !docker-ee227685 docker-ee227685  anywhere             172.18.0.4           tcp dpt:3000
    0     0 ACCEPT     tcp  --  !docker-ee227685 docker-ee227685  anywhere             172.18.0.5           tcp dpt:4000

Chain DOCKER-ISOLATION-STAGE-1 (0 references)
 pkts bytes target     prot opt in     out     source               destination
   11   921 DOCKER-ISOLATION-STAGE-2  all  --  docker-ee227685 !docker-ee227685  anywhere             anywhere
    0     0 DOCKER-ISOLATION-STAGE-2  all  --  docker0 !docker0  anywhere             anywhere
   85 23174 RETURN     all  --  any    any     anywhere             anywhere

Chain DOCKER-ISOLATION-STAGE-2 (2 references)
 pkts bytes target     prot opt in     out     source               destination
    0     0 DROP       all  --  any    docker-ee227685  anywhere             anywhere
    0     0 DROP       all  --  any    docker0  anywhere             anywhere
   11   921 RETURN     all  --  any    any     anywhere             anywhere

Chain DOCKER-USER (0 references)
 pkts bytes target     prot opt in     out     source               destination
   85 23174 RETURN     all  --  any    any     anywhere             anywhere

Chain DOS_PROTECT (1 references)
 pkts bytes target     prot opt in     out     source               destination
    0     0 RETURN     icmp --  eth0   any     anywhere             anywhere             icmp echo-request limit: avg 1/sec burst 5
    0     0 DROP       icmp --  eth0   any     anywhere             anywhere             icmp echo-request
    0     0 RETURN     tcp  --  eth0   any     anywhere             anywhere             tcp flags:FIN,SYN,RST,ACK/RST limit: avg 1/sec burst 5
    0     0 DROP       tcp  --  eth0   any     anywhere             anywhere             tcp flags:FIN,SYN,RST,ACK/RST
    0     0 RETURN     tcp  --  eth0   any     anywhere             anywhere             tcp flags:FIN,SYN,RST,ACK/SYN limit: avg 10000/sec burst 100
    0     0 DROP       tcp  --  eth0   any     anywhere             anywhere             tcp flags:FIN,SYN,RST,ACK/SYN

Chain FORWARD_FIREWALL (1 references)
 pkts bytes target     prot opt in     out     source               destination
    0     0 ACCEPT     all  --  lo     any     anywhere             anywhere
    0     0 ACCEPT     all  --  any    any     anywhere             anywhere             state RELATED,ESTABLISHED
    0     0 RETURN     udp  --  any    any     anywhere             anywhere             multiport sports 19997,netbios-ns,netbios-dgm,65001,5004,rfe
    0     0 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports http,https,rtsp,netbios-ns,netbios-dgm,netbios-ssn,microsoft-ds
    0     0 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports 9025:9040,6281,16881,4662,5005,5006,1723
    0     0 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports telnet,5022,ssh,50002,50001,8083,3307
    0     0 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports smtp,smtps,submission,pop3,pop3s,imap,imaps
    0     0 RETURN     udp  --  any    any     anywhere             anywhere             multiport dports 19998,19999,ntp,65001,5004,rfe,6881
    0     0 RETURN     udp  --  any    any     anywhere             anywhere             multiport dports 4672,1194,l2tp,4500,isakmp,1900
    0     0 RETURN     47   --  any    any     anywhere             anywhere
    0     0 RETURN     esp  --  any    any     anywhere             anywhere
    0     0 RETURN     ah   --  any    any     anywhere             anywhere
    0     0 RETURN     all  --  any    any     anywhere             anywhere             source IP range 192.168.1.1-192.168.1.255
    0     0 RETURN     all  --  any    any     anywhere             anywhere             Source countries: AU,BE,BS,CA,DE,ES,FR,GB,GF,IE,IT,NL,NO,TH,US
 1420 81456 DROP       all  --  any    any     anywhere             anywhere
    0     0 RETURN     udp  --  eth0   any     anywhere             anywhere             multiport sports 65001,5004,rfe
    0     0 RETURN     tcp  --  eth0   any     anywhere             anywhere             multiport dports http,https,9025:9040
    0     0 RETURN     udp  --  eth0   any     anywhere             anywhere             multiport dports 65001,5004,rfe
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source countries: FR,GF
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: CA
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: US
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: BE
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: DE
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: GB
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: NO
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: ES
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             source IP range 192.168.1.1-192.168.1.255
    0     0 DROP       all  --  eth0   any     anywhere             anywhere
    0     0 RETURN     all  --  eth1   any     anywhere             anywhere             Source countries: BE,BS,CA,CH,CZ,DE,FR,GB,GF,IE,IT,MU,PF,TH,US
    0     0 RETURN     all  --  eth1   any     192.168.1.0/24       anywhere
    0     0 DROP       all  --  eth1   any     anywhere             anywhere
    0     0 RETURN     all  --  eth1   any     anywhere             anywhere

Chain INPUT_FIREWALL (1 references)
 pkts bytes target     prot opt in     out     source               destination
 263K  235M ACCEPT     all  --  lo     any     anywhere             anywhere
  13M 1113M ACCEPT     all  --  any    any     anywhere             anywhere             state RELATED,ESTABLISHED
20761 1811K RETURN     udp  --  any    any     anywhere             anywhere             multiport sports 19997,netbios-ns,netbios-dgm,65001,5004,rfe
 2057  119K RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports http,https,rtsp,netbios-ns,netbios-dgm,netbios-ssn,microsoft-ds
    9   420 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports 9025:9040,6281,16881,4662,5005,5006,1723
11208  699K RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports telnet,5022,ssh,50002,50001,8083,3307
    0     0 RETURN     tcp  --  any    any     anywhere             anywhere             multiport dports smtp,smtps,submission,pop3,pop3s,imap,imaps
    0     0 RETURN     udp  --  any    any     anywhere             anywhere             multiport dports 19998,19999,ntp,65001,5004,rfe,6881
73789   34M RETURN     udp  --  any    any     anywhere             anywhere             multiport dports 4672,1194,l2tp,4500,isakmp,1900
    0     0 RETURN     47   --  any    any     anywhere             anywhere
    0     0 RETURN     esp  --  any    any     anywhere             anywhere
    0     0 RETURN     ah   --  any    any     anywhere             anywhere
44423   10M RETURN     all  --  any    any     anywhere             anywhere             source IP range 192.168.1.1-192.168.1.255
11444  686K RETURN     all  --  any    any     anywhere             anywhere             Source countries: AU,BE,BS,CA,DE,ES,FR,GB,GF,IE,IT,NL,NO,TH,US
 6496 2117K DROP       all  --  any    any     anywhere             anywhere
    0     0 RETURN     udp  --  eth0   any     anywhere             anywhere             multiport sports 65001,5004,rfe
    0     0 RETURN     tcp  --  eth0   any     anywhere             anywhere             multiport dports http,https,9025:9040
    0     0 RETURN     udp  --  eth0   any     anywhere             anywhere             multiport dports 65001,5004,rfe
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source countries: FR,GF
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: CA
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: US
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: BE
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: DE
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: GB
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: NO
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             Source country: ES
    0     0 RETURN     all  --  eth0   any     anywhere             anywhere             source IP range 192.168.1.1-192.168.1.255
    0     0 DROP       all  --  eth0   any     anywhere             anywhere
    0     0 RETURN     all  --  eth1   any     anywhere             anywhere             Source countries: BE,BS,CA,CH,CZ,DE,FR,GB,GF,IE,IT,MU,PF,TH,US
    0     0 RETURN     all  --  eth1   any     192.168.1.0/24       anywhere
    0     0 DROP       all  --  eth1   any     anywhere             anywhere
    0     0 RETURN     all  --  eth1   any     anywhere             anywhere
Benn picture Benn on 11 Jun 2020

FWIW, the 5 second delay is caused by the -w 5 argument so that is expected.

The timeout for port 5433 strongly suggests a firewall problem that is blocking all communication between docker containers (it should have given "Connection refused").

The firewall is controlled by the iptables rules but none of the docker-specific rules are referenced in the FORWARD rule, so that would explain why it doesn't work. Interestingly, the packet count for some of the docker-specific rules is non-zero, so it looks like they were referenced for a short time in the past.

Is this the standard firewall config? Can you turn off the firewall temporarily (if that is safe) to see if that fixes it?

dyxyl picture dyxyl on 12 Jun 2020
👍1

Hi, @dyxyl
Thanks for your time !
I tried disabling the firewall and get the same results.

Benn picture Benn on 15 Jun 2020

I tried uninstalling the docker package and starting over and now get different logs for Teslamate :

date | stream | content
-- | -- | --
2020-06-14聽23:06:46 | stderr | Crash聽dump聽is聽being聽written聽to:聽erl_crash.dump...done
2020-06-14聽23:06:46 | stderr | 聽
2020-06-14聽23:06:46 | stderr | Kernel聽pid聽terminated聽(application_controller)聽({application_start_failure,teslamate,{{shutdown,{failed_to_start_child,'Elixir.TeslaMate.Api',{#{'__exception__'聽=>聽true,'__struct__'聽=>聽'Elixir.DBConne
2020-06-14聽23:06:46 | stdout | {"Kernel聽pid聽terminated",application_controller,"{application_start_failure,teslamate,{{shutdown,{failed_to_start_child,'Elixir.TeslaMate.Api',{#{'__exception__'聽=>聽true,'__struct__'聽=>聽'Elixir.DBConnection.ConnectionError',message聽=>聽<<\"connection聽not聽available聽and聽request聽was聽dropped聽from聽queue聽after聽2999ms.聽This聽means聽requests聽are聽coming聽in聽and聽your聽connection聽pool聽cannot聽serve聽them聽fast聽enough.聽You聽can聽address聽this聽by:\n\n聽聽1.聽By聽tracking聽down聽slow聽queries聽and聽making聽sure聽they聽are聽running聽fast聽enough\n聽聽2.聽Increasing聽the聽pool_size聽(albeit聽it聽increases聽resource聽consumption)\n聽聽3.聽Allow聽requests聽to聽wait聽longer聽by聽increasing聽:queue_target聽and聽:queue_interval\n\nSee聽DBConnection.start_link/2聽for聽more聽information\n\">>,severity聽=>聽error},[{'Elixir.Ecto.Adapters.SQL',raise_sql_call_error,1,[{file,\"lib/ecto/adapters/sql.ex\"},{line,593}]},{'Elixir.Ecto.Adapters.SQL',execute,5,[{file,\"lib/ecto/adapters/sql.ex\"},{line,526}]},{'Elixir.Ecto.Repo.Queryable',execute,4,[{file,\"lib/ecto/repo/queryable.ex\"},{line,192}]},{'Elixir.Ecto.Repo.Queryable',all,3,[{file,\"lib/ecto/repo/queryable.ex\"},{line,17}]},{'Elixir.TeslaMate.Auth',get_tokens,0,[{file,\"lib/teslamate/auth.ex\"},{line,22}]},{'Elixir.TeslaMate.Api',init,1,[{file,\"lib/teslamate/api.ex\"},{line,85}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,374}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,342}]}]}}},{'Elixir.TeslaMate.Application',start,[normal,[]]}}}"}
2020-06-14聽23:06:44 | stdout | (stdlib聽3.12.1)聽gen_server.erl:342:聽:gen_server.init_it/6
2020-06-14聽23:06:44 | stdout | (stdlib聽3.12.1)聽gen_server.erl:374:聽:gen_server.init_it/2
2020-06-14聽23:06:44 | stdout | (teslamate聽1.19.4)聽lib/teslamate/api.ex:85:聽TeslaMate.Api.init/1
2020-06-14聽23:06:44 | stdout | (teslamate聽1.19.4)聽lib/teslamate/auth.ex:22:聽TeslaMate.Auth.get_tokens/0
2020-06-14聽23:06:44 | stdout | (ecto聽3.4.3)聽lib/ecto/repo/queryable.ex:17:聽Ecto.Repo.Queryable.all/3
2020-06-14聽23:06:44 | stdout | (ecto聽3.4.3)聽lib/ecto/repo/queryable.ex:192:聽Ecto.Repo.Queryable.execute/4
2020-06-14聽23:06:44 | stdout | (ecto_sql聽3.4.3)聽lib/ecto/adapters/sql.ex:526:聽Ecto.Adapters.SQL.execute/5
2020-06-14聽23:06:44 | stdout | (ecto_sql聽3.4.3)聽lib/ecto/adapters/sql.ex:593:聽Ecto.Adapters.SQL.raise_sql_call_error/1
2020-06-14聽23:06:44 | stdout | 聽
2020-06-14聽23:06:44 | stdout | See聽DBConnection.start_link/2聽for聽more聽information
2020-06-14聽23:06:44 | stdout | 聽
2020-06-14聽23:06:44 | stdout | 3.聽Allow聽requests聽to聽wait聽longer聽by聽increasing聽:queue_target聽and聽:queue_interval
2020-06-14聽23:06:44 | stdout | 2.聽Increasing聽the聽pool_size聽(albeit聽it聽increases聽resource聽consumption)
2020-06-14聽23:06:44 | stdout | 1.聽By聽tracking聽down聽slow聽queries聽and聽making聽sure聽they聽are聽running聽fast聽enough
2020-06-14聽23:06:44 | stdout | 聽
2020-06-14聽23:06:44 | stdout | **聽(DBConnection.ConnectionError)聽connection聽not聽available聽and聽request聽was聽dropped聽from聽queue聽after聽2999ms.聽This聽means聽requests聽are聽coming聽in聽and聽your聽connection聽pool聽cannot聽serve聽them聽fast聽enough.聽You聽can聽address聽this聽by:
2020-06-14聽23:06:44 | stdout | **聽(EXIT)聽an聽exception聽was聽raised:
2020-06-14聽23:06:44 | stdout | 23:06:44.658聽[info]聽Application聽teslamate聽exited:聽TeslaMate.Application.start(:normal,聽[])聽returned聽an聽error:聽shutdown:聽failed聽to聽start聽child:聽TeslaMate.Api
2020-06-14聽23:06:41 | stdout | 23:06:41.640聽[info]聽Version:聽1.19.4
2020-06-14聽23:06:06 | stdout | 23:06:06.146聽[info]聽Already聽up
2020-06-14聽23:05:48 | stderr | Crash聽dump聽is聽being聽written聽to:聽erl_crash.dump...done
2020-06-14聽23:05:48 | stderr | 聽
2020-06-14聽23:05:48 | stderr | Kernel聽pid聽terminated聽(application_controller)聽({application_start_failure,teslamate,{{shutdown,{failed_to_start_child,'Elixir.TeslaMate.Api',{#{'__exception__'聽=>聽true,'__struct__'聽=>聽'Elixir.DBConne
2020-06-14聽23:05:48 | stdout | {"Kernel聽pid聽terminated",application_controller,"{application_start_failure,teslamate,{{shutdown,{failed_to_start_child,'Elixir.TeslaMate.Api',{#{'__exception__'聽=>聽true,'__struct__'聽=>聽'Elixir.DBConnection.ConnectionError',message聽=>聽<<\"connection聽not聽available聽and聽request聽was聽dropped聽from聽queue聽after聽2999ms.聽This聽means聽requests聽are聽coming聽in聽and聽your聽connection聽pool聽cannot聽serve聽them聽fast聽enough.聽You聽can聽address聽this聽by:\n\n聽聽1.聽By聽tracking聽down聽slow聽queries聽and聽making聽sure聽they聽are聽running聽fast聽enough\n聽聽2.聽Increasing聽the聽pool_size聽(albeit聽it聽increases聽resource聽consumption)\n聽聽3.聽Allow聽requests聽to聽wait聽longer聽by聽increasing聽:queue_target聽and聽:queue_interval\n\nSee聽DBConnection.start_link/2聽for聽more聽information\n\">>,severity聽=>聽error},[{'Elixir.Ecto.Adapters.SQL',raise_sql_call_error,1,[{file,\"lib/ecto/adapters/sql.ex\"},{line,593}]},{'Elixir.Ecto.Adapters.SQL',execute,5,[{file,\"lib/ecto/adapters/sql.ex\"},{line,526}]},{'Elixir.Ecto.Repo.Queryable',execute,4,[{file,\"lib/ecto/repo/queryable.ex\"},{line,192}]},{'Elixir.Ecto.Repo.Queryable',all,3,[{file,\"lib/ecto/repo/queryable.ex\"},{line,17}]},{'Elixir.TeslaMate.Auth',get_tokens,0,[{file,\"lib/teslamate/auth.ex\"},{line,22}]},{'Elixir.TeslaMate.Api',init,1,[{file,\"lib/teslamate/api.ex\"},{line,85}]},{gen_server,init_it,2,[{file,\"gen_server.erl\"},{line,374}]},{gen_server,init_it,6,[{file,\"gen_server.erl\"},{line,342}]}]}}},{'Elixir.TeslaMate.Application',start,[normal,[]]}}}"}
2020-06-14聽23:05:46 | stdout | (stdlib聽3.12.1)聽gen_server.erl:342:聽:gen_server.init_it/6
2020-06-14聽23:05:46 | stdout | (stdlib聽3.12.1)聽gen_server.erl:374:聽:gen_server.init_it/2
2020-06-14聽23:05:46 | stdout | (teslamate聽1.19.4)聽lib/teslamate/api.ex:85:聽TeslaMate.Api.init/1
2020-06-14聽23:05:46 | stdout | (teslamate聽1.19.4)聽lib/teslamate/auth.ex:22:聽TeslaMate.Auth.get_tokens/0
2020-06-14聽23:05:46 | stdout | (ecto聽3.4.3)聽lib/ecto/repo/queryable.ex:17:聽Ecto.Repo.Queryable.all/3
2020-06-14聽23:05:46 | stdout | (ecto聽3.4.3)聽lib/ecto/repo/queryable.ex:192:聽Ecto.Repo.Queryable.execute/4
2020-06-14聽23:05:46 | stdout | (ecto_sql聽3.4.3)聽lib/ecto/adapters/sql.ex:526:聽Ecto.Adapters.SQL.execute/5
2020-06-14聽23:05:46 | stdout | (ecto_sql聽3.4.3)聽lib/ecto/adapters/sql.ex:593:聽Ecto.Adapters.SQL.raise_sql_call_error/1
2020-06-14聽23:05:46 | stdout | 聽
2020-06-14聽23:05:46 | stdout | See聽DBConnection.start_link/2聽for聽more聽information
2020-06-14聽23:05:46 | stdout | 聽
2020-06-14聽23:05:46 | stdout | 3.聽Allow聽requests聽to聽wait聽longer聽by聽increasing聽:queue_target聽and聽:queue_interval
2020-06-14聽23:05:46 | stdout | 2.聽Increasing聽the聽pool_size聽(albeit聽it聽increases聽resource聽consumption)
2020-06-14聽23:05:46 | stdout | 1.聽By聽tracking聽down聽slow聽queries聽and聽making聽sure聽they聽are聽running聽fast聽enough
2020-06-14聽23:05:46 | stdout | 聽
2020-06-14聽23:05:46 | stdout | **聽(DBConnection.ConnectionError)聽connection聽not聽available聽and聽request聽was聽dropped聽from聽queue聽after聽2999ms.聽This聽means聽requests聽are聽coming聽in聽and聽your聽connection聽pool聽cannot聽serve聽them聽fast聽enough.聽You聽can聽address聽this聽by:
2020-06-14聽23:05:46 | stdout | **聽(EXIT)聽an聽exception聽was聽raised:
2020-06-14聽23:05:46 | stdout | 23:05:46.987聽[info]聽Application聽teslamate聽exited:聽TeslaMate.Application.start(:normal,聽[])聽returned聽an聽error:聽shutdown:聽failed聽to聽start聽child:聽TeslaMate.Api
2020-06-14聽23:05:43 | stdout | 23:05:43.976聽[info]聽Version:聽1.19.4
2020-06-14聽23:05:08 | stdout | 23:05:08.895聽[info]聽==聽Migrated聽20200502140646聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.893聽[info]聽drop聽index聽if聽exists聽addresses_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:08 | stdout | 23:05:08.890聽[info]聽drop聽index聽if聽exists聽positions_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:08 | stdout | 23:05:08.889聽[info]聽==聽Running聽20200502140646聽TeslaMate.Repo.Migrations.DropUnusedIndexes.change/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.866聽[info]聽==聽Migrated聽20200410112005聽in聽0.6s
2020-06-14聽23:05:08 | stdout | 23:05:08.830聽[info]聽alter聽table聽updates
2020-06-14聽23:05:08 | stdout | 23:05:08.796聽[info]聽alter聽table聽tokens
2020-06-14聽23:05:08 | stdout | 23:05:08.745聽[info]聽alter聽table聽states
2020-06-14聽23:05:08 | stdout | 23:05:08.675聽[info]聽alter聽table聽charges
2020-06-14聽23:05:08 | stdout | 23:05:08.588聽[info]聽alter聽table聽positions
2020-06-14聽23:05:08 | stdout | 23:05:08.550聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:08 | stdout | 23:05:08.401聽[info]聽alter聽table聽drives
2020-06-14聽23:05:08 | stdout | 23:05:08.313聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:08 | stdout | 23:05:08.268聽[info]聽alter聽table聽addresses
2020-06-14聽23:05:08 | stdout | 23:05:08.208聽[info]聽alter聽table聽cars
2020-06-14聽23:05:08 | stdout | 23:05:08.204聽[info]聽==聽Running聽20200410112005聽TeslaMate.Repo.Migrations.DatabaseEfficiencyImprovements.change/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.196聽[info]聽==聽Migrated聽20200401171923聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.184聽[info]聽==聽Running聽20200401171923聽TeslaMate.Repo.Migrations.EnableStreaming.up/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.082聽[info]聽==聽Migrated聽20200401171402聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.078聽[info]聽alter聽table聽car_settings
2020-06-14聽23:05:08 | stdout | 23:05:08.078聽[info]聽==聽Running聽20200401171402聽TeslaMate.Repo.Migrations.RemoveSleepModeRequirements.change/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.067聽[info]聽==聽Migrated聽20200401170940聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.061聽[info]聽drop聽table聽geofence_sleep_mode_blacklist
2020-06-14聽23:05:08 | stdout | 23:05:08.055聽[info]聽drop聽table聽geofence_sleep_mode_whitelist
2020-06-14聽23:05:08 | stdout | 23:05:08.052聽[info]聽alter聽table聽car_settings
2020-06-14聽23:05:08 | stdout | 23:05:08.051聽[info]聽==聽Running聽20200401170940聽TeslaMate.Repo.Migrations.RemoveSleepModeToggles.up/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.041聽[info]聽==聽Migrated聽20200320140020聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.039聽[info]聽alter聽table聽drives
2020-06-14聽23:05:08 | stdout | 23:05:08.038聽[info]聽==聽Running聽20200320140020聽TeslaMate.Repo.Migrations.DropPowerAvg.change/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.015聽[info]聽==聽Migrated聽20200318164021聽in聽0.0s
2020-06-14聽23:05:08 | stdout | 23:05:08.012聽[info]聽alter聽table聽car_settings
2020-06-14聽23:05:08 | stdout | 23:05:08.012聽[info]聽==聽Running聽20200318164021聽TeslaMate.Repo.Migrations.UseStreamingApi.change/0聽forward
2020-06-14聽23:05:08 | stdout | 23:05:08.000聽[info]聽==聽Migrated聽20200306133847聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.998聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.997聽[info]聽==聽Running聽20200306133847聽TeslaMate.Repo.Migrations.AddFlatFee.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.974聽[info]聽==聽Migrated聽20200306130218聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.970聽[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"
2020-06-14聽23:05:07 | stdout | 23:05:07.969聽[info]聽==聽Running聽20200306130218聽TeslaMate.Repo.Migrations.UpdateCities.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.960聽[info]聽==聽Migrated聽20200302100654聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.957聽[info]聽alter聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.957聽[info]聽==聽Running聽20200302100654聽TeslaMate.Repo.Migrations.AddVehicleConfigAttrbitues.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.948聽[info]聽==聽Migrated聽20200216121330聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.944聽[info]聽alter聽table聽settings
2020-06-14聽23:05:07 | stdout | 23:05:07.943聽[info]聽==聽Running聽20200216121330聽TeslaMate.Repo.Migrations.UseRatedAsDefaultPreferredRange.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.933聽[info]聽==聽Migrated聽20200212001245聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.924聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.924聽[info]聽==聽Running聽20200212001245聽TeslaMate.Repo.Migrations.LocationBasedChargeCostIncreaseScale.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.916聽[info]聽==聽Migrated聽20200203180529聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.912聽[info]聽alter聽table聽car_settings
2020-06-14聽23:05:07 | stdout | 23:05:07.910聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.910聽[info]聽==聽Running聽20200203180529聽TeslaMate.Repo.Migrations.LocationBasedChargeCost.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.899聽[info]聽==聽Migrated聽20200203120311聽in聽0.1s
2020-06-14聽23:05:07 | stdout | 23:05:07.891聽[info]聽alter聽table聽updates
2020-06-14聽23:05:07 | stdout | 23:05:07.887聽[info]聽drop聽constraint聽updates_car_id_fkey聽from聽table聽updates
2020-06-14聽23:05:07 | stdout | 23:05:07.861聽[info]聽alter聽table聽states
2020-06-14聽23:05:07 | stdout | 23:05:07.857聽[info]聽drop聽constraint聽states_car_id_fkey聽from聽table聽states
2020-06-14聽23:05:07 | stdout | 23:05:07.843聽[info]聽alter聽table聽positions
2020-06-14聽23:05:07 | stdout | 23:05:07.839聽[info]聽drop聽constraint聽positions_drive_id_fkey聽from聽table聽positions
2020-06-14聽23:05:07 | stdout | 23:05:07.835聽[info]聽drop聽constraint聽positions_car_id_fkey聽from聽table聽positions
2020-06-14聽23:05:07 | stdout | 23:05:07.792聽[info]聽alter聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.787聽[info]聽drop聽constraint聽drives_end_geofence_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.783聽[info]聽drop聽constraint聽drives_start_geofence_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.783聽[info]聽constraint聽"drives_end_address_id_fkey"聽of聽relation聽"drives"聽does聽not聽exist,聽skipping
2020-06-14聽23:05:07 | stdout | 23:05:07.782聽[info]聽drop聽constraint聽if聽exists聽drives_end_address_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.781聽[info]聽constraint聽"drives_start_address_id_fkey"聽of聽relation聽"drives"聽does聽not聽exist,聽skipping
2020-06-14聽23:05:07 | stdout | 23:05:07.780聽[info]聽drop聽constraint聽if聽exists聽drives_start_address_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.775聽[info]聽drop聽constraint聽if聽exists聽trips_end_address_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.772聽[info]聽drop聽constraint聽if聽exists聽trips_start_address_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.768聽[info]聽drop聽constraint聽drives_end_position_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.764聽[info]聽drop聽constraint聽drives_start_position_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.764聽[info]聽constraint聽"drives_car_id_fkey"聽of聽relation聽"drives"聽does聽not聽exist,聽skipping
2020-06-14聽23:05:07 | stdout | 23:05:07.762聽[info]聽drop聽constraint聽if聽exists聽drives_car_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.758聽[info]聽drop聽constraint聽if聽exists聽trips_car_id_fkey聽from聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.742聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.738聽[info]聽drop聽constraint聽charging_processes_geofence_id_fkey聽from聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.734聽[info]聽drop聽constraint聽charging_processes_address_id_fkey聽from聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.730聽[info]聽drop聽constraint聽charging_processes_car_id_fkey聽from聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.722聽[info]聽alter聽table聽charges
2020-06-14聽23:05:07 | stdout | 23:05:07.718聽[info]聽drop聽constraint聽charges_charging_process_id_fkey聽from聽table聽charges
2020-06-14聽23:05:07 | stdout | 23:05:07.711聽[info]聽alter聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.706聽[info]聽drop聽constraint聽cars_settings_id_fkey聽from聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.706聽[info]聽==聽Running聽20200203120311聽TeslaMate.Repo.Migrations.CascadeDelete.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.697聽[info]聽==聽Migrated聽20200120142602聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.694聽[info]聽execute聽"ALTER聽SEQUENCE聽addresses_id_seq聽RESTART;"
2020-06-14聽23:05:07 | stdout | 23:05:07.692聽[info]聽execute聽"DELETE聽FROM聽addresses;"
2020-06-14聽23:05:07 | stdout | 23:05:07.690聽[info]聽execute聽"UPDATE聽charging_processes聽SET聽address_id聽=聽NULL;"
2020-06-14聽23:05:07 | stdout | 23:05:07.687聽[info]聽execute聽"UPDATE聽drives聽SET聽start_address_id聽=聽NULL,聽end_address_id聽=聽NULL;"
2020-06-14聽23:05:07 | stdout | 23:05:07.682聽[info]聽create聽index聽addresses_osm_id_osm_type_index
2020-06-14聽23:05:07 | stdout | 23:05:07.679聽[info]聽alter聽table聽addresses
2020-06-14聽23:05:07 | stdout | 23:05:07.677聽[info]聽drop聽index聽addresses_place_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.675聽[info]聽==聽Running聽20200120142602聽TeslaMate.Repo.Migrations.ReplacePlaceIdWithOsmid.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.664聽[info]聽==聽Migrated聽20200120130125聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.661聽[info]聽alter聽table聽settings
2020-06-14聽23:05:07 | stdout | 23:05:07.660聽[info]聽==聽Running聽20200120130125聽TeslaMate.Repo.Migrations.AddLanguage.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.651聽[info]聽==聽Migrated聽20200116190926聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.648聽[info]聽alter聽table聽charges
2020-06-14聽23:05:07 | stdout | 23:05:07.648聽[info]聽==聽Running聽20200116190926聽TeslaMate.Repo.Migrations.ChargesAddUsableBatteryLevel.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.619聽[info]聽==聽Migrated聽20200103073606聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.616聽[info]聽alter聽table聽positions
2020-06-14聽23:05:07 | stdout | 23:05:07.616聽[info]聽==聽Running聽20200103073606聽TeslaMate.Repo.Migrations.AddUsableBatteryLevel.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.608聽[info]聽==聽Migrated聽20191212230527聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.605聽[info]聽==聽Running聽20191212230527聽TeslaMate.Repo.Migrations.RecalcEnergyUsed.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.596聽[info]聽==聽Migrated聽20191212215130聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.594聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.593聽[info]聽==聽Running聽20191212215130聽TeslaMate.Repo.Migrations.RemovePhaseCorrection.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.579聽[info]聽==聽Migrated聽20191119162847聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.569聽[info]聽create聽table聽geofence_sleep_mode_blacklist
2020-06-14聽23:05:07 | stdout | 23:05:07.558聽[info]聽create聽table聽geofence_sleep_mode_whitelist
2020-06-14聽23:05:07 | stdout | 23:05:07.556聽[info]聽alter聽table聽car_settings
2020-06-14聽23:05:07 | stdout | 23:05:07.555聽[info]聽==聽Running聽20191119162847聽TeslaMate.Repo.Migrations.GeofenceSleep.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.546聽[info]聽==聽Migrated聽20191117171307聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.540聽[info]聽alter聽table聽settings
2020-06-14聽23:05:07 | stdout | 23:05:07.535聽[info]聽create聽index聽cars_settings_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.530聽[info]聽alter聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.526聽[info]聽drop聽constraint聽cars_settings_id_fkey聽from聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.516聽[info]聽alter聽table聽cars
2020-06-14聽23:05:07 | stdout | 23:05:07.505聽[info]聽create聽table聽car_settings
2020-06-14聽23:05:07 | stdout | 23:05:07.504聽[info]聽==聽Running聽20191117171307聽TeslaMate.Repo.Migrations.CarSettings.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.492聽[info]聽==聽Migrated聽20191117143038聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.485聽[info]聽alter聽table聽settings
2020-06-14聽23:05:07 | stdout | 23:05:07.484聽[info]聽==聽Running聽20191117143038聽TeslaMate.Repo.Migrations.AddGrafanaUrl.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.466聽[info]聽==聽Migrated聽20191117042320聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.463聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.462聽[info]聽==聽Running聽20191117042320聽TeslaMate.Repo.Migrations.AddCostFieldToCharges.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.451聽[info]聽==聽Migrated聽20191026185642聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.447聽[info]聽==聽Running聽20191026185642聽TeslaMate.Repo.Migrations.CalculateChargeEnergyUsed.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.412聽[info]聽==聽Migrated聽20191026145925聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.410聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.409聽[info]聽==聽Running聽20191026145925聽TeslaMate.Repo.Migrations.PhaseCorrection.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.400聽[info]聽==聽Migrated聽20191026144449聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.397聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.397聽[info]聽==聽Running聽20191026144449聽TeslaMate.Repo.Migrations.DropCpConfidenceAndInterval.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.387聽[info]聽==聽Migrated聽20191020130234聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.383聽[info]聽alter聽table聽positions
2020-06-14聽23:05:07 | stdout | 23:05:07.378聽[info]聽alter聽table聽charges
2020-06-14聽23:05:07 | stdout | 23:05:07.374聽[info]聽alter聽table聽updates
2020-06-14聽23:05:07 | stdout | 23:05:07.366聽[info]聽alter聽table聽states
2020-06-14聽23:05:07 | stdout | 23:05:07.363聽[info]聽alter聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.360聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.359聽[info]聽==聽Running聽20191020130234聽TeslaMate.Repo.Migrations.IncreaseDatetimePrecision.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.342聽[info]聽==聽Migrated聽20191017003836聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.339聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.338聽[info]聽==聽Running聽20191017003836聽TeslaMate.Repo.Migrations.AddEstTotalChargeEnergy.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.330聽[info]聽==聽Migrated聽20191008191431聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.328聽[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"
2020-06-14聽23:05:07 | stdout | 23:05:07.327聽[info]聽==聽Running聽20191008191431聽TeslaMate.Repo.Migrations.FixLlToEarth.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.317聽[info]聽==聽Migrated聽20191007105010聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.313聽[info]聽create聽index聽addresses_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.309聽[info]聽create聽index聽positions_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.306聽[info]聽drop聽index聽geofences__earth_box_ll_to_earth_latitude__longitude___radius_index
2020-06-14聽23:05:07 | stdout | 23:05:07.304聽[info]聽drop聽index聽addresses_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.301聽[info]聽drop聽index聽positions_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.297聽[info]聽create聽index聽drives_end_geofence_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.293聽[info]聽create聽index聽drives_start_geofence_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.288聽[info]聽create聽index聽drives_end_position_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.231聽[info]聽create聽index聽drives_start_position_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.228聽[info]聽==聽Running聽20191007105010聽TeslaMate.Repo.Migrations.AddNewFkeyIndexes.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.215聽[info]聽==聽Migrated聽20191003132415聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.209聽[info]聽==聽Running聽20191003132415聽TeslaMate.Repo.Migrations.AddPositionIdsAndApplyGeofences.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.200聽[info]聽==聽Migrated聽20191003130650聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.195聽[info]聽create聽index聽positions_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.191聽[info]聽alter聽table聽addresses
2020-06-14聽23:05:07 | stdout | 23:05:07.186聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:07 | stdout | 23:05:07.175聽[info]聽alter聽table聽drives
2020-06-14聽23:05:07 | stdout | 23:05:07.173聽[info]聽==聽Running聽20191003130650聽TeslaMate.Repo.Migrations.AddStartAndEndPositionToDrives.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.165聽[info]聽==聽Migrated聽20190928155641聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.163聽[info]聽alter聽table聽settings
2020-06-14聽23:05:07 | stdout | 23:05:07.162聽[info]聽==聽Running聽20190928155641聽TeslaMate.Repo.Migrations.AddBaseUrlSetting.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.146聽[info]聽==聽Migrated聽20190925182253聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.137聽[info]聽create聽index聽addresses_geofence_id_index
2020-06-14聽23:05:07 | stdout | 23:05:07.133聽[info]聽alter聽table聽geofences
2020-06-14聽23:05:07 | stdout | 23:05:07.127聽[info]聽alter聽table聽addresses
2020-06-14聽23:05:07 | stdout | 23:05:07.125聽[info]聽==聽Running聽20190925182253聽TeslaMate.Repo.Migrations.AddGeofenceIdToAddresses.up/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.117聽[info]聽==聽Migrated聽20190925161034聽in聽0.0s
2020-06-14聽23:05:07 | stdout | 23:05:07.111聽[info]聽create聽index聽addresses_ll_to_earth_latitude__longitude_index
2020-06-14聽23:05:07 | stdout | 23:05:07.110聽[info]聽==聽Running聽20190925161034聽TeslaMate.Repo.Migrations.CreateIndexOnAddressPositions.change/0聽forward
2020-06-14聽23:05:07 | stdout | 23:05:07.098聽[info]聽==聽Migrated聽20190925152807聽in聽0.1s
2020-06-14聽23:05:07 | stdout | 23:05:07.090聽[info]聽create聽index聽geofences__earth_box_ll_to_earth_latitude__longitude___radius_index
2020-06-14聽23:05:07 | stdout | 23:05:07.051聽[info]聽execute聽"CREATE聽EXTENSION聽IF聽NOT聽EXISTS聽earthdistance"
2020-06-14聽23:05:06 | stdout | 23:05:06.914聽[info]聽execute聽"CREATE聽EXTENSION聽IF聽NOT聽EXISTS聽cube"
2020-06-14聽23:05:06 | stdout | 23:05:06.913聽[info]聽==聽Running聽20190925152807聽TeslaMate.Repo.Migrations.CreateGeoExtensions.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.905聽[info]聽==聽Migrated聽20190913175543聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.846聽[info]聽==聽Running聽20190913175543聽TeslaMate.Repo.Migrations.SetStartAndEndRatedRangeKm.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.818聽[info]聽==聽Migrated聽20190913175011聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.815聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.813聽[info]聽rename聽column聽end_range_km聽to聽end_ideal_range_km聽on聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.811聽[info]聽rename聽column聽start_range_km聽to聽start_ideal_range_km聽on聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.809聽[info]聽alter聽table聽charges
2020-06-14聽23:05:06 | stdout | 23:05:06.806聽[info]聽alter聽table聽drives
2020-06-14聽23:05:06 | stdout | 23:05:06.804聽[info]聽rename聽column聽end_range_km聽to聽end_ideal_range_km聽on聽table聽drives
2020-06-14聽23:05:06 | stdout | 23:05:06.802聽[info]聽rename聽column聽start_range_km聽to聽start_ideal_range_km聽on聽table聽drives
2020-06-14聽23:05:06 | stdout | 23:05:06.800聽[info]聽rename聽column聽battery_range_km聽to聽rated_battery_range_km聽on聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.799聽[info]聽==聽Running聽20190913175011聽TeslaMate.Repo.Migrations.AddRatedRangeToDrives.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.791聽[info]聽==聽Migrated聽20190913165850聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.788聽[info]聽alter聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.786聽[info]聽execute聽"CREATE聽TYPE聽public.range聽AS聽ENUM聽('ideal',聽'rated')"
2020-06-14聽23:05:06 | stdout | 23:05:06.785聽[info]聽==聽Running聽20190913165850聽TeslaMate.Repo.Migrations.AddRangeEnum.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.776聽[info]聽==聽Migrated聽20190903151524聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.770聽[info]聽create聽index聽cars_vin_index
2020-06-14聽23:05:06 | stdout | 23:05:06.769聽[info]聽==聽Running聽20190903151524聽TeslaMate.Repo.Migrations.AddUniqueIndexOnVins.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.753聽[info]聽==聽Migrated聽20190828150058聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.751聽[info]聽rename聽column聽version聽to聽trim_badging聽on聽table聽cars
2020-06-14聽23:05:06 | stdout | 23:05:06.748聽[info]聽alter聽table聽cars
2020-06-14聽23:05:06 | stdout | 23:05:06.747聽[info]聽==聽Running聽20190828150058聽TeslaMate.Repo.Migrations.DoNotRequireEfficiency.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.739聽[info]聽==聽Migrated聽20190828122529聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.737聽[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"
2020-06-14聽23:05:06 | stdout | 23:05:06.736聽[info]聽==聽Running聽20190828122529聽TeslaMate.Repo.Migrations.AddMToFtConversionHelper.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.728聽[info]聽==聽Migrated聽20190828104902聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.726聽[info]聽rename聽column聽altitude聽to聽elevation聽on聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.725聽[info]聽==聽Running聽20190828104902聽TeslaMate.Repo.Migrations.AddElevation.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.716聽[info]聽==聽Migrated聽20190828094708聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.713聽[info]聽alter聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.713聽[info]聽==聽Running聽20190828094708聽TeslaMate.Repo.Migrations.AddBatteryRange.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.690聽[info]聽==聽Migrated聽20190826142828聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.689聽[info]聽==聽Running聽20190826142828聽TeslaMate.Repo.Migrations.FixIncompleteChargingProcessesV3.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.681聽[info]聽==聽Migrated聽20190823173437聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.677聽[info]聽alter聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.676聽[info]聽==聽Running聽20190823173437聽TeslaMate.Repo.Migrations.AddSleepRequirements.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.651聽[info]聽==聽Migrated聽20190821155748聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.648聽[info]聽alter聽table聽drives
2020-06-14聽23:05:06 | stdout | 23:05:06.647聽[info]聽==聽Running聽20190821155748聽TeslaMate.Repo.Migrations.DropConsumptionColumns.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.640聽[info]聽==聽Migrated聽20190821143938聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.637聽[info]聽create聽check聽constraint聽positive_duration聽on聽table聽updates
2020-06-14聽23:05:06 | stdout | 23:05:06.634聽[info]聽create聽check聽constraint聽positive_duration聽on聽table聽states
2020-06-14聽23:05:06 | stdout | 23:05:06.629聽[info]聽create聽index聽states_car_id__end_date_IS_NULL_index
2020-06-14聽23:05:06 | stdout | 23:05:06.628聽[info]聽==聽Running聽20190821143938聽TeslaMate.Repo.Migrations.AddConstraints.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.620聽[info]聽==聽Migrated聽20190816200723聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.618聽[info]聽alter聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.618聽[info]聽==聽Running聽20190816200723聽TeslaMate.Repo.Migrations.AddEstBatteryRangeKm.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.610聽[info]聽==聽Migrated聽20190816165713聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.603聽[info]聽alter聽table聽cars
2020-06-14聽23:05:06 | stdout | 23:05:06.602聽[info]聽==聽Running聽20190816165713聽TeslaMate.Repo.Migrations.ExtendCarTable.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.571聽[info]聽==聽Migrated聽20190814152810聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.565聽[info]聽alter聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.564聽[info]聽==聽Running聽20190814152810聽TeslaMate.Repo.Migrations.IncreaseSuspendMin.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.556聽[info]聽==聽Migrated聽20190813184320聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.556聽[info]聽==聽Running聽20190813184320聽TeslaMate.Repo.Migrations.FixIncompleteChargingProcessesV2.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.548聽[info]聽==聽Migrated聽20190812191616聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.546聽[info]聽execute聽"ALTER聽TABLE聽positions聽RENAME聽CONSTRAINT聽positions_trip_id_fkey聽TO聽positions_drive_id_fkey"
2020-06-14聽23:05:06 | stdout | 23:05:06.544聽[info]聽execute聽"ALTER聽INDEX聽positions_trip_id_index聽RENAME聽TO聽positions_drive_id_index;"
2020-06-14聽23:05:06 | stdout | 23:05:06.542聽[info]聽rename聽column聽trip_id聽to聽drive_id聽on聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.540聽[info]聽rename聽table聽trips聽to聽drives
2020-06-14聽23:05:06 | stdout | 23:05:06.539聽[info]聽==聽Running聽20190812191616聽TeslaMate.Repo.Migrations.RenameTripsToDrives.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.531聽[info]聽==聽Migrated聽20190810151901聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.527聽[info]聽create聽index聽geofences_address_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.513聽[info]聽create聽table聽geofences
2020-06-14聽23:05:06 | stdout | 23:05:06.512聽[info]聽==聽Running聽20190810151901聽TeslaMate.Repo.Migrations.CreateGeofences.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.487聽[info]聽==聽Migrated聽20190810131321聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.484聽[info]聽alter聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.483聽[info]聽==聽Running聽20190810131321聽TeslaMate.Repo.Migrations.PersistSuspendSettings.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.475聽[info]聽==聽Migrated聽20190810105216聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.438聽[info]聽alter聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.436聽[info]聽execute聽"CREATE聽TYPE聽public.temperature聽AS聽ENUM聽('C',聽'F')"
2020-06-14聽23:05:06 | stdout | 23:05:06.434聽[info]聽execute聽"CREATE聽TYPE聽public.length聽AS聽ENUM聽('km',聽'mi')"
2020-06-14聽23:05:06 | stdout | 23:05:06.431聽[info]聽==聽Running聽20190810105216聽TeslaMate.Repo.Migrations.UnitOfLegnthAndTemperature.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.423聽[info]聽==聽Migrated聽20190805092941聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.423聽[info]聽==聽Running聽20190805092941聽TeslaMate.Repo.Migrations.FixIncompleteChargingProcesses.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.415聽[info]聽==聽Migrated聽20190731154452聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.396聽[info]聽create聽table聽settings
2020-06-14聽23:05:06 | stdout | 23:05:06.395聽[info]聽==聽Running聽20190731154452聽TeslaMate.Repo.Migrations.CreateSettings.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.386聽[info]聽==聽Migrated聽20190730101523聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.357聽[info]聽create聽table聽tokens
2020-06-14聽23:05:06 | stdout | 23:05:06.356聽[info]聽==聽Running聽20190730101523聽TeslaMate.Repo.Migrations.CreateTokens.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.336聽[info]聽==聽Migrated聽20190729181314聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.332聽[info]聽==聽Running聽20190729181314聽TeslaMate.Repo.Migrations.FixTripEfficiency.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.317聽[info]聽==聽Migrated聽20190729142656聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.315聽[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"
2020-06-14聽23:05:06 | stdout | 23:05:06.309聽[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"
2020-06-14聽23:05:06 | stdout | 23:05:06.308聽[info]聽==聽Running聽20190729142656聽TeslaMate.Repo.Migrations.AddConversionFunctions.up/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.296聽[info]聽==聽Migrated聽20190717184003聽in聽0.1s
2020-06-14聽23:05:06 | stdout | 23:05:06.283聽[info]聽create聽index聽updates_car_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.271聽[info]聽create聽index聽trips_end_address_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.265聽[info]聽create聽index聽trips_start_address_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.261聽[info]聽create聽index聽trips_car_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.189聽[info]聽create聽index聽states_car_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.177聽[info]聽create聽index聽positions_trip_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.173聽[info]聽create聽index聽positions_car_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.164聽[info]聽create聽index聽charging_processes_address_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.153聽[info]聽create聽index聽charging_processes_position_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.148聽[info]聽create聽index聽charging_processes_car_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.144聽[info]聽create聽index聽charges_charging_process_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.141聽[info]聽==聽Running聽20190717184003聽TeslaMate.Repo.Migrations.AddFkeyIndexes.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.134聽[info]聽==聽Migrated聽20190525125700聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.132聽[info]聽rename聽column聽end_soc聽to聽end_range_km聽on聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.130聽[info]聽rename聽column聽start_soc聽to聽start_range_km聽on聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.129聽[info]聽==聽Running聽20190525125700聽TeslaMate.Repo.Migrations.RenameSocFields.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.121聽[info]聽==聽Migrated聽20190416125429聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.117聽[info]聽create聽index聽charges_date_index
2020-06-14聽23:05:06 | stdout | 23:05:06.111聽[info]聽create聽index聽positions_date_index
2020-06-14聽23:05:06 | stdout | 23:05:06.111聽[info]聽==聽Running聽20190416125429聽TeslaMate.Repo.Migrations.AddIndexesOnDates.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.103聽[info]聽==聽Migrated聽20190415192200聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.098聽[info]聽alter聽table聽charging_processes
2020-06-14聽23:05:06 | stdout | 23:05:06.098聽[info]聽==聽Running聽20190415192200聽TeslaMate.Repo.Migrations.AddAddressToChargingProcess.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.090聽[info]聽==聽Migrated聽20190415130705聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.081聽[info]聽alter聽table聽trips
2020-06-14聽23:05:06 | stdout | 23:05:06.081聽[info]聽==聽Running聽20190415130705聽TeslaMate.Repo.Migrations.AddAddressesToTrips.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.072聽[info]聽==聽Migrated聽20190415130006聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.067聽[info]聽create聽index聽addresses_place_id_index
2020-06-14聽23:05:06 | stdout | 23:05:06.049聽[info]聽create聽table聽addresses
2020-06-14聽23:05:06 | stdout | 23:05:06.047聽[info]聽==聽Running聽20190415130006聽TeslaMate.Repo.Migrations.CreateAddresses.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.039聽[info]聽==聽Migrated聽20190415115227聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.036聽[info]聽alter聽table聽charges
2020-06-14聽23:05:06 | stdout | 23:05:06.033聽[info]聽alter聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.032聽[info]聽==聽Running聽20190415115227聽TeslaMate.Repo.Migrations.AddBatteryHeaterFields.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.022聽[info]聽==聽Migrated聽20190415103933聽in聽0.0s
2020-06-14聽23:05:06 | stdout | 23:05:06.019聽[info]聽alter聽table聽trips
2020-06-14聽23:05:06 | stdout | 23:05:06.015聽[info]聽alter聽table聽positions
2020-06-14聽23:05:06 | stdout | 23:05:06.014聽[info]聽==聽Running聽20190415103933聽TeslaMate.Repo.Migrations.AddInsideTemp.change/0聽forward
2020-06-14聽23:05:06 | stdout | 23:05:06.003聽[info]聽==聽Migrated聽20190408203117聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.987聽[info]聽create聽table聽updates
2020-06-14聽23:05:05 | stdout | 23:05:05.986聽[info]聽==聽Running聽20190408203117聽TeslaMate.Repo.Migrations.CreateUpdates.change/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.975聽[info]聽==聽Migrated聽20190330200000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.953聽[info]聽create聽table聽charges
2020-06-14聽23:05:05 | stdout | 23:05:05.952聽[info]聽==聽Running聽20190330200000聽TeslaMate.Repo.Migrations.CreateCharges.change/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.944聽[info]聽==聽Migrated聽20190330190000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.930聽[info]聽create聽table聽charging_processes
2020-06-14聽23:05:05 | stdout | 23:05:05.929聽[info]聽==聽Running聽20190330190000聽TeslaMate.Repo.Migrations.CreateChargingProcesses.change/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.921聽[info]聽==聽Migrated聽20190330180000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.910聽[info]聽create聽table聽states
2020-06-14聽23:05:05 | stdout | 23:05:05.906聽[info]聽execute聽"CREATE聽TYPE聽public.states_status聽AS聽ENUM聽('online',聽'offline',聽'asleep')"
2020-06-14聽23:05:05 | stdout | 23:05:05.901聽[info]聽==聽Running聽20190330180000聽TeslaMate.Repo.Migrations.CreateStates.up/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.890聽[info]聽==聽Migrated聽20190330170000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.874聽[info]聽create聽table聽positions
2020-06-14聽23:05:05 | stdout | 23:05:05.873聽[info]聽==聽Running聽20190330170000聽TeslaMate.Repo.Migrations.CreatePositions.change/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.864聽[info]聽==聽Migrated聽20190330160000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.844聽[info]聽create聽table聽trips
2020-06-14聽23:05:05 | stdout | 23:05:05.843聽[info]聽==聽Running聽20190330160000聽TeslaMate.Repo.Migrations.CreateTrips.change/0聽forward
2020-06-14聽23:05:05 | stdout | 23:05:05.723聽[info]聽==聽Migrated聽20190330150000聽in聽0.0s
2020-06-14聽23:05:05 | stdout | 23:05:05.707聽[info]聽create聽index聽cars_vid_index
2020-06-14聽23:05:05 | stdout | 23:05:05.702聽[info]聽create聽index聽cars_eid_index
2020-06-14聽23:05:05 | stdout | 23:05:05.646聽[info]聽create聽table聽cars
2020-06-14聽23:05:05 | stdout | 23:05:05.638聽[info]聽==聽Running聽20190330150000聽TeslaMate.Repo.Migrations.CreateCar.change/0聽forward
2020-06-14聽23:04:40 | stdout | waiting聽for聽postgres聽at聽database:5432聽(4sec)
2020-06-14聽23:02:31 | stdout | waiting聽for聽postgres聽at聽database:5432聽(2sec)

I looks like it did manage to connect to the database and run some queries (or am I misreading this ?)
Anyway, still the same results after that, with or without firewall.

Benn picture Benn on 15 Jun 2020

Yes, it apparently did manage to run the initial migrations, but initialization of teslamate itself failed. You could try setting DATABASE_POOL_SIZE: 20 in environment section of the teslamate containing in docker-compose.yml (where MQTT_HOST is set) but I don't know if that will help.

dyxyl picture dyxyl on 18 Jun 2020
👍2

Hi Dyxyl,
Thanks again for your time.
I tried adding DATABASE_POOL_SIZE=20, but still not luck.
Cheers

Benn picture Benn on 25 Jun 2020

Sorry, I'm running out of ideas. The only thing I can think of is to check the output of iptables -L -v again after it fails, but it seems unlikely to be a firewall problem when the initial migrations have worked.

dyxyl picture dyxyl on 8 Jul 2020

I'll just have to keep a raspberry pi running until I replace my Synology I guess... :)
Thanks again !

Benn picture Benn on 31 Jul 2020

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] picture stale[bot] on 29 Sep 2020
Was this page helpful?
0 / 5 - 0 ratings

Related issues

bahree picture bahree  路  5Comments
olivercho picture olivercho  路  4Comments
jun3280net picture jun3280net  路  4Comments
Highlander1694 picture Highlander1694  路  3Comments
petariga picture petariga  路  5Comments