SELECT DISTINCT ipInterface.ipAddr FROM ipInterface WHERE (iplike(ipInterface.IPADDR, '*.*.*.*'))
2006-09-12 15:33:24,505 WARN  [OpenNMS.Collectd] EventIpcManagerDefaultImpl$ListenerThread: run: an unexpected error occured during ListenerThread OpenNMS.Collectd r
un
java.lang.IllegalStateException: Cannot set ifIndex if snmpInterface relation isn't setup
        at org.opennms.netmgt.model.OnmsIpInterface.setIfIndex(OnmsIpInterface.java:233)
        at org.opennms.netmgt.dao.jdbc.ipif.IpInterfaceFactory.assignId(IpInterfaceFactory.java:62)
        at org.opennms.netmgt.dao.jdbc.Factory.createWithId(Factory.java:70)
        at org.opennms.netmgt.dao.jdbc.Factory.get(Factory.java:61)
        at org.opennms.netmgt.dao.jdbc.Cache.obtain(Cache.java:118)
        at org.opennms.netmgt.dao.jdbc.monsvc.MonitoredServiceFactory.assignId(MonitoredServiceFactory.java:65)
        at org.opennms.netmgt.dao.jdbc.Factory.createWithId(Factory.java:70)
        at org.opennms.netmgt.dao.jdbc.Factory.get(Factory.java:61)
        at org.opennms.netmgt.dao.jdbc.Cache.obtain(Cache.java:118)
        at org.opennms.netmgt.dao.jdbc.monsvc.MonitoredServiceMapper.mapRow(MonitoredServiceMapper.java:30)
        at org.opennms.netmgt.dao.jdbc.monsvc.MonitoredServiceMappingQuery.mapRow(MonitoredServiceMappingQuery.java:71)
        at org.springframework.jdbc.object.MappingSqlQuery.mapRow(MappingSqlQuery.java:64)
        at org.springframework.jdbc.object.MappingSqlQueryWithParameters$RowMapperImpl.mapRow(MappingSqlQueryWithParameters.java:115)
        at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:97)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:531)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:467)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:519)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:544)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:576)
        at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:104)
        at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:114)
        at org.opennms.netmgt.dao.jdbc.monsvc.MonitoredServiceMappingQuery.findUnique(MonitoredServiceMappingQuery.java:83)
        at org.opennms.netmgt.dao.jdbc.MonitoredServiceDaoJdbc.get(MonitoredServiceDaoJdbc.java:162)
        at org.opennms.netmgt.collectd.Collectd.scheduleInterface(Collectd.java:286)
        at org.opennms.netmgt.collectd.Collectd.scheduleForCollection(Collectd.java:791)
        at org.opennms.netmgt.collectd.Collectd.handlePrimarySnmpInterfaceChanged(Collectd.java:899)
        at org.opennms.netmgt.collectd.Collectd.onEvent(Collectd.java:422)
        at org.opennms.netmgt.eventd.EventIpcManagerDefaultImpl$ListenerThread.run(EventIpcManagerDefaultImpl.java:172)
        at java.lang.Thread.run(Thread.java:595)