VMware vSphere

 View Only
  • 1.  Multiple PostgreSQL Service Health Alarms daily

    Posted May 16, 2022 07:40 PM

    I'm getting these alarms multiple times a day where the status goes back and forth between Normal and Warning.

     

    I looked in the /var/log/vmware/vpostgres/postgresql-16.log and I'm seeing these messages repeated.  Everything seems to be running fine other than this

    Version 7.0.3.00500

     

    2022-05-16 14:29:09.327 UTC 62825cd8.1caa2 0 LOG: Updating instance status...
    2022-05-16 14:29:09.327 UTC 62825cd8.1caa2 0 LOG: Checking bloat of WAL caused by replication slots
    2022-05-16 14:29:09.327 UTC 62825cd8.1caa2 0 LOG: Memory check: flag = rss, mem_used_bytes = 418152 kB, mem_avail = 1308672 kB
    2022-05-16 14:29:09.327 UTC 62825cd8.1caa2 0 LOG: Writing instance status...
    2022-05-16 14:29:09.329 UTC 62825cd8.1caa2 0 LOG: Wrote instance status successfully.
    2022-05-16 14:29:09.329 UTC 62825cd8.1caa2 0 LOG: Updated instance status successfully.
    2022-05-16 14:29:22.366 UTC 62825f9f.717e 0 VCDB vc LOG: could not receive data from client: Connection reset by peer
    2022-05-16 14:29:22.366 UTC 62825f9f.717e 0 VCDB vc LOG: unexpected EOF on client connection with an open transaction
    2022-05-16 14:29:33.477 UTC 62825cd8.1caa2 0 LOG: Updating instance status...
    2022-05-16 14:29:33.477 UTC 62825cd8.1caa2 0 LOG: Checking bloat of WAL caused by replication slots
    2022-05-16 14:29:33.477 UTC 62825cd8.1caa2 0 LOG: Memory check: flag = rss, mem_used_bytes = 423388 kB, mem_avail = 1308672 kB
    2022-05-16 14:29:33.478 UTC 62825cd8.1caa2 0 LOG: Writing instance status...
    2022-05-16 14:29:33.478 UTC 62825cd8.1caa2 0 LOG: Wrote instance status successfully.
    2022-05-16 14:29:33.478 UTC 62825cd8.1caa2 0 LOG: Updated instance status successfully.
    2022-05-16 14:29:34.848 UTC 62825cd8.1caa2 0 LOG: Updating instance status...
    2022-05-16 14:29:34.848 UTC 62825cd8.1caa2 0 LOG: Checking bloat of WAL caused by replication slots
    2022-05-16 14:29:34.849 UTC 62825cd8.1caa2 0 LOG: Memory check: flag = rss, mem_used_bytes = 424048 kB, mem_avail = 1308672 kB
    2022-05-16 14:29:34.849 UTC 62825cd8.1caa2 0 LOG: Writing instance status...
    2022-05-16 14:29:34.850 UTC 62825cd8.1caa2 0 LOG: Wrote instance status successfully.
    2022-05-16 14:29:34.850 UTC 62825cd8.1caa2 0 LOG: Updated instance status successfully.
    2022-05-16 14:29:53.146 UTC 62825fe1.775d 0 root root FATAL: password authentication failed for user "root"
    2022-05-16 14:29:53.146 UTC 62825fe1.775d 0 root root DETAIL: Role "root" does not exist.
    Connection matched pg_hba.conf line 7: "local all all md5"



  • 2.  RE: Multiple PostgreSQL Service Health Alarms daily

    Posted May 17, 2022 05:15 PM

    7.0.3.00600 is available as of this week. When did this start?



  • 3.  RE: Multiple PostgreSQL Service Health Alarms daily

    Posted May 17, 2022 05:27 PM

    I was seeing this in  7.0.2 and I'm still seeing it after the upgrade.