[Spacewalk-list] taskomatic scheduled task 'cobbler-sync-default' throwing exception every minute

[Scott Worthington]

Hello,

I have created channels and scheduled repo syncs in those channels 
in Spacewalk 1.6 on CentOS 6.2. I have also created kickstartable 
distributions and kickstarts for those channels.

As new point releases of CentOS become available, I have created new 
base channels and retired and deleted the older base channels. 
Through the web GUI, you must first delete existing kickstarts, then 
kickstart distributions, then child channels, and finally the base 
channel in that order to properly delete a base channel.

I have used the web GUI exclusively to perform the above functions
(however, I now see there is a CLI 'spacewalk-remove-channel' that
I may use in the future instead of the web GUI).

Every minute, I am seeing errors being logged into 
/var/log/rhn/rhn_taskomatic_daemon.log:

INFO   | jvm 1    | 2012/01/05 08:30:00 | 2012-01-05 08:30:00,185 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - RuntimeExceptioneError trying to sync to cobbler: No row with the given identifier exists: [com.redhat.rhn.domain.kickstart.KickstartableTree#6]
INFO   | jvm 1    | 2012/01/05 08:30:00 | org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.redhat.rhn.domain.kickstart.KickstartableTree#6]
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.type.ManyToOneType.assemble(ManyToOneType.java:196)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.cache.StandardQueryCache.get(StandardQueryCache.java:130)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.loader.Loader.getResultFromQueryCache(Loader.java:2161)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2126)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.loader.Loader.list(Loader.java:2096)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.common.hibernate.HibernateFactory.listObjectsByNamedQuery(HibernateFactory.java:265)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.domain.kickstart.KickstartFactory.lookupKickstartTrees(KickstartFactory.java:639)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.manager.kickstart.cobbler.CobblerDistroSyncCommand.store(CobblerDistroSyncCommand.java:137)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.taskomatic.task.CobblerSyncTask.execute(CobblerSyncTask.java:91)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:168)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO   | jvm 1    | 2012/01/05 08:30:00 |       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO   | jvm 1    | 2012/01/05 08:30:00 | 2012-01-05 08:30:00,185 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - re-throwing exception since we havent yet.
INFO   | jvm 1    | 2012/01/05 08:30:00 | 2012-01-05 08:30:00,185 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - No row with the given identifier exists: [com.redhat.rhn.domain.kickstart.KickstartableTree#6]
INFO   | jvm 1    | 2012/01/05 08:30:00 | 2012-01-05 08:30:00,185 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask -

I see that cobbler-sync-default is scheduled in the postgresql 
taskomatic table 'rhntaskoschedule' with the entry '0 * * * * ?'

Which postgresql table should I check to find the entry for the 
'KickstartableTree' that does not physically exist?

Is there a possible a row was not deleted from one of the 
'rhnkickstart*' databases?

--ScottW