Ad Widget

Collapse

Housekeeper and PostgreSQL: Deleted 0 records

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MrFreeze
    Junior Member
    • Sep 2009
    • 1

    #1

    Housekeeper and PostgreSQL: Deleted 0 records

    When i was checking if the houskeeper was doing his job, i saw the following lines in de 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?
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    I registered it as https://support.zabbix.com/browse/ZBX-1055. Please expect our response soon.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    Working...