Xormon 1.8.1 - Database system in recovery mode
I've built out Xormon 1.8.1 on a Linux Debian 12 VM in VMware. All works fine for a day or so but then every 1-2 days i will try to load the URL and get the following error from the URL;
{
"statusCode": 500,
"message": "the database system is in recovery mode"
}
I can ssh to the VM fine and i can run ./xormon.sh stop everything stops but when I try to stop i get the following error and asked to change the password for the DB which fails.
ERROR: Database connection denied. Used credentials:
DB_HOST=127.0.0.1
DB_PORT=5432
DB_USERNAME=postgres
DB_DATABASE=postgres
error: the database system is in recovery mode
ERROR: Database connection denied. Used credentials:
DB_HOST=127.0.0.1
DB_PORT=5432
DB_USERNAME=postgres
DB_DATABASE=postgres
error: the database system is in recovery mode
Incorrect password!
Do you want to change the password?(y)
Comments
-
Hello,
it is not about password, the database is down,
error: the database system is in recovery mode
run the commands below and let us know:
systemctl status 'postgresql*'if status is failed run the command below
journalctl -xeu postgresql-16.service -
Service is active when checking the status of the service and no entries from the second command.
I tried to stop and restart the service but it now wont load
Howdy, Stranger!
Categories
- 1.7K All Categories
- 113 XorMon
- 26 XorMon Original
- 170 LPAR2RRD
- 14 VMware
- 19 IBM i
- 2 oVirt / RHV
- 5 MS Windows and Hyper-V
- Solaris / OracleVM
- 1 XenServer / Citrix
- Nutanix
- 8 Database
- 2 Cloud
- 10 Kubernetes / OpenShift / Docker
- 139 STOR2RRD
- 20 SAN
- 7 LAN
- 19 IBM
- 7 EMC
- 12 Hitachi
- 5 NetApp
- 17 HPE
- 1 Lenovo
- 1 Huawei
- 3 Dell
- Fujitsu
- 2 DataCore
- INFINIDAT
- 4 Pure Storage
- Oracle