search

matt-FFFFFF / hassio-addon-postgres

MIT License
2 stars 0 forks source link

PostgresSQL Add-On does not start properly #5

Closed LeChuck2909 closed 9 months ago

LeChuck2909 commented 9 months ago

Hi, i noticed that my Teslamate addon is not working anymore. When i restarted the Teslamate addon an checked the log i noticed that it seems to wait for the postgradesql addon. As this was not running i started it but it does not start up. This is the according log from the addon:

PostgreSQL Database directory appears to contain a database; Skipping initialization

2024-01-08 21:12:24.928 CET [7] LOG:  starting PostgreSQL 12.5 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.3.0) 9.3.0, 64-bit
2024-01-08 21:12:24.928 CET [7] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-01-08 21:12:24.928 CET [7] LOG:  listening on IPv6 address "::", port 5432
2024-01-08 21:12:24.929 CET [7] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-01-08 21:12:24.936 CET [34] LOG:  database system was interrupted while in recovery at 2024-01-08 21:04:29 CET
2024-01-08 21:12:24.936 CET [34] HINT:  This probably means that some data is corrupted and you will have to use the last backup for recovery.
2024-01-08 21:12:24.947 CET [34] LOG:  database system was not properly shut down; automatic recovery in progress
2024-01-08 21:12:24.948 CET [34] LOG:  redo starts at 0/59845848
2024-01-08 21:12:24.954 CET [34] PANIC:  could not access status of transaction 0
2024-01-08 21:12:24.954 CET [34] DETAIL:  Could not fsync file "pg_xact/0001": No error information.
2024-01-08 21:12:24.954 CET [34] CONTEXT:  WAL redo at 0/598B81D0 for CLOG/ZEROPAGE: page 46
2024-01-08 21:12:25.094 CET [7] LOG:  startup process (PID 34) was terminated by signal 6: Aborted
2024-01-08 21:12:25.094 CET [7] LOG:  aborting startup due to startup process failure
2024-01-08 21:12:25.098 CET [7] LOG:  database system is shut down

Im running HA 2024.1.2 and all went smooth up to now, i have no clue what could have triggered the issue. I googled some of the log messages, but without success. The Grafana HA Addon had a update quite recently, which i updated. Do you know what could be the issue ?

Thank you.

LeChuck2909 commented 9 months ago

i restored the db with restoring the addon via HA backup. in addition with reinstalling teslamate HA addon i ultimatively managed to get everything up and running again.