>
>The SnmpInterfaceUpgrade is just a place holder to parse the ResultSet.
Maybe I'm missing something inside that class, or something else. I'm trying
to see if I can put some defensive code and do more validations, because the
exception is not providing too much details (maybe adding the exception's
class name could help).
>
Well, interestingly the query does return results.
SELECT n.nodeid, n.foreignsource, n.foreignid, i.snmpifdescr, i.snmpifname,
i.snmpphysaddr from node n, snmpinterface i where n.nodeid = i.nodeid and
i.snmpcollect in ('C','UC') and i.snmpphysaddr is not null;
~~~8<~~~
(10807 rows)
One thing I did notice however, was that the some of the returned values
maybe unexpected :)
SELECT n.nodeid, n.foreignsource, n.foreignid, i.snmpifdescr, i.snmpifname,
i.snmpphysaddr from node n, snmpinterface i where n.nodeid = i.nodeid and
i.snmpcollect in ('C','UC') and i.snmpphysaddr is not null and
i.snmpphysaddr='';
~~~8<~~~
(115 rows)
..in other words, some of the snmpinterface entries are not null, but
"nothing" or "blank".
I also noticed, and this may or may not be an issue, that snmpifname is
sometimes null, even though snmpifdescr is populated:
SELECT n.nodeid, n.foreignsource, n.foreignid, i.snmpifdescr, i.snmpifname,
i.snmpphysaddr from node n, snmpinterface i where n.nodeid = i.nodeid and
i.snmpcollect in ('C','UC') and i.snmpphysaddr is not null and snmpifname is
null;
~~~8<~~~
(456 rows)
If these unexpected results are the issue, I guess you could either update
the query or add some more handling in your parsing logic.
What do you think?
Cheers,
jcat
--
View this message in context:
http://opennms.530661.n2.nabble.com/1-12-Upgrade-tools-failure-for-many-rrd-files-tp7585683p7585758.html
Sent from the OpenNMS - devel mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
