[opennms-devel] No preformance data

[Bradley W. <bra...@po...>]

I'm running 1.3.2 and I don't get any performance data.  A look at the
collectd.log shows:

=20

2006-07-05 23:01:06,096 DEBUG [BootStrapper] Collectd: start: Collectd
running

2006-07-05 23:01:06,104 DEBUG [CollectdScheduler-50 Pool] Scheduler:
run: scheduler running

2006-07-05 23:01:06,105 DEBUG [CollectdScheduler-50 Pool] Scheduler:
run: found ready runnable org.opennms.netmgt.collectd.Collectd$1@9733fa

2006-07-05 23:01:06,169 DEBUG [CollectdScheduler-50 Pool]
RunnableConsumerThreadPool$SizingFifoQueue: adjust: started fiber
CollectdScheduler-50 Pool-fiber0 ratio =3D 1.0, alive =3D 0

2006-07-05 23:01:06,169 DEBUG [CollectdScheduler-50 Pool] Scheduler:
run: no ready runnables scheduled, waiting...

2006-07-05 23:01:06,174 DEBUG [CollectdScheduler-50 Pool-fiber0]
Collectd: scheduleExistingInterfaces: svcName =3D JBoss32

2006-07-05 23:01:08,961 DEBUG [CollectdScheduler-50 Pool-fiber0]
RunnableConsumerThreadPool$FiberThreadImpl: run: an unexpected error
occured during fiber run, calling error liseners

2006-07-05 23:01:08,962 ERROR [CollectdScheduler-50 Pool-fiber0]
RunnableConsumerThreadPool$FiberThreadImpl: No error listeners defined
for for unexpected error=20

org.springframework.jdbc.BadSqlGrammarException:
PreparedStatementCallback; bad SQL grammar [SELECT nodeid, ipAddr,
ifIndex, serviceId, lastGood, lastFail, qualifier, status, source,
notify FROM ifservices, service where ifservices.serviceid =3D
service.serviceid and service.servicename =3D ? and ifservices.status !=3D
'D']; nested exception is org.postgresql.util.PSQLException: ERROR:
column reference "serviceid" is ambiguous

org.postgresql.util.PSQLException: ERROR: column reference "serviceid"
is ambiguous

        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1512)

        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1297)

        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:430)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:346)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:250)

        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxy
PreparedStatement.java:76)

        at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcT
emplate.java:535)

        at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476
)

        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)

        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)

        at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)

        at
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:114)

        at
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:201)

        at
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:209)

        at
org.opennms.netmgt.dao.jdbc.MonitoredServiceDaoJdbc.findByType(Monitored
ServiceDaoJdbc.java:183)

        at
org.opennms.netmgt.collectd.Collectd.scheduleExistingInterfaces(Collectd
.java:346)

        at
org.opennms.netmgt.collectd.Collectd.access$000(Collectd.java:79)

        at org.opennms.netmgt.collectd.Collectd$1.run(Collectd.java:204)

        at
org.opennms.core.concurrent.RunnableConsumerThreadPool$FiberThreadImpl.r
un(RunnableConsumerThreadPool.java:412)

        at java.lang.Thread.run(Thread.java:534)


CONFIDENTIAL:=20=20
The information contained in this email communication is confidential infor=
mation intended only for the use of the addressee.  Unauthorized use, discl=
osure or copying of this communication is strictly prohibited and may be un=
lawful.  If you have received this communication in error, please notify us=
 immediately by return email and destroy all copies of this communication, =
including all attachments.