Strange Poller Problem

[ambrose]

I have run into an issue with not being able to graph interface statistics for one of my hosts. Running with Debug, I see the following logs for this data source:

Code: Select all

03/01/2007 02:15:18 PM - CMDPHP: Poller[0] Host[67] DS[4245] SNMP: v2: 10.25.99.5, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 3485673249
03/01/2007 02:15:18 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (4245,'traffic_in','2007-0
3-01 14:15:16','U')"

Why is the poller inserting a, 'U' into the database for this datasource instead of the returned output(3485673249)?

[TheWitness]

This is quite odd. I thought it was an issue with 64bit vs. 32bit, but the number is not high enough. What is your version of PHP? Are there any updates available? I suspect a PHP core function issue because I am doing lot's of cleanup for various buggy agents using regular expressions and the like.

Run the following in MEDIUM, see if you get any warnings:

php -q cmd.php 67 67

TheWitness

[ambrose]

Yes this is very odd. I ran the command you mentioned, but it did not result in any errors or warnings in the logs. Thanks for the advice, I'll look into upgrading PHP. I'm currently running php version 5.1.2. The device I am polling is a Cisco Pix 525. As a note, I am actually monitoring interfaces on another Pix 525, and it isn't experiencing the same issue:

Code: Select all

03/01/2007 02:35:03 PM - CMDPHP: Poller[0] Host[9] DS[175] SNMP: v2: hpix, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, output: 2381141943
03/01/2007 02:35:03 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (175,'traffic_in','2007-03
-01 14:35:02','2381141943')"

[TheWitness]

Don't goto 5.2.1 unless you get the latest cmd.php from SVN BRANCH_0_8_6 though.

TheWitness