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

Postgresql out of memory using timescaledb

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.4
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Db: CentOS Linux 7, Postgresql 11.4, timescaledb-11-1.2.2
      Server: CentOS Linux 7, zabbix 4.2.4 (from RPM)
    • Team:
      Team C
    • Sprint:
      Sprint 63 (Apr 2020), Sprint 64 (May 2020)
    • Story Points:
      1

      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

        1. image-2020-04-01-11-28-53-520.png
          image-2020-04-01-11-28-53-520.png
          6 kB
        2. pgsql.log
          121 kB
        3. zabbix_server.conf
          17 kB
        4. zabbix_server.log
          84 kB

          Issue Links

            Activity

              People

              Assignee:
              arimdjonoks Artjoms Rimdjonoks
              Reporter:
              wsuzabbixapw Aaron Whiteman
              Votes:
              34 Vote for this issue
              Watchers:
              51 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: