Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-16987

Recovery lag arise for master Postgres database after unclean shutdown restart

XMLWordPrintable

      Steps to reproduce:

      1. Create Postgresql master-slave replication servers
      2. Monitor it using standart Template DB PostgreSQL
      3. Start some workload (pgbench)
      4. Kill some process of master postgresql server with kill -9 <pid>

      Result:
      Restart master postgresql server
      Look at pgsql.replication.lag.sec item - the values start to rise.

      Expected:
      When postgres start after unclean shutdown it perform some initial recovery before database became open. That recover process involves some WAL replay, so pg_last_wal_replay_lsn() points to recovery end. A lag measured by pgsql.replication.lag.sql script grows linear by time.
      So i have covered original script with pg_is_in_recovery() function.

            drasikhov Denis Rasikhov
            iox Sergey
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: