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
Hello,
I want to upgrade to the newer 2.0.X Teslamate versions but i can't create a valid backup file. Everything seems to work fine with the current database in V1.33.0, however the backup command fails on me:
I am not an expert in Database repair and i was hoping for a fix that does not require detailed knowledge of database structures. I messed around with REINDEX and VACUUM FULL but that seemed to made it worse. Any help from the community who experienced similar issues and found a solution?
docker compose --verbose exec -T database pg_dump -U teslamate --verbose teslamate > ./teslamate.bck pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
.
.
.
.
pg_dump: dumping contents of table "public.positions"
pg_dump: error: Dumping the contents of table "positions" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: invalid page in block 121423 of relation base/16384/17399
pg_dump: error: The command was: COPY public.positions (id, date, latitude, longitude, speed, power, odometer, ideal_battery_range_km, battery_level, outside_temp, elevation, fan_status, driver_temp_setting, passenger_temp_setting, is_climate_on, is_rear_defroster_on, is_front_defroster_on, car_id, drive_id, inside_temp, battery_heater, battery_heater_on, battery_heater_no_power, est_battery_range_km, rated_battery_range_km, usable_battery_level, tpms_pressure_fl, tpms_pressure_fr, tpms_pressure_rl, tpms_pressure_rr) TO stdout;
DEBU[0117] [hijack] End of stdout
steffi-pi1@raspberrypi:~ $
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
Uh oh!
There was an error while loading. Please reload this page.
-
Hello,
I want to upgrade to the newer 2.0.X Teslamate versions but i can't create a valid backup file. Everything seems to work fine with the current database in V1.33.0, however the backup command fails on me:
I am not an expert in Database repair and i was hoping for a fix that does not require detailed knowledge of database structures. I messed around with REINDEX and VACUUM FULL but that seemed to made it worse. Any help from the community who experienced similar issues and found a solution?
docker compose --verbose exec -T database pg_dump -U teslamate --verbose teslamate > ./teslamate.bck pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
.
.
.
.
pg_dump: dumping contents of table "public.positions"
pg_dump: error: Dumping the contents of table "positions" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: invalid page in block 121423 of relation base/16384/17399
pg_dump: error: The command was: COPY public.positions (id, date, latitude, longitude, speed, power, odometer, ideal_battery_range_km, battery_level, outside_temp, elevation, fan_status, driver_temp_setting, passenger_temp_setting, is_climate_on, is_rear_defroster_on, is_front_defroster_on, car_id, drive_id, inside_temp, battery_heater, battery_heater_on, battery_heater_no_power, est_battery_range_km, rated_battery_range_km, usable_battery_level, tpms_pressure_fl, tpms_pressure_fr, tpms_pressure_rl, tpms_pressure_rr) TO stdout;
DEBU[0117] [hijack] End of stdout
steffi-pi1@raspberrypi:~ $
Beta Was this translation helpful? Give feedback.
All reactions