Error 'OpenNMS Disconnect -- is the OpenNMS daemon running?' after upgrade
"Ross Gailer" <[email protected]>
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
Our OpenNMS upgraded over the weekend when we executed an apt-get
upgrade on our Ubuntu server.
Config:
OpenNMS 1.8.10 (from web console)
Ubuntu Server 9.10
Postrgresql 8.3
All services are listed as running:
root@armbk02:/var/log/opennms/controller# /etc/init.d/opennms status
OpenNMS.Eventd : running
OpenNMS.Trapd : running
OpenNMS.Queued : running
OpenNMS.Dhcpd : running
OpenNMS.Actiond : running
OpenNMS.Capsd : running
OpenNMS.Notifd : running
OpenNMS.Scriptd : running
OpenNMS.Rtcd : running
OpenNMS.Pollerd : running
OpenNMS.PollerBackEnd : running
OpenNMS.Ticketer : running
OpenNMS.Collectd : running
OpenNMS.Threshd : running
OpenNMS.Discovery : running
OpenNMS.Vacuumd : running
OpenNMS.EventTranslator: running
OpenNMS.PassiveStatusd : running
OpenNMS.Statsd : running
OpenNMS.Provisiond : running
OpenNMS.Reportd : running
OpenNMS.Alarmd : running
OpenNMS.AsteriskGateway: running
OpenNMS.Ackd : running
OpenNMS.JettyServer : running
opennms is running
Stopped OpenNMS, cleaned out all logs, restarted. Following received on
startup:
Starting Open Network Management System: opennmsStarted OpenNMS, but it
has not finished starting up
Checked error logs:
collectd.log:2011-02-28 11:46:56,212 ERROR [CollectdScheduler-50
Pool-fiber0] RunnableConsumerThreadPool$FiberThreadImpl: No error
listeners defined for unexpected error:
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
could not execute query; uncategorized SQLException for SQL [select
distinct onmsipinte0_.id as id4_, onmsipinte0_.ipAddr as ipAddr4_,
onmsipinte0_.ipHostName as ipHostName4_, onmsipinte0_.ipLastCapsdPoll as
ipLastCa4_4_, onmsipinte0_.isManaged as isManaged4_,
onmsipinte0_.isSnmpPrimary as isSnmpPr6_4_, onmsipinte0_.nodeId as
nodeId4_, onmsipinte0_.snmpInterfaceId as snmpInte8_4_ from ipInterface
onmsipinte0_ inner join ifServices monitoreds1_ on
onmsipinte0_.id=monitoreds1_.ipInterfaceId, service onmsservic2_ where
monitoreds1_.serviceId=onmsservic2_.serviceId and
onmsservic2_.serviceName=?]; SQL state [25P02]; error code [0]; ERROR:
current transaction is aborted, commands ignored until end of
transaction block; nested exception is
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block
collectd.log:org.springframework.jdbc.UncategorizedSQLException:
Hibernate operation: could not execute query; uncategorized SQLException
for SQL [select distinct onmsipinte0_.id as id4_, onmsipinte0_.ipAddr as
ipAddr4_, onmsipinte0_.ipHostName as ipHostName4_,
onmsipinte0_.ipLastCapsdPoll as ipLastCa4_4_, onmsipinte0_.isManaged as
isManaged4_, onmsipinte0_.isSnmpPrimary as isSnmpPr6_4_,
onmsipinte0_.nodeId as nodeId4_, onmsipinte0_.snmpInterfaceId as
snmpInte8_4_ from ipInterface onmsipinte0_ inner join ifServices
monitoreds1_ on onmsipinte0_.id=monitoreds1_.ipInterfaceId, service
onmsservic2_ where monitoreds1_.serviceId=onmsservic2_.serviceId and
onmsservic2_.serviceName=?]; SQL state [25P02]; error code [0]; ERROR:
current transaction is aborted, commands ignored until end of
transaction block; nested exception is
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block
misc.log:2011-02-28 11:46:55,618 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] A PooledConnection that has
already signalled a Connection error is still in use!
misc.log:2011-02-28 11:46:55,673 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] Another error has occurred [
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block ] which will
not be reported to listeners!
misc.log:2011-02-28 11:46:55,724 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] A PooledConnection that has
already signalled a Connection error is still in use!
misc.log:2011-02-28 11:46:55,725 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] Another error has occurred [
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block ] which will
not be reported to listeners!
misc.log:2011-02-28 11:46:55,747 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] A PooledConnection that has
already signalled a Connection error is still in use!
misc.log:2011-02-28 11:46:55,747 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] Another error has occurred [
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block ] which will
not be reported to listeners!
misc.log:2011-02-28 11:46:55,826 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] A PooledConnection that has
already signalled a Connection error is still in use!
misc.log:2011-02-28 11:46:55,826 WARN [CollectdScheduler-50
Pool-fiber0] NewPooledConnection: [c3p0] Another error has occurred [
org.postgresql.util.PSQLException: ERROR: current transaction is
aborted, commands ignored until end of transaction block ] which will
not be reported to listeners!
misc.log:2011-02-28 11:47:20,291 ERROR
[databaseReport_QuartzSchedulerThread] ErrorLogger: An error occured
while scanning for the next trigger to fire.
spring.log:2011-02-28 11:46:55,932 INFO [CollectdScheduler-50
Pool-fiber0] XmlBeanDefinitionReader: Loading XML bean definitions from
class path resource
[org/springframework/jdbc/support/sql-error-codes.xml]
Note that I have confirmed that the Postrgresql is running and is
accessible with the specified userid and password. Copying the SQL
statement into mypgadmin throws an error of:
RROR: operator does not exist: character varying =?
LINE 1: ...viceId=onmsservic2_.serviceId and onmsservic2_.serviceName=?
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
In statement:
select distinct onmsipinte0_.id as id4_, onmsipinte0_.ipAddr as
ipAddr4_, onmsipinte0_.ipHostName as ipHostName4_,
onmsipinte0_.ipLastCapsdPoll as ipLastCa4_4_, onmsipinte0_.isManaged as
isManaged4_, onmsipinte0_.isSnmpPrimary as isSnmpPr6_4_,
onmsipinte0_.nodeId as nodeId4_, onmsipinte0_.snmpInterfaceId as
snmpInte8_4_ from ipInterface onmsipinte0_ inner join ifServices
monitoreds1_ on onmsipinte0_.id=monitoreds1_.ipInterfaceId, service
onmsservic2_ where monitoreds1_.serviceId=onmsservic2_.serviceId and
onmsservic2_.serviceName=?
Ross Gailer
Manager
Data Info Tech
82 Glen Innes Road
PO Box 1775
Armidale NSW 2350
Phone: 02 6771 1999
www.datainfotech.com.au <http://www.datainfotech.com.au/>
Think before you print. Please don't print this email unless it's
really necessary
The contents of this e-mail are strictly confidential. If you are not
the intended recipient, any use, disclosure or copying of this e-mail
(including any attachments) is unauthorised and prohibited. This email
may contain opinions of the author and these may not reflect those of
Data Info Tech Pty Limited. If you have received this e-mail in error,
please notify Data Info Tech immediately by return e-mail and then
delete the message from your system.
Data Info Tech Pty Limited ABN 70 113 905 061
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-install mailing list
To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install