The Cacti Manual
Prev | Chapter 20. Command Line Scripts | Next

# Empty Poller Output Table

During normal poller operation, all retrieved results are intermediately stored in the table named `poller_output` After execution of cmd.php or Spine, this table holds all results. The poller.php finally issues all rrdtool update operations. Thus, after polling has completed, the table should be empty.

Conditions may arise, where the table is not (completely) emptied. The most often known issue is lack of php memory. In those cases, the table is bigger than the php memory size, thus not all items are handled correctly. If that issue occurs, you may save all pending updates after increasing PHP memory appropriately by running this very script. Calling the script with the parameter `--help` yields

    shell>php -q poller_output_empty.php --help
    Cacti Empty Poller Output Table Script 1.0, Copyright 2004-2010 - The Cacti Group

    usage: poller_output_empty.php [-h] [--help] [-v] [--version]

    -v --version  - Display this help message
    -h --help     - Display this help message

You see, no parameter is required for operating successfully. Under normal circumstances, running this script should yield

    shell>php -q poller_output_empty.php
    There were 0, RRD updates made this pass
    shell>

In case, you hit the poller process or if the table was really not fully processed, you may find

    shell>php -q poller_output_empty.php
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.04
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.00 r:0.05
    OK u:0.00 s:0.01 r:0.06
    There were 21, RRD updates made this pass
    shell>

If logging level verbosity was switched to `DEBUG` you may find additional debug messages that usually show up in `cacti.log`

Prev | Home | Next
Re-Index Hosts | Up | Reapply Suggested Names to Graphs