[Spacewalk-list] Monitoring in spacewalk 1.3

[Benedetto Vassallo]

Hello list,
I have some issues from monitoring in spacewalk 1.3

First of all I want you to know the issue i had in spacewalk 1.2 was  
fixed (see my previous post having subject "Monitoring problem after  
1.1 -> 1.2 update" on 03 Feb 2011).
Now I see system probes and suite probes correctly.
By the way I do not receive all notofications about probes, but I  
receive a RHN TASKOMATIC NOTIFICATION with the following content:
------------------------
Taskomatic bunch sync-probe-bunch was scheduled to run within the  
sync-probe-default schedule.

Subtask sync-probe-state failed.

For more information check  
/var/lib/rhn/tasko/sat/sync-probe-bunch/sync-probe-state_191885_err.
------------------------

The content of  
/var/lib/rhn/tasko/sat/sync-probe-bunch/sync-probe-state_191885_err is  
the following:
----------------------------
2011-03-22 18:49:03,233 [DefaultQuartzScheduler_Worker-10] ERROR  
com.redhat.rhn.taskomatic.task.SynchProbeState  - Error during probe  
state sync
com.redhat.rhn.common.db.WrappedSQLException: ORA-00060: deadlock  
ottenuto in attesa della risorsa
ORA-06512: a "SWKUNIPA.RHN_SYNCH_PROBE_STATE", line 4
ORA-06512: a line 1

         at  
com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:84)
         at  
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
         at  
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
         at  
com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
         at  
com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
         at  
com.redhat.rhn.taskomatic.task.SynchProbeState.execute(SynchProbeState.java:44)
         at  
com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
         at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:168)
         at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
         at  
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.sql.SQLException: ORA-00060: deadlock ottenuto in  
attesa della risorsa
ORA-06512: a "SWKUNIPA.RHN_SYNCH_PROBE_STATE", line 4
ORA-06512: a line 1

         at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
         at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
         at  
oracle.jdbc.driver.T2CCallableStatement.executeForDescribe(T2CCallableStatement.java:544)
         at  
oracle.jdbc.driver.T2CCallableStatement.executeForRows(T2CCallableStatement.java:727)
         at  
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
         at  
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
         at  
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
         at  
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)
         at  
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
         at  
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)
         at  
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
         ... 7 more
2011-03-22 18:49:03,235 [DefaultQuartzScheduler_Worker-10] ERROR  
com.redhat.rhn.taskomatic.task.SynchProbeState  -  
com.redhat.rhn.common.db.WrappedSQLException: ORA-00060: deadlock  
ottenuto in attesa della risorsa
ORA-06512: a "SWKUNIPA.RHN_SYNCH_PROBE_STATE", line 4
ORA-06512: a line 1

2011-03-22 18:49:03,235 [DefaultQuartzScheduler_Worker-10] ERROR  
com.redhat.rhn.taskomatic.task.SynchProbeState  -  
com.redhat.rhn.common.db.WrappedSQLException: ORA-00060: deadlock  
ottenuto in attesa della risorsa
ORA-06512: a "SWKUNIPA.RHN_SYNCH_PROBE_STATE", line 4
ORA-06512: a line 1
--------------------------

It seems that the process dies becouse a deadlock in oracle.

In case it is useful for you, after pushing the monitor configuration,  
for example when I add or modify a probe, I have to wait for a  
loooooooooooooooong time ant then I have the "push failed" icon in the  
web ui.

I still can't change the e-mail address in notitication method and  
notification filters still don't work.

I hope you can fix it as soon as possible, becouse monitoring is very  
important to me.
It was the primary reason for install spacewalk.
Of course after I installed and tested, I really appreciate all other  
features, but monitoring is still very important to me.
Please help.
Thank you.
-- 
Benedetto Vassallo
Sistema Informativo di Ateneo
Settore Gestione Reti Hardware e Software
U.O.B. Sviluppo e manutenzione dei sistemi
Università degli studi di Palermo

Red Hat Certified Engineer Certificate Number: 804007793324656

Phone: +3909123860056
Fax: +390916529124

-------------------------------------------------------------------------
This message was sent using the University of Palermo web mail interface.