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

Postgresql out of memory using timescaledb

    XMLWordPrintable

    Details

    • 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

          Activity

            People

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

              Dates

              Created:
              Updated: