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

Upgrade to 4.0 incorrectly sets request_method to 1 for all items

    XMLWordPrintable

    Details

    • Type: Documentation task
    • Status: Needs documenting
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.0.30, 5.0.11, 5.2.6
    • Fix Version/s: 6.0 (plan)
    • Component/s: Proxy (P), Server (S)
    • Labels:
      None
    • Team:
      Team A
    • Sprint:
      Sprint 76 (May 2021), Sprint 77 (Jun 2021)
    • Story Points:
      1

      Description

      Upgrade scripts seem to first set the default value of request_method to 1 and then to 0:

      grep -r request_method ./* 
      ./dbupgrade_3050.c: const ZBX_FIELD field = {"request_method", "1", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL | ZBX_PROXY, 0}; 
      ./dbupgrade_3050.c: const ZBX_FIELD field = {"request_method", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0};
      

      After a clean 3.4 DB was upgraded to 4.0 this is what that column contains:

      select request_method, count(*) from items group by 1;
      +----------------+----------+
      | request_method | count(*) |
      +----------------+----------+
      |              1 |     1656 |
      +----------------+----------+
      

      This column is only used for http agent items, but is exported as non-default value for all items.
      It might also cause "unforeseen consequences" in future.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              martins-v Martins Valkovskis
              Reporter:
              zux Edgars Melveris
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: