[Spacewalk-list] deleting/re-adding systems causes "internal error"

[Guy Matz]

Hi!  Deleted a system:
spacecmd -y system_delete nyc-desk-l16

Then tried to re-add:
$ sudo rhnreg_ks --force --serverUrl=http://nyc-pkgms-lv01/XMLRPC
--sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
--activationkey=1-9e6976328a163d2d1f0c1f4b80f02a40
rhn-plugin: Error communicating with server. The message was:
Internal Server Error

/var/log/up2date on the client says:
[Fri Aug 17 19:35:06 2018] up2date A protocol error occurred: Internal
Server Error , attempt #1,
[Fri Aug 17 19:35:06 2018] up2date
Traceback (most recent call last):
  File "/sbin/rhnreg_ks", line 217, in <module>
    cli.run()
  File "/usr/share/rhn/up2date_client/rhncli.py", line 96, in run
    sys.exit(self.main() or 0)
  File "/sbin/rhnreg_ks", line 95, in main
    rhnreg.getCaps()
  File "/usr/share/rhn/up2date_client/rhnreg.py", line 264, in getCaps
    s.capabilities.validate()
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 185, in
__get_capabilities
    self.registration.welcome_message()
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 67, in __call__
    return rpcServer.doCall(method, *args, **kwargs)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 290, in doCall
    raise_with_tb(up2dateErrors.CommunicationError(e.errmsg))
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 214, in doCall
    ret = method(*args, **kwargs)
  File "/usr/lib64/python2.7/xmlrpclib.py", line 1233, in __call__
    return self.__send(self.__name, args)
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 48, in _request1
    ret = self._request(methodname, params)
  File "/usr/lib/python2.7/site-packages/rhn/rpclib.py", line 394, in
_request
    self._handler, request, verbose=self._verbose)
  File "/usr/lib/python2.7/site-packages/rhn/transports.py", line 177, in
request
    headers, fd = req.send_http(host, handler)
  File "/usr/lib/python2.7/site-packages/rhn/transports.py", line 740, in
send_http
    response.status, response.reason, response.msg)
<class 'up2date_client.up2dateErrors.CommunicationError'>: rhn-plugin:
Error communicating with server. The message was:
Internal Server Error

while /var/log/rhn/rhn_server_xmlrpc.log on the server says:
2018/08/17 16:43:56 -07:00 5240 172.18.4.65:
rhnServer/server_certificate.valid('Server id ID-*1000010021* not found in
database',)

But I think the important bit is this that I get in an email:
Frame call_function in /usr/lib/python2.7/site-packag
es/spacewalk/server/apacheRequest.py at line 195
                           e = <class 'psycopg2.IntegrityError'> insert or
update on table "rhnserverpath" violates foreign key constraint
"rhn_serverpath_psid_fk"
DETAIL:  Key (proxy_server_id)=(*1000010021*) is not present in table
"rhnserver".

Anyone have any idea how/if my DB got into an inconsistent state?  Any
ideas what I can do now?

THanks!!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180817/9b430229/attachment.htm>