[Spacewalk-list] Error in rhn_taskomatic_daemon.log

[Wojtak, Greg (Superfly)]

On 2012-04-12 7:40 AM, "Jan Pazdziora" <jpazdziora at redhat.com> wrote:

>On Wed, Apr 11, 2012 at 02:54:11PM +0000, Wojtak, Greg (Superfly) wrote:
>> CentOS 6.2, Spacewalk 1.6, Postgres backend, 64-bit
>> 
>> I was watching rhn_taskomatic_daemon.log to make sure that the repo
>>metadata got updated after rhnpush'ing a package.  I'm not really seeing
>>any troubles, but an error keeps popping up in the log:
>> 
>> INFO   | jvm 1    | 2012/04/11 10:51:00 | 2012-04-11 10:51:00,720
>>[Thread-42679] ERROR com.redhat.rhn.common.db.datasource.CachedStatement
>>- Error while processing cached statement sql: insert into
>>rhnPackageRepodata (package_id)
>> INFO   | jvm 1    | 2012/04/11 10:51:00 |               (select
>>cp.package_id as id from rhnChannelPackage cp left join
>>rhnPackageRepoData rd on cp.package_id = rd.package_id
>>
>> INFO   | jvm 1    | 2012/04/11 10:51:00 |       ... 9 more
>> 
>> Like I said, I don't really see any symptoms, but I wanted to report it
>>in case it was something that needed to be addressed.
>
>Does it prevent the repodata from being correctly regenerated for the
>channel? I suspect there might be two of these tasks running and the
>same time, causing this primary key violation. But subsequent runs of
>the same task should heal the problem.
>
>-- 
>Jan Pazdziora
>Principal Software Engineer, Satellite Engineering, Red Hat
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list

It does get generated within say 30 seconds or less.  I haven't noticed
any symptoms because of these errors, but I did notice that there
consistently seems to be one job stuck in the queue that never seems to
clear out.  Any way to tell what that job might be?