[Spacewalk-list] errors on registration

[Jan Pazdziora]

On Fri, Mar 30, 2012 at 03:32:28PM +0100, Bill Gunter wrote:
> I recently upgraded from Spacewalk 1.0 to 1.2 (yes, we're really
> behind) and I'm having problems with new system registration. The
> error on using rhnreg_ks is only "Internal Server Error." The apache
> error_log on the spacewalk server has something more ominous:

[...]

> rhnException: (4068, 'ORA-04068: existing state of packages has been
> discarded\nORA-04065: not executed, altered or dropped stored
> procedure "SPACEWALK.QUEUE_SERVER"\nORA-06508: PL/SQL: could not find
> program unit being called: "SPACEWALK.QUEUE_SERVER"\nORA-06512: at
> "SPACEWALK.RHN_CHANNEL", line 149\nORA-06512: at line 1\n')

You've upgraded the schema while your Apache was still running and
application having its connections to it. That's not advisable. On the
other hand, restarting Apache should fix the problem just fine.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat