"Internal Server Error" when displaying channels on 2023.01
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
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
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
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
I have seen this error as well. I ended up editing the database itself and removed the rows with the offending identifier and recreated the channels. Seems like maybe a constraint is missing in the database allowing duplicates. On 2/23/2023 9:41 AM, Allen Beddingfield wrote:
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
-- Brett Morrow Systems Administrator III DNI Contract Support to the National Weather Center | NSSL (405) 325-6995 Brett.Morrow@noaa.gov
I'm not familiar enough with Postgresql or what this should look like in the database to even know where to begin trying to do that, though. -- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu ________________________________________ From: Brett Morrow (NOAA Affiliate) via Uyuni Users <users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 11:37 AM To: users@lists.uyuni-project.org Cc: Brett Morrow (NOAA Affiliate) Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01 I have seen this error as well. I ended up editing the database itself and removed the rows with the offending identifier and recreated the channels. Seems like maybe a constraint is missing in the database allowing duplicates. On 2/23/2023 9:41 AM, Allen Beddingfield wrote:
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
-- Brett Morrow Systems Administrator III DNI Contract Support to the National Weather Center | NSSL (405) 325-6995 Brett.Morrow@noaa.gov
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B. -- 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
Hi Allen, Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever. You can execute the following command to do that, be aware this is not recommended but can be used as last resort /$ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct -/ Best regards, Abid On 24.02.23 16:29, Allen Beddingfield wrote:
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B.
-- 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
Abid, Thanks for the suggestion. When I try that, it yields this error: uyuni01:~ # echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: syntax error at or near "delete_channel" LINE 1: delete_channel(102); I tried single quotes as well. Also, I'm wondering if there is a way to determine the numerical ID for a channel? If I knew that, maybe I could try the spacewalk-remove-channel command on it? Allen B. -- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu ________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 9:49 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01 Hi Allen, Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever. You can execute the following command to do that, be aware this is not recommended but can be used as last resort $ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - Best regards, Abid On 24.02.23 16:29, Allen Beddingfield wrote: Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B. -- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu<mailto:allen@ua.edu> ________________________________________ From: Allen Beddingfield <allen@ua.edu><mailto: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<mailto:allen@ua.edu> ________________________________________ From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org><mailto:users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 8:57 AM To: users@lists.uyuni-project.org<mailto: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<mailto:allen@ua.edu>
ah my mistake, this should work echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct - Best regards, Abid On 24.02.23 17:05, Allen Beddingfield wrote:
Abid, Thanks for the suggestion. When I try that, it yields this error:
uyuni01:~ # echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: syntax error at or near "delete_channel" LINE 1: delete_channel(102);
I tried single quotes as well. Also, I'm wondering if there is a way to determine the numerical ID for a channel? If I knew that, maybe I could try the spacewalk-remove-channel command on it? Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 9:49 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
Hi Allen,
Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever.
You can execute the following command to do that, be aware this is not recommended but can be used as last resort
$ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 16:29, Allen Beddingfield wrote:
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu<mailto:allen@ua.edu>
________________________________________ From: Allen Beddingfield <allen@ua.edu><mailto: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<mailto:allen@ua.edu>
________________________________________ From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org><mailto:users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 8:57 AM To: users@lists.uyuni-project.org<mailto: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<mailto:allen@ua.edu>
Ah, thanks. That's yielded this message: uyuni01:~ # echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: update or delete on table "rhnchannel" violates foreign key constraint "rhn_channel_parent_ch_fk" on table "rhnchannel" DETAIL: Key (id)=(102) is still referenced from table "rhnchannel". CONTEXT: SQL statement "delete from rhnChannel where id = channel_id_in" PL/pgSQL function delete_channel(numeric) line 13 at SQL statement uyuni01:~ # Allen B. -- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu ________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 10:06 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01 ah my mistake, this should work echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct - Best regards, Abid On 24.02.23 17:05, Allen Beddingfield wrote:
Abid, Thanks for the suggestion. When I try that, it yields this error:
uyuni01:~ # echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: syntax error at or near "delete_channel" LINE 1: delete_channel(102);
I tried single quotes as well. Also, I'm wondering if there is a way to determine the numerical ID for a channel? If I knew that, maybe I could try the spacewalk-remove-channel command on it? Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 9:49 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
Hi Allen,
Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever.
You can execute the following command to do that, be aware this is not recommended but can be used as last resort
$ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 16:29, Allen Beddingfield wrote:
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu<mailto:allen@ua.edu>
________________________________________ From: Allen Beddingfield <allen@ua.edu><mailto: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<mailto:allen@ua.edu>
________________________________________ From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org><mailto:users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 8:57 AM To: users@lists.uyuni-project.org<mailto: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<mailto:allen@ua.edu>
So it's a parent channel which has childs and can't be removed, Ok let's try a different way then. echo "select name, label from rhnchannel where id=102;" | spacewalk-sql --select-mode-direct - Check which channel is it and then 1try from spacewalk-remove channel with spacewalk-remove-channel -a <channel-label> Best regards, Abid On 24.02.23 17:08, Allen Beddingfield wrote:
Ah, thanks. That's yielded this message:
uyuni01:~ # echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: update or delete on table "rhnchannel" violates foreign key constraint "rhn_channel_parent_ch_fk" on table "rhnchannel" DETAIL: Key (id)=(102) is still referenced from table "rhnchannel". CONTEXT: SQL statement "delete from rhnChannel where id = channel_id_in" PL/pgSQL function delete_channel(numeric) line 13 at SQL statement uyuni01:~ #
Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 10:06 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
ah my mistake, this should work
echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 17:05, Allen Beddingfield wrote:
Abid, Thanks for the suggestion. When I try that, it yields this error:
uyuni01:~ # echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: syntax error at or near "delete_channel" LINE 1: delete_channel(102);
I tried single quotes as well. Also, I'm wondering if there is a way to determine the numerical ID for a channel? If I knew that, maybe I could try the spacewalk-remove-channel command on it? Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 9:49 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
Hi Allen,
Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever.
You can execute the following command to do that, be aware this is not recommended but can be used as last resort
$ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 16:29, Allen Beddingfield wrote:
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu<mailto:allen@ua.edu>
________________________________________ From: Allen Beddingfield <allen@ua.edu><mailto: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<mailto:allen@ua.edu>
________________________________________ From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org><mailto:users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 8:57 AM To: users@lists.uyuni-project.org<mailto: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<mailto:allen@ua.edu>
Thanks Abid! It was the channel for Rocky Linux 8. I've been able to successfully remove it with this command: spacewalk-remove-channel -a rockylinux8-x86_64 --unsubscribe --username=admin. It took about an hour for it to remove everything. Now, the UI allows me to view the channel listings again. I notice that this channel, and the sub channels are still listed in the channel list in the web ui, with 0 packages. Do you suggest that I do any additional steps before trying to add them back with spacewalk-common-channels -a, to prevent this from happening again? Thanks. Allen B. -- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu ________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 10:18 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01 So it's a parent channel which has childs and can't be removed, Ok let's try a different way then. echo "select name, label from rhnchannel where id=102;" | spacewalk-sql --select-mode-direct - Check which channel is it and then 1try from spacewalk-remove channel with spacewalk-remove-channel -a <channel-label> Best regards, Abid On 24.02.23 17:08, Allen Beddingfield wrote:
Ah, thanks. That's yielded this message:
uyuni01:~ # echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: update or delete on table "rhnchannel" violates foreign key constraint "rhn_channel_parent_ch_fk" on table "rhnchannel" DETAIL: Key (id)=(102) is still referenced from table "rhnchannel". CONTEXT: SQL statement "delete from rhnChannel where id = channel_id_in" PL/pgSQL function delete_channel(numeric) line 13 at SQL statement uyuni01:~ #
Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 10:06 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
ah my mistake, this should work
echo "select delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 17:05, Allen Beddingfield wrote:
Abid, Thanks for the suggestion. When I try that, it yields this error:
uyuni01:~ # echo "delete_channel(102);" | spacewalk-sql --select-mode-direct - psql:<stdin>:1: ERROR: syntax error at or near "delete_channel" LINE 1: delete_channel(102);
I tried single quotes as well. Also, I'm wondering if there is a way to determine the numerical ID for a channel? If I knew that, maybe I could try the spacewalk-remove-channel command on it? Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu
________________________________________ From: Abid Mehmood <amehmood@suse.de> Sent: Friday, February 24, 2023 9:49 AM To: users@lists.uyuni-project.org Subject: Re: [EXTERNAL] Re: "Internal Server Error" when displaying channels on 2023.01
Hi Allen,
Not sure, how you get into this situation. But before starting from scratch, just try removing the channel with id 102 from the sever.
You can execute the following command to do that, be aware this is not recommended but can be used as last resort
$ echo "delete_channel(102);" | spacewalk-sql --select-mode-direct -
Best regards,
Abid
On 24.02.23 16:29, Allen Beddingfield wrote:
Anyone have any ideas on how to get out of this mess? If I can't get this running soon, I'm going to have to just start over from scratch with a new Uyuni server, and I don't want to have to do that. Allen B.
-- Allen Beddingfield Systems Engineer Office of Information Technology The University of Alabama Office 205-348-2251 allen@ua.edu<mailto:allen@ua.edu>
________________________________________ From: Allen Beddingfield <allen@ua.edu><mailto: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<mailto:allen@ua.edu>
________________________________________ From: Cedric Bosdonnat via Uyuni Users <users@lists.uyuni-project.org><mailto:users@lists.uyuni-project.org> Sent: Thursday, February 23, 2023 8:57 AM To: users@lists.uyuni-project.org<mailto: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<mailto:allen@ua.edu>
participants (4)
-
Abid Mehmood -
Allen Beddingfield -
Brett Morrow (NOAA Affiliate) -
Cedric Bosdonnat