[Spacewalk-list] Problem enabling Monitoring

Kelle-Emden, Andreas kelle-emden at rz.rwth-aachen.de
Wed May 29 06:47:00 UTC 2013


Hello,

thank you for your reply!

> Do you have upgraded Satellite?

Yes. I initially installed version 1.7. Recently, I installed upgrades first
to 1.8 and then to 1.9.

> What does `rhn-schema-version` say?

[root at spacewalk ~]# rhn-schema-version
Traceback (most recent call last):
  File "/usr/bin/rhn-schema-version", line 62, in <module>
    options = processCommandline()
  File "/usr/bin/rhn-schema-version", line 58, in processCommandline
    return options
NameError: global name 'options' is not defined

> What is your OS version?

Scientific Linux 6.3.

> Can you find relevant pieces of these logs?
> 
> /var/log/httpd/*error_log
> /var/log/tomcat/catalina.out

error_log:

[Wed May 29 08:40:14 2013] [error] Exception KeyError:
KeyError(140042602940384,) in <module 'threading' from
'/usr/lib64/python2.6/threading.pyc'> ignored

(Same message appears more often, but only once at the time where I tried
enabling monitoring)


ssl_error_log is empty, catalina.out follows below.

Best regards,
Andreas



[root at spacewalk tomcat6]# cat catalina.out
2013-05-29 08:40:34,014 [TP-Processor11] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
2013-05-29 08:40:34,014 [TP-Processor11] ERROR
org.hibernate.util.JDBCExceptionReporter - ORA-01400: Einfügen von NULL in
("SPACEWALK"."RHN_SAT_CLUSTER"."PHYSICAL_LOCATION_ID") nicht möglich

2013-05-29 08:40:34,014 [TP-Processor11] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert:
[com.redhat.rhn.domain.monitoring.satcluster.SatCluster]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2267)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2660)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abst
ractFlushingEventListener.java:298)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAut
oFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811
)
        at
com.redhat.rhn.domain.monitoring.satcluster.SatClusterFactory.lookupSatNodeB
yCluster(SatClusterFactory.java:215)
        at
com.redhat.rhn.manager.satellite.ConfigureSatelliteCommand.enableMonitoring(
ConfigureSatelliteCommand.java:265)
        at
com.redhat.rhn.manager.satellite.ConfigureSatelliteCommand.storeConfiguratio
n(ConfigureSatelliteCommand.java:129)
        at
com.redhat.rhn.frontend.action.satellite.GeneralConfigAction.execute(General
ConfigAction.java:138)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:425)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        at
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcess
or.java:99)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:120)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter
.java:129)
        at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java
:77)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(Localiz
edEnvironmentFilter.java:67)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilte
r.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:5
5)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetChar
acterEncodingFilter.java:97)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102
)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java
:891)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:690)
        at java.lang.Thread.run(Thread.java:679)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
Einfügen von NULL in ("SPACEWALK"."RHN_SAT_CLUSTER"."PHYSICAL_LOCATION_ID")
nicht möglich

        at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)
        at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)
        at
oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatem
ent.java:546)
        at
oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.
java:729)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1329)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3584)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:3665)
        at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePrepar
edStatementWrapper.java:1352)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPre
paredStatement.java:469)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2247)
        ... 56 more
2013-05-29 08:40:34,015 [TP-Processor11] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception thrown:
class org.hibernate.exception.ConstraintViolationException
2013-05-29 08:40:34,015 [TP-Processor11] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
Rolling back
javax.servlet.ServletException:
org.hibernate.exception.ConstraintViolationException: could not insert:
[com.redhat.rhn.domain.monitoring.satcluster.SatCluster]
        at
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.
java:520)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:427)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
        at
com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcess
or.java:99)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
        at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:120)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter
.java:129)
        at
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java
:77)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(Localiz
edEnvironmentFilter.java:67)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilte
r.java:108)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:5
5)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetChar
acterEncodingFilter.java:97)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:235)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102
)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java
:891)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:690)
        at java.lang.Thread.run(Thread.java:679)
Caused by: org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.domain.monitoring.satcluster.SatCluster]
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
:43)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2267)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2660)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abst
ractFlushingEventListener.java:298)
        at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAut
oFlushEventListener.java:41)
        at
org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811
)
        at
com.redhat.rhn.domain.monitoring.satcluster.SatClusterFactory.lookupSatNodeB
yCluster(SatClusterFactory.java:215)
        at
com.redhat.rhn.manager.satellite.ConfigureSatelliteCommand.enableMonitoring(
ConfigureSatelliteCommand.java:265)
        at
com.redhat.rhn.manager.satellite.ConfigureSatelliteCommand.storeConfiguratio
n(ConfigureSatelliteCommand.java:129)
        at
com.redhat.rhn.frontend.action.satellite.GeneralConfigAction.execute(General
ConfigAction.java:138)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:425)
        ... 40 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400:
Einfügen von NULL in ("SPACEWALK"."RHN_SAT_CLUSTER"."PHYSICAL_LOCATION_ID")
nicht möglich

        at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)
        at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)
        at
oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatem
ent.java:546)
        at
oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.
java:729)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1329)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3584)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:3665)
        at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePrepar
edStatementWrapper.java:1352)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPre
paredStatement.java:469)
        at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntity
Persister.java:2247)
        ... 56 more
2013-05-29 08:40:34,019 [RHN Message Dispatcher] WARN
com.redhat.rhn.common.messaging.SmtpMail - MessagingException while trying
to send email: javax.mail.SendFailedException: Send failed;
  nested exception is:
        javax.mail.MessagingException: Connection refused;
  nested exception is:
        java.net.ConnectException: Connection refused
2013-05-29 08:40:34,019 [RHN Message Dispatcher] ERROR
com.redhat.rhn.common.messaging.ActionExecutor -
com.redhat.rhn.common.messaging.JavaMailException: MessagingException while
trying to send email: javax.mail.SendFailedException: Send failed;
  nested exception is:
        javax.mail.MessagingException: Connection refused;
  nested exception is:
        java.net.ConnectException: Connection refused
com.redhat.rhn.common.messaging.JavaMailException: MessagingException while
trying to send email: javax.mail.SendFailedException: Send failed;
  nested exception is:
        javax.mail.MessagingException: Connection refused;
  nested exception is:
        java.net.ConnectException: Connection refused
        at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:145)
        at
com.redhat.rhn.frontend.events.BaseMailAction.execute(BaseMailAction.java:43
)
        at
com.redhat.rhn.common.messaging.ActionExecutor.run(ActionExecutor.java:69)
        at
com.redhat.rhn.common.messaging.MessageDispatcher.run(MessageDispatcher.java
:58)
        at java.lang.Thread.run(Thread.java:679)
Caused by: javax.mail.SendFailedException: Send failed;
  nested exception is:
        javax.mail.MessagingException: Connection refused;
  nested exception is:
        java.net.ConnectException: Connection refused
        at javax.mail.Transport.doSend(Transport.java:231)
        at javax.mail.Transport.send(Transport.java:75)
        at com.redhat.rhn.common.messaging.SmtpMail.send(SmtpMail.java:139)
        ... 4 more


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5550 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130529/57b24171/attachment.p7s>


More information about the Spacewalk-list mailing list