[Spacewalk-list] errata import problem

[Sindre Skogen]

Hello spacewalkers.

I'm using the excellent "errata-import.pl" script from 
http://cefs.steve-meier.de/

Lately I've been getting errors when importing errata like this:
"
Fault returned from XML RPC Server, fault code 2601: 
redstone.xmlrpc.XmlRpcFault: Errata already exists with advisory 
CESA-2013:1142
"

spacecmd "errata_list" does not show this errata. When I look directly 
in the database, table "rhnerrata", it is there.

So, it seems the errata is in the postgres database, but is not reported 
by spacecmd.

Any idea what could be wrong, or how to fix?



I found this which seems to be the same issue:
https://www.redhat.com/archives/spacewalk-list/2014-October/msg00041.html

I compared the output of spacecmd with the DB, and found that 709 of the 
3088 errata in the DB are not shown by spacecmd.

Deleting all these from the "rhnerrata" table gives me a new error when 
running the import script:
"
DEBUG: Removing package 48661 from centos7-updates-x86_64
Fault returned from XML RPC Server, fault code -1: 
redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: 
deadlock detected
   Detail: Process 11147 waits for ShareLock on transaction 34947686; 
blocked by process 11144.
Process 11144 waits for ShareLock on transaction 34947711; blocked by 
process 11147.
   Hint: See server log for query details.
"

The logfile "rhn_web_api.log" shows this error:
"
[2015-09-11 13:29:09,677] ERROR - REQUESTED FROM: 127.0.0.1 CALL: 
channel.software.remove_packages(machineuser, centos7-updates-x86_64, 
48661) CALLER: (machineuser) TIME: 6.431 seconds
redstone.xmlrpc.XmlRpcFault: unhandled internal exception: ERROR: 
deadlock detected
   Detail: Process 11147 waits for ShareLock on transaction 34947686; 
blocked by process 11144.
Process 11144 waits for ShareLock on transaction 34947711; blocked by 
process 11147.
   Hint: See server log for query details.
         at 
com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:208)
         at 
redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)
         at 
com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)
         at 
com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
         at 
com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:100)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
         at 
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
         at 
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
         at 
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
         at 
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
         at 
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
         at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
         at java.lang.Thread.run(Thread.java:701)
"

Deleting all errata first with spacecmd then the rest from the DB gave 
the same result.