Dear All
I found that the inventory service is not starting up and look up the log in C:ProgramDataVMwarevCenterServerlogsvpostgres
The DB status is always in “starting up” with FATAL. Does anyone know how to fix it? Please find attached logs.
2019-10-08 14:28:33.079 HKT 5d9c2c91.a0c 0 VCDB vc FATAL: the database system is starting up
2019-10-08 14:29:48.425 HKT 5d9c0db9.2104 0 LOG: received fast shutdown request
2019-10-08 15:09:16.702 HKT 5d9c361c.2790 0 LOG: database system was interrupted while in recovery at 2019-10-08 12:16:58 HKT
2019-10-08 15:09:16.702 HKT 5d9c361c.2790 0 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2019-10-08 15:10:02.234 HKT 5d9c361c.2790 0 LOG: database system was not properly shut down; automatic recovery in progress
2019-10-08 15:10:02.241 HKT 5d9c361c.2790 0 LOG: redo starts at 41/83FE29B8
2019-10-08 15:10:05.853 HKT 5d9c361c.2790 0 LOG: redo done at 41/85FFF6D8
2019-10-08 15:10:05.853 HKT 5d9c361c.2790 0 LOG: last completed transaction was at log time 2019-10-06 05:45:05.252+08
2019-10-08 15:20:42.924 HKT 5d9c361c.2370 0 LOG: received fast shutdown request
2019-10-08 15:25:05.862 HKT 5d9c39d1.1870 0 LOG: database system was interrupted while in recovery at 2019-10-08 15:10:02 HKT
2019-10-08 15:25:05.862 HKT 5d9c39d1.1870 0 HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2019-10-08 15:25:09.850 HKT 5d9c39d1.1870 0 LOG: database system was not properly shut down; automatic recovery in progress
2019-10-08 15:25:09.874 HKT 5d9c39d1.1870 0 LOG: redo starts at 41/83FE29B8
2019-10-08 15:25:14.612 HKT 5d9c39d1.1870 0 LOG: redo done at 41/85FFF6D8
2019-10-08 15:25:14.618 HKT 5d9c39d1.1870 0 LOG: last completed transaction was at log time 2019-10-06 05:45:05.252+08
2019-10-08 15:25:25.159 HKT 5d9c39e5.1ad4 0 VCDB vc FATAL: the database system is starting up
2019-10-08 15:36:04.705 HKT 5d9c3c64.8b8 0 VCDB vc FATAL: the database system is starting up
2019-10-08 15:36:59.679 HKT 5d9c3c9b.1d8c 0 VCDB vc FATAL: the database system is starting up
2019-10-08 15:38:25.192 HKT 5d9c3cf1.270 0 VCDB vc FATAL: the database system is starting up
2019-10-08 15:42:38.272 HKT 5d9c3dee.1648 0 VCDB vc FATAL: the database system is starting up
2019-10-08 15:43:14.428 HKT 5d9c3e12.1f4c 0 VCDB vc FATAL: the database system is starting up