[Spacewalk-list] Errata Cache bunch running forever on Spacewalk 2.4

[Robert Paschedag]

Can anybody give a hint, in which db table to search for these errata-cache tasks, that are started over and over again? I just don't get it myself right now . It also looks like that it is always the same prox. 50 servers that this occurs.

Regards
Robert
Am 07.01.2016 10:11 vorm. schrieb Paschedag.Netlution at swr.de:
>
> Hi all, 
>
> it looks like one (or more?) jobs have been interrupted, while the spacewalk service had shut down for upgrade. I upgraded my spacewalk server from 2.2 -> 2.3 -> 2.4. 
>
> Now it looks like the errata-cache bunch tasks is running forever and the errata notification mail is not started anymore. I think it gets called from errata-cache, when this has finished. 
>
> Errata Cache:
> 2016-01-07 10:00:00 MEZ
> RUNNING
> Errata Notification Mail:
> 2016-01-04 08:30:00 MEZ
> INTERRUPTED
>
>
> When I look into the database, I can see several tasks in the rhntaskqueue but I'm pretty sure, that these tasks do not get cleared correctly, so the task is run for every server over and over again. I'm not sure! This is just my thinking. 
>
> rhnschema=# select * from rhntaskqueue; 
>  org_id |         task_name          | task_data  | priority |           earliest 
> --------+----------------------------+------------+----------+------------------------------- 
>       1 | update_server_errata_cache | 1000010701 |        0 | 2016-01-07 10:00:45.963006+01 
>       1 | update_server_errata_cache | 1000010274 |        0 | 2016-01-07 10:00:53.198001+01 
>       1 | update_server_errata_cache | 1000010527 |        0 | 2016-01-07 10:01:03.768592+01 
>       1 | update_server_errata_cache | 1000010689 |        0 | 2016-01-07 10:01:56.915296+01 
>       1 | update_server_errata_cache | 1000010641 |        0 | 2016-01-07 10:02:41.775593+01 
>       1 | update_server_errata_cache | 1000010687 |        0 | 2016-01-07 10:05:01.471365+01 
>       1 | update_server_errata_cache | 1000010650 |        0 | 2016-01-07 10:05:26.492405+01 
>       1 | update_server_errata_cache | 1000010520 |        0 | 2016-01-07 10:06:38.052352+01 
> (8 Zeilen) 
>
> rhnschema=# 
>
> Any help will be appreciated to debug this further. 
>
> Regards, 
> Robert 
>
>
> Mit freundlichen Grüßen 
>
> Robert Paschedag 
> Netlution GmbH 
> Landteilstr. 33 
> 68163 Mannheim 
>
> im Auftrag des 
> SWR 
> Südwestrundfunk 
> Informations- und Kommunikationssysteme 
> Neckarstraße 230 
> 70190 Stuttgart 
>
> Telefon +49 (0)711 /929-12654 oder 
> Telefon +49 (0)711 /929-13714 
> paschedag.netlution at swr.de 
>
> swr.de 
>