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

[Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.2rc1, 2.3.0
    • Component/s: Server (S)
    • Environment:
      Hedhat 6.4 Linux server OS on VMWARE machine ( 8Gb memory , 50Gb disk )
      Zabbix 2.2.0 from sources compiled with gcc
      gcc-4.4.7-3.el6.x86_64
      php-5.3.3-22.el6.x86_64
      MySQL-server-5.6.15-1.el6.x86_64

      Description

      into the "zabbix_server.log" i find regular lines like this
      48751:20131218:093541.722 [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values (10137,1),(10138,1),(10139,1),(10140,1);]
      into the table "host_inventory" there are ONLY two lines ( i expect +- 400 lines )

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              vrbro Robert VERBERT
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: