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

Postgres segfaults in timescaledb while performing "select distinct graphid from graphs_items where graphid=8842 and not itemid in (...)"

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 5.0.11
    • Server (S)
    • Debian Linux Buster amd64
      PostgreSQL 12.6-1.pgdg100+1
      timescaledb-2-postgresql-12 2.2.0~debian10

      TImescaledb segfaults when running a Zabbix query:

      LOG: server process (PID 13688) was terminated by signal 11: Segmentation fault
      DETAIL: Failed process was running: select distinct graphid from graphs_items where graphid=8842 and not itemid in (66228 ,66239,66250,66261,66272,66283,66294)
      LOG: terminating any other active server processes

      In the OS log:

      kernel: [17617266.094283] postgres[13688]: segfault at 0 ip 00007f381a23826e sp 00007ffce0d6d2a0 error 4 in timescaledb-tsl-2.2.0.so[7
      f381a235000+54000]
      kernel: [17617266.103776] Code: 0f 0b 48 8b 04 25 08 00 00 00 0f 0b 48 8b 04 25 08 00 00 00 0f 0b 48 8b 04 25 00 00 00 00 0f 0b 48 8b
      04 25 00 00 00 00 0f 0b <48> 8b 04 25 00 00 00 00 0f 0b 48 89 04 25 00 00 00 00 0f 0b 48 8b

      Steps to reproduce:

      I don't know how to reproduce it. Moreover, if you tell me this is not a Zabbix-related issue I'll try to open a case with the Timescaledb people.

            zabbix.support Zabbix Support Team
            vas_mpeks Victor Sudakov
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: