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.6K All Categories
- 73 XORMON NG
- 25 XORMON
- 160 LPAR2RRD
- 14 VMware
- 18 IBM i
- 2 oVirt / RHV
- 4 MS Windows and Hyper-V
- Solaris / OracleVM
- XenServer / Citrix
- Nutanix
- 7 Database
- 2 Cloud
- 10 Kubernetes / OpenShift / Docker
- 133 STOR2RRD
- 20 SAN
- 7 LAN
- 19 IBM
- 5 EMC
- 12 Hitachi
- 5 NetApp
- 15 HPE
- Lenovo
- 1 Huawei
- 2 Dell
- Fujitsu
- 2 DataCore
- INFINIDAT
- 4 Pure Storage
- Oracle