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

Housekeeper does not count deleted records correctly with PostgreSQL

XMLWordPrintable

      When i was checking if the houskeeper was doing his job, i saw the following lines in the server logfile (old example, but still the same with 1.6.6)

      6928:20090122:202631 Deleted 0 records from history and trends
      6928:20090122:212737 Deleted 0 records from history and trends
      6928:20090122:222842 Deleted 0 records from history and trends
      6928:20090122:232948 Deleted 0 records from history and trends
      6928:20090123:003317 Deleted 0 records from history and trends
      6928:20090123:013448 Deleted 0 records from history and trends
      6928:20090123:024052 Deleted 0 records from history and trends

      My google-searches gave me the indication that counting the deleted records should not be done with PQntuples() in zbx_db_vexecute (zabbix-1.6.6\src\libs\zbxdb\db.c). When deleting/inserting/updating a record, the function PQcmdTuples() should give the correct count.

      After modification:

      30047:20090922:095640 Deleted 1273 records from history and trends
      30047:20090922:105747 Deleted 28503 records from history and trends

      Can a real programmer verify if this is the correct solution?

            sasha Alexander Vladishev
            alexei Alexei Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: