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

Sqlite database insert failures

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.6 (beta)
    • Fix Version/s: 1.9.7 (beta)
    • Component/s: Proxy (P)
    • Labels:
    • Environment:
      RHEL5 x64
      2 CPU and 6 GB RAM

      Description

      I'm running Zabbix 1.9.6 (compiled on my own) on RHEL5. My setup is that I have a main Zabbix server (16 CPU, 64GB RAM) that runs just fine. Along with that I have an active Zabbix proxy server (2CPU, 6GB RAM) that is having issues with its SQLite3 database.

      I have a discovery rule for the proxy that is having issues inserting data into the SQLite database. Every time the proxy tries to write to the database the following error shows up in the logs:

      [Z3005] query failed: [0] proxy_dhistory.dcheckid may not be NULL [insert into proxy_dhistory (clock,druleid,type,ip,dns,status) values (1316636599,2,-1,'ip.add.xxx.xxx','server.fqdn.com',1)]

      I have tried recompiling to account for any oddities that could've showed up, but it didn't make any difference.

      Now here's the real kicker: I have this exact same setup in another environment. That other environment works great without any problems. In fact, the scripts I use to do all the compilation/configuring/install were used in both environments. I have compared the configuration in the non-working environment to the working environment and both are identical (with the exception of server names of course).

      I have already verified that permissions on the file system were correct for the zabbix user to be able to write to the database. Everything checks out there.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            heaje Corey Shaw
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: