Postgresql strange housekeepers code

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: 1.6
    • Component/s: None
    • None
    • Environment:
      FreeBSD7 postgresql 8.3

      grep oid zabbix-1.6/create/schema/postgresql.sql
      snmp_oid varchar(255) DEFAULT '' NOT NULL,

      while housekeeper.c has

      #elif defined(HAVE_POSTGRESQL)
      deleted = DBexecute("delete from %s where oid in (select oid from %s where %s=" ZBX_FS_UI64 " limit 500)",
      housekeeper.tablename,
      housekeeper.tablename,
      housekeeper.field,
      housekeeper.value);

      So in my logs I get lot's of errors about not haveing oid like
      Oct 2 19:20:07 clu004 postgres[15302]: [7-1] ERROR: column "oid" does not exist at character 42
      Oct 2 19:20:07 clu004 postgres[15302]: [7-2] STATEMENT: delete from history where oid in (select oid from history where itemid=121680 limit 500)

            Assignee:
            Alexei Vladishev
            Reporter:
            Zaitsev Kirill (teferi)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: