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

Postgresql out of memory using timescaledb

    Details

    • Type: Incident report
    • Status: Need info
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.2.4
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Db: CentOS Linux 7, Postgresql 11.4, timescaledb-11-1.2.2
      Server: CentOS Linux 7, zabbix 4.2.4 (from RPM)

      Description

      Steps to reproduce:

      1. Install PgSQL 11 + timescaledb
      2. Configure with 9 proxies, with vps ~ 2200
      3. Restart zabbix-server process

      Result:
      On restart, the zabbix server sends a large UPDATE query that eventually exhausts available memory on the pgsql Server. Server is configured with 64Gb RAM, 40Gb Swap, with large work_mem to satisfy requirements of zabbix select queries.

       

      When this occurs, the history syncer processes do not update history and the database/server falls behind, generating multiple triggers and alerts.

      See log file...
      See memory dump...
      Expected:
      History syncer does not generate queries that exhaust database memory.

       

      Note: this appears to be the same issue reported in ZBX-9722 .

        Attachments

          Activity

            People

            • Assignee:
              neogan Andrei Gushchin
              Reporter:
              wsuzabbixapw Aaron Whiteman
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: