[opennms-devel] Fwd: Re: [opennms-discuss] eventd error after 1.3.10 upgrade
"DJ Gregor" <[email protected]>
| Newsgroups | gmane.network.opennms.bugs |
|---|---|
| Message-ID | <[email protected]> |
Sigh... so a nasty bug sneaked in with my eventd changes ~2 weeks ago
that affects events containing an IP that are not unique in the
database. The issue is that such events don't get persisted to the
database and all future processing on those events doesn't happen (alarm
persistence and broadcasting to interesting listeners, including
notifd). Should we roll a patch (e.g.: "put
AAA-opennms-services-bug2247-patch.jar into $OPENNMS_HOME/lib") or roll
1.3.11?
- djg
On Wed, 06 Feb 2008 23:42:30 -0500, "DJ Gregor" <[email protected]> said:
> This issue is resolved in trunk revision 8378.
>
> On Wed, 06 Feb 2008 23:17:00 -0500, "DJ Gregor" <[email protected]> said:
> > Okay. I've found it. It's a bug.
> >
> > http://bugzilla.opennms.org/show_bug.cgi?id=2247
> >
> > Previous versions would write out the first matching hostname to the
> > event entry in the database, even if its the hostname for that IP
> > address *on for a different node than the event* (this is another bug).
> >
> > The new code in 1.3.10 verifies that it only gets one row and if it gets
> > more than one, it throws the exception like you've seen. It should only
> > throw the exception if it finds multiple rows in the ipInterface table
> > for the same IP address *and* node ID. The problem is that right now it
> > only looks for entries in the ipInterface table by IP address, and in
> > your case, there are multiple nodes that have interfaces with the same
> > IP address in the database.
> >
> > I'm working on a fix now.
> >
> >
> > - djg
> >
> > On Thu, 07 Feb 2008 14:46:22 +1100, "Adam Cassar"
> > <[email protected]> said:
> > > Hello,
> > >
> > > Interesting, I have to f5 load balancers that onms for some reason has
> > > picked up twice and duplicating the interfaces.
> > >
> > > The f5 is sending snmp traps to onms which is causing the error.
> > >
> > > No I am not using the importer or provisioning groups of the web
> > > interface. Yes I do have several nodes with duplicate IP addresses.
> > >
> > > DJ Gregor wrote:
> > > > Doh! That is a problem, either with the code and/or your database
> > > > (probably the code because I was shortsighted when changing getHostName
> > > > in eventd). Does your database have the same IP address assigned to
> > > > multiple nodes, by chance? Are you using the importer (this includes
> > > > the "provisioning groups" feature of the web interface)?
> > > >
> > > > Look in your logs a few lines up for other lines with
> > > > "[EventHandlerPool-fiber1]". Do any of them have a node ID or an IP
> > > > address?
> > > >
> > > >
> > > > - djg
> > > >
> > > > On Thu, 07 Feb 2008 10:37:56 +1100, "Adam Cassar"
> > > > <[email protected]> said:
> > > >
> > > >> Hi Guys,
> > > >>
> > > >> Thanks for the great release.
> > > >>
> > > >> After the upgrade I am now getting this error in the eventd.log:
> > > >>
> > > >> What does it mean? Is it anything to be concerned about?
> > > >>
> > > >>
> > > >> 2008-02-07 10:35:59,200 WARN [EventHandlerPool-fiber1]
> > > >> DefaultEventHandlerImpl: Unknown exception processing event with
> > > >> processor org.opennms.netmgt.eventd.processor.JdbcEventWriter@1a3d191;
> > > >> not processing with any later processors. Exception:
> > > >> org.springframework.dao.IncorrectResultSizeDataAccessException:
> > > >> Incorrect result size: expected 1, actual 2
> > > >> org.springframework.dao.IncorrectResultSizeDataAccessException:
> > > >> Incorrect result size: expected 1, actual 2
> > > >> at
> > > >> org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:74)
> > > >> at
> > > >> org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:669)
> > > >> at
> > > >> org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:679)
> > > >> at
> > > >> org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:95)
> > > >> at
> > > >> org.opennms.netmgt.eventd.processor.JdbcEventWriter.getHostName(JdbcEventWriter.java:421)
> > > >> at
> > > >> org.opennms.netmgt.eventd.processor.JdbcEventWriter.getEventHost(JdbcEventWriter.java:452)
> > > >> at
> > > >> org.opennms.netmgt.eventd.processor.JdbcEventWriter.insertEvent(JdbcEventWriter.java:196)
> > > >> at
> > > >> org.opennms.netmgt.eventd.processor.JdbcEventWriter.process(JdbcEventWriter.java:127)
> > > >> at
> > > >> org.opennms.netmgt.eventd.DefaultEventHandlerImpl$EventHandlerRunnable.run(DefaultEventHandlerImpl.java:134)
> > > >> at
> > > >> org.opennms.core.concurrent.RunnableConsumerThreadPool$FiberThreadImpl.run(RunnableConsumerThreadPool.java:422)
> > > >> at java.lang.Thread.run(Thread.java:619)
> > > >>
> > > >> -------------------------------------------------------------------------
> > > >> This SF.net email is sponsored by: Microsoft
> > > >> Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > >> _______________________________________________
> > > >> Please read the OpenNMS Mailing List FAQ:
> > > >> http://www.opennms.org/index.php/Mailing_List_FAQ
> > > >>
> > > >> opennms-discuss mailing list
> > > >>
> > > >> To *unsubscribe* or change your subscription options, see the bottom of
> > > >> this page:
> > > >> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
> > > >>
> > > >
> > > > -------------------------------------------------------------------------
> > > > This SF.net email is sponsored by: Microsoft
> > > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > > _______________________________________________
> > > > Please read the OpenNMS Mailing List FAQ:
> > > > http://www.opennms.org/index.php/Mailing_List_FAQ
> > > >
> > > > opennms-discuss mailing list
> > > >
> > > > To *unsubscribe* or change your subscription options, see the bottom of this page:
> > > > https://lists.sourceforge.net/lists/listinfo/opennms-discuss
> > > >
> > > >
> > >
> > > --
> > > Adam Cassar
> > > ICT Manager
> > > NetRegistry
> > >
> > > email: [email protected]
> > >
> > > T +61 2 9699 6099 | F +61 2 9699 6088 | http://www.netregistry.com.au
> > > PO Box 270 Broadway, NSW 2007, Australia
> > >
> > > Domain Names | Email Solutions | Web Hosting | Dedicated Hosting |
> > > eCommerce | Online Marketing
> > >
> > >
> > > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Microsoft
> > > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > > _______________________________________________
> > > Please read the OpenNMS Mailing List FAQ:
> > > http://www.opennms.org/index.php/Mailing_List_FAQ
> > >
> > > opennms-discuss mailing list
> > >
> > > To *unsubscribe* or change your subscription options, see the bottom of
> > > this page:
> > > https://lists.sourceforge.net/lists/listinfo/opennms-discuss
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > Please read the OpenNMS Mailing List FAQ:
> > http://www.opennms.org/index.php/Mailing_List_FAQ
> >
> > opennms-discuss mailing list
> >
> > To *unsubscribe* or change your subscription options, see the bottom of
> > this page:
> > https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-discuss mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of
> this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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