Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01

23 Feb 2023

      In addition to this, I'm also receiving an error when bootstrapping a new system/applying highstate.  This is an OEL8 system.  From what I can determine, it is with adding the repo for the Uyuni Client Tools.  The error is pasted below.  It seems to be trying to pull the key for the repo down from the external source, instead of from the Uyuni server on the client.  Although that client has a proxy configured, maybe it isn't using the ones specified in the http_proxy and https_proxy variables?  Does that proxy need to be specified somewhere else, specially for this?  Also, why is it pulling it directly, instead of from the external source?  We do have some systems that can't access the internet at all.  I can't view the config on the channel, because of the previous error I've reported.
Here is the error I'm getting on initial bootstrap and applying highstate:
          ID: https_//download.opensuse.org/repositories/systemsmanagement_/Uyuni_/Stable_/CentOS8-Uyuni-Client-Tools/CentOS_8/repodata/repomd.xml.key
    Function: mgrcompat.run
        Name: pkg.add_repo_key
      Result: false
     Comment: Module function pkg.add_repo_key threw an exception. Exception: Error: HTTP 599: Timeout while connecting reading /repositories/systemsmanagement:/Uyuni:/Stable:/CentOS8-Uyuni-Client-Tools/CentOS_8/repodata/repomd.xml.key
     Started: 10:31:09.070314
    Duration: 20022.907
         SLS: channels.gpg-keys
     Changed: {}

--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
allen@ua.edu

________________________________________
From: Allen Beddingfield <allen@ua.edu>
Sent: Thursday, February 23, 2023 9:41 AM
To: General discussion related to the openSUSE Uyuni project
Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01

Yes, this error occurs over and over in that log file:

2023-02-23 08:57:48,297 [ajp-nio-127.0.0.1-8009-exec-1] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.servlet.ServletException: org.hibernate.HibernateException: More than one row with the given identifier was found: 102, for class: com.redhat.rhn.domain.channel.Channel
        at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) ~[struts.jar:1.2.9]
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) ~[struts.jar:1.2.9]
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237) ~[struts.jar:1.2.9]
        at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:104) ~[rhn.jar:?]
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) ~[struts.jar:1.2.9]
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) ~[struts.jar:1.2.9]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-servlet-4.0-api.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-servlet-4.0-api.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:99) ~[rhn.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) ~[sitemesh.jar:?]
        at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) ~[sitemesh.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:71) ~[rhn.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:102) ~[rhn.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.36]
        at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:59) [rhn.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.36]
        at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:98) [rhn.jar:?]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:9.0.36]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:9.0.36]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.36]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:9.0.36]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [catalina.jar:9.0.36]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.36]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.36]
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.36]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.36]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.36]
        at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:432) [tomcat-coyote.jar:9.0.36]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.36]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.36]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1591) [tomcat-coyote.jar:9.0.36]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.36]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.36]
        at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: org.hibernate.HibernateException: More than one row with the given identifier was found: 102, for class: com.redhat.rhn.domain.channel.Channel
        at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.extractEntityResult(AbstractLoadPlanBasedEntityLoader.java:254) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:198) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4290) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:604) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:572) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:226) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:350) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:127) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:93) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1277) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1265) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:208) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2901) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2875) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at org.hibernate.internal.SessionImpl.get(SessionImpl.java:1097) ~[hibernate5_hibernate-core.jar:5.3.25.Final]
        at com.redhat.rhn.domain.channel.ChannelFactory.lookupById(ChannelFactory.java:85) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.dto.ChannelTreeNode.compareTo(ChannelTreeNode.java:395) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.dto.ChannelTreeNode.compareTo(ChannelTreeNode.java:33) ~[rhn.jar:?]
        at java.util.ComparableTimSort.binarySort(ComparableTimSort.java:262) ~[?:?]
        at java.util.ComparableTimSort.sort(ComparableTimSort.java:207) ~[?:?]
        at java.util.Arrays.sort(Arrays.java:1315) ~[?:?]
        at java.util.Arrays.sort(Arrays.java:1509) ~[?:?]
        at java.util.ArrayList.sort(ArrayList.java:1750) ~[?:?]
        at java.util.Collections.sort(Collections.java:145) ~[?:?]
        at com.redhat.rhn.frontend.filter.TreeFilter.handleOrphans(TreeFilter.java:197) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.filter.TreeFilter.filterData(TreeFilter.java:93) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.listview.ListControl.filterData(ListControl.java:167) ~[rhn.jar:?]
        at com.redhat.rhn.manager.BaseManager.processListControl(BaseManager.java:184) ~[rhn.jar:?]
        at com.redhat.rhn.manager.BaseManager.makeDataResult(BaseManager.java:94) ~[rhn.jar:?]
        at com.redhat.rhn.manager.channel.ChannelManager.myChannelTree(ChannelManager.java:269) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.action.channel.MyChannelTreeAction.getDataResult(MyChannelTreeAction.java:34) ~[rhn.jar:?]
        at com.redhat.rhn.frontend.action.channel.BaseChannelTreeAction.execute(BaseChannelTreeAction.java:55) ~[rhn.jar:?]
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) ~[struts.jar:1.2.9]

--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
allen@ua.edu

________________________________________
From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org>
Sent: Thursday, February 23, 2023 8:57 AM
To: users@lists.uyuni-project.org
Cc: Cedric Bosdonnat
Subject: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01

Hi Allen,

You can check in the /var/log/rhn/rhn_web_ui.log file if there is any stack trace that could be related to the issue.
This would help us help you.

--
Cedric

On Thu, 2023-02-23 at 14:44 +0000, Allen Beddingfield wrote:
...
I'm getting an "Internal Server Error" message when trying to access "All" or "My Channels" under Software/Channel List.
The server was recently updated to 2023.01, but that was working after the update.  The only change I can think of that I have made is to do try to add the Leap 15.4 channels again, as they were display but not syncing.  I did that with similar commands to this for the channels:  spacewalk-common-channels -a x86_64 opensuse_leap15_4
Any help in troubleshooting this would be appreciated!
Thanks.
Allen B.
--
Allen Beddingfield
Systems Engineer
Office of Information Technology
The University of Alabama
Office 205-348-2251
allen@ua.edu