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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Won't fix
    • Affects Version/s: 5.0.11
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Debian Linux Buster amd64
      PostgreSQL 12.6-1.pgdg100+1
      timescaledb-2-postgresql-12 2.2.0~debian10

      Description

      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.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: