Bug 645702

Summary: Need to get rid of rhnPaidErrataTempCache temporary table
Product: [Community] Spacewalk Reporter: Jan Pazdziora <jpazdziora>
Component: ServerAssignee: Tomas Lestach <tlestach>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: low    
Version: 1.2CC: xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-java-1.2.79-1 spacewalk-schema-1.2.60-1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-11-19 16:16:31 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 623772    

Description Jan Pazdziora 2010-10-22 09:33:07 UTC 
Description of problem:

We have temporary table rhnPaidErrataTempCache in our schema. It seems to be used by java/code/src/com/redhat/rhn/taskomatic/task/ErrataMailer.java to store some data which are immediatelly processed and then removed from this table.

We need the logic rewritten in such a way that the data which gets stored in that temporary table are selected in correct order and processed on the fly, for each user and each server.

We want to get rid of that temporary table because the semantics of temporary tables is different in PostgreSQL, and besides, it can be done better some different way anyway.

Version-Release number of selected component (if applicable):

Spacewalk nightly (1.2).

How reproducible:

Look at code.

Steps to Reproduce:
1. Check errata mailer operation.
  
Actual results:

For the errata mailer to work, the temporary table rhnPaidErrataTempCache is needed.

Expected results:

Errata mailer should keep on working even after refactoring, when temporary table rhnPaidErrataTempCache is removed.


Additional info:
Comment 1 Tomas Lestach 2010-11-01 11:26:22 UTC 
Table removed.

spacewalk.git: 8015ae73ed6bb341407ecf9edd015a874ae2fa6e
Comment 2 Tomas Lestach 2010-11-01 12:37:33 UTC 
adding upgrade script for delete_errata procedure

spacewalk.git: 8230ee7cdd4449b1437825fe6a54b7f4ba2de1f3
Comment 3 Jan Pazdziora 2010-11-15 19:30:40 UTC 
Moving ON_QA.

Please use the Spacewalk 1.2 release candidate yum repo at

http://koji.spacewalkproject.org/spacewalk/split/spacewalk-5E/server/spacewalk-5E-1.2/$basearch/os
http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f12/server/spacewalk-f12-1.2/$basearch/os
http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f13/server/spacewalk-f13-1.2/$basearch/os
http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f14/server/spacewalk-f14-1.2/$basearch/os

(depending on your OS) to verify the bugzilla.
Comment 4 Jan Pazdziora 2010-11-19 16:16:31 UTC 
With Spacewalk 1.2 released, marking as CLOSED CURRENTRELEASE.

https://www.redhat.com/archives/spacewalk-list/2010-November/msg00111.html