[Spacewalk-list] Spacewalk Errata notification

Nahelou Sébastien sebastien.nahelou at worldline.com
Wed Nov 19 09:06:22 UTC 2014


Hello

In order to increase performance and mainly workaround 503 timeout errors, I'm looking for some DB optimizations.
I have more and more users (more than 1000) and I would like to disable errata mailer.

Do you think it's normal that this table is growing up every day ?
spaceschema=#   select count(*) from rhnerratanotificationqueue;
45917
spaceschema=#   select modified from rhnerratanotificationqueue limit 5;
2013-03-29 08:30:09.82804+00
2013-03-29 08:30:09.82804+00
2013-04-03 14:20:11.65948+00
2013-04-03 14:20:11.65948+00
2013-04-26 02:50:19.440463+00

And do you think that if I purge this table, I can increase some performances (because value seems very old) ?


In addition, I already force email_notify in table rhnUserInfo to 0 but when I looking code it seems this option appears late in the batch:
https://git.fedorahosted.org/cgit/spacewalk.git/tree/java/code/src/com/redhat/rhn/taskomatic/task/ErrataMailer.java?id=1ad3fcf6bc5c80cdab76c93cc8ee2eae01967898

Do you think it's possible to add a global option which force results to null in order to bypass this job ? :)

public void execute(JobExecutionContext context, boolean testContext)
        throws JobExecutionException {

        try {
            List results = getErrataToProcess();
            if (results == null || results.size() == 0) {
                if (logger.isDebugEnabled()) {
                    logger.debug("No errata found...exiting");
                }
            }

Thank you in advance
Regards



Sébastien NAHELOU
Ingénieur système mutu
Worldline - Seclin - France
+33(0)3.20.60.97.06
www.worldline.com<http://www.worldline.com/>

[cid:image002.gif at 01D003E0.0D9B65F0]


________________________________

Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité de Worldline ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis.

This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141119/69d62457/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1388 bytes
Desc: image001.gif
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141119/69d62457/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 2438 bytes
Desc: image002.gif
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20141119/69d62457/attachment-0001.gif>


More information about the Spacewalk-list mailing list