issue with importing data from Teslamate

[kysersoze81]

Details: teslamate-import.exe.config

Server=127.0.0.1;Database=teslalogger;Uid=root;Password=teslalogger; Host=192.168.1.230;Username=teslamate;Password=secret;Database=teslamate Teslamate docker config teslamate: image: teslamate/teslamate:latest restart: always environment: - ENCRYPTION_KEY=***redacted*** - DATABASE_USER=teslamate - DATABASE_PASS=secret - DATABASE_NAME=teslamate - DATABASE_HOST=database - MQTT_HOST=mosquitto ports: - 4000:4000 volumes: - ./import:/opt/app/import cap_drop: - all database: image: postgres:14 restart: always environment: - POSTGRES_USER=teslamate - POSTGRES_PASSWORD=secret - POSTGRES_DB=teslamate ports: - 5432:5432 volumes: - teslamate-db:/var/lib/postgresql/data grafana: image: teslamate/grafana:latest restart: always environment: - DATABASE_USER=teslamate - DATABASE_PASS=secret - DATABASE_NAME=teslamate - DATABASE_HOST=database ports: - 3000:3000 volumes: - teslamate-grafana-data:/var/lib/grafana mosquitto: image: eclipse-mosquitto:2 restart: always command: mosquitto -c /mosquitto-no-auth.conf ports: - 1883:1883 volumes: - mosquitto-conf:/mosquitto/config - mosquitto-data:/mosquitto/data teslamateagile: image: mattjeanes/teslamateagile:latest restart: always environment: - DATABASE_USER=teslamate - DATABASE_PASS=secret - DATABASE_NAME=teslamate - DATABASE_HOST=database - TeslaMate__UpdateIntervalSeconds=300 - TeslaMate__GeofenceId=1 - TeslaMate__EnergyProvider=FixedPrice - FixedPrice__TimeZone=Australia/Brisbane - FixedPrice__Prices__0=16:00-01:00=0.20493 - FixedPrice__Prices__1=01:00-10:00=0.17259 - FixedPrice__Prices__2=10:00-16:00=0.0 volumes: teslamate-db: teslamate-grafana-data: mosquitto-conf: mosquitto-data: Receiving the following from running the import tool mono ./TeslaLogger/Teslamate-Import/bin/Teslamate-Import.exe 08/04/2022 03:35:00 - ***** Teslamate Import 1.2.0.0 Started ***** 08/04/2022 03:35:00 - Teslamate DB:Host=192.168.1.230;Username=teslamate;Password=secret;Database=teslamate 08/04/2022 03:35:00 - Teslalogger DB:Server=127.0.0.1;Database=teslalogger;Uid=root;Password=teslalogger; 08/04/2022 03:35:00 - First Teslalogger Data: 09/13/2021 16:06:34 08/04/2022 03:35:49 1000 - Pos 06/12/2021 23:42:45 08/04/2022 03:36:02 2000 - Pos 06/12/2021 23:48:19 08/04/2022 03:36:13 3000 - Pos 06/12/2021 23:53:06 (Shortened ) 08/04/2022 04:51:57 464000 - Pos 07/11/2021 10:18:08 08/04/2022 04:52:06 465000 - Pos 07/11/2021 10:23:40 08/04/2022 04:52:15 466000 - Pos 07/11/2021 10:29:05 08/04/2022 04:52:51 - Npgsql.NpgsqlException (0x80004005): Exception while reading from stream ---> System.IO.IOException: Unable to read data from the transport connection: Operation on non-blocking socket would block. ---> System.Net.Sockets.SocketException: Operation on non-blocking socket would block at System.Net.Sockets.Socket.Receive (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <33b19a7ad5234d94abf4fd9b47566616>:0 at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x00065] in <33b19a7ad5234d94abf4fd9b47566616>:0 --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x000ac] in <33b19a7ad5234d94abf4fd9b47566616>:0 at Npgsql.NpgsqlReadBuffer+<>c__DisplayClass30_0.g__EnsureLong|0 () [0x00196] in <55e26c95a3804e57b2aa1bb038d1837e>:0 at Npgsql.NpgsqlReadBuffer+<>c__DisplayClass30_0.g__EnsureLong|0 () [0x002b9] in <55e26c95a3804e57b2aa1bb038d1837e>:0 at Npgsql.NpgsqlConnector+<>c__DisplayClass160_0.g__ReadMessageLong|0 (Npgsql.DataRowLoadingMode dataRowLoadingMode2, System.Boolean readingNotifications2, System.Boolean isReadingPrependedMessage) [0x00462] in <55e26c95a3804e57b2aa1bb038d1837e>:0 at Npgsql.NpgsqlDataReader.Read (System.Boolean async) [0x001ab] in <55e26c95a3804e57b2aa1bb038d1837e>:0 at Npgsql.NpgsqlDataReader.Read () [0x00023] in <55e26c95a3804e57b2aa1bb038d1837e>:0 at Teslamate_Import.Program.CopyPositions () [0x002f8] in :0 at Teslamate_Import.Program.Main (System.String[] args) [0x0008a] in :0 08/04/2022 04:52:51 - ***** Teslamate Import 1.2.0.0 Finish *****

[bassmaster187]

well, it seems like it is working for over ohne hour. Could you please send me a backup of your Teslamate DB, so I can try debugging. Drop it on any cloud storage and send me the link: mail@pogea.de

[kysersoze81]

Have emailed you link to download