[Spacewalk-list] Help - Garbage in Database

[Waldirio Manhães Pinheiro]

Hello Francisco, good morning

If you check inside the directory that Stephen told you, you can see a lot
of sql scripts (Oracle and Postgresql), check the scripts according your db
and check what they are doing.

You can check in your db and see if you need or not apply the command's.

If you are not familiar with db administration, I really recommend you
prepare a new machine, create a backup of your prod machine, restore in the
new server (using the same ssl cert) and test with a lab client, check
where you get errors or messages in nowadays in your prod. environment and
test in the new server.

Ps.: Try to do this in a separated network (virtual for example) and test,
if works fine, you can just upgrade your scenario.

I'm not sure about "all error" that you are getting, but this can be a good
way.

Take Care




______________
Atenciosamente
Waldirio
msn: waldirio at gmail.com
Skype: waldirio
Site: www.waldirio.com.br
Blog: blog.waldirio.com.br
LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
PGP: www.waldirio.com.br/public.html

On Wed, Feb 4, 2015 at 12:46 PM, Francisco Cardoso <
francisco.cardoso at gmail.com> wrote:

> Stephen,
>
> Can you tell me how to apply those scripts ?
> Is there any "way" with the spacewalk-schema-upgrade ?
> Never have to do this so if you could give me some pointers would really
> appreciate it.
>
> Regards,
>
> FC
>
> -----Original Message-----
> From: Stephen Herr [mailto:sherr at redhat.com]
> Sent: 04 February 2015 14:36
> To: francisco.cardoso at gmail.com; spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Help - Garbage in Database
>
> On 02/02/2015 07:54 PM, Francisco Cardoso wrote:
> > Hello,
> >
> > I finally had the time to look up into why I think I was having
> > Internal Server Errors on some of my pages and I think I know why L
> >
> > Some of my Activation Keys , Systems and so on had the Monitoring
> > Entitlement activated.
> >
> > Any way I can prune the database and get rid of it ?
> >
> > Regards,
> >
> > Francisco
> >
>
> This should not be a problem unless you are running Spacewalk Nightly
> packages on an un-upgraded database. You need to manually apply the
> database
> changes that have not been applied to your db (ensure you have latest
> spacewalk-schema installed, look in
>
> /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.2-to-spacewalk-schema-2
> .3/).
> spacewalk-schema-upgrade cannot do it for you if you're using nightly, only
> if you're upgrading from one release to another (2.1 to 2.2).
>
> -Stephen
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150208/92d93a2c/attachment.htm>