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

    • Icon: Documentation task Documentation task
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 6.0 (plan)
    • 4.0.30, 5.0.11, 5.2.6
    • Proxy (P), Server (S)
    • None
    • Team A
    • Sprint 76 (May 2021), Sprint 77 (Jun 2021)
    • 1

      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.

            martins-v Martins Valkovskis
            zux Edgars Melveris
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: