JDBCCollector Appears to Be Broken - stores last value only
Description
Environment
Acceptance / Success Criteria
Attachments
Lucidchart Diagrams
Activity
Alejandro Galue October 21, 2011 at 10:29 AM
Based on my tests and the resulted graphs, I can said that it works fine so I'm going to close this issue.
Fixed on revision 3652032c7be1b0563399eba5f167f75d22f94207 for 1.8
Fixed on revision 987ce22a98e8cc45779c06372c53ce03dec989f9 for 1.10
Alejandro Galue October 20, 2011 at 6:50 PM
Here is what I found on my tests about the usage of the attributes of the column element, after applying my patch.
For example, suppose that we have the following definition:
a) This will extract the data from the column named "Value" from the ResultSet returned by the query.
b) If storeByGroup=false, the name of the DS and the JRB will be the same as the alias. In the example, the DS will be "MyComStmtExecute", and the JRB will be "MyComStmtExecute.jrb"
c) If storeByGroup=true, the name of the DS will be the same as the alias, but the name of the JRB will be the name of the query (as expected). In the example, the DS will be "MyComStmtExecute", and the JRB will be "Com_stmt_execute.jrb"
d) _com_stmt_execute is the name that will be used internally for the AttributeGroupType. Here is what you will see in the logs:
We could make improvements in the future about the content of jdbc-datacollection-config.xml, but that means we should take extra care when upgrading OpenNMS because the configuration changed their format, so I suggest to just apply the patch that I suggested and update the wiki to reflect the following rules:
Set the attributes "name" and "alias" to be the same.
Set the attribute "data-source-name" to be the desired column from the ResourceSet.
Make sense?
Alejandro Galue October 20, 2011 at 6:14 PM
Based on a previous comment: "data-source-name refers to the name of the column in the ResultSet while the name attribute is your arbitrary given name"; and keeping untouched the current information on the Wiki related with MySQL and JDBC Collector, the fix for this issue is as simple as the following:
Certainly I'm agree with Tarus comments about the proper names and configuration of jdbc-datacollection, but for now this is the simplest solution to solves the problem and keep wiki untouched.
I tested the solution and it works as expected with 1.8. Because the code is not much different between 1.8 and 1.10, from JdbcCollector point of view, it should work on 1.10 too.
I'll make some additional tests before commit.
One of our customers is experiencing this issue.
Jeff Gehlbach May 4, 2011 at 7:14 AM
Check whether resolves this issue as well. I'm on site and don't have time to evaluate that myself, sorry.
Tarus Balog March 11, 2011 at 12:08 PM
Okay, with the attached patch I am now able to collect the data I need from MySQL 5.0 systems.
There is a change required to get the configs in the wiki to work. The data-source-name is now the column name (or field name) and the "name" attribute matches the alias attribute, so we now have:
<column name="MyUptime" data-source-name="Value" alias="MyUptime" type="GAUGE"/>
which duplicates name and alias. Plus, "data source" is synonymous with "alias" throughout OpenNMS, whereas here is seems to be used for choosing a column. I would suggest getting rid of "name" altogether, and changing data-source-name to field-name.
Anyway, I suggest we apply the attached patch to 1.8.11 and consider how to clean up the naming convention before closing this bug.
Trying to set up JDBC MySQL monitoring per this post on the wiki:
http://www.opennms.org/wiki/JDBC_Collection_configuration_for_MySQL
Unfortunately, I'm only getting the last value, MyThreadsRunng.
It looks like it is collecting all the values, but not iterating over the whole list.
Here is the log:
2011-03-10 16:11:03,379 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,379 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,379 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,379 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=12890060
2011-03-10 16:11:03,383 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=12890060
2011-03-10 16:11:03,383 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=12890060
2011-03-10 16:11:03,384 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:12890060'
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=17671545173358
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=17671545173358
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=17671545173358
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:17671545173358'
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=23815867921990
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=23815867921990
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=23815867921990
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:23815867921990'
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=25028
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=25028
2011-03-10 16:11:03,388 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=25028
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,388 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:25028'
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:0'
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=113375543
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=113375543
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=113375543
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:113375543'
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=6859
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=6859
2011-03-10 16:11:03,389 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=6859
2011-03-10 16:11:03,389 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:6859'
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=581183
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=581183
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=581183
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:581183'
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=972
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=972
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=972
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:972'
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=96647
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=96647
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=96647
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:96647'
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:0'
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,390 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,390 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=92665
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=92665
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=92665
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:92665'
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=785922
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=785922
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=785922
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:785922'
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=4294967296
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=4294967296
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=4294967296
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:4294967296'
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=1024
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=1024
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=1024
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:1024'
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,391 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=0
2011-03-10 16:11:03,391 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:0'
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=233109174656
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=233109174656
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=233109174656
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:233109174656'
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=680980075
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=680980075
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=680980075
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:680980075'
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=61903515014
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=61903515014
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=61903515014
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:61903515014'
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=1945983391
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=1945983391
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=1945983391
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:1945983391'
2011-03-10 16:11:03,392 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,392 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=1769
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=1769
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=1769
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:1769'
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=1144
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=1144
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=1144
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:1144'
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=6000
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting JdbcCollectionAttribute MyThreadsRunng=6000
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Storing attribute JdbcCollectionAttribute MyThreadsRunng=6000
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: createRRD: creating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: updating RRD file /opt/opennms/share/rrd/snmp/117/MyThreadsRunng.jrb with values '1299802263:6000'
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] RrdUtils: updateRRD: RRD update command completed.
2011-03-10 16:11:03,393 INFO [CollectdScheduler-50 Pool-fiber0] OneToOnePersister: Persisting data for resource Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: Visiting Group AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node]
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] AttributeGroup: AttrGroupType[name=Threads_running, ifType=all] for Node[117]/type[node].shouldPersist = true
2011-03-10 16:11:03,393 DEBUG [CollectdScheduler-50 Pool-fiber0] JdbcCollectionAttribute: Visiting attribute JdbcCollectionAttribute MyThreadsRunng=117662205
2011-03-10 16:11:03,393 DEBUG [Collec