You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
today I had issues with my docker based setup on a raspy. My evcc did not respond. Therefore I restored a backup from the day before. Nice cvcc worked again - but the teslamate container does not work anymore. Seems the file in ram was ok as it worked like a charm before but the backup (SD clone tech night) seems defect. I have three nights - all defect!
Is there a way to fix the DB. Otherwise I loose more than a year of data...
This is the error:
2025-01-24 17:12:30.328 UTC [475] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:12:30.328 UTC [475] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:12:30.332 UTC [473] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:12:30.332 UTC [473] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:12:30.332 UTC [471] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:12:30.332 UTC [471] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:13:36.781 UTC [497] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.781 UTC [497] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.981 UTC [503] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:13:36.981 UTC [503] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:13:36.982 UTC [504] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.982 UTC [504] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.987 UTC [502] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.987 UTC [502] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.987 UTC [501] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:13:36.987 UTC [501] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.631 UTC [525] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.631 UTC [525] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:14:42.809 UTC [520] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.809 UTC [520] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:14:42.809 UTC [524] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:14:42.809 UTC [524] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p1."id", p1."latitude", p1."longitude", p2."id", p2."latitude", p2."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.816 UTC [529] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:14:42.816 UTC [529] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p1."id", p1."latitude", p1."longitude", p2."id", p2."latitude", p2."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.816 UTC [522] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.816 UTC [522] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:49.899 UTC [546] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:49.899 UTC [546] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:50.104 UTC [544] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:50.104 UTC [544] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:50.104 UTC [551] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:15:50.104 UTC [551] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:15:50.108 UTC [549] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:15:50.108 UTC [549] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:15:50.108 UTC [548] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:50.108 UTC [548] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:50.880 UTC [27] LOG: checkpoint starting: time
2025-01-24 17:16:51.004 UTC [27] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.005 s, total=0.124 s; sync files=2, longest=0.005 s, average=0.003 s; distance=12 kB, estimate=26 kB
2025-01-24 17:16:55.911 UTC [572] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:55.911 UTC [572] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:56.076 UTC [573] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:56.076 UTC [573] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:56.076 UTC [569] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:16:56.076 UTC [569] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:16:56.080 UTC [571] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:16:56.080 UTC [571] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:16:56.082 UTC [574] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:56.082 UTC [574] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.005 UTC [595] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.005 UTC [595] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.175 UTC [604] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.175 UTC [604] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.175 UTC [601] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:18:02.175 UTC [601] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:18:02.179 UTC [603] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:18:02.179 UTC [603] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:18:02.179 UTC [599] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.179 UTC [599] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.759 UTC [622] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.759 UTC [622] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.937 UTC [625] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.937 UTC [625] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.937 UTC [627] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:19:07.937 UTC [627] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:19:07.941 UTC [623] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.941 UTC [623] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.941 UTC [628] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:19:07.941 UTC [628] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.517 UTC [648] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.517 UTC [648] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:20:14.685 UTC [651] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:20:14.685 UTC [651] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.686 UTC [649] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.686 UTC [649] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:20:14.689 UTC [652] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:20:14.689 UTC [652] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.690 UTC [643] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.690 UTC [643] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.122 UTC [667] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.122 UTC [667] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.279 UTC [674] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.279 UTC [674] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.279 UTC [673] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:21:21.279 UTC [673] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:21:21.284 UTC [669] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:21:21.284 UTC [669] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:21:21.284 UTC [670] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.284 UTC [670] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi,
today I had issues with my docker based setup on a raspy. My evcc did not respond. Therefore I restored a backup from the day before. Nice cvcc worked again - but the teslamate container does not work anymore. Seems the file in ram was ok as it worked like a charm before but the backup (SD clone tech night) seems defect. I have three nights - all defect!
Is there a way to fix the DB. Otherwise I loose more than a year of data...
This is the error:
2025-01-24 17:12:30.328 UTC [475] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:12:30.328 UTC [475] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:12:30.332 UTC [473] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:12:30.332 UTC [473] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:12:30.332 UTC [471] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:12:30.332 UTC [471] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:13:36.781 UTC [497] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.781 UTC [497] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.981 UTC [503] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:13:36.981 UTC [503] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:13:36.982 UTC [504] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.982 UTC [504] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.987 UTC [502] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:13:36.987 UTC [502] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:13:36.987 UTC [501] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:13:36.987 UTC [501] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.631 UTC [525] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.631 UTC [525] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:14:42.809 UTC [520] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.809 UTC [520] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:14:42.809 UTC [524] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:14:42.809 UTC [524] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p1."id", p1."latitude", p1."longitude", p2."id", p2."latitude", p2."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.816 UTC [529] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:14:42.816 UTC [529] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p1."id", p1."latitude", p1."longitude", p2."id", p2."latitude", p2."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:14:42.816 UTC [522] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:14:42.816 UTC [522] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:49.899 UTC [546] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:49.899 UTC [546] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:50.104 UTC [544] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:50.104 UTC [544] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:15:50.104 UTC [551] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:15:50.104 UTC [551] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:15:50.108 UTC [549] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:15:50.108 UTC [549] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:15:50.108 UTC [548] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:15:50.108 UTC [548] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:50.880 UTC [27] LOG: checkpoint starting: time
2025-01-24 17:16:51.004 UTC [27] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.005 s, total=0.124 s; sync files=2, longest=0.005 s, average=0.003 s; distance=12 kB, estimate=26 kB
2025-01-24 17:16:55.911 UTC [572] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:55.911 UTC [572] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:56.076 UTC [573] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:56.076 UTC [573] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:16:56.076 UTC [569] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:16:56.076 UTC [569] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:16:56.080 UTC [571] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:16:56.080 UTC [571] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:16:56.082 UTC [574] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:16:56.082 UTC [574] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.005 UTC [595] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.005 UTC [595] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.175 UTC [604] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.175 UTC [604] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:18:02.175 UTC [601] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:18:02.175 UTC [601] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:18:02.179 UTC [603] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:18:02.179 UTC [603] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:18:02.179 UTC [599] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:18:02.179 UTC [599] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.759 UTC [622] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.759 UTC [622] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.937 UTC [625] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.937 UTC [625] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.937 UTC [627] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:19:07.937 UTC [627] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:19:07.941 UTC [623] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:19:07.941 UTC [623] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:19:07.941 UTC [628] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:19:07.941 UTC [628] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.517 UTC [648] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.517 UTC [648] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:20:14.685 UTC [651] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:20:14.685 UTC [651] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.686 UTC [649] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.686 UTC [649] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:20:14.689 UTC [652] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:20:14.689 UTC [652] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:20:14.690 UTC [643] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:20:14.690 UTC [643] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.122 UTC [667] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.122 UTC [667] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.279 UTC [674] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.279 UTC [674] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d1."start_date" > $1) AND (p0."id" > $2)) GROUP BY p0."drive_id" HAVING (count() FILTER (WHERE NOT (p0."odometer" IS NULL) AND (p0."ideal_battery_range_km" IS NULL)) = 0)
2025-01-24 17:21:21.279 UTC [673] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:21:21.279 UTC [673] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:21:21.284 UTC [669] ERROR: could not read block 56 in file "base/16384/17068": read only 0 of 8192 bytes
2025-01-24 17:21:21.284 UTC [669] STATEMENT: SELECT d0."id", d0."car_id", d0."start_date", p2."id", p2."latitude", p2."longitude", p1."id", p1."latitude", p1."longitude" FROM "drives" AS d0 INNER JOIN "positions" AS p1 ON p1."id" = d0."start_position_id" INNER JOIN "positions" AS p2 ON p2."id" = d0."end_position_id" WHERE (((d0."start_address_id" IS NULL) OR (d0."end_address_id" IS NULL)) AND (NOT (d0."start_position_id" IS NULL) AND NOT (d0."end_position_id" IS NULL))) ORDER BY d0."id" DESC LIMIT $1
2025-01-24 17:21:21.284 UTC [670] ERROR: could not read block 13616 in file "base/16384/17218": read only 0 of 8192 bytes
2025-01-24 17:21:21.284 UTC [670] STATEMENT: SELECT p0."drive_id" FROM "positions" AS p0 INNER JOIN "drives" AS d1 ON d1."id" = p0."drive_id" WHERE ((d
Beta Was this translation helpful? Give feedback.
All reactions